General Ledger > Reports >

Financial Spreadsheet

 

         

 

 

Financial Spreadsheet


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

 

 

Filters and Options


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).

 

On the Filters tab select the Accounts to Print: Balance Sheet and/or Income Expense. In the Account Structure area select the levels you want to include on the report.

 

The Account Number 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.
 

 

 

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

 

Options

Select an Ending Period for the report. The Ending Period represents the last period in the range of periods that displays on the report. Next, select your Report Type: Actual, Budget, or 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.

 

You then have several 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

 

Select the Line Spacing and then select your Page Break Options: None or Department Name. You then select your Print Format of Wide or Narrow.

 

Click the Run Report button to generate a preview of the report.

Click the Clear Preferences link to reset all of your report preferences to their default values.

Click the Close Report button to return to the dashboard.

The report displays on the Report Preview page. Refer to the Report Preview help page for more information.

 

 

Compiled on 9/18/2018 2:32:11 PM