In this guide 6 sections
Old rates reach invoices by three routes. A brand revises its list and nobody keys it in, counter staff type a remembered rate, or a quote outlives its date. Dated rate lists and written buyer agreements make the system choose the rate by bill date, so a late circular or a fading memory cannot rewrite an invoice.
Three routes carry an old rate onto a bill
A dealer in emulsion paint, plywood, CPVC pipe or switchgear buys from brands that revise their circulars several times a year. Each revision arrives as an email attachment or portal download, and someone in the accounts office must key it in by hand, line by line, from a PDF.
The old rate stays on screen. The invoice prints cleanly. The buyer pays it, or argues a month later when the statement reaches his accounts clerk and the figures fail to match his own purchase order.
Three routes cause most of the damage. Each has a different owner inside the shop. No blanket fix works.
- The brand’s revised list, keyed late or never
- A rate carried in a clerk’s memory
- A quotation left open past its validity date
- A negotiated buyer rate that was never written down
The revised list that sits in an inbox
Take a paint dealer with a hundred shade and pack combinations, where the company sends a revised list carrying an effective date and new pack prices. The purchase side updates its cost price. The sales side never hears. The circular went to the owner’s mail.
Selling price now sits below replacement cost. It stays there until a buyer or a stock auditor notices, and by then every counter bill has used the old rate.
Plywood is worse, since thickness, grade, face veneer, sheet size and moisture rating all multiply the lines, and one missed row leaves a whole family at last quarter’s rate. Name one owner for each brand’s list. That person loads each revision with its effective date before the first bill under it is raised, then checks five items against the circular. No exceptions.
The rate somebody remembers
A painting contractor wants wall putty. The clerk recalls last time’s rate. He types it over whatever the screen shows, which feels like good service at a busy counter, and nobody records that the rate was changed.
Overrides like this are rarely logged. The invoice carries a rate that matches no list on file, and months later nobody can explain why two buyers paid different amounts on the same day.
Allow the override. Make a reason mandatory. Let staff choose from a short pick list such as buyer agreement, damaged pack, clearance or manager approval, so the month end review has something to read.
The quote that outlives its date
An electrician’s quotation for a flat with forty points goes out in the first week of the month and the buyer says go ahead three weeks later. The order converts at the quoted rates. Copper wire and modular switch plates have both moved since, so the quoted rates no longer match what the next purchase will cost the shop.
The quote said valid for fifteen days. The software never checked.
Give every quotation a validity date. On conversion, show each line whose quoted rate differs from today’s list, and ask the salesman or the owner to decide before the order saves.
- Validity date printed on the quote
- Warning on conversion after expiry
- Line by line comparison with the current list
- Approver named for any exception
Dated rate lists and buyer agreements as the control
Date every rate, start and end. The bill date then picks the rate, a list loaded on the first leaves last week’s invoices alone, and a late correction cannot rewrite history.
Record negotiated buyer rates per product group, each with its own date range and a named approver who signed the agreement, so a live agreement wins over the list. A lapsed agreement yields to the list again.
Start this week by printing ten recent invoices and checking each rate against the circular that was in force on the bill date, line by line. The mismatches show which route hurts you most.
Rate source audit sheet
Each invoice line takes one row. Columns cover invoice number, bill date, item, rate billed, list rate on that date, buyer agreement rate, quote number, variance and route (list, memory or quote). A footer totals variances by route and names the owner of each brand list, so every fix has a person attached to it.
Open a blank worksheet to printQuestions owners ask
How often should a dealer reload brand price lists?
Whenever the brand issues a circular. Load it with its effective date so that earlier invoices keep the rates they were billed at, and never overwrite the old list.
Should counter staff be allowed to change a rate?
Yes, within limits. Require a reason code, and an approval once the gap from the list rate passes a threshold the owner sets, so every override can be reviewed at month end.
What happens to open quotes when a new list arrives?
They keep their quoted rate until the validity date, after which the system flags them and asks for a refreshed rate before the order converts.
How do buyer rate agreements fit with brand lists?
Each agreement stores a rate or discount per product group, with dates, and the system checks agreements first before it falls back to the dated brand list.