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 | Html macro |
Select the Balance Sheet <img style="display: inline" src="https://api.media.atlassian.com/file/896b480d-6fa9-48fb-9863-f64c3e115160/image?collection=emoji-site-00847474-03e0-4098-9300-78c7fccb23e9&width=31&height=32&max-age=31536000&token=eyJraWQiOiJtaWNyb3NcL3BmLWVtb2ppLXNlcnZpY2VcL3A4dmIxcHY5dXNicnJuaGQiLCJhbGciOiJSUzI1NiJ9.eyJzdWIiOiJtaWNyb3NcL3BmLWVtb2ppLXNlcnZpY2UiLCJhdWQiOiJtZWRpYSIsImFjY2VzcyI6eyJ1cm46ZmlsZXN0b3JlOmNvbGxlY3Rpb246ZW1vamktc2l0ZS0wMDg0NzQ3NC0wM2UwLTQwOTgtOTMwMC03OGM3ZmNjYjIzZTkiOlsicmVhZCJdfSwiY2xpZW50SWQiOiJjZGEzNzUyYy1hNWE4LTRlZjMtYTAxNy03ZjliZmYwN2Q2NzciLCJuYmYiOjE2NzY5MjQwNDcsImlzcyI6Im1pY3Jvc1wvcGYtZW1vamktc2VydmljZSIsImV4cCI6MTY3NjkyNzU4NywiaWF0IjoxNjc2OTI0MDQ3LCJqdGkiOiJkOGI5NjQ0NS00NTkzLTRiMDItOThlYi0wNjk3MjZjMzYyYjEifQ.jDCE_A6UEyhjbU7uoDWb3dZjsJjHGhzZMMwVSW-S-7qgL3bpWABGjzZc6BUv6_i3kny1wWEok2W4yzqU3BHyfYSe7z2lKbZghlStU8mv3isLIVKPD_m46jcGuxloiNIYVXA79JROfbjy4kTupeVKWyCN2vIodkkF7mXFenneaEk2kWUrzp0U6_sSinESh4X5easBwgad8v1CK_KSdqFyrcwoKnKYJdWHlpH99sgZ4u6m5cbKzxoRnTueQR2VL4963t5PlRmAClkZOdwbfWiremGsXwxNWIfcXX-76Kxr5vPdl89rZhkCntb5Y8xC974xRLl9yimXs4ySReu2GRjN-A&client=cda3752c-a5a8-4ef3-a017-7f9bff07d677" >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.You can have less Profit and Loss budget Profit and Loss.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 Profit and Loss November 2022 to October 2023 prior to October 20227 | in the main Profit and Loss budget.8 | Click Next. | 9 | Map the Retained Earnings account codes in the selected dimension Profit and Loss General Ledger retained earnings account code codes no levels, such as in the case of a consolidate Balance Sheet budget, you will only have one retained earnings account to map. 10 | Click Next. | 11 | Map the cash accounts to bank codes consolidate 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.