Balance Sheet (MoM & YoY)

The Balance Sheet (MoM & YoY) workbook shows a standard balance sheet as of a specific date, with both Year-over-Year and Month-over-Month comparisons. Year-over-Years columns compare each balance to the same period in the previous year, while Month-over-Month columns compare it to the period right before it. This layout helps finance teams quickly spot movements in assets, liabilities, and equity and understand which accounts are driving the changes.

Selection page

When you open the workbook, the Selection Page appears before the balance sheet loads. Run As Date and Reporting Book are required fields and must be completed before you can proceed. All other filters are optional and help you narrow the results.

• Run As Date – the "as of" date for the balance sheet. (required)
• Reporting Book – the primary reporting book used for balances. (required)
• Adjustment Book
• Location – select a single location to avoid mixing currencies. (required for multi-currency)
• Department
• Project
• Customer
• Product Line
• Class

Balance sheet

The report shows account balances as of the selected date and includes two comparison blocks: Year-over-Year on the left and Month-over-Month on the right.

As of Current Period

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): balance of the same account for the equivalent period in the previous fiscal year.
• Var $: dollar change between TY and LY (TY - LY).
• Var %: percentage change between TY and LY, calculated as (TY - LY) / LY * 100.

Prior Period

Compares the selected period to the immediately prior period.

• PP (prior period): balance as of the prior period.
• Var $: dollar change between TY and PP (TY - PP).
• Var %: percentage change between TY and PP, calculated as (TY - PP) / PP * 100.

Parameters and mapping

Parameters

The workbook displays the key dates and settings used to generate the balance sheet, including the as-of date, comparison periods, books, and any active filters. Review these values to confirm they match your selection. If something looks incorrect, return to the Selection Page, adjust your choices, and reopen the workbook. Only blue cells are editable. All other values come directly from the selection page.

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, combines the Reporting Book and Adjustment Book into a single set of balances.
Statistical Accounts	Controls whether statistical accounts are included. These accounts store non-financial values such as quantities and do not represent GL transactions. Options: Exclude (default), Include, Only.

For each dimension filter such as Location, Department, or Project, you can choose whether to include sub-dimensions. Enable this option when you want the selection to cover all child values under the selected dimension, for example a parent department and all of its sub-departments. If a sub-dimension toggle is not available, it means no hierarchy exists for that dimension in Sage Intacct.

Mapping

The balance sheet is organized into sections such as Current Assets, Fixed Assets, Liabilities, and Equity. 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 only need to update this mapping if your Intacct account groups differ from the default setup, for example if you use different group IDs, have renamed your financial statement groups, or notice accounts appearing in the wrong section.

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