You can add a tab in your Profit and Loss budget workbook in which you can created your Balance Sheet budget. If required, you can derive your Cash Flow budget from the Profit and Loss and Balance Sheet budgets. You can then publish those budgets as streams in the Financial Statements module.
Add a Balance Sheet tab
Click the blue plus button
next to the Main tab, enter a name for the Balance Sheet tab, select Balance Sheet, then click Add.
Select the Balance Sheet template. This setting determines the layout of the budget. The options available depend on the types of Balance Sheet statements your organization has created in the Financial Statements module. If your organization only uses one Balance Sheet template, it will be applied by default.
Set the Balance Sheet budget hierarchy (determines how the dimensions are grouped in your workbook):
Select the dimension you want to sit at the top level in your budget hierarchy.
Add lower levels, if required: Click the blue plus button
, then select the dimension you want to add at that level.Reorder the levels, if required: 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.
Select the Cash Flow option, if required.
Select the Opening Balance stream, period end date (this date must be before your budget period start date) and measure.
Click Create Balance Sheet.
Proceed to explore your new 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.
Explore the Balance Sheet budget
Click the Balance Sheet tab to view the budget, which has the following key elements, as identified by the numbers in the image below.
Opening balance column with data brought in from the selected stream.
Adjustments column where you can enter adjustments.
Adjusted opening column displays the new opening balance after your adjustments are taken into account.
Period columns
The data in every 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.
If you enter a value in a cell, you will see that everything to the right of that cell will change.
Add an adjustment line
Gives you the ability to change the value above it
A hidden sum row sits under the adjustment line that references the left column and as a result, the data in all the columns to the right of that column updates accordingly.
View Retained earnings
The Retained Earnings (P&L Movement) value in the Balance Sheet is automatically inserted for you. This value comes from the Net Profit After Tax value in the Profit and Loss statement on the Main tab.
The Shareholder Equity plus the P&L Movement gives you the value for the next column.
You can also add adjustment lines in this section of the Balance Sheet.
Other
You can reorder dimensions, add comparison rows.
Publish a balance Sheet
You can publish your Balance Sheet budget to a stream.
Publishing a balance sheet is slightly different than publishing a budget. Instead of publishing the raw values which are in the cells, we have to publish the difference between where you are versus where you came from. So, for example, if I was published in the value for Feb 2021, I came from Jan 2021, and the difference here is zero. So I would publish a zero for Feb 2021.
