Is it a driver?
Currently B&F only provided for budgeting of the P&L statement. Balance Sheet and Cashflow statements can be defined in Financial Statements, and the FS team have recently added the ability to have budget Balance Sheet streams uploaded from Excel/CSV. When FS has both and BS and P&L budget stream, the cashflow budget can be calculated from the other 2 statements.
We have a design for full 3-way budgeting in B&F but we could consider a cut down version where the P&L and BS are done in B&F and published to FS, and the Cash Flow budget is then derived in FS.
Currently in B&F users can add a reference only database driver that users the Balance Sheet stream, however no statement can be provided, there is not way of entering an opening balance, and the tab can not be published. An MVP could address these issues to get to a quick V1.
Create a new tab with the structure of a Balance Sheet. You can publish the Balance Sheet budget.
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 stream and template.
Select the Opening Balance stream and date (this date must be before your budget period start date).
Click Create Balance Sheet.
Get familiar with the Balance Sheet tab
The Balance Sheet budget 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.
