How to reconcile event income across multiple vendors

Your ticketing dashboard says one thing, the bar report says another, and the caterer has sent a spreadsheet with a number called net sales. Meanwhile, your bank account has received several deposits that don't match any of them. How much did the event earn?

Start by working out which sales belong to your business, then reconcile each vendor's report with the agreement and the money received. Combine those checked amounts into one event summary, keeping unpaid income, money owed to other people and payment costs visible. Adding the totals from every dashboard won't give you a reliable answer because those totals often describe different things.

This is a practical guide to that process for paid events with several income sources. We'll follow one hypothetical event through tickets, bar commission, merchandise and sponsorship, including the missing reports and awkward adjustments that tend to arrive after everyone thinks the event is finished.

Decide whose money you're counting

Before opening another spreadsheet, ask what each vendor actually does for the event. A bar operator selling its own drinks and paying you a commission has a different relationship with you from a catering supplier you pay to serve a meal included in admission. Their reports shouldn't enter your event accounts in the same way.

The bar's customer sales help you calculate your commission. They aren't automatically your event's revenue. The caterer's invoice is a cost of delivering your ticket promise. Your own merchandise sales may belong to you in full, with stock and selling costs recorded separately. An artist selling shirts independently may owe you only an agreed commission or pitch fee.

Write this down for each income source before collecting totals. Who sells to the customer? Who receives the payment? What does your business earn? Who owes whom money when the event closes? It's much easier to resolve an unfamiliar report when you already know what relationship it's supposed to describe.

Formal accounting treatment needs more than a label on a contract. The IFRS Foundation's review of IFRS 15 explains that principal and agent decisions affect whether revenue is reported gross or net. Your accountant should confirm that treatment for your agreements. For the operational report we're building here, the immediate job is to distinguish customer spending from the amount your business is entitled to keep.

That distinction can change a booking decision. A food area that generates impressive customer spending may earn you relatively little once the agreed share and your support costs are considered. You need to see both figures without confusing them.

Ask for reports you can actually compare

A single total in an email isn't enough to check a settlement. Ask each vendor for the report supporting its calculation, the contract terms it applied and the payment reference for anything already transferred. Agree this before trading starts where possible, while the vendor still has time to organise its reporting.

You don't need every supplier to buy the same software. You need them to answer the same questions. Identify the event, trading dates, locations, currency, sales basis, refunds, permitted deductions and amount due to your business. Ask whether reported sales include tax, tips, complimentary items or transactions that haven't completed.

Our event vendor agreement template helps you specify reporting responsibilities before the event. Include a reporting deadline, the detail you can inspect when figures don't agree and the person authorised to approve corrections. If the contract only says you'll receive a percentage of sales, you've left the meaning of sales unresolved.

Keep the original reports unchanged. Work from a copy when you rename columns or adjust the presentation. Otherwise, a vendor can ask how you reached a figure and you'll discover that your working file has replaced the evidence you were supposed to check.

The US Internal Revenue Service's recordkeeping guidance in Publication 583 explains the role of supporting documents, including sales records, invoices and bank records. Those records serve different purposes. In your event file, the agreement explains the entitlement, the sales report supports its calculation and the bank record supports payment. A deposit alone doesn't explain all three.

Set one reporting window for the event

An event that finishes after midnight is a good way to expose a reporting problem. Your bar exports calendar days, your ticket report follows the event date and a payment provider exports in another time zone. The figures can disagree even when no sale is missing.

Define the trading window using actual dates, times and the event's local time zone. Give it to each reporting owner. Include presales in the ticket reconciliation, and identify later refunds separately so your summary covers the event rather than only the hours the venue was open.

Then record the date you prepared the settlement. That's a different date. A report prepared the next morning may exclude a delayed card transaction, an approved refund or a sponsor invoice still awaiting confirmation. You want someone reading the file later to understand what was known when.

Stripe's explanation of differences between dashboard exports and financial reports identifies time periods, time zones and included fees among the reasons reports differ. Use that as a prompt to check definitions before assuming a vendor has made a mistake.

