Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

image-20240212-234937.pngImage Added
  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 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. Retained Earnings Cash account row - Displays the movement movements in the Profit and Loss valuecash 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 Net Profit After Tax value change in EBITA in the Profit and Loss statement on the budget’s Main tab, so you can’t edit them, as indicated by the white background.

Image RemovedThe account that is selected
  1. The values automatically adjust to offset any changes you make in the Profit and Loss and/or other Balance Sheet accounts.

    Image Added
  2. Retained Earnings account row - Displays the movement in the Profit and Loss value in the Retained Earnings

section of
  1. account you mapped in the Balance Sheet setup

is labelled P&L Movement. This account row also displays with a white background, as the values cannot be edited
  1. . 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.

Image Removed
  1. Image Added
  2. The

account that is selected in the Cash Mapping section of the
  1. 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.Image RemovedThe Balance Sheet
  1. 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.

Image RemovedImage Added