Balance Sheet
The Balance Sheet workbook presents a standard balance sheet statement for a selected fiscal period, including Assets, Liabilities, and Equity. It displays the current year alongside the previous year for the same period, with both Actual and Budget figures and their variances, so you can assess financial position and track year-over-year changes in one view.
Selection page
When you open the workbook, the Selection Page appears before the workbook loads. You can also click the Selection Page sheet at any time to update your parameters directly.
- Fiscal Year
- Fiscal Period
- Company
- Department
- Cost Center
Balance Sheet
The report shows account balances for the selected period across two year columns: the current year and the prior year. Each year includes the following columns.
- Actual: actual balance of each account for the selected period.
- Budget: budgeted balance of each account for the same period.
- Var $: variance between actual and budget, calculated as Actual - Budget.
- Var %: percentage variance between actual and budget, calculated as (Var $ / Budget) x 100.
Mapping
The balance sheet is organized into sections such as Current Assets, Fixed Assets, Liabilities, and Equity. Each section is linked to an Account Grouping that determines which accounts appear in that section and how totals are calculated. Two mapping tables control this structure. In most cases, these tables should not be modified. Changes are typically only required if your Sage 200 account structure differs from the default setup or if accounts are appearing in the wrong section.
The first table defines the main balance sheet sections and is refreshed manually when account group assignments change in Sage 200.
| Account Grouping Description | Account Grouping |
|---|---|
| Current Assets | KPI_CURRENT_ASSETS |
| Fixed Asset | KPI_FIXED_ASSET |
| Current Liabilities | KPI_CURRENT_LIABILITIES |
| Long-Term Liabilities | KPI_LONG_TERM_LIABILITIES |
| Equity | KPI_EQUITY |
The second table controls which accounts are extracted and feeds the balance sheet dynamically. Update this table if specific account groupings need to be added or adjusted.
| Account Grouping Description | Account Grouping |
|---|---|
| Accounts Payable | KPI_AP |
| Accounts Receivable | KPI_AR |
| Accrued Expenses | KPI_ACCRUED_EXPENSES |
| Assets | KPI_ASSETS |