Balance Sheet - YoY
The Balance Sheet - YoY workbook shows a standard balance sheet as of the date you select, with a built-in Year-over-Year comparison. It displays balances for this year alongside the same date last year, plus the variance in dollars and percent, so you can quickly see what changed from last year.
Selection page
When you open the workbook, the Selection Page appears. It lets you choose what you want to see before the balance sheet loads. The Run As Date and Reporting Book fields are required (shown in grey) and must be completed before you can confirm. All other filters are optional and help you narrow the results.
- Run As Date – (mandatory) the "as of" date for the balance sheet.
- Reporting Book – (mandatory) the primary reporting book used for balances.
- Adjustment Book
- Location – (required for multi-currency) select a single location to avoid mixing currencies.
- Department
- Project
- Customer
- Product Line
- Class
Balance sheet
The report shows account balances as of the date you selected, with a Year-over-Year comparison in the Year to Date columns.
Year to Date
Compares the selected as-of date to the same period last year.
- TY (this year): actual balance of each account as of the selected reporting period.
- LY (last year): actual balance of the same account as of the equivalent period in the prior fiscal year.
- Var $: dollar change between TY and LY (TY - LY).
- Var %: percentage change between TY and LY, calculated as (TY - LY) / LY * 100.
Parameters and mapping
Parameters
The workbook shows the key dates and settings it used to generate the Balance Sheet (as-of date, comparison periods, books, and any filters). Review these values to make sure they match your selection. If something looks incorrect, return to the Selection Page, adjust your choices, and open the workbook again. Only the blue cells can be edited and all other values come from the selection page.
| Report Setting | Description |
|---|---|
| Reporting Book | The main book used to calculate balances. Set on the selection page. |
| Adjustment Book | Optional adjustment book. Set on the selection page. |
| Combine Reporting and Adjustment | When enabled, the workbook combines the Reporting Book and Adjustment Book results into a single set of balances. |
| Statistical Accounts | Controls whether statistical (non-financial) accounts are included. These accounts don't represent GL transactions and often store quantities or other operational values used for reporting. Options: Exclude (default), Include, Only. |
For each dimension filter (Location, Department, Project, etc.), you can choose whether to include sub-dimensions. Turn this on when you want the selection to include all child values under the dimension you chose (for example, a parent department and all of its sub-departments). If a dimension doesn't show a sub-dimension toggle, it means there is no hierarchy available for that dimension in Sage Intacct.
Mapping
The Balance Sheet is organized into sections: Current Assets, Fixed Assets, Liabilities, Equity, etc. Each section is linked to a Sage Intacct Account Group, which determines which accounts appear in that section and how totals are calculated. You typically update this mapping only if your Intacct Account Groups are different from the default setup. That might happen if you use different group IDs, renamed your financial statement groups, or notice accounts showing up in the wrong place.
| Report Section | Account Group |
|---|---|
| Current Assets | 132 |
| Fixed Assets | 91 |
| Other Assets | 130 |
| Current Liabilities | 174 |
| Long Term Liabilities | 83 |
| Capital Stock | 107 |
| Retained Earnings | 209 |
| Current Profit/Loss | 117 |