The Statement of Financial Position report allows you to print a statement of the balances for your balance sheet accounts: Assets, Liabilities, and Capital.
Note: This report runs based on your currently selected period. Change the currently selected period to run the report on a different period (More Information).
Filter
- Complete the following filters as needed.
- Select which levels you want to include.
Note: If you see companies listed in the Account Structure filter, see General Ledger Plus for information on running reports.
Options
- Complete the following options as needed:
- Change Appearance?: Check the box to change the font type and size. A drop-down option also controls the white space between the columns by percentage.
- Banded Rows?
- Report Name
- Suppress Zero Balances
- Print Account Number
- Show Sub Accounts
- Only Show Current Balance for Each Net Asset Item
- Print in Landscape
- Print Totals Only
- Wrap Description
- Columnar By Period: Prints a consolidated statement of financial position by period for the different levels of your account structure.
- Columnar By Fund: Displays a column for each selected fund on the Filters tab, with totals for each balance sheet account in each fund. When this option is selected, the Pre-defined formats drop-down list and the columnar options are unavailable.
-
Pre-defined formats: Several pre-defined formats are available:
- Current Year Only: Prints only current year balances.
- Current & prior year: Prints current and prior year balances.
- Current & prior month: Prints current year and last month's balances.
- Current & beginning of year: Prints current, beginning of year, and the difference.
- 2-year comparison: Prints the current year and prior-year information, including the prior-year FYE.
- 3-year comparison: Prints the current year and prior-year information, including FYEs for the prior 2 years.
- 4-year comparison: Prints the current year and prior-year information, including FYEs for the prior 3 years.
- 5-year comparison: Prints the current year and prior-year information, including FYEs for the prior 4 years.
- 6-year comparison: Prints the current year and prior-year information, including FYEs for the prior 5 years.
- 7-year comparison: Prints the current year and prior-year information, including FYEs for the prior 6 years.
- Available Options and Selected Options: Customize what appears in the report by dragging options horizontally between the Available Options and Selected Options. You can also drag options vertically to re-order the Selected Options column. We recommend dragging items between the columns rather than using the ">>" and "<<" buttons, since those buttons move all items.
-
Export:
- None
- CSV
- Excel
Note: You can print your report using one of three methods: Columnar by Period, Columnar by Fund, or Pre-defined formats, or a custom report. You can also select a pre-defined format as a starting point and further customize the output.
Note: Accounts that do not exist in the current year do not print on the report.
Note: The Available Option labeled "Difference" simply shows the difference between the previous two columns.
Report
- 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.
- Click the Close Report button to return to the dashboard.
Drill Down
Click any total on the report to display the Posted Journals page in a new browser tab. This page displays all the journal detail that comprises the total you click. Capital account totals do not have the Drill Down function. Liability accounts used as closing accounts have the Drill Down function, but the Posted Journals page displays only amounts posted directly to those accounts.
Note: The Drill Down functionality only applies to "Actual" columns. In addition, percentage-based columns do not have this feature.
Updated