Balance Sheet (MoM & YoY)

The Balance Sheet (MoM & YoY) workbook shows a standard balance sheet as of a selected date and includes both Year-over-Year (YoY) and Month-over-Month (MoM) comparisons. Year-over-Years columns compare balances to the same period in the prior year, while Month-over-Month columns compare balances to the immediately preceding period. This format helps finance teams quickly spot movements in Assets, Liabilities, and Equity and understand which sections and accounts are driving the change.

Selection page

The Selection Page appears when you open the workbook and lets you choose what you want to see before the Balance Sheet loads. In this workbook, Run As Date and Reporting Book are required (shown in grey) and must be completed before you can confirm. You can optionally narrow the results using the other dimension filters. This helps you get the right view right away without editing the workbook.

• 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 prevent mixing currencies in the same workbook.
• Department
• Project
• Customer
• Product Line
• Class

Balance sheet

The report shows your balances as of the selected date, with two comparisons separated in two main columns with their subcolumns.

As of Current Period

• 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 period.
• Var $: absolute dollar variance between the TY and LY balances.
• Var %: percentage change between TY and LY, calculated as (TY - LY) / LY * 100.

Prior Period

• PP (prior period): balance as of the prior period.
• Var $:
• Var %:

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 them to make sure they match what you intended. If something is off, return to the Selection Page, update your selections, and confirm again. Only the blue cells can be edited and all other values are from the selection page.

Report Setting	Description
Reporting Book	Cannot be changed.
Adjustment Book	Cannot be changed.
Combine Reporting and Adjustment
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 any child values under the dimension you chose (for example, a parent department and all of its sub-departments). If a dimension does not 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.). This mapping links each section to a Sage Intacct Account Group, which tells the workbook which accounts belong in that section and what to total together. You typically update this mapping only if your Intacct Account Groups are different from the default setup (for example, you use different group IDs, you renamed/rebuilt your financial statement groups, or accounts are appearing under 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