Vendor Spend Ranking

What this report shows

A ranked list of vendors by total bill amount over the trailing 12 months. Only posted (or paid) bills count — drafts and voided invoices are excluded.

Use this to spot concentration risk (one vendor accounting for an outsized share of spend) and to find good candidates for renegotiation or vendor consolidation.

How to read it

• Each row is one vendor, ordered by total spend, descending.
• Total spend is the sum of bill totals over the 12-month window.
• Bill count shows how many separate bills make up the total — useful for spotting "one big bill" vs "many recurring small bills".
• Share of total is each vendor's % of total 12-month spend across all vendors.

Common questions

• Why is a vendor I just paid missing? The bill must be posted (or paid). Drafts don't count. Confirm the bill status in `/admin/accounting/purchase-invoices`.
• Why does the same business show up twice? Vendors are joined by `vendor_id`, not by name. If the same business was set up as two vendor records (e.g. once with an EIN, once without), they'll appear separately. Merge them via the vendor admin.
• Why is the page empty? The purchase-invoices or vendors table isn't installed in this environment — apply migration 135.

What to do if numbers look wrong

1. Cross-check the top vendor's total against `/admin/accounting/purchase-invoices` filtered to that vendor.
2. Confirm the date window — the report is rolling 12 months, not calendar-year.
3. If a recurring vendor is missing, check whether their bills were posted or are still drafts.