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

Go to Reports > Debtors > Debtor Statements Balance Forward.
Select a layout and click Run.
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.
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

Navigate to the client you wish to print historical debtor transactions for and on the Task bar select Debtors ledger.
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.
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.
Click Export ledger to excel on the Tasks Bar to export to Microsoft Excel.

MYOB INTERNAL STAFF ONLY

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