Language:


Liquidity Forecast

This page describes the Liquidity Forecast report in the Nominal Ledger.

---

The Liquidity Forecast report is a forecast of future incoming and outgoing payments that will be useful for cash flow prediction purposes. The forecast will be based on the following records (depending on the options that you select when running the report):

  • Open (unpaid) Purchase and Sales Invoices. The report will predict that these Invoices will be paid on their Due Dates.

    If you have agreed a different payment date with a Customer or Supplier, you can register that date in a record in the Liquidity Report Info setting. The report will take the agreed date into account if you produce it using the Detailed incl. Liq. Info. option.

  • Simulation rows that post to the Cash and Bank Accounts specified in the Payment Modes setting and in which the Status is "Active". You would have entered these Simulations in advance to predict payments that will not be recorded in the Sales and Purchase Ledgers (examples might be Simulations that represent the future payments of rent and salaries).

  • If you are subscribing to the Cheques module, you can also include Cheques and Own Cheques in the Liquidity Forecast report. (Accepted and Deposited Cheques and Accepted Own Cheques will not be included.)
When printed to screen, the Detailed version of the Liquidity Forecast report has the Standard ERP Drill-down feature. Click (Windows/macOS) or tap (iOS/Android) on the record number of any transaction in the report to open the relevant transaction in a record window.

Running the Liquidity Forecast report will open the following window:

Period
Paste Special    Reporting Periods setting, System module
Enter the report period.

If you are using the Leading Zero before Day, Leading Zero before Month and/or Century options in your Date and Numeric Format, you do not need to type the leading zeros or the century digits as these will be inserted automatically. For example, if you type "1-1-20", this will be converted to "01-01-2020" automatically (if you are using all three of the options mentioned).

If your report period is a single day, just enter the date once and this will be converted to a period format automatically.

The default value will be taken from the first row of the Reporting Periods setting.

Start Balance Accounts
Paste Special    Account register, Nominal Ledger/System module
Range Reporting    Alpha
If you specify an Account here (e.g. a Bank or Cash Account), the report will contain an opening balance for that Account, incremented balances after each Receipt, Payment or other transaction, and a theoretical closing balance. If you specify a range of Accounts separated by a colon (:), the opening balance for the report will be the sum of the opening balances of the Accounts in the range.

Function
Use these options to control the level of detail shown in the report.

Detailed
The Detailed option produces a report listing each transaction in expected payment date order. The calculation of the expected payment dates will depend on the Receipts and Payments options that you choose below. The estimated payment amounts will be the outstanding amounts for each Invoice (if an Invoice is payable in Instalments, the Instalments will be listed individually). The outstanding amount for an Invoice in Currency will be converted to your home Currency using the Exchange Rate for the report date.

Overview
The Overview contains a single line summary for each day on which it is expected a payment will be made or received. Expected payment dates, payment amounts and Currency conversion will be determined in the same way as in the Detailed report described above.

Detailed incl. Liq. Info.
The Liquidity Report Info setting allows you to change the Due Date of a Sales or Purchase Invoice solely for this report (i.e. without changing the Invoice itself). You can also use this setting to re-schedule the payment of an Invoice into instalments. If you are using this setting, select this option to include the information in the setting in the report.

In the example illustrated below, the expected payment date for Invoice 980160 has been delayed by one month and the payment for Invoice 980161 has been divided into three instalments.

Please refer here for details about the Liquidity Report Info setting.

Registers
Use these options to include records from various registers in the report.

Receipt Forecast
Select this option if you need open (unpaid) Sales Invoices to be included in the report. For an Invoice to be included in the report, its Due Date must fall within the report period.

Payment Forecast
Select this option if you need open (unpaid) Sales Invoices to be included in the report. For a Purchase Invoice to be included in the report, its Due Date must fall within the report period.

Simulations
Select this option if you need Simulation rows to be included in the report. A Simulation row will be included in the report if it meets the following criteria:

  • The Status in the Simulation row must be "Active".

  • The Simulation row must post to one of the Accounts that you have used with Payment Modes whose Type is "Free", "Credit Card". "Debit Card", "Cash", "On Account", "Bank Transfer", "Received Cheques" or "Own Cheques".

  • The row must be included in a Simulation whose Trans. Date falls within the report period.

Cheques
If you are subscribing to the Cheques module, you can use this option if you need Cheques to be included in the report. A Cheque will be included in the report if it meets the following criteria:

  • It is not an Accepted or Deposited Cheque.

  • Its Estimated Cl. Date falls within the report period.

Own Cheques
If you are subscribing to the Cheques module, you can use this option if you need Own Cheques to be included in the report. An Own Cheque will be included in the report if it meets the following criteria:

  • It is not an Accepted Own Cheque.

  • Its Effect Date falls within the report period.

Status Purch. Inv.
Select the Only Not on Hold option if you do not want Purchase Invoices that have been marked as On Hold to be included in the report. Usually you will not pay a Purchase Invoice that you have marked as On Hold.

Receipts, Payments
Use these options to specify how the estimated payment dates for Sales and Purchase Invoices will be calculated.
Net
Select this option if you need the report to show that payments will be received or issued on the relevant Due Date.

Discount
Select this option if Invoices with settlement discount terms will be paid on their Discount Dates. The Discount Date is the date when a settlement discount expires. The payment amount shown in the report will include the deduction for the settlement discount.

X days late
Select this option when you assume that all Invoices will be paid on average a specified number of days later than their Due Dates. Specify the number of days in the field to the right of this option.
Cut Names
If you are using the Detailed option, the Customer or Supplier Name will be shown for each Invoice, and each Simulation Text will be printed in full. Select this option if you would like to cut these Names and Comments so that only the first 15 characters are printed.

Cut Decimals
Select this option 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 you use this option.

Skip Disputed Invoices
Select this option if you would like Sales Invoices that you have marked as Disputed to be excluded from the report.
---

Reports in the Nominal Ledger:

---

Go back to: