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

Note: 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 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. Note: 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?: select the checkbox to change the font type and size. A drop-down option controls the white space between columns by percentage.
   • Banded Rows?
   • Ending Period: the last period in the range of periods that displays on the report.

   • Report Type:

     • Actual
     • Budget
     • Revised Budget

     Note: if you select Budget or Revised Budget, you can select Use Actuals For Closing Periods, which replaces budget columns with actual dollars if the month is marked as closed.

   • Report Options:
     • Suppress Zero Balances
     • Wrap Account Description
     • Use Reverse Signs: applies reverse signs to Income accounts.
     • Show Whole Dollars Only
     • Show Sub Accounts
   • Line Spacing:
     • Single
     • 1.5 Lines
     • Double
   • Page Break Options:
     • None
     • Department Name
   • Print Format:
     • Wide
     • Narrow
   • Export:
     • None
     • CSV
     • Excel

Report

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

Updated May 26, 2026 17:12