What this screen is for
This report groups purchasing by supplier. Over a date range you choose, and optionally for a single supplier, it shows how many distinct suppliers you bought from, the number of bills, the total purchased and the amount still due. Beneath that, each supplier gets a row with their bill count, total purchases, amount paid, amount due and average bill value.
The report can be printed, or exported as Excel, CSV or a landscape PDF.
When to use it
At period end, to see where your spending is concentrated and which suppliers you still owe. It is also the report to bring to a supplier negotiation, since it shows volume and payment history in one place.
What you see on this screen
Four cards head the page: Unique Vendors, Total Bills, Total Purchases and Due.
The detail table carries:
- # — the row number.
- Vendor — the supplier's name, with their email underneath.
- Bills — how many bills they raised in the period.
- Total Purchases — what you bought from them.
- Paid — how much of it has been settled, shown in green.
- Due — what is still outstanding, in red where it is above zero.
- Avg Bill — the average value of their bills.
A totals row closes the table. Where the range returns nothing, the table is replaced by a note suggesting the date range or filters be adjusted.
Filters and actions
- The date range picker in the header sets the period.
- Filters — opens a Vendor selector, to narrow to one supplier, with a Reset button.
- Print — opens a printable version.
- Export — a menu offering Excel (.xlsx), CSV and PDF (landscape).
Related
- Expense by Vendor — expenses grouped the same way
- Purchase Orders — the commitments behind the bills