Page Comparison

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 budgetYou 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

1. Click the blue plus button next to the Main tab, enter a name for the Balance Sheet tab, select Balance Sheet, then click Add.

   Image Added

2. 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 Balance Sheet stream and templateFinancial Statements module. If your organization only uses one Balance Sheet template, it will be applied by default.

3. Set the Balance Sheet budget hierarchy (determines how the dimensions are grouped in your workbook):

   1. Select the dimension you want to sit at the top level in your budget hierarchy.

   2. Add lower levels, if required: Click the blue plus button , then select the dimension you want to add at that level.

   3. 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.

4. Select the Cash Flow option, if required.

5. Select the Opening Balance stream and , period end date (this date must be before your budget period start date) and measure.

6. Click Create Balance Sheet.

Image Removed

Get familiar with the Balance Sheet tab

1. 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.

   Image Added

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.

1. Opening balance column with data brought in from the selected stream.

2. Adjustments column where you can enter adjustments.

3. Adjusted opening column displays the new opening balance after your adjustments are taken into account.

4. 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.