Financial Spreadsheet Report

The Financial Spreadsheet report allows you to print net amounts posted to Income and Expense accounts by each period for an entire year.

Filters

The Financial Spreadsheet uses your currently selected period as the ending period for the report. Change the currently selected period to run the report on a different range (More Information).

1. Complete the following filters as needed.

• • Accounts to Print:
    • Balance Sheet
    • Income Expense

  • Account Number - This filter allows you to further narrow down which accounts you want to display on the report. Selecting any option other than Show All displays fields so you can input the numbers.

    

  • Account Structure - Select the levels you want to include on the report.

If you see companies listed in the Account Structure filter, see General Ledger Plus for information on running reports.

Options

1. Complete the following options as needed.

• • Change Appearance? - Check the box in order to change the font type and size. There is also a drop-down option to control the white space between the columns by a percentage.
  • Banded Rows?
  • Ending Period - The Ending Period represents the last period in the range of periods that displays on the report.
  • Report Type:
    • Actual, Budget
    • Revised Budget - If you select Budget or Revised Budget, you can select to 
      • Use Actuals For Closing Periods. This replaces budget columns with actual dollars if the month is marked as closed.
  • Report Options:
    • Suppress Zero Balances
    • Wrap Account Description
    • Use Reverse Signs: This causes the reverse signs to be used for Income accounts.
    • Show Whole Dollars Only
    • Show Sub Accounts
  • Line Spacing
    • Single
    • 1.5 Lies 
    • Double
  • Page Break Options: 
    • None
    • Department Name
  • Print Format
    • Wide
    • Narrow
  • Export:
    • None
    • CSV
    • Excel

Report

1. Click the Run Report button to generate a preview of the report. Refer to the Report Preview help page for more information. Click the Clear Preferences link to reset all of your report preferences to their default values if needed. 
2. Click the Close Report button to return to the dashboard.

Updated February 27, 2025 20:31