Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Do We Keep Track of Which Price Each Pub and Wholesaler Is Meant to Pay for Our Beer?
Problems We Solve

How Do We Keep Track of Which Price Each Pub and Wholesaler Is Meant to Pay for Our Beer?

Brewery trade pricing drifts when every pub has its own deal. We keep price lists, discounts and promotions per account so invoices match what was agreed.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Trade prices drift because each pub, free house and wholesaler has a deal agreed in conversation, and those deals live in people's heads and old emails. We build a price list per account type with account-level agreements and time-limited promotions, used when orders are entered and invoiced, so the price on the invoice is the one that was agreed.

Which price did we give the Plough?

The Plough gets a discount on the best bitter because they took it as a permanent line. The city bar gets a better keg price because they take three lines. The wholesaler has a different price per container. There was a promotion on the new stout last month, extended for some accounts. The office invoices from the standard price list, the landlord queries it, and someone looks back through emails to find out what was said.

Why pricing becomes a mess

Prices are agreed by people, often the owner or a sales rep, in a pub, by phone or by text. The agreement rarely reaches the system that invoices. Your brewery system or accounts package may support price lists, but setting them up takes time, so the standard list gets used and exceptions are handled by credit notes after the landlord complains.

  • Deals are agreed verbally or by text.
  • Discounts are not recorded against the account.
  • Promotions have no end date in the system.
  • Wholesaler and distributor prices differ by container.
  • Price rises are applied to some accounts and not others.

What drifting prices cost

Credit notes and queries that take office time. Discounts that continue long after they were meant to stop. Accounts that were never moved on to a price rise. And relationships strained when a landlord feels you have gone back on a deal. You also lose sight of margin, because the real price per account is unknown.

When a price rise comes round, the uncertainty gets worse. Nobody is quite sure which accounts are on old deals, so the rise is applied unevenly and some customers notice.

Prices kept where invoices are raised

  1. Base price lists per account type: free trade, tied, wholesaler, distributor, events, taproom.
  2. Account-level agreements on top, with who agreed them, when, and any end date.
  3. Promotions set up with start and end dates and the accounts or types they apply to.
  4. A quick way for the owner or rep to record a new deal from a phone, which goes to the office for approval before it is used.
  5. Prices applied automatically when an order is entered, and passed to your brewery system or Xero invoice.
  6. A report of every account's effective price per beer and container, and of deals about to expire.
  7. Price rises applied to a list, with a check of which accounts have agreements that override it.
Price sourceWhere it livedWhere it lives now
Standard listSpreadsheetBase list per account type
Pub dealOwner's memoryAccount agreement with date
PromotionEmailPromotion with end date
Wholesaler priceContract PDFWholesaler list
Price riseApplied by handApplied with override check

If your brewery system already supports customer price lists, we fill them properly and add the approval and expiry parts it lacks, rather than building a second pricing system.

Invoices that match the handshake

Orders are priced as agreed. Promotions end when they should. Queries fall away because invoices are right the first time. When prices rise, you know exactly which accounts are on deals and can decide what to do with each. The owner can see real margin per account instead of guessing from the standard list.

New staff and reps benefit most. Instead of learning each pub's arrangement by asking around, they see it on the account, with who agreed it and when it runs out, and they cannot accidentally undercut a deal someone else made.

Does this sound like your pricing?

  • Pubs regularly query invoice prices.
  • Deals are agreed verbally and not recorded.
  • Promotions continue past their end.
  • Some accounts were never moved to the last price rise.
  • Nobody knows the effective price per account.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Can reps agree prices on the spot?

Yes, within limits you set. Anything outside the limits goes to the owner for approval before it is used.

Will it work with our accounts package?

Yes, if invoices are raised there. We pass prices to Xero, QuickBooks or Sage, or to your brewery system if that raises the invoice.

Do we have to set up every account at once?

No. Accounts start on the base list for their type, and deals are added as they come up or as queries arrive.

Can it handle container deposits or charges?

Yes, as separate lines, using whatever policy you choose. How to treat them in your accounts is for your bookkeeper.

Keep reading

More on Problems We Solve

Start here

Tell us where the brewery loses track

Describe the problem, the brewery software and spreadsheets you use, and roughly how many trade accounts and vessels you run. We will tell you what we would build and what we would leave alone, and if a setting in the system you already pay for would fix it, we will say so.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →