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 with data brought in from the selected stream.
Adjustments column where you can enter adjustments to reset opening balance.
Adjusted opening balance column that displays the new opening balance after your adjustments are taken into account.
Period columns with 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 where you can see the movement in the Profit and Loss value. This value comes from the Net Profit After Tax value in the Profit and Loss statement on the budget’s Main tab. CHECK THIS
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.