For recurring events, assign a separate event code to each date. Keep it on reports, invoices and settlement correspondence. A vendor serving several dates may send one monthly payment, which is fine, but the supporting statement still needs to show how much belongs to each event. Otherwise, a healthy month can conceal an underpayment on one date.

Build a summary with evidence behind every amount

The main summary should let you understand the event without reading every transaction. Underneath it, retain enough detail to reproduce the totals. A spreadsheet is adequate for a small operation if the calculations are controlled and someone owns the final review.

Use one summary row for each commercial arrangement, rather than one row for each file received. If the bar sends a sales report, commission calculation and remittance advice, those are supporting records for the same income source. They aren't separate streams of revenue.

Useful summary fields are:

• Income source and reporting owner.

• Agreement reference and the calculation that determines your entitlement.

• Customer sales used in that calculation, where relevant.

• Revenue belonging to your event business.

• Payment costs or other authorised deductions.

• Amount received and the supporting bank reference.

• Amount still due, its due date and any unresolved difference.

For tax and tips, agree the presentation before comparing vendors. One report may show customer payments including tax while another shows sales excluding it. Keep the original values and a separate adjustment explaining the difference. Ask your accountant which amounts belong in revenue and which are amounts collected for another party. Don't remove a percentage from every total simply because it resembles a familiar tax rate.

Tips can require a separate explanation too. If the vendor's report includes tips paid to its staff, check whether those amounts affect your contractual commission base. If your business holds them temporarily, record the obligation to the people entitled to them. The bank balance can include money you can't spend.

Write the chosen treatment above the relevant calculation. That makes it easier to compare the next report and stops a colleague silently changing the basis because another spreadsheet uses a different heading. When you discuss the event with a vendor, refer to the actual included amounts rather than assuming you both mean the same thing by gross or net. Keep unresolved tax treatment provisional until the person responsible for your accounts confirms it.

Keep the reporting currency visible on every summary page, especially when you share individual pages with partners or event managers.

Keep calculations and direct inputs distinguishable. If someone can type over the commission formula without noticing, the sheet needs a clearer layout or a protected formula. The supporting detail should identify the source file and report date, so another person can trace a total without asking the preparer to remember it.

Don't force every source into a gross sales minus fees formula. A fixed exhibitor fee, a percentage of bar sales and your own merchandise have different calculations. The summary can use common fields while the supporting detail preserves those differences.

Follow one event through the numbers

Let's use a hypothetical paid evening event with four income sources. All amounts are in USD, and the example assumes no separate tax adjustment is required. These are teaching figures, not market benchmarks, actual vendor terms or Loopyah prices.

The event sells $24,000 of tickets before refunds. It refunds $800, leaving $23,200 of ticket revenue. The ticketing and payment charges borne by the organizer total $900. There are no other ticket deductions in this example, so expected ticket receipts are $22,300.

An independent bar operator reports $12,000 in eligible sales after the deductions specifically allowed in its agreement. Your agreed commission is 20%, so your event earns $2,400. The operator keeps the rest. Its $12,000 sales figure supports the commission calculation; it doesn't get added to your event's revenue.

Your business also sells its own merchandise. Sales after customer refunds are $3,000, payment charges are $90 and the cost of the items sold is $1,200. Finally, a sponsor owes $4,000 for a package whose agreed work has been delivered. The sponsor has paid half by the reporting date.

Your event revenue is therefore $32,600. That's $23,200 in ticket sales after refunds, $2,400 bar commission, $3,000 merchandise sales and $4,000 sponsorship. The $12,000 bar turnover is excluded. The $990 combined ticket and merchandise payment costs are expenses here, as is the $1,200 merchandise cost.

Those costs aren't the event's entire budget. Venue, staff, production, sponsor delivery and other event costs still need to be deducted before you have a profit figure. For that next step, use our event profit and loss template. This reconciliation establishes reliable income and settlement figures to feed into it.

Check what has reached the bank

Now suppose the ticket provider has paid $21,300 and still holds $1,000 due to the event. The bar operator has paid its full $2,400 commission. Merchandise receipts of $2,910 have reached the bank after the $90 processing charge. The sponsor has paid $2,000 and owes the remaining $2,000.

Cash received from these sources totals $28,610. Another $3,000 remains due, consisting of the ticket balance and unpaid sponsorship. Together, received and outstanding amounts equal $31,610. Add the $990 payment costs deducted before settlement, and you reconcile to the $32,600 event revenue figure.

This comparison assumes the event revenue has been earned under the management reporting approach we're using. It doesn't decide when your business should report income for tax. Keep your formal accounting basis consistent with your accountant's advice.

Notice why the difference matters commercially. The sponsor's unpaid balance contributes to the event result in this example, but it can't pay tomorrow's crew invoice. The ticket balance has a different collection route and expected payment date. Combining both into a single note saying money pending hides what you need to do next.

Record the ticket provider's balance and expected release date separately from the sponsor invoice. The person chasing the sponsor may have nothing to do with payout administration. Our event cash-flow forecast guide explains how to translate those expected receipts into the dates when you can actually make payments. A settled revenue calculation and an available bank balance answer different questions.

Match payments without counting them as new sales

A ticket sale can appear in the ticket report, the payment provider's report and the bank statement. That's one customer purchase appearing at different stages. Adding all three amounts is an obvious error once you describe it that way, but less obvious when a workbook contains several tabs named revenue.

Choose the sales record that establishes the event's revenue. Use the settlement report to explain deductions and transfers. Use the bank statement to confirm that the transfer arrived. Keep a reference joining the records, rather than copying each amount into the revenue column.

Stripe's payout reconciliation documentation describes matching automatic payouts to their underlying transaction batches. Its downloadable itemised report can include payments, refunds, disputes and fees. Manual and instant payouts need a different reconciliation approach because Stripe can't necessarily identify a specific transaction batch for them. Check the available report for your payment arrangement instead of assuming every deposit has an identical breakdown.

The same principle applies when your venue pays bar commission together with a returned deposit. One transfer can settle two unrelated balances. Record the commission against the bar agreement and the deposit return against the original deposit. Counting the whole transfer as bar revenue makes that bar deal look better than it was.

If a payout covers several events, allocate it using the provider's underlying records. Don't divide it equally because the event dates are close together. Keep any amount you can't identify in an unresolved list until you have supporting detail. A tidy total isn't useful if its event allocation is a guess.

Recalculate the vendor share before approving it

The phrase net sales does a lot of work in vendor reports. One operator may mean customer spending after refunds. Another may also deduct processing costs, discounts, staff meals or a management fee. Your agreement needs to determine which calculation is allowed.

Return to the bar example. The $12,000 is the agreed eligible sales base, and 20% produces $2,400 commission. If the operator then deducts an additional $300 processing fee before applying your percentage, the commission becomes $2,340. That $60 difference is a contract question before it's a spreadsheet question.

Ask the operator to show each deduction and its contractual basis. If processing costs are permitted before calculating commission, the revised calculation may be correct. If they aren't, the operator needs to correct its statement. Don't invent a compromise percentage just to finish the close.

Fixed fees and minimum guarantees need equally careful handling. Your agreement might require the greater of a minimum fee and a sales percentage, or it might require both. Those are different commercial deals. Our guide to negotiating bar revenue shares explains why the calculation base matters as much as the headline percentage.

A report discrepancy doesn't automatically mean bad faith. The vendor may have used its normal report for an agreement with different terms. Send the calculation you expect, the relevant clause and the specific difference. A clear request is easier to resolve than an email saying the numbers look wrong, particularly when the vendor has several event settlements underway.

Keep customer credits, bundles and complimentary items separate

Prepaid event credit creates another opportunity to count the same money twice. A customer can buy credit and then spend it at several stands. Those movements describe funding and spending, which need to be connected before you decide what belongs in revenue or vendor settlement.

Suppose a ticket includes a food voucher. The ticket system may show the full ticket price while the caterer reports the redeemed voucher value as sales. Adding both reports can count part of the attendee's payment twice. Establish how the ticket income is recorded, what you owe the caterer and which record supports each amount.

Complimentary credit needs a clear funding owner too. If you give a sponsor's guests free drinks, the bar may still be entitled to payment for serving them. That can be an event cost, a sponsor delivery cost or another agreed arrangement. It isn't automatically new customer income because the bar report assigns those drinks a retail value.

Unused credit and unredeemed vouchers need their own review. Who owes the customer a refund? Who holds the funds? Does the agreement allow the vendor to claim payment without redemption? Record the remaining balance and the applicable terms rather than treating every unused amount as profit on event night.

You don't need to settle every accounting question in the operations workbook. You do need to preserve the movements and flag what remains undecided. Your accountant can assess the treatment when the underlying records show funding, redemption, refunds and obligations separately. A single cashless total usually can't explain that whole sequence.

Reconcile merchandise and supplier credits properly

Merchandise sold by your business needs sales evidence and a stock explanation. Compare opening stock, additional stock received, units sold, complimentary items, damaged items and closing stock. Investigate differences before assuming that every missing shirt was sold for cash.

Stock counts won't always agree perfectly with sales records. A shirt exchanged for another size changes stock quantities without necessarily creating a new sale. A damaged item may leave stock without producing income. Keep those adjustments visible, with the person approving them, so the merchandise result remains explainable.

For consignment merchandise, confirm who owns unsold goods and who owes the artist or supplier. If you collect money on someone else's behalf, the balance due to that person needs to remain visible even while the cash is in your bank account. Ask your accountant how the specific arrangement should appear in revenue and costs.

Supplier credits require similar care. A caterer might reduce its invoice after failing to deliver an agreed item. That normally changes what the service costs you under the agreed treatment; it doesn't create another stream of attendee sales. Keep the credit against the original supplier invoice so you can see the corrected cost.

The Australian Government's guide to setting up a profit and loss statement separates sales, cost of goods sold and operating expenses. Preserve those distinctions when moving your checked figures into the event result. Otherwise, the merchandise stand can appear highly profitable because the income arrived while the stock cost disappeared into another file.

Handle cash with a count and a handover record

Cash needs a record of what was counted and where it went. A sales report that includes cash doesn't prove the cash reached your business. A bank deposit doesn't prove every cash sale was recorded. You need to compare both with the cash handover.

Start with the opening float, meaning the change provided before trading. Add recorded cash sales, subtract approved cash refunds and any documented cash removals, then compare the expected amount with the physical count. Identify the float separately when calculating sales proceeds. Returning your own starting cash isn't new revenue.

Have the person handing over the cash and the person receiving it confirm the amount and time. Record any sealed bag or deposit reference used by your operation. If the cash goes directly from a vendor to a cash collection service, retain the supporting handover record rather than waiting for the eventual bank entry to explain everything.

Paying a supplier from the takings doesn't reduce customer sales. Record the full sales amount and the authorised supplier payment separately, with its receipt. Otherwise, you understate both income and costs and make it harder to compare this event with the next.

When the count differs, record the difference explicitly. Check refunds, cash removals, starting floats and payment-method entries before deciding what happened. A card sale accidentally recorded as cash can create a shortage on paper. Assign a person to investigate the difference and retain the result; don't bury it in a miscellaneous fee to make the sheet balance.

Find the difference without changing the agreed total

When two reports disagree, work through the likely causes in a consistent order. First check that both reports cover the same event and period. Next compare the definitions of sales and deductions. Then inspect the underlying transactions and payments. Starting with individual transactions while the reports use different dates can waste an afternoon.

Ask whether a second file replaces the first or adds missing activity. A corrected bar report can look like another day's sales when it arrives with a new filename and no explanation. Keep the superseded copy for evidence, but exclude it from the active calculation. Ask the vendor to explain what changed between versions.

Check currencies before adding amounts. If the merchandise provider reports one currency and your event summary uses another, retain both amounts and document the conversion method. Keep conversion charges visible. The exchange rate in a supplier's estimate may differ from the rate applied when payment settles, so a difference doesn't necessarily mean sales were missed.

Then look for duplicate records. An invoice number or transaction reference is more useful than matching only on value. Two customers can spend the same amount; one customer can make several legitimate purchases. A repeated amount deserves inspection, rather than automatic deletion.

Keep a short differences log while investigating. Record the amount, likely cause, evidence requested, owner and next review date. If the bar's commission is disputed but the merchandise settlement is verified, the summary should show that distinction. You can use the merchandise figure confidently while the bar calculation remains provisional.

Turn the report into a useful vendor conversation

The finished summary should help you decide whether an arrangement worked. Compare what the event earned from each vendor with the costs and effort you took on to support it. A commission calculation can be correct while the overall deal remains poor for your business.

For example, our hypothetical event earns $2,400 from the bar. Suppose the event also incurs $700 in bar-specific support costs, covering agreed power and additional cleaning. That leaves $1,700 before any shared event overhead. Those support costs need to appear in expenses; subtracting them only in a private email would make the main event result incomplete.

If the operator asks for a lower commission next time, you can now discuss the actual arrangement. Could it cover more of those support costs? Would a minimum payment make the risk acceptable? Has it supplied evidence that the current percentage prevents it delivering a viable service? You have specific terms to negotiate instead of reacting to a request for a cheaper pitch.

Avoid comparing vendors on customer turnover alone. A merchandise seller may generate less spending than the bar but require less space, power and supervision. A sponsor may contribute more revenue while creating substantial delivery work. Use the figures to understand each arrangement before deciding which one to expand.

Keep customer experience in that discussion. Reducing service staff may improve a vendor's immediate settlement while lengthening queues and disappointing paying attendees. The report should help you ask better questions about next time, with the service obligations and commercial terms considered together.

Close the event with decisions still visible

You can finish the initial settlement before every balance is paid, provided the outstanding amounts are specific. Name the counterparty, amount, supporting record, due date and next action. Distinguish an expected payment from a disputed calculation. They require different follow-up.

For our example, the sponsor's $2,000 should have an invoice reference and collection owner. The ticket provider's $1,000 should have an identifiable provider balance and expected release basis. If either amount changes, update the event summary and preserve the reason. Don't leave the original report circulating as though it still describes the final position.

Set a review point after the first settlement, based on your agreements and the records still outstanding. Check for later refunds, chargebacks, vendor corrections, sponsor credits and invoices relating to the event. There isn't a universal closing day that makes those obligations disappear.

Someone other than the preparer should review substantial settlements where your team allows it. They should be able to reproduce the income total, trace received amounts to the bank and understand each unresolved item. The review is also a chance to catch costs deducted twice or vendor turnover mistakenly recorded as your revenue.

Use the result to improve the next agreement. If the same vendor repeatedly sends unusable summaries, change the reporting requirement before booking again. If a sponsor consistently pays late, change the payment schedule or collection process. The point of checking the numbers is to make better commercial decisions while you still control the terms.

Use connected reporting, then finish the vendor settlement

Loopyah's event management software shows ticket sales, sponsorship and payouts within the same event system. Use event records as your starting evidence, then obtain the reports and contractual calculations for independent vendors whose activity sits elsewhere.

Before calling a figure final, ask whether you can explain each income source without switching definitions halfway through. Can you show the sales belonging to your business, the commission you earned, the deductions you authorised and the money still outstanding? Can another person follow the references and reach the same answer?

If the answer is yes, you have a report you can use to decide what the event earned and what needs collecting. If a vendor's report still doesn't explain the amount due, resolve that specific calculation before signing its settlement. Use the verified figures when negotiating future bookings.