Explore the Balance Sheet and Cash Flow budgets

Owned by Denise McGettigan
Last updated: Apr 02, 2024
3 min read

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 include a Cash Flow 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.

image-20240402-203831.png

  1. Opening balance column - Contains the data brought in from the selected stream.

  2. Adjustments column - Contains editable cells where you can enter adjustments to reset opening balance.

  3. Adjusted opening balance column - Displays the new opening balance after your adjustments are taken into account.

  4. 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.

  5. 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.

  6. Retained Earnings account row - Displays the movement in the Profit and Loss value 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 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.

  7. 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.