Event management dashboard: bookings, capacity and costs

An event management dashboard compares bookings, attendance, capacity, and event costs against a stated plan. It should explain whether the team filled the available places, whether registered people attended, and what the event cost to deliver. Keep those questions separate: a strong booking rate does not prove a strong attendance result or a favorable budget outcome.

Define the event and the reporting cutoff

Use one event identifier across the registration export, check-in list, budget, and supplier expense file. Set a cutoff for costs and record whether the figures are final or still awaiting invoices. The same event name typed differently in separate files should not create separate events in the review.

Define active registrations as distinct confirmed attendee places after cancellations. Define attendance as distinct participants recorded as attending, rather than every check-in scan. Decide how walk-ins, complimentary places, staff, and guests enter both populations before computing a rate.

Capacity here means sellable attendee places supplied by the event owner. It is a commercial planning field, not a calculation of the venue's permitted occupancy. The venue and event team must establish the appropriate operational limits separately.

The layout can stay compact:

Use the same figures in the wider management reporting package so event results do not change when they reach finance.

A worked US event portfolio

A fictional US professional-services company runs customer workshops in Chicago, Denver, and Atlanta during September 2026. The following review is after all three events, with their direct costs complete. Capacity and registrations exclude staff; attendance includes only registered attendees. There are no walk-ins in this example.

Ticket revenue is net of refunds and excludes sales tax collected for remittance. All financial amounts are USD. Sponsorship revenue is reported on the same event-performance basis as ticket revenue.

Booking utilization = Active registrations / Sellable capacity

Attendance rate = Unique attendees / Active registrations

Registrants who did not attend = Active registrations − Attendees

Percentages are rounded to one decimal using unrounded calculations. The portfolio attendance rate is 555 / 675 = 82.2%. Denver's 135 / 180 = 75.0% deserves a different discussion from booking utilization: every event booked the same percentage of available places, yet the attendance outcomes differ.

Remaining places are capacity less active registrations, measured at the final booking cutoff. They are not an estimate of how many people could have been admitted safely on the day.

Put event costs beside the attendance result

The company includes venue, catering, and other direct event costs in this review. It excludes corporate overhead and staff salaries, so the resulting contribution is not company net profit.

Actual cost sums the three categories. Cost variance is actual less budget, so a positive variance means over budget. Cost per attendee divides actual cost by attendees, not registrations.

Per-attendee amounts are rounded to cents. Denver's cost per attendee is 11,500 / 135 = $85.19. Portfolio cost per attendee is 42,800 / 555 = $77.12; contribution is 45,500 − 42,800 = $2,700. The portfolio is under budget, but that total does not remove Denver's overrun or negative direct contribution.

Use the expense management dashboard for the separate expense-control review. Contract commitments and renewal dates belong in a contract management dashboard, rather than being implied by the event cost total.

Change attendance without changing cost

Suppose Chicago attendance rises from 240 to 270, with registrations, revenue, and every cost unchanged. This variation changes only attendance; it assumes no additional catering or other charges.

Cost per attendee falls because 17,100 / 270 = $63.33. Contribution stays unchanged because neither revenue nor total expense moved. The lower unit cost is better utilization of the same expenditure, not a cash saving.

Reconcile the files and avoid false comparisons

Check that event-level attendee counts sum to the check-in export after duplicate scans are removed. Financially, the category totals satisfy 22,500 + 15,000 + 5,300 = $42,800, and that cost must reconcile to the included finance records. Also prove that $42,000 ticket revenue plus $3,500 sponsorship equals $45,500 event revenue.

For a cost export with event in A, category in B, and amount in C, the following Excel formula sums Chicago venue costs:

=SUMIFS($C$2:$C$1000,$A$2:$A$1000,"Chicago",$B$2:$B$1000,"Venue")

Microsoft documents SUMIFS as adding values that meet multiple criteria. Covirage is not affiliated with Microsoft.

• Mixing payment dates with event costs. The SBA's finance guide distinguishes cash and accrual recording. Use a consistent accounting basis and show payment timing separately when needed.
• Counting scans as people. Repeat check-ins inflate attendance unless records are deduplicated by attendee and event.
• Averaging event ratios. Portfolio rates must divide the relevant totals, particularly when event sizes differ.
• Treating missing invoices as savings. Mark incomplete costs and update the review when charges are recorded.
• Reading commercial capacity as a safety assessment. A risk management dashboard addresses a different review; booking ratios alone do not establish event safety.

Review your event exports in Covirage

Bring a sample of your own registration, attendance, budget, and event-cost files. Covirage maps the columns; its tools compute and check the comparisons, and the external AI model explains the result with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring your file.

See project cost control for the supporting business use.