Balance Sheet - Rolling 12 Month

The Balance Sheet - Rolling 12 Month workbook shows the ending balance of every account across the last 12 fiscal periods from the selected date, also referred to as Trailing 12 Months (TTM). Each column represents one period, giving a month-by-month view of how assets, liabilities, and equity have moved over time.

Selection page

When you open the workbook, the Selection Page appears before the balance sheet loads. Fiscal Year and Fiscal Period are required fields and must be completed before you can proceed. All other filters are optional and help you narrow the results.

• Company: the company to report on.
• Fiscal Year: the fiscal year of the most recent period in the 12-month window. (required)
• Fiscal Period: the period used as the end point of the 12-month window. (required)
• Segment 02
• Segment 03
• Segment 04
• Segment 05
• Segment 06

Rolling 12 month report

The report shows account balances organized into Assets, Liabilities, and Equity. Each column represents one fiscal period within the 12-month window, labeled in YYYY-MM format. The Total column on the right sums all periods in the window.

• [Period]: the ending balance of each account as of the close of that fiscal period.
• Total: the sum of all 12 period balances for each account.

Mapping

The balance sheet is organized into sections such as Current Assets, Liabilities, and Equity. Each section is linked to a Sage 100 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 account groups differ from the default setup, for example if you use different group codes or notice accounts appearing in the wrong section.

Account Group Description	Account Group Code
Current Assets	000
Property, Plant And Equipment	150
Other Assets	180
Current Liabilities	200
Long Term Liabilities	275
Equity	300
Cost of Goods Sold	450
Current Assets	000
Current Liabilities	200
Equity	300
General & Administrative Expenses	700