Cash Flow Management and Analysis

Document path Reference Contents > Ledgers Nominal or General Ledger > Cash Flow Management and Analysis

The Cash Flow system enables you to view predicted movements of bank account cash. Having selected a bank account, the Build List button function will:

* The default bank account is that which is set in the Ledgers -- Ledger Manager -- Control Settings, Default Accounts tab pane.

If you are going to use this feature you should also be doing regular bank reconciliation using the Clear system in the Bank Account Review and Reconciliation window, otherwise the cash flow list will be unreasonably dominated by historic bank transactions.

To use this analysis tool you must first select a bank account and choose an extent which will control how far ahead the analysis will extend. Then click the Build List button.

To add a projected value, right click on the list and operate Add Entry or use the Add Entry button. You can assign an account from either of the ledgers and give any date when the cash movement is due to take place. However, the list is ordered by date AFTER the current uncleared bank account transactions recorded. Any overdue movements are indicated by red text.

Projected entries can be set to be recurring. Such entries are repeated on a the basis of the recurring cycle periods; 1 for monthly, 3 for quarterly, etc. The date after the anniversary of the period start of the entered date can be set by using the offset days field. Finally, you need to set the number of recurring occasions. For example, if you have a quarterly payment due on the 28th of the month following the quarter end and recurring over 4 years (16 periods), you would enter 3 periods, 28 days offset and 16 occasions. The system automatically ignores occurrences due prior to today and will automatically decrement down the occurrences as they drop off the calendar.

The type of entry is significant. Estimate and Firm and simple entries that are differentiated by displaying estimates in italics.

Account balance is a special type where the system populates the amount from the balance of the ledger account entered for the ledger period appropriate to the date. If the ledger chosen is either A/P or A/R, then any outstanding due amounts normally collected for these accounts are removed from the list. This is useful when a customer generally pays a months invoices at a time rather than individually. It is also useful for recording when sales tax returns are due to the revenue authority.

Split payment is also a special type which is used when an agreement has been made to split an invoice over a number of payments. This adjusts previous entries for the account with the same document reference, so you must have the correct ledger, account and document reference entered.

Field

Description

Bank account code

General Ledger Accounts.Account code (combined account group and cost centre). {GLAFILE.GLACODE char 10 Idx} You can only enter a bank account here.

Bank account reference

General Ledger Accounts. User reference. {GLAFILE.GLAUSER char 255 Idx}

Bank account currency

General Ledger Accounts. Currency of the account. {GLAFILE.GLACUR char 3} All values in the analysis will be in this currency.

Bank account description

General Ledger Accounts. Description. {GLAFILE.GLADESC char 40}

Extent

Select the extent into the future that you want a cash flow analysis.

Opening balance

Shows the opening balance before any uncleared transactions listed below. Negative is overdrawn.

Button

Action

Build List

Click to build the transaction list and cash flow analysis.

Field

Description

List

A list of system generated and entered cash flow transactions on the bank account. The following columns are shown:

Type icon

Shows the type of entry. See the legend at the bottom left corner of the window.

Memo icon

Indicates whether there is a Memo record associated with the transaction. To view a memo, select the transaction in the list and double-click on the memo icon 15031 column. You cannot add a memo from here.

Date

Transaction date.

Description

Customer or supplier name or account description.

Comment

Cash flow description or transaction comment.

Reference

Document reference.

Paid out

Payment out of the bank account (actually a credit transaction in the bank account).

Paid in

Payment into the bank account (actually a debit transaction in the bank account).

Balance

Running balance in bank account currency.

 

When you click on a list line the following fields are shown below the list for the selected line. Where the entry is a projected cash flow entry, or the first in a repeating group, you will be permitted to edit the details.

Date

Cash Flow entries. Due date or base date for type 2 and recurring. {CASFILE.CASDUED date date1980}

Ledger

Ledger part of account identifier, either R for Receivable, P for Payable or G for General Ledger.

Account code

Account code of the Customer, Supplier or G/L account.

Account name

Customer or supplier name or account description.

Recurring cycle

Cash Flow entries. Recurring period type (0 = Period-end, N = N-Monthly on due date anniversary). {CASFILE.CASRECC integer shortint}

Recurring offset days

Cash Flow entries. Payment offset days for type 2. {CASFILE.CASOFFD integer}

Recurring occasions

Cash Flow entries. Recurring occasions. {CASFILE.CASRECU integer}

Estimate

Select this option if the entry is an estimate of a future transaction.

Firm

Select this option if the entry is a firm future transaction.

Account balance

Select this option for the balance on a A/P, A/R or G/L asset account.

Linked split payment

Select this option for a split payment linked by the account and document reference.

Comment

Cash Flow entries. Comment. {CASFILE.CASCOMM char 30}

Tax regime and class

If the payment is taxed, select a regime and class. Use the delete key to clear the lists to non-taxed.

Reference

Cash Flow entries. Document reference. {CASFILE.CASDOCR char 15 Idx}

Paid out amount

Payment out of the bank account (actually a credit transaction).

Paid in amount

Payment into the bank account (actually a debit transaction).

Button

Action

Add Entry

Click to add a projected cash movement entry, copying the currently selected line. This is the same as right-clicking on the list and operating Add Entry from the context menu.

Delete Entry

Click to delete the currently selected projected cash movement entry. This is the same as right-clicking on the list and operating Delete Entry from the context menu.

Print Results

To print the cash flow analysis.

Save Changes

Click to save any changes for use in a future Cash Flow review.

Compiled in Program Version 3.10. Help data last modified 25 MAY 2004 17:38. Class wAcCashFlow last modified 5 JUL 2008 07:00:53.

Document path Reference Contents > Ledgers Nominal or General Ledger > Cash Flow Management and Analysis