This report presents a forecast of all actual and future payments to and from the firm during a specified period. The forecast is based on the Due Dates of Purchase and Sales Invoices. Also included are any records in the Simulation register affecting the Cash and Bank Accounts specified in the Payment Modes setting in the Sales and Purchase Ledgers. These simulated transactions would be entered in advance to reflect payments that do not occur in the Sales and Purchase Ledgers, thus rendering this report more accurate. Such Simulations can easily be converted to Transactions at the appropriate time using the 'Transactions' function on the Operations menu of the 'Simulations: Browse' window. If you have the Cheques module, you can also take Cheques and Own Cheques into account.

When printed to screen, this report has Hansa's Drill-down feature. Click on any Transaction Number in the report to open the Transaction. Invoices will be shown in the 'Invoice: Inspect' window, Purchase Invoices in the 'Purchase Invoice: Inspect' window.

Double-clicking 'Liquidity Forecast' in the 'Reports' list opens the following window:

Period

Paste Special Reporting Periods setting, System module

Enter the report period, in the format "01-02-02:28-02-02". If you are using four-digit years as in the illustration, the leading digits will be inserted automatically. If your report period is a single day, just enter the date once and this will be converted to a period format automatically. The first row of the Reporting Periods setting is the default value.

Function

Choose between the Detailed option, showing each Transaction, and the Overview, showing a single line summary for each day.

Registers

By default, the report contains the Debtors' and Creditors' forecasts and Simulations containing any of the Accounts used in the Payment Modes setting. You can exclude any of these sections from the report by clicking in these boxes. If you have the Cheques module, you can also include sections for Cheques and Own Cheques.

Status Purch. Inv.

You can choose to exclude those Purchase Invoices for which payment has been prevented (those whose Hold check box has been switched on).

Receipts, Payments

Select an alternative for the payment pattern to be used in calculating the Receipt and Payment schedule.

Net: This option assumes that payment will be received or issued on the Due Date.
Discount: This option assumes that invoices with a cash discount term will be paid by the Discount Date in order to qualify for the cash discount.
X days late: This option allows you to assume that all Invoices will be paid on average a specified number of days later than the Due Date.

Cut Names

If you are using the Detailed option, the Customer or Supplier Name will be shown for each Invoice, and each Simulation comment will be printed in full. Check this box if you would like to cut these Names and Comments so that the first 25 characters only are printed.

Cut Decimals

Check this box if you would like whole numbers only to be shown in the report. For example, an amount of 5.88 will be shown as 5 if this box is checked.

Skip Disputed Invoices

Check this box to exclude from the report Sales Invoices marked as Disputed.

This report can be a very useful tool in your liquidity management. Like all Hansa's reports it can be exported as a text file. Import the data to an Excel model, and use Excel's excellent graphing capabilities to produce a graph of the money flowing through your business.

Previous Next Top Entire Chapter in Printable Form