logo
 
Open Invoices Report

The Open Invoices report will provide you with a report of all invoices which remain unpaid. You also have the ability to only produce the report for overdue invoices, that is, invoices you have sent to customers where the due date of the invoice has been passed.

The open invoices download files can be used as the basis for a file to submit via your bank or BACS to claim payment direct from customers if you have the appropriate direct debit arrangements in place. You are responsible for ensuring the file is in a format appropriate to the needs of your bank or BACS service provider.


Select List

You can click on one or more items to select them for printing on the report. If 'All' is selected then it is assumed that the report should be generated containing all appropriate items.

Selected List

The selected area displays the items that have been selected for printing on the report. You can click on one or more items to unselect them from the report.

Overdue Invoices

Selects a report for only those invoices issued to customers that have become overdue against the agreed trading terms.

From Date

Enter or select a date from which to include invoices.

Enter the dates manually (e.g 19/12/2002) or click on the calendar icon to select date from calendar. These are the start and end date of the current financial year. Examples '1/01/2002 to 31/12/2002' '1/04/2003 to 31/03/2004'

When entering dates manually, a date guessing routine speeds up the input by taking the user input and assuming the missing month and or year based on the current date as the user leaves the field i.e.

the date today is 30th October 2009

Payment File Format

Payment files can be generated for employee, supplier and customer payments.

Select the most suitable format to use as a starting point for your electronic payment file. Please contact support@libertyaccounts.com if you need a different format for a specific online payment system operated by a major UK bank.

The BACS style files have dates and amounts formatted in the BACS style, but still need to be processed by your BACS software into proper BACS files.

Supplier Payments Generic Format

The following fields are generated in the unpaid bills download:

  • Payment Date
  • Originator Bank Sort Code
  • Originator Bank Account Number
  • Originator Bank Account Name
  • Originator Reference - Supplier Invoice Number
  • Supplier Bank Sort Code
  • Supplier Bank Account Number
  • Supplier Bank Account Name
  • Supplier Reference - Supplier Invoice Number
  • Amount (pounds.pence)

    • Supplier Payments BACS Style Data Format

    The following fields are generated in the unpaid bills download:

  • Supplier Bank Sort Code
  • Supplier Bank Account Number
  • Originator Bank Sort Code
  • Originator Bank Account Number
  • Amount (pence)
  • Originator Bank Account Name
  • Reference - Supplier Invoice Number
  • Supplier Bank Account Name
  • Payment Date in BACS processing date format

    • Supplier Payments Natwest Bankline Standard Payment Format

    The records are as per the Natwest Bankline spec and include:

  • Originator Reference - Supplier Invoice Number
  • Originator Bank Sort Code+Originator Bank Account Number
  • Amount (pounds.pence)
  • Payment Date (ddmmyyyy)
  • Supplier Bank Sort Code
  • Supplier Bank Account Number
  • Supplier Bank Account Name
  • Supplier Reference - Supplier Invoice Number

    • Customer Payments Generic Format (preparatory to direct debit)

    The following fields are generated in the open invoices download:

  • Payment Date
  • Originator Bank Sort Code
  • Originator Bank Account Number
  • Originator Bank Account Name
  • Originator Reference - Customer Code from customer detail screen
  • Customer Bank Sort Code
  • Customer Bank Account Number
  • Customer Bank Account Name
  • Reference - Invoice Number
  • Amount (pounds.pence)

    • Customer Payments BACS Style Data Format (preparatory to direct debit)

    The following fields are generated in the open invoices download:

  • Customer Bank Sort Code
  • Customer Bank Account Number
  • Originator Bank Sort Code
  • Originator Bank Account Number
  • Amount (pence)
  • Originator Bank Account Name
  • Reference - Customer Code from customer detail screen
  • Customer Bank Account Name
  • Payment Date in BACS processing date format

    • Payroll Payments Generic Format

    The following fields are generated in the payroll payments download:

  • Payment Date
  • Originator Bank Sort Code
  • Originator Bank Account Number
  • Originator Bank Account Name
  • Originator Reference - Payroll Reference
  • Employee Bank Sort Code
  • Employee Bank Account Number
  • Employee Bank Account Name
  • Reference - Business Name
  • Amount (pounds.pence)

    • Payroll Payments BACS Style Data Format

    The following fields are generated in the payroll payments download:

  • Employee Bank Sort Code
  • Employee Bank Account Number
  • Originator Bank Sort Code
  • Originator Bank Account Number
  • Amount (pence)
  • Originator Bank Account Name
  • Reference - Business Name
  • Employee Bank Account Name
  • Payment Date in BACS processing date format

    • Payroll Payments Natwest Bankline Standard Payment Format

    The records are as per the Natwest Bankline spec and include:

  • Originator Reference - Payroll Reference
  • Originator Bank Sort Code+Originator Bank Account Number
  • Amount (pounds.pence)
  • Payment Date (ddmmyyyy)
  • Employee Bank Sort Code
  • Employee Bank Account Number
  • Employee Bank Account Name
  • Reference - Business Name

    • Payroll Payments Natwest Bankline Bulk List Template Format

    The records are as per the Natwest Bankline spec and include an initial debit record with details of the originating account followed by the credit items with the following data:

  • Originator Reference - Payroll Reference
  • Employee Bank Sort Code
  • Employee Bank Account Number
  • Employee Bank Account Name
  • Reference - Business Name

    • Payroll Payments Natwest Bankline Bulk List Payment Format

    The records are as per the Natwest Bankline spec and include an initial debit record with details of the originating account followed by the credit items with the following data:

  • Originator Reference - Payroll Reference
  • Amount (pounds.pence)
  • Employee Bank Sort Code
  • Employee Bank Account Number
  • Employee Bank Account Name
  • Reference - Business Name

    • Payment File Originating Account

    For payments to employees and suppliers specify the account from which funds paid.

    For payments requested from customers (BACS direct debits) specify the account into which funds are received.

    Save Report As...

    Save report as screenshot

    Reports can be saved locally to your computer, or within the Liberty Accounts database.

    If you are viewing a report in Adobe Acrobat you can save it by clicking on the file save icon within the Adobe Acrobat reader application.

    If you are on the report parameters screen after generating a report you will see some extra options displayed as above. To save the report pdf file to your computer right-click on the "view report" link next to the Adobe Adobe File Icon file icon and select the "Save target as" menu option.

    If you want to save the report within the Liberty Accounts database simply give the report a meaningful name by editing the suggested report name then click the "Save" button. Reports saved within Liberty Accounts can be viewed at a later date via the menu option Reports | View Saved Reports.