How To: Print a Detailed Debtors or Creditors Report

Table Of Contents

Introduction

Introduction

A detailed Debtors or Creditors report provides a more comprehensive view of outstanding balances by including the individual invoice details associated with each customer or supplier.
This report is useful when reviewing outstanding debts, chasing overdue invoices, reconciling balances or preparing information for management and finance teams.
For a simpler summary report, see /?title=How_To:_Print_a_Basic_Debtors_or_Creditors_ReportHow To: Print a Basic Debtors or Creditors Report.

Generate a Detailed Debtors or Creditors Report

  1. Open an Accounts screen (show me how).
  2. Open the [ Accounts | Debt Management ] tab.
  3. Select either:
    • Debtors to report on customer balances, or
    • Creditors to report on supplier balances.
  4. Apply any additional filters required, such as:
    • Date range
    • Customer Classification
    • Currency
    • Other reporting criteria
  5. Click Go to populate the grid.
  6. Click within the Owed column.
  7. Press Ctrl + U to sort the grid in descending order.
    This will display the customers or suppliers with the largest outstanding balances at the top of the list.
  8. Select the records you want to include in the report.
    • Use green selection to choose specific entries.
    • Press Ctrl + A to select all displayed records.
  9. Right-click within the grid and select:
    Detailed Report (Includes Invoices)
  10. The report will be generated and displayed on screen.
  11. You can then:
  • Print the report.
  • Save the report.
  • Export the report if required.

Result

The report will include:
  • Customer or supplier details.
  • Outstanding balances.
  • Individual invoice information.
  • Supporting debt or creditor transaction details.
This provides a more detailed view than the standard Debtors or Creditors report.

Currency Information

The report is normally displayed in your Base Currency.
If you apply a currency filter before generating the report:
  • The foreign currency amount will be displayed.
  • The Base Currency equivalent will also be shown.
  • Currency symbols are included throughout the report to make different currencies easy to identify.
This is particularly useful for businesses trading in multiple currencies.

Tips

  • Sort by the Owed column before running the report to quickly identify your largest debtors or creditors.
  • Apply filters to focus on specific customer groups, suppliers or currencies.
  • Use Ctrl + A when you need to include all displayed records in the report.
  • Review the report on screen before printing to ensure the correct records have been selected.

When Would You Use This Report?

Typical uses include:
  • Credit control and debt chasing.
  • Reviewing overdue customer balances.
  • Monitoring supplier liabilities.
  • Reconciling account balances.
  • Providing detailed information to accountants or management.
  • Investigating outstanding invoice queries.

See Also


Did you find this article helpful?