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 include a Cash Flow budget , an additional tab is added for that budget(for 3-statement budgeting), it displays in a separate tab.
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 with - 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 that displays - 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.
Cash account row - Displays the movements in the cash value in the Cash account you mapped in the Balance Sheet setup. Initially, this is the only row in which the values change across the period. The values come from the change in EBITA in the Profit and Loss statement on the Main tab, so you can’t edit them, as indicated by the white background. The values automatically adjust to offset any changes you make in the Profit and Loss and/or other Balance Sheet accounts.
Retained Earnings row where you can see account row - Displays the movement in the Profit and Loss value . This value comes in the Retained Earnings account you mapped in the Balance Sheet setup. The values come from the Net Profit After Tax value in the Profit and Loss statement on the budget’s Main tab, so you can’t edit them, as indicated by the white background. This is where the profit or loss from the applicable dimension (AUS in image below) is allocated in the Balance Sheet.
The Balance Sheet might also include mini driver lines.
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.
Related pages
CreateAdd a Balance Sheet ( and Cash Flow ) budgetEdit the Balance Sheet budgettab (budget owner or administrator)