Skip to main content
Skip table of contents

Printing a full listing of debtors transactions for a client

This support note applies to:

  • AO Practice Manager (NZ)
  • AO Practice Manager (AU)
  • AE Practice Manager (NZ)
  • AE Practice Manager (AU)
Article ID: 35389

You may be required to print a list of historical entries for a client to review their debtor ledger/ transactions. These entries would include:

  • invoices
  • receipts
  • adjustments
  • bad debts
  • credit notes
  • discounts applied

There are 2 options available:

You can either run a Balance Forward Debtor Statement report or export the entries from the Debtors ledger to Excel. Both methods are listed below.

To run a Balance Forward Debtor Statement
  1. Go to Reports > Debtors > Debtor Statements Balance Forward.
  2. Select a layout and click Run
  3. Enter the date range for the report and search for the client code of the specific client as a filter in the Client Code field.
  4. If the client balance is zero you should also remove the <>0 filter from the Client Outstanding field.
To export the debtor ledger entries to Excel
  1. Navigate to the client you wish to print historical debtor transactions for and on the Task bar select Debtors ledger.

  2. Tick the Show Zero field. A list of transactions from the date specified appears, with the default set to display transactions for one year back from today's date.

  3. Enter the date from which you want to export the entries. The transaction list is updated to include the additional entries.

     Entering the date 01/01/1990 will ensure that all entries are included.

  4. Click Export ledger to excel on the Tasks Bar to export to Microsoft Excel.


This article is for both AE and AO Practice Manager but is something that is more frequently requested by AO clients.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.