Select the Balance Sheet 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 levels, as required: Add : Click the blue plus button , then select the dimension you want to add at that levelThis 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.You can have less Profit and Loss budget Profit and Loss. from.6 the period end Profit and Loss November 2022 to October 2023 prior to October 2022 the main Profit and Loss budget. Map the Retained Earnings account codes in the selected dimension Profit and Loss Depending on your account structure, you can use the same General Ledger retained earnings account code for several entities or use different codes as required. retained earnings The Retained Earning Mapping screen contains a grid where you map entities on the left to the Retained Earnings account code on the right to limit the number of entities that display in the grid, .Select individual corresponding entity in the main database (in the window ) The Retained Earnings account is suggested for you and displays at the top of the list (marked with a star) but you can select a different account as required.1011 the cash accounts to bank codes consolidate The Cash Mapping screen contains a grid where you map . The process is the same as that on the previous Retained Earning Mapping screen. However, this time, it is the that are suggested for you and displays 12 Create Balance Sheet. 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.
Step
Notes
1
Click the blue plus button next to the Main tab, enter a name for the Balance Sheet tab, select the Balance Sheet tab type, then click Add.
2
3
Reorder the levels: 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 position.
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
7
8
Click Next.
9