When you create a Balance Sheet budget, a new tab is added to your budget workbook for that Balance Sheet budget. If you opted to add a Cash Flow budget, an additional tab is added for that budget.
Balance Sheet budget
Click the Balance Sheet tab (its name depends on whatever you called it) to view the budget, which has the following key elements, as identified by the numbers in the image below.
Opening balance column - Contains the data brought in from the selected stream.
Adjustments column - Contains editable cells where you can enter adjustments to reset opening balance.
Adjusted opening balance column - Displays the new opening balance after your adjustments are taken into account.
Period columns (grid) - Contains with budget data based on the selected stream. The data in each column references the data in the column to its left. For example, January 2021 references the Adjusted Opening column and February 2021 references January 2021. For this reason, you might notice that the values in many of the columns are the same. If you enter a value in a cell, you will see that everything to the right of that cell will change.
Retained Earnings row - Displays the movement in the Profit and Loss value. The values come from the Net Profit After Tax value in the Profit and Loss statement on the budget’s Main tab.
The account that is selected in the Retained Earnings section of the Balance Sheet setup is labelled P&L Movement. This account row also displays with a white background, as the values cannot be edited. This is where the profit or loss from the applicable dimension (AUS in image below) is allocated in the Balance Sheet.
The account that is selected in the Cash Mapping section of the Balance Sheet setup displays with a white background, as the values cannot be edited. The values in this account row are automatically adjusted to offset any changes you make in the Profit and Loss and/or other Balance Sheet accounts.
Cash Flow budget
Click the Cash Flow tab (its name depends on whatever you called it) to view the budget, where you can see the derived budget values.
