General Ledger > Reports >

Financial Spreadsheet

 

         

 

 

Overview

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

 

This Help page contains the following sections:

Filters and Options

Report

 

 

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.

 

 

Report

Click the Run Report button to display a preview of your Financial Spreadsheet report. You may also click the Clear Preferences link to reset all of your report preferences to their initial values. Once the preview displays you can navigate the pages, export to several formats (e.g., PDF, Excel, Word), and Print. Click Report Preferences on the blue bar above the report preview to return to Report Preferences or click the Close Report button to return to the main General Ledger page.

 

 

Compiled on 1/24/2018 8:42:27 AM