Balance Sheet Reports
Access this report using Reports>Financial Statement >Balance Sheet.
Use this report to view a standard balance sheet. This report can be used to comply with ASC 958 (FAS 117 superseded)/GASB if the Segment Substitution feature is used to report the Net Asset section by Restriction (on the Options tab). To use this report a balance sheet must first be set up using Financial Statement Formats in the Report Builder Setup Tab. This report contains:
- Additional items and filters if any user defined fields were created by the Administrator. Only user defined fields with a field type of String, Editable Drop-Down List, or Non-Editable Drop-Down List are available in the Items by Page group box on the Content tab and are listed as an available filter.
These are the System Default reports available for Balance Sheet:
- Comparative Balance Sheet - Annual Report
- Comparative Balance Sheet - Monthly Report
Note: Additional Custom Reports for Balance Sheet may be available depending on your MIP implementation.
Setup
Use this tab to assign:
-
Balances Dates
- Current Period Dates
- Financial Statement Formats
- Report Groups
- Columns
- Items by Page (Page Breaks)
Balance Dates
The Balance Dates for the report display.
See Report Builder Setup Tab for more information on adjusting Balance Dates.
Current Period Dates
The Current Period Dates for the report display.
See Report Builder Setup Tab for more information on adjusting Current Period Dates.
Financial Statement Formats
The Financial Statement Format for the report displays.
See Report Builder Setup Tab for more information on adjusting Financial Statement Formats.
Report Groups
Selecting a Report Group in Columns, Items by Page (Page Breaks), or Filter displays the Select\Edit Group Code dialog box.
See Report Builder Setup Tab for more information on working with Report Groups.
Columns
The current column configuration for the reports displays.
See Report Builder Setup Tab for more information on adjusting report columns.
These are the available columns with their descriptions for Balance Sheet reports.
Note: Fewer or additional report columns may be available depending on your MIP implementation.
|
Column |
Description |
|
Financial Statement Section Titles |
The financial statement level Section Titles that were set up using the using Financial Statement Formats in the Report Builder Setup Tab. This column always prints on the report. |
|
Title |
The actual title assigned to the account code. The report prints the title, such as Housing, Federal Fund, or Service Fees. |
|
Account Code |
The actual code assigned to the account. The report prints the account code, such as 201, 05, or 45001. |
|
Beginning Year Balance |
The balance at the beginning of the current reporting year. |
|
Beginning Period Balance |
The balance at the beginning of the period before the current period amounts. |
|
Current Period Balance |
The balance for the current period. This period was designated in the Current Period Dates group box on the Setup tab. It is calculated by taking the debits minus the credits when the G/L Account Code's section account category is equal to Assets. Otherwise, calculated by taking the credits minus the debits. |
|
Current Year |
The balance for the current year through the Ending Balances date from the Setup tab. It is calculated by taking the debits minus the credits when the G/L Account Code's section account category is equal to Assets. Otherwise, calculated by taking the credits minus the debits. |
|
Prior Year |
The balance from the prior year for the same time frame in comparison to the current year. Current year is defined as the time between the Current Reporting Year Begins date and the Ending Balances date. If these dates cover more than twelve months, the prior year amounts will also have the same number of months, but will be one year back. |
|
Current Period Change |
The monetary increase or decrease between the current balance and the balance at the beginning of the period. |
|
Current Period % Change |
The percentage increase or decrease between the current balance and the balance at the beginning of the period. |
|
YTD Change |
The monetary amount increase or decrease between the current year balance and the balance at the beginning of the year. |
|
YTD % Change |
The percentage increase or decrease between the current year balance and the balance at the beginning of the year. |
|
Current Year Change |
The monetary increase or decrease between the current year balance and the prior year balance for the same time frame. |
|
Current Year % Change |
The percentage increase or decrease between the current year balance and the prior year balance for the same time frame. |
Items by Page (Page Breaks)
The current data arrangement per page for the report displays.
Use Items by Page to divided report items onto separate pages, starting a new page for each item.
See Report Builder Setup Tab for more information on separating report pages.
These are the available columns with their descriptions for Balance Sheet reports.
Note: Fewer or additional report columns may be available depending on your MIP implementation.
|
Column |
Description |
|
{Segment Name} Code |
The code assigned to the segment. The report shows a segment code—01, 201, 11001, for example. The report prints one column for each segment, such as Fund Code or GL Code. |
|
{Segment Name} Group Code |
The group code that was defined. The report prints a column for each group code, such as Fund Group Code. |
|
{User Defined Field} - {Segment Name} Code |
A segment type user defined field and its data. There is a separate column for each field. |
|
{User Defined Field} - {Segment Name} Contract Code |
A segment type user defined field and its data. There is a separate column for each field. |
|
{User Defined Field} - {Segment Name} Division Code |
A segment type user defined field and its data. There is a separate column for each field. |
Filters
The current column filtering for the reports displays.
Use filtering to narrow down and more explicitly define the data to include in the report.
See Report Builder Filter Tab for more information on adjusting report filters.
These are the available columns with their descriptions for Balance Sheet reports.
Note: Fewer or additional report columns may be available depending on your MIP implementation.
|
Column |
Description |
|
{Segment Name} Code |
The code assigned to the segment. The report shows a segment code—01, 201, 11001, for example. The report prints one column for each segment, such as Fund Code or GL Code. |
|
{Segment Name} Group Code |
The group code that was defined. The report prints a column for each group code, such as Fund Group Code. |
|
{User Defined Field} - {Segment Name} Code |
A segment type user defined field and its data. There is a separate column for each field. |
|
{User Defined Field} - {Segment Name} Contract Code |
A segment type user defined field and its data. There is a separate column for each field. |
|
{User Defined Field} - {Segment Name} Division Code |
A segment type user defined field and its data. There is a separate column for each field. |
Options
Use this tab to set up any Available Options for the report.
See Report Builder Options Tab for more information on adjusting report options.
These are the available options with their descriptions for Balance Sheets reports.
|
Options |
Description |
|
Financial Statement| |
Select a segment to substitute for the General Ledger segment, or leave it at the default, None. The GL Code or GL Group Code must be selected in the Report Body in order to use this option. Selecting a group code is the same as filtering by group code on the entire report. |
|
Financial Statement| |
Select this option to determine the statement level to print to. These levels (1-3) were created when the section titles were entered using the using Financial Statement Formats in the Report Builder Setup Tab. |
|
Include| |
Select this option to have the EN (Encumbrance) and RV (Reserve for Encumbrance) accounts display in your format with the appropriate amounts. Whether the box is checked or not, this Encumbrance information is only available if you have set up the report format to include Encumbrance amounts using Financial Statement Formats in the Report Builder Setup Tab.. |
| Include| Unposted Transactions |
Select this option to include unposted transaction sessions. You can view how unposted transactions affect the detail balance information. When this option is selected, "Unposted Transactions Included in Report" prints in the report header. |
|
Include|Year End Adjustments |
Select this option to mark the entry type as A (Year End Adjustments). The entry is posted to the last day of the fiscal year. It allows the user to make year-end adjustments and print reports including or excluding an adjustment. |
|
Miscellaneous| |
Select this option to suppress any activity lines and Show Totals in the financial statement that net to a zero value. Totaling lines, as designated by the Financial Statement Format, will not be suppressed even if they net to a zero value. If it is not selected, every line prints, even if it has a zero value. |
|
Miscellaneous| |
Select this option to round the amounts to the nearest whole number when printing the report. Select "None" to not round the amounts. |
| Security|Do Not Allow Changes to this Report | Select this option to lock the report and disallow changes. |
Layout
Use this tab to change the font and page setup for a report.
See Report Builder Layout Tab for more information on adjusting the report layout.