Supplier & Customer Report Reports

Shows outstanding balances and totals (purchases, sales, returns, opening balance) per contact, split by customer and supplier.

The Supplier & Customer Report (labelled Contacts Report internally) aggregates each contact's transaction history into totals — purchases, purchase returns, invoiced sales, sell returns, ledger discounts, opening balance and the resulting Due amount. It requires the contacts_report.view permission.

The Due column nets purchase and sales activity together: total invoiced minus amount received minus sell-discount, less (total purchase minus amount paid minus purchase-discount), less sell returns paid, plus purchase returns received, then adjusted by the contact's opening balance (added for customers, subtracted for suppliers).

Filters include Contact Type (customer, supplier, or both), Customer Group, Business Location, a specific Contact, and a transaction date range. Only locations the logged-in user is permitted to access are included, and clicking a contact's name opens their full contact profile in a new tab.

Step-by-step Workflow

1. Open the reportGo to Reports > Supplier & Customer Report.
2. Filter by contact typeChoose customers, suppliers, or both.
3. Narrow furtherOptionally filter by customer group, location, a single contact, or a date range.
4. Review totalsCheck total purchase, total invoice, returns and opening balance per contact.
5. Check the Due columnIdentify contacts with outstanding balances.
6. Open a contactClick a name to view their full transaction history.