The opening balance for the cash flow is always the amount shown in the total column of the balance row. This is the cell in the bottom left corner of the spreadsheet. If any reconciled accounts have been selected to use, the cash flow balance will be the total of all the reconciled account balances. If no accounts have been selected to use than the total cash flow opening balances can be entered direct.
To enter or edit the cash flow opening amount if there are no accounts enabled for this budget, then:
1.Select the Opening Balance option from the Setup menu. The amount shown in the new window is an editable version of the Opening Balance.
2.Type in the new opening balance for the spreadsheet and press the Enter key. When accounts are enabled, the opening balance for each account is displayed in the Total column of each account row.
To select reconciled accounts for use in the budget and enter opening balances:
1.Select Use Accounts from the Setup menu.
2.Tick the required accounts
3.Click OK
4.Select the Opening Balance option from the Setup menu. You will then be shown a window that lists the opening balance for each enabled bank account.
5.Type in the new opening balance for each bank account and then press the Enter key. The new opening balance is saved when you save the spreadsheet. The final cash flow balance will be the total of the reconciled accounts opening balance.
