Balance Sheet - MoM & YoY Comparison
This report presents a standard Balance Sheet statement with both Year-Over-Year (YoY) and Month-Over-Month (MoM) comparisons.
It allows users to analyze how account balances have changed compared to both the same period last year and the immediately preceding period, helping finance teams quickly identify balance fluctuations and trends.
Key metrics at a glance:
- TY (This Year): Displays the actual balance of each account as of the selected reporting period.
- LY (Last Year): Displays the balance of the same account for the equivalent period in the previous fiscal year.
- Var $: Shows the absolute dollar variance between the TY and LY balances.
- Var %: Shows the percentage change between TY and LY, calculated as (TY - LY) / LY * 100
Mapping and Filtering
Mapping
All the reports in the Balance Sheet section have the same report structure that can be customized based on the Account Grouping of Sage Intacct.
The following mapping needs to be changed accordingly in the "Mapping" Sheet of each report.
| Report Section | Account Group |
|---|---|
| Current Assets | 3 |
| Fixed Assets | 5 |
| Other Assets | 8 |
| Current Liabilities | 4 |
| Long Term Liabilities | 7 |
| Capital Stock | 1 |
| Retained Earnings | 23 |
| Current Profit/Loss | 21 |
Selection Page:
- Run As Date
- Reporting Book
- Adjustment Book
- Location
- Budget ID
- Department
- Project
- Customer
- Product Line
- Class