This report is used to identify invoices that are due for payment. The payment date defaults to the system date but any date in the past or future can be entered, however only payments due for the current date or in future can be paid automatically via the cashbook payments routine. This date is compared to the payment terms for each supplier, to establish which transactions require payment. An account range or an Accounting Group may be selected.
By ticking the ‘Include Queried/Logged’ field, relevant transactions will also be displayed. Select ‘BACS’, to report on Suppliers with invoices due for payment, where the supplier account has been set up for BACS payments.
Click on ‘Create Report’ to display the report on screen.
The report displays the accounting period for the transaction posting, the transaction category i.e. Invoice or Credit Note, the transaction reference, the run number the transaction was posted in, the transaction date, and the Purchase Ledger reference which is a system generated reference number, the payment due date and transaction amount.
The status will show either Overdue, Next 7 days, Last 7 days or blank (if it is due exactly on the payment due date).
The Nett payment is the amount that will be paid if the Automatic Payment Run is done via Cashbook Payments – see Cashbook section for full details of this.
The Account Balance is the balance on the purchase ledger account, including any transactions that are not yet due.
Any transactions appearing on this report that are not to be paid via the Automatic Payment Run should have the status changed to 'Queried' on the account enquiry screen. When the report is run again these transactions will not appear in the Nett Payment values.
Any Purchase Ledger Accounts that have been set to ‘Prevent Auto Payments’ in the Account Maintenance screen will still appear on this report but will not be included in the Automatic Payment Run.