Skip to main content

Next Generation - The Balance Sheet Summary enquiry

All our Profit and Loss, Balance Sheet, Trial Balance, and Not For Profit Summary enquiries share the same screens and the same functionality for consistency purposes.
For more information on the layout and the functionality of the screen please refer to profit and loss summary enquiry.

The purpose of the balance sheet is to provide a snapshot of your company's financials position as at a specified point of time.

The treatment of a nominal account within the balance sheet as an asset or liability account is determined by the Major Heading assigned to each nominal account.

You can only see nominal accounts which are assigned to a balance sheet type major heading. These are major heading 7 to major heading 12.

For more information, please refer to default Major Headings and Reporting Codes.

Note: Any nominal account that has been set up with the Allow Zero Budgets option selected will always be included in the P&L and Balance Sheet enquiries regardless of the Include Zero Lines option on the Advanced Filter panel.


The year and period fields default to the current working or open period and can be changed.

The Balance Sheet Summary Enquiry grid in more detail:

Field

Description

Place value or Units

  • Drop-down list for the value of a digit according to its position in a number such as:

    • Tens

    • Hundreds

    • Thousands

    • Millions
      Note: Only changes the view of the enquiry and does not pull through to the excel report.

Decimal place number

  • Drop-down list that changes the number of decimal places displayed dependent on your selection of a number from one to eight.

Note: Only changes the view of the enquiry and does not pull through to the excel report.

Saved Filters

  • A list of saved filters that are available.

  • Filters are saved using the advanced Filter pane, for more information please refer to how to use the advanced filter.

Cog

  • Contains a list of actions which can be carried out on the enquiry.

  • Configure Columns - Customise the displayed columns in the best order to suit your needs. For more information please refer to Configure Columns

  • Clear Criteria - Clears all the filter criteria that you have added directly for a column displayed. Doesn't clear the filter you have added to the Advanced Filter panel.

  • Export to Excel - Full Summary - Exports all transactions for all your nominal categories in expanded mode.

  • Export to Excel - Current View - Exports all transactions displayed on the enquiry in collapsed mode.

The Balance Sheet Summary enquiry headings are as follows:

Headings

Description

Fixed Assets

  • Includes all nominal accounts where the major heading is 7.

Intangible Assets

  • Includes all nominal accounts where the major heading is 8.

Current Assets

  • Includes all nominal accounts where the major heading is 9.

Current Liabilities

  • Includes all nominal accounts where the major heading is 10.

Total Assets Less Current Liabilities

  • Calculated as (Fixed Assets + Intangible Assets + Current Assets) - Current Liabilities.

Long Terms Liabilities

  • Includes all nominal accounts where the major heading is 11.

Net Assets

  • Calculated as Total Assets less Current Liabilities - Long Term Liabilities.

Capital Employed

  • Includes all nominal accounts where the major heading is 12.

Profit and Loss for Year

  • Calculated as Net Assets - Capital Employed.

Did this answer your question?