S2S Balance Sheet Report

This financial statement has the following features:

  • Currency symbol display. Select Display Currency Symbol in the reporting definition to enable this feature.
  • Collapsible rows and groups. Select Allow Expand and Collapse in the reporting definition to enable this feature.
  • Retained earnings. Historical profit that is not brought forward is displayed in the Retained Earnings section (if you import the reporting definition).
  • Two sets of variance and variance percentage calculations. Columns A to D are used for variance calculations. To ignore variance calculations, the first column must be column E.
  • Rows 21 to 90 show reversed signs (credits are displayed as positive and debits are displayed as negative).
  • Only row totals are displayed for rows 91 to 99.

S2S Trial Balance Report

Refer to the reporting definition data sheet below for information about how this financial statement is calculated. The display names of labels, rows, and columns are user-defined.

Reporting Definition Data Sheet

Item

Type

Key

Calculations
Current Assets Row R01 The sum of reporting balances from the Current Assets trial balance 2.
Fixed Assets Row R11 The sum of reporting balances from the Fixed Assets trial balance 2.
Intangible Assets Row R13 The sum of reporting balances from the Intangible Assets trial balance 2.
Total Assets Label L12 The sum of rows 1 to 20.
Current Liabilities Row R21 The sum of reporting balances from the Current Liabilities trial balance 2.
Long Term Liabilities Row R31 The sum of reporting balances from the Long Term Liabilities trial balance 2.
Total Liabilities Label L13 The sum of rows 21 to 40.
Stockholders Equity Row R41 The sum of reporting balances from the Shareholders Funds trial balance 2 excluding the Retained Profit general ledger account.
Retained Earnings Row R91 The sum of reporting balances excluding general ledger accounts of type Balance Sheet.
Total Equity Label L14 The sum of rows 41 to 90.
Total Liabilities and Equity Label L15 The sum of rows 21 and higher.
Current YTD Column A The sum of reporting balances from all periods up to and including the current period.
Last YTD Column B The sum of reporting balances from the previous year up to and including the current period.
Variance Label L20 Column A minus column B.
Variance % Label L22 Column A minus column B divided by column B.
Variance Label L21 Column C minus column D.
Variance % Label L23 Column C minus column D divided by column D.