GL> Reports> Balance Sheet
GL Balance Sheet Report
Summary
The Balance Sheet report displays balance totals for asset, liability, and cash carry-over accounts. Choose
to print the Balance Sheet report to show year-to-date totals through the current fiscal period or through a
previous fiscal period.
Related Links
Click here for information on Chart of Account Maintenance.
Step by Step
1 Open the Balance Sheet window (GL> Reports> Balance Sheet).
2 Configure the report.
- The Fund field is used to filter the report by fund. If this field is left blank the report will display balance totals for all funds.
- The format of the fund entered in this field must exactly match the format used in the application.
- The Fiscal Period field is used to filter the balance totals that display on the report by fiscal period.
- The Fiscal Year field is used to filter the balance totals that display on the report by fiscal year.
- Check the Print accounts toggle to include GL accounts on the report. When this toggle is not checked, the report displays only the balance totals for the accounts.
- Included GL accounts will be grouped by account type and sorted by account number.
- Check the Include inactive accounts toggle if inactive GL accounts should display on the report. If you do not check this toggle, inactive GL accounts will not display on the report even if there have been journal entries posted to those accounts.
- GL accounts are set up as inactive on the Chart of Accounts Maintenance window (GL> Maintenance> Chart of Accounts> General tab> Account is active toggle). Click here for information on Chart of Account Maintenance.
- Check the Include uncommitted journal entries toggle to include uncommitted manual journal entries on the report. Checking this toggle will not include uncommitted AP invoice batches or other uncommitted transaction in other modules; it will only include uncommitted manual journal entries (GL> Journal Entries).
3 Print the report.
- Once the required report settings have been specified, click the Print button to print your report.
- Click the options arrow on the right side of the Print button to see other print options.
- Select PDF to print the report in the default Springbrook PDF format.
- Select Excel to export the report data to an Excel spreadsheet as unformatted data.
- Select Excel (Formatted) to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
- Once a print option is selected, that option will automatically be selected the next time you access the report. For example, if you select Excel from the drop-down menu, the next time you access the report the Excel button will be displayed by default.
- Click the Schedule icon next to the Print button in order to schedule the report to generate at a later date and time.
- Enter a Date and Time to generate the report and click SUBMIT.
- Users can also regenerate a report with the same configuration as a prior report via the report history section. This can help improve efficiency when an identical report is frequently generated.
- Once a report has been generated, the date and time it was generated will display in the report history accessed via the Expand Arrow button on the right side of the window.
- Expand the report history and click on a previous report record to automatically populate the report criteria with the criteria specified on the previously generated report. This section will display the last three times the report was generated.