Back to Recent changes >

CASH FLOW (09 November 2006)

This new facility is in Ledger – Money – Cash Flow.

It provides a simple method of viewing the projected cash flow for the company using figures from various types of record which are present in the system i.e. customer and supplier invoices, automatic customer and supplier payments, journal entries, input/output VAT, and manual adjustments.

The initial screen lets you chose which bank accounts are relevant. The current balance for the selected account(s) will be the starting figure for the cash flow projection. You can also select whether or not you want to include the sales and purchase ledger invoice amounts. Both the sales and purchase invoices are assumed paid on their due date and therefore included in the ‘in’ or ‘out’ column for the appropriate week.

If your business does not involve credit accounts, or you don’t want to rely on the invoice payment dates, you can use manual entries as an alternative; either for the sales or purchase ledger or both.

Clicking the tab ‘show cash flow’ gives a grid, with each row representing a week (with ISO week number) and columns for IN, OUT and BALANCE. The grid will go as far out into the future as you have entries. The cash flow can also be displayed in graphical form.

You can view the individual entries that go into a week. This screen also has the option to create manual entries, each of which is simply a date and amount with a note to say what it is plus whether ‘in’ or ‘out’. When setting up a manual entry you can get the system to repeat it n times either weekly or monthly. Manual entries can be adjusted and deleted when no longer relevant.