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 Commission Owed to Venue-Finding Agencies Without a Spreadsheet Nobody Trusts?
Problems We Solve

How Do We Keep Track of Commission Owed to Venue-Finding Agencies Without a Spreadsheet Nobody Trusts?

Event venues pay commission to venue-finding agencies on some bookings, not others. We build commission tracking tied to each booking and its final invoice.

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

Venue-finding agencies bring a large share of corporate enquiries, and each has its own commission terms: which items count, whether it is on the final bill, and when it must be paid. Most venues track this in a spreadsheet updated after the fact. We build commission tracking that tags each booking to its agency at enquiry, calculates commission from the final invoice using that agency's terms, and produces statements to match their claims.

The agency says you owe commission on six events

An email arrives from an agency's finance team with a statement listing events they say were booked through them and the commission due. Your finance manager checks it against the commission spreadsheet. Two events are not on your list at all. One has a different value because the agency calculated on the proposal, not the final invoice. Another was a repeat booking that the client says they made directly.

Working it out means going back through enquiry emails, proposals and invoices, some of them months old, and the person who handled the original enquiry may have left.

When an enquiry comes in through an agency, its source is obvious that day. Once the booking is confirmed and handed to operations, the agency reference often lives only in the original email. By invoice time, nobody is looking at the source, and each agency has different rules about what they are paid on.

  • Commissionable items differ by agency: room hire and catering, but not bar or accommodation, for example.
  • Some calculate on the net invoice, some on the gross, some exclude cancellation charges.
  • Repeat bookings may or may not count if the first was through an agency.
  • Agencies send statements in their own format, on their own schedule.

Disputes, overpayments and strained relationships

When commission is tracked loosely, you either pay what the agency claims because checking is too hard, or you spend days arguing about each statement. Neither is good. Agencies are an important source of business, and a venue that is slow or unreliable on commission gets fewer referrals. Equally, paying on items your agreement excludes adds up over a year.

We do not interpret your agency agreements. You and your adviser decide what they mean. We make sure the terms you agree are applied the same way every time.

How we build commission tracking tied to the booking

  1. Each enquiry is tagged with its source at intake, including the agency and their reference, and the tag stays with the booking through to the invoice.
  2. Each agency's terms are held in a small rules table: rate, commissionable items, base (net or gross), treatment of cancellations and repeat bookings.
  3. When the final invoice is raised, commission is calculated line by line using that agency's rules and recorded as a liability against the booking.
  4. Monthly statements per agency are produced in a consistent format, listing the booking, their reference, the invoice and the commission.
  5. Agency statements received are compared with yours, and differences are listed with the reason so a person can resolve them.
  6. Commission payments are recorded in your accounts system so the liability clears when paid.
QuestionAnswered by
Was this booking from an agency?Source tag from the enquiry
Which items count?That agency's rules table
How much is due?Calculated from the final invoice lines
Why does their statement differ?Line-by-line comparison with reasons

What month end looks like

Finance produces agency statements from the system rather than a spreadsheet. When an agency sends its own, differences are listed with reasons, and most can be answered by forwarding the relevant line. The sales team can see which agencies actually bring confirmed business, not just enquiries.

When an agency changes its terms, one row changes, and bookings made before the change keep the old terms.

Signs your commission tracking needs work

  • Your commission spreadsheet is updated after invoices go out, if at all.
  • Agency statements regularly include events you cannot match.
  • You are not sure whether you pay on items your agreement excludes.
  • Repeat bookings from agency clients cause arguments.
  • Nobody can say which agencies bring the most confirmed revenue.

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 this read agency statements automatically?

Where the agency sends a consistent spreadsheet or PDF, yes. Unusual formats are read and then checked by a person.

Do you tell us what our agency contracts mean?

No. You decide how each agreement applies, with your own adviser where needed. We apply those decisions consistently.

Does it work with Xero or Sage?

Yes, commission can be posted to either through their APIs, or to other accounts systems where they allow it.

What drives the cost?

The number of agencies and variations in their terms, how your booking system records sources, and whether you want automatic statement matching.

What do you need from us?

A list of agencies and their commission terms, a few recent statements, and access to booking and invoice data.

Keep reading

More on Problems We Solve

Start here

Tell us where bookings get stuck at your venue

Describe how an event moves through your venue today, from the first enquiry to the final invoice, which booking or diary system you use and where the spreadsheets and email threads take over. We will tell you what we would build and what we would leave alone, and if your current system already has a setting that fixes 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 →