Supplier Report

Supplier Report is the other side of the ledger from Client Receivable: not what you are owed, but what you owe.

Open it from Add Report — see generating a report.

What it asks for

Date Range is the only required filter, with Show Column beside it.

The date range is about when the supplier was added

This is the one thing to get straight before reading the report, because it is not what most people expect.

Date Range decides which suppliers appear, by when each was created on the system. It does not filter the money. A supplier added inside the range appears with their whole balance, whatever period the orders behind it came from.

So a supplier you set up two years ago will not appear in a report run over this quarter — even if you owe them a great deal today. To see everyone, widen the range back to before your oldest supplier record.

What comes back

Reports → Supplier Report

Column	What it holds
Supplier Name	The supplier, as named on their record.
Company Name	Their registered company, where it differs from the trading name.
Total Amount	Everything ordered from them.
Total Paid	What has gone out to them.
Due Amount	The difference — what you still owe.
Created Date	When the supplier was added, which is the date the filter above works on.

Reading it

Due Amount is the column that matters, and it is worth sorting on. A large balance against one supplier is either a bill somebody forgot or an account being run deliberately — and the report cannot tell you which, so it is worth knowing which of the two you are looking at before a delivery gets stopped.

Total Paid at or near zero against a substantial Total Amount usually means orders have been raised and received, but the payments were never recorded against them — the money may well have gone out of the bank. See purchase orders for where a payment is recorded.

For the individual orders behind a balance, see the Purchase Order Report.

Related

• Suppliers — the supplier record, their billing summary and order history.
• Purchase Order Report — the orders themselves.
• Client Receivable Report — the same question pointed the other way.