Edit the Balance Sheet budget
Typically, you edit the Balance Sheet budget in the same way you edit other types of budgets, by directly entering in new values or using formulas. However, the Balance Sheet budget has some unique characteristics:
You will notice that the values in most account rows look the same across the periods. This is what keeps the Balance Sheet in balance.
There are two accounts in which the values move in each period:
Cash - Adjusts with any movements in the Balance Sheet.
Retained Earnings (account you selected in the budget setup) - Adjusts with the movements in the profit in the Profit and Loss budget (Main tab).
When you edit a cell in a Balance Sheet budget, the values in the period cells to the right of that cell update accordingly. You will also see movement in the Cash account row and, if you opted to create a Cash Flow budget, you will see your changes there.
As with other types of budgets, when your Balance Sheet budget is complete, you can publish it to a stream so that is is available for use in the Financial Statements module.
You cannot edit the Cash Flow budget, as it is derived from the Profit and Loss and Balance Sheet budgets. Any changes you make to those two budgets are automatically reflected in the Cash Flow budget.
Adjust the opening balance
Click the Adj Opening button to display the Adjustments column.
Expand the row in which you want to enter the adjustment.
Enter the adjustment (value) into the Adjustment cell in the required row and press Enter.
Enter budget values
You can edit the budget worksheet in the same way you edit the main budget worksheet, which means you can enter new values into any of the yellow cells. In particular, you might want to:
Use formulas to calculate values.
Use drivers to refer to a manual entry tab or other database sources.
Use workflows to collaborate with other users and delegate tasks.
Add an adjustment row
An adjustment row is unique to the Balance Sheet budget. It allows you to change the values in the row above it. You can enter values directly into the adjustment row or link it to the Profit and Loss budget. A hidden sum row sits under the adjustment row, which references the column on the left and as a result, the values in all the columns to the right update accordingly.
Expand the applicable account group row and locate the account for which you want to add the adjustment.
Hover over the account name and click the blue Add button that displays. An adjustment row displays underneath the account row.
Enter a name for the adjustment row.
Enter the adjustment value in the applicable period cell and press Enter.
Publish a Balance Sheet budget
You can publish your Balance Sheet budget as a stream in the underlying database, either as an existing stream or a new stream. See Publish a budget workbook.
View the Balance Sheet (and Cash Flow) budget in Financial Statements
After you publish the Balance Sheet budget as a stream, you can add it to a budget package in Financial Statements. See Manage budgets (in Financial Statements).
As the Balance Sheet stream uses 'balance brought forward’ logic, the opening balance is published, along with the movements for the period, so that you can view the balance sheet position at the relevant date in Financial Statements.
When you link the Profit and Loss and Balance Sheet budgets in a budget package in Financial Statements, the Cash Flow budget is derived automatically for you.