Balance Sheet - Rolling 12 Month
This report shows the Balance Sheet Statement for the last 12 months (from the selected period), showcasing the ending balance of each account, which is also known as Trailing 12 months (TTM).
Key metrics at a glance:
- Year-Month: This column shows the Ledger Posting of each account for the period.
Mapping and Filtering
Mapping
The following mapping needs to be changed accordingly in the "Mapping" Sheet of each report. Note that the account mapping to each Reporting Code is defined in the Reporting Code configuration worksheet.
| Report Section | Reporting Code |
|---|---|
| Cash | KPI_CASH |
| Accounts Receivable | KPI_ACCOUNT_RECEIVABLE |
| Prepaid Expenses | KPI_PRE_PAID_EXPENSES v |
| Inventory | KPI_INVENTORY |
| Fixed Assets | KPI_FIXED_ASSET |
| Accounts Payable | KPI_ACCOUNTS_PAYABLE |
| Accrued Expenses | KPI_ACCRUED_EXPENSES |
| Tax Payables | KPI_TAX_PAYABLE |
| Intersite Clearing | KPI_INTERSITE_CLEARING |
| Retained Earnings | KPI_RETAINED_EARNINGS |
| Current Earnings | KPI_CURRENT_EARNINGS |
Selection Page:
- Company
- Fiscal Year
- Fiscal period
- Ledger
- Ledger Type
- Budget
- Mapped Dimension 1
- Mapped Dimension 2
- Mapped Dimension 3