2Step | Notes |
---|
1 | Click the blue plus button next to the Main tab, enter a name for the Balance Sheet tab, select Balance Sheet, then click Add. | template Balance Sheet budget. The options available depend on the types of Balance Sheet statements If your organization only uses one Balance Sheet template, it will be applied by default. 3 | levels, as required: Add levels: Click the blue plus button , then select the dimension you want to add at that level.
Reorder the : Click and hold the level's Move button (a blue box displays around the row), then drag the level up or down to its new positionThis setting determines how the dimensions are grouped in your Balance Sheet budget. cannot this other dimensions as lower levels. The dimensions that are available in the list depend on how you set up the Profit and Loss budget.4 | (Optional) Select the Cash Flow template. | This setting creates a Cash Flow budget on a separate tab in the workbook. The values in the Cash Flow budget are automatically derived from the values in the Profit and Loss and Balance Sheet budgets. The budget hierarchy levels are inherited from the Balance Sheet budget but if available, you can add custom levels which will help you to group your Cash Flow statement. |
5 | from6 | the period end main Profit and Loss November 2022 to October 2023 period end prior to October 2022 tracked7 in the main Profit and Loss budget.8 | Review the Retained Earnings account code and change it, if required. | By default, the Retained Earnings General Ledger account code is selected for you, as it is linked to the Balance Sheet template you selected in step 2. This setting determines the account code Profit and Loss budget is allocated.9 | Click Next. | 10 | Map the cash accounts to bank codes consolidate 11 | Click Create Balance Sheet. | 12 | budget worksheet(s). A new tab is added to your budget workbook for the Balance Sheet budget. If you opted to add a Cash Flow budget, an additional tab is added for that budget. | Image Removed