Balance Sheet - Rolling 12 Month
The Balance Sheet - Rolling 12 Month workbook presents a balance sheet statement across the last 12 consecutive months based on the period you select, also known as Trailing 12 Months (TTM). Each month is displayed as its own column, showing the ending balance of each account, making it easy to track how your financial position has evolved over time.
Selection page
When you open the workbook, the Selection Page appears before the workbook loads. You can also click the Selection Page sheet at any time to update your parameters directly.
- Fiscal Year
- Fiscal Period
- Company
- Department
- Cost Center
Balance Sheet
The report shows the ending balance of each account for each of the last 12 consecutive months, starting from the fiscal period you selected and going back one full year.
- Each month is displayed as its own column, giving you a continuous view of how balances evolved over time.
- Covers Assets, Liabilities, and Equity across all 12 months in a single view.
Mapping
The balance sheet is organized into sections such as Current Assets, Fixed Assets, Liabilities, and Equity. Each section is linked to an Account Grouping that determines which accounts appear in that section and how totals are calculated. Two mapping tables control this structure. Two mapping tables control this structure. In most cases, these tables should not be modified. Changes are typically only required if your Sage 200 account structure differs from the default setup or if accounts are appearing in the wrong section.
The first table defines the main balance sheet sections and is refreshed manually when account group assignments change in Sage 200.
| Accounts Grouping Description | Account Grouping |
|---|---|
| Current Assets | KPI_CURRENT_ASSETS |
| Fixed Asset | KPI_FIXED_ASSET |
| Current Liabilities | KPI_CURRENT_LIABILITIES |
| Long-Term Liabilities | KPI_LONG_TERM_LIABILITIES |
| Equity | KPI_EQUITY |
The second table controls which accounts are extracted and feeds the balance sheet dynamically. Update this table if specific account groupings need to be added or adjusted.
| Accounts Grouping Description | Account Grouping |
|---|---|
| Accrued Expenses | KPI_ACCRUED_EXPENSES |
| Amortisation | KPI_AMORTISATION |
| Accounts Payable | KPI_AP |
| Accounts Receivable | KPI_AR |
| Assets | KPI_ASSETS |
| Accounts Receivable | KPI_AR |
| Amortisation | KPI_AMORTISATION |
| Assets | KPI_ASSETS |
| Capital Expenditures | KPI_OTHER_CURRENT_LIABILITIES |
| Cash | KPI_CASH |
| COGS | KPI_COGS |
| Current Assets | KPI_CURRENT_ASSETS |
| Current Liabilities | KPI_CURRENT_LIABILITIES |
| Equity | KPI_EQUITY |
| Fixed Asset | KPI_FIXED_ASSET |
| Interest Expenses | KPI_INTEREST_EXPENSES |
| Interest Income | KPI_INTEREST_INCOME |
| Inventory | KPI_INVENTORY |
| Liabilities | KPI_AMORTISATION |
| Long-Term Liabilities | KPI_LONG_TERM_LIABILITIES |
| Net Credit Sales | KPI_NET_CREDIT_SALES |
| Operating Cash Flow | KPI_OPERATING_CASHFLOW |
| Operating Expenses | KPI_OPERATING_EXPENSES |
| Other Current Asset | KPI_OTHER_CURRENT_ASSET |
| Other Current Liabilities | KPI_OTHER_CURRENT_LIABILITIES |
| Prepaid | KPI_PREPAID_EXPENSES |
| Revenue | KPI_REVENUE |