Cash flow

The total balance for the selected bank accounts at this date.

The total of all regular payments from recurring bank payments, recurring journal credits, and recurring purchase payments on account.

The total value of all forecast payments, such as purchase invoices and entries with a credit value.

The total value of all regular receipts for the selected bank accounts.

The total value of all forecasted receipts, such as sales invoices, and entries with a debit value.

The closing value for the bank accounts selected for inclusion in the cash flow. This calculates as:

Book balance for Bank Accounts + ((Regular Receipts + Forecast Receipts) - (Regular Payments + Forecast Payments))

The account reference of the bank account.

The name of the bank account.

The current balance of the bank account.

Any minimum limit you have set up for the bank account.

Tip: You can assign a minimum limit to a bank account in the Bank Record.

Select this box if you want to include the bank account in the forecast.

The date that the payment or receipt of the transaction is expected to be made. Sales invoices use the following calculation for this date:

Due date + average number of days that it usually takes the customer to pay.

All other transactions default to the due date.

The date that this transaction was due. You cannot change this date.

The details on the transaction.

The number of days difference between the current software date and the due date.

If the transaction is in dispute a 'd' shows.

Note: Any transaction that has been flagged as disputed is not included in the cash flow forecast but it appears in the list.

To include the disputed transaction, select the Include check box for the transaction.

To include the entry in the cash flow, select this check box.

The amount outstanding on the transaction if the transaction is a sales invoice, recurring bank receipt, recurring journal debit or recurring customer receipt on account.

Note: You can only change the amount in this column if the transaction is a manual entry.

The amount outstanding on the transaction if the transaction is a purchase invoice, recurring bank payment, recurring supplier payment on account or recurring journal credit.

Note: You can only change the amount in this column if the transaction is a manual entry.

The running total of the forecast balance for each day. The last transaction for the day shows the total.

Note: By default, your cash flow sorts by the Forecast Date column. If it is sorted in a different order, nothing appears in this column.

This balance calculates as:
Opening Balance for the day + total Debit Amount for day - total Credit Amount for day

If this balance is less than zero, or below the minimum limit for the bank, the value appears in red.

Enter the date when you expect to actually receive or make the payment.

Enter an account reference.

Enter a description.

To include the entry in the cash flow, select the check box.

Enter the amount of a sales invoice, bank receipt, journal debit or customer payment on account.

Enter the amount of a purchase invoice, bank payment, journal credit or supplier payment on account.