Reports - Financial - Balance Sheet Statement

Overview

This report presents balances of all Asset and Liability account types formatted as a Balance Sheet as of a specified Fiscal Period.

Roles

This report is available to users having any of the following roles:  Administrator and GL Viewers.

License

This report is available with the Project Financials family of Unanet licenses.

Topics covered on this help page include:

• Selection Criteria   (options available to tailor report output)

• Example Report Output

• Report Generation Notes

• Special Entries (Retained Earnings & Net Income)

• PDF and Excel Output

Selection Criteria

Field Descriptions (click on a link below for additional information)

Example Report Output

The resulting output will resemble the following example.  

Report Generation Notes

Amount Calculation Notes:

• If the account being displayed on the line is an Asset account, the amount on the line is a sum of all (debit - credit) amounts from the GL satisfying the selection criteria.
• If the account being displayed on the line is a Liability account, the amount on the line is a sum of all (credit - debit) amounts from the GL satisfying the selection criteria.
• The group Total is always a sum of all (debit - credit) amounts being included in the group, and if the header level account is a Liability account, the total will be multiplied by (-1).

Report Column Notes:

Based on the specified choices in the Column Options and Comparison Column Options, the following columns may potentially be included in the output:

• As Of period end date amount is always included, regardless of the search criteria options.
• • The amount includes all charges for the account and /or org posted to the GL  through the end of the fiscal period end date.
• As Of previous fiscal year end date amount is included if Show Balance Through Previous Fiscal Year End option is selected.  
• • The amount includes all charges for the account and /or org posted to the GL through the end of the previous fiscal year.
• As Of last year's period end date is included if Compare Actuals to Previous Year Actuals is selected.
• • The amount includes all charges for the account and /or org posted to the GL through the end of the corresponding fiscal period from previous fiscal year (meaning: the same number, only year before).
• As Of year before previous fiscal year end date is included if Compare Actuals to Previous Year Actuals and Show Balance Through Previous Fiscal Year End are selected.
• • The amount includes all charges for the account and /or org posted to the GL through the end of the fiscal year prior the previous fiscal year (2 years prior to the selected fiscal period).
• Budget is a budget amount for the account/org for the selected fiscal period
• Prior Year Budget is a budget amount for the account/org for the prior's year fiscal period

Report Row Notes:

This section describes behavior common to all/any criteria selection.

The report will display an account tree structure with all accounts that have charges posted to the General Ledger for:

1. Accounts of Type "Asset" and "Liability"
2. GL Organizations that belongs to the selected Legal Entity
3. The sum of all column amounts (through the selected fiscal period end, through prior year end, or budget amounts) when result is not equal to zero
4. The user running the report has access to organizations being charged in GL as a GL viewer
5. If an organization has been used to filter the data in the criteria screen, only GL charges for the selected organizations will be included in the final results.
     

1. • Account Financial Tree is always displayed in the report as a complete structure.
   • As long as an account on the lower level has a charge, all top level accounts must be displayed to show the tree structure. If a charge (with an Org belonging to the selected legal entity) has been made within the selected fiscal range, it will be displayed on the report.
   • If there is no charge that exists in the GL for the top level account, or even if the top level account is not of Type "Asset" or "Liability", it will still be displayed, but with the amount blanked out.
   • A Total will be printed at the end of each group, displaying a sum of all charges for children accounts next to the name of the parent account. Totals are preceded by an underscore.
        

The first four levels of accounts are not indented, three next levels are incrementally indented by 0.2.

If Show Organizations check box has been selected in criteria's Row Detail Options, we will list GL amounts breakdown by organization under each account (if there were any direct charges to the account in GL). The account becomes a header of the group, and at the bottom of the group we will print total of charges for the account.

If Arrange Report By: Legal Entity has been selected:
The account tree will print as is, without any additional breakdowns.

If Arrange Report By: Organization has been selected:
The account tree will be broken down into smaller sections organized by the GL's Organization. The org Name will be printed at the very beginning of each section, and PDF version of the report will do page break after each organization. "Show Organization" can still be selected, however the same org as the header's org will be printed under each account, unnecessary repeating the same information (not a recommended combination of settings for running the report).

If Arrange Report By: Organization Hierarchy Level X has been selected:
The account tree will be broken down into smaller sections organized by the GL's Organization level with the roll-up to the selected level X. For example, if we have the following org hierarchy:
1;
   1.01;
       1.01.02; 1.01.03;
   1.02;
       1.02.01; 1.02.02;

And we selected to Arrange report by org level 2, all charges for organizations 1.01.02 and 1.01.03 will be included into the 1.01 org section, and all charges for orgs 1.02.01 and 1.02.02 will be included into 1.02 org section. PDF version of the report will insert page break after each organization section.

If any account Roll-up level has been selected, we will summarize all charges for accounts at/and below the selected level, and only the Total of all charges will be printed at the roll-up level. Accounts above the roll-up level will continue displaying the sum of direct charges to the account.

Special Entries  (Retained Earnings and Net Income)

In addition to all Asset and Liability accounts that have charges in the General Ledger for the selected fiscal period, we will also include two amounts within the report body in the following way:

• Unposted Retained Earnings Entry
  • Account – the Retained Earnings account category in Admin-> Setup -> Posting Groups -> System Default posting group
  • Organization – Default GL posting organization for the selected Legal Entity
  • Amount – Sum(credit amount – debit amount) for all Revenue and Expense accounts where the Fiscal period belongs to a fiscal year prior to the fiscal year of the As of Fiscal Period and greater that the last closed fiscal year of the legal entity (Note that this does not need to be done if the prior fiscal year has already been closed)

• Current Year Net Income
  • Account – the Net Income account category setup in Admin-> Setup -> Posting Groups -> System Default posting group
  • Organization – Default GL posting organization for legal entity
  • Amount – Sum(credit amount – debit amount) for all Revenue and Expense accounts where the Fiscal period belongs to the fiscal year of the As of Fiscal Period and is less than or equal to the As of Fiscal Period

The Retained Earnings and Net Income entries will be displayed as part of the regular Financial Account Tree, and if a regular charge for the accounts exists in the General Ledger (it has to satisfy other criteria, such as account type A or L, and so on), we will add the calculated above amounts to the sum of GL charges for the account and/or organization. These entries are subject to all criteria selection described above, such as account roll-up, or Arrange By selection.

The two special records will not be included on the report if:

• the user running the report doesn't have access to the legal entity's default GL posting organization
• If previous Fiscal Year is closed, the special Retained Earnings record will not be included
• If Org filter has been applied, and the legal Entity's default GL posting org is not selected

PDF and Excel Output

On this report you will notice the pdf () and Excel () icons, which can be used to produce the report output in these alternative formats.