What You Actually Spend With Each Supplier, and Why QuickBooks Cannot Tell You

The problem: Money leaves the business every week against prices nobody checks, freight nobody assigns, and rebate tiers nobody claims.

The solution: Land every cost on the product it belongs to, so you can see which supplier spending is buying something and which is simply leaking.

Your bookkeeper can tell you what you paid each supplier last year. That number is in the accounting system and it is correct. It is also nearly useless for making a decision, because it tells you the total that left the building and nothing about whether any of it was the right amount.

The questions that would matter are one layer down. Did the price on the invoice match the price you negotiated. What did it cost to get the goods here, and which products carried that cost. Did you hit the volume tier that pays a rebate, and did anyone claim it. Every one of those is answerable in principle. None of them is answerable today, because the pieces sit in an inbox, an accounting system, a carrier portal, and a supplier agreement in a filing drawer.

The invoice price is not always the price you agreed

Most price leakage at this size is not a supplier behaving badly. It is a price change that was announced in an email in February, applied in March, and never questioned, because the person who opens the invoice does not have the agreed price in front of them and has no realistic way to get it.

That is a design problem, not a diligence problem. Checking one invoice line against a contract price takes a minute. Checking every line on every invoice from thirty suppliers across a year is thousands of minutes, so nobody does it, so it does not happen. What happens instead is that a price is spot-checked when something feels off, which means the increases that stay small enough to feel normal are never caught at all.

Over a year, on a few million dollars of purchasing, a fraction of a point moving quietly is real money. It just never appears as an event. There is no day on which you overpaid. There is only a cost of goods line that came in slightly heavier than the year before, for reasons everyone can explain and nobody can decompose.

Freight and rebates never reach the product

Two more costs behave the same way, in opposite directions.

Freight usually gets booked as a lump. It is a real expense and it is recorded honestly, but it does not attach to anything. So the heavy, bulky, low-margin item that costs a fortune to get onto the shelf looks exactly as profitable as the light one, and pricing decisions get made on a cost that is missing a chunk. When freight sits in its own bucket, you cannot see that a whole category is being carried by the rest.

Rebates run the other way, and they are money you are owed rather than money you overpaid. Supplier programs are tiered, the tiers are stated in agreements signed a year or two ago, and hitting one requires knowing where you stand with two months left in the program year. Almost nobody at this size knows that. So a tier gets missed by a small margin that a single extra order would have covered, or it gets hit and never claimed, because claiming it requires assembling twelve months of purchases from the accounting system by hand.

Where the answer comes from

None of this needs a purchasing department. It needs the pieces joined up so that a cost lands on a product when it exists rather than being reconstructed later.

That means the things the business already tracks are connected: each supplier tied to its agreed prices and rebate terms, each purchase order tied to the invoice that follows it, each freight bill tied to the shipment it moved, and all of it landing on the products in the shipment. Once those sit in one connected picture, landed cost per product is not an analysis, it is a field. What you have spent with a supplier year to date against the tier you are chasing is not a project, it is a number.

The upkeep is what makes it survive contact with a real week, and that is the part to automate. Nobody is going to check three hundred invoice lines by hand, but automation will, every time, and raise only what does not match: the line billed above the agreed price, the shipment with no freight assigned, the supplier program you are eight percent short of with sixty days to go. The person who currently opens invoices stops keying and starts deciding, which is the part of that job worth paying for.

A look at a multi-location retailer

Consider a specialty retailer with six locations doing about $10 million a year, buying roughly $6 million of goods from around thirty suppliers. Purchase orders are placed by phone and email. Invoices go to the bookkeeper, who keys them into the accounting system and pays them. Freight lands as its own expense line. The supplier agreements are in a drawer and get looked at when someone remembers.

Suppose the retailer connects suppliers, agreed prices, purchase orders, invoices, freight, and products into one picture, and lets the matching run automatically. What you would expect to surface in the first two quarters falls into three groups.

First, a handful of price variances that had been running since a change nobody logged, plausibly worth a point on the affected lines. Second, freight finally landing on products, which would likely reveal a category whose real cost is meaningfully above what everyone assumed, and which has therefore been priced too thin for years. Third, one or two rebate tiers within reach that nobody was tracking toward.

Put a rough number on it. On $6 million of purchasing, recovering something on the order of two points across those three, about $120k a year, is a plausible outcome, and it does not require negotiating a single new price. It is money that was already agreed to and simply never collected or never assigned.

The change in how decisions get made is worth more than the recovery. An owner who can see landed cost by product can tell which categories are actually earning their shelf space, and an owner who can see supplier spend against terms walks into the annual negotiation with the same information the supplier has always had.

How to start

1. Pull your three largest suppliers' agreed prices. Put them beside the last quarter of invoice lines from those suppliers. That comparison alone usually pays for the afternoon.
2. Assign one month of freight to products. Take a single month of freight bills and land them on what they carried. The category that changes shape is the finding.
3. Find where you stand on every rebate program. List the tiers, then work out your year-to-date position against each while there is still time to move.
4. Let the checking run itself. Set automation to match invoice lines to agreed prices, freight to shipments, and purchases to rebate tiers, and put only the exceptions in front of a person.

The takeaway

You know what left the bank account. What you do not know is which of it bought something. Prices drift because checking them by hand is impossible, freight hides in its own line because nothing forces it onto a product, and rebates go unclaimed because nobody can see the position in time. Join the suppliers, orders, invoices, freight, and products together, let the matching run on its own, and what you spend becomes something you can question rather than something you reconcile. Start with your three biggest suppliers and one month of freight, and the first pass will probably be worth more than the work of doing it.