There are several different balance sheet layouts available:
Balance Sheet Analysis - This page is available in individual organisations within Spotlight Reporting, and in both individual and group reports in Spotlight Multi. In a group report, this page shows consolidated figures for all entities in the group.
Group Balance Sheet Analysis - This page is available in group reports in Spotlight Reporting. It shows consolidated figures for all entities in the group.
Entity Balance Sheet Analysis - This page is available in group reports in Spotlight Reporting. It shows a side-by-side comparison for all entities in the group.
Balance sheet page settings
If you prefer, you can change the format of the balance sheet in several ways.
To access the settings
From the Customise Layout tab, locate the Balance Sheet page, then click Customise.
To open the settings, click Show Settings.
The options available
Balance Sheet Format
You can choose between the standard format and alternative format.
Standard Layout - This layout is typically used within the Australia and New Zealand. It is structured in the following order:
Total Current Assets Total Assets Total Current Liabilities Total Liabilities Net Assets Equity
Alternative Layout - This layout is typically used within the UK and is structured in the following order:
Total Current Assets Total Current Liabilities Net Current Assets Total Assets less Current Liabilities Net Assets Total Capital and Reserves
Detail Level
There are different detail levels to choose from:
Note: If your detailed report shows the Spotlight Display Names instead of the account names, this means that you have manually changed these to custom names. When using custom Spotlight Display Names, these overwrite the default Display Names applied by Spotlight.
Summary with charts - This option uses the Spotlight Display Names to produce the accounts on the report. There are also three standard charts at the bottom of the report page. If required, you can change these charts.
Summary only - This option uses the Spotlight Display Names to produce the accounts on the report. The table used in this report is the same table used above, however, there are no charts included on this report page.
Detailed - This report provides a full breakdown of accounts on the report using the account name imported from your data source. This version of the report requires more space, so no charts are included on this report page.
Column Groups
The column group is used to select the columns you would like appearing on the PDF report page, there are four column groups to choose from:
Note: You can have a maximum of seven columns going across the page.
Now - One column showing the current year to date figure, up to the current month.
Actual vs last year to date - A group of three columns, the first showing last year's year to date figures, second showing the difference between this year and last year as a currency variance and the last column showing the difference between this year and last year as a percentage variance.
Last 3 months - A group of three columns, showing the past three months periods based on the report date. Values in these columns are monthly values. For example, if your report date is currently set for April, the columns will show the monthly values for January, February and March.
Year-End Analysis - A group of three columns - Last EOFY, Variance and Variance %. The first column shows the annual total for last financial year, the variance shows the currency variance and the variance % column shows the variance values as a percentage.
Monitors
There are two monitors available. If you prefer not to see these, you can turn them off. To do this, clear the Show Monitors check box.
CAPEX - The CAPEX monitor includes all accounts with the ASS.NCA.FIX.OWN report code, with the exception of accounts using the ASS.NCA.FIX.OWN.ACC report code.
Note: CAPEX values only appear if there has been a movement from the final balance of the last financial year to the current month balance.
Debt Monitor - The Debt Monitor uses accounts with the following report codes for its information:
Accounts Payable - All accounts with the code LIA.CUR.PAY Current Loans - All accounts with the code LIA.CUR.LOA, minus any accounts with the code LIA.CUR.LOA.UNS Shareholders - All accounts with the codes LIA.CUR.LOA.UNS and LIA.NCL.LOA.UNS Taxes - All accounts with the code LIA.CUR.TAX Term Loans - All accounts with the code LIA.NCL.LOA, minus any accounts with the code LIA.NCL.LOA.UNS Other - All other codes in the liabilities (LIA) section.
Customise Rows
Within this option, you can set the Rounding Account as visible or not visible. You can also change the terminology used in the account name and/or select whether it appears as an Asset or Liability.
Note: You cannot delete rows from the Balance Sheet.
Rounding balances
All Spotlight products work on Swedish Rounding, so when we import the values into the system we round every balance to the nearest whole number. This rounding may cause Net Assets and Equity to fall slightly out of balance, so to prevent an imbalance any difference is applied to the rounding account.
If the rounding line holds a large balance, it can mean that there was an issue with the values in the Balance Sheet. Either the values did not balance initially when imported into Spotlight, or the values have been manually adjusted in Spotlight. To help track this down, we'd recommend comparing the reports held in Spotlight to the reports generated from your accounting system.
