Event bordereaux
The Bordereaux tab generates detailed sales reports for splitting revenue between venues, producers, and other parties. It's essential for professional event accounting.
Who can see it: any role with read access to Events — Owner, Admin, Producer (their assigned events) and Analyst (read-only). With a Custom role, it's enabled via the Events → Bordereaux sub-tab. Creating or editing configurations requires write access, and manual entries can only be managed by Owner and Admin.
Getting started
If no configuration assigned
You'll see: "Bordereaux not configured. To view the bordereaux for this event, you need to assign a bordereaux configuration."
To assign:
- Select an existing configuration from the dropdown
- Or click "Create" to make a new one
- Click "Assign configuration to event"
Creating a configuration
See Bordereaux settings for detailed instructions. Quick overview:
| Field | Description |
|---|---|
| Name | Configuration name for reference |
| Venue % | Percentage of net going to venue |
| Producer % | Percentage of net going to producer |
| Discounts | Pre-agreed deductions (fixed amount, %, or ticket quantity) |
| IP Owner | Intellectual property owner details |
The bordereaux report
Once configured, you'll see a comprehensive sales report.
Header information
- Brand name
- Location
- Event name
- Date
- Total capacity
- IP Owner (if configured)
Report actions
| Button | Function |
|---|---|
| Print the report | |
| Generate PDF | Download as PDF |
| Export to XLSX | Download as Excel spreadsheet |
| Edit | Edit the assigned configuration |
| Configuration | Change configuration, create a new one, set up notifications, or add manual entries |
Configuration options
The Edit button and the Configuration dropdown are now separate controls:
- Edit: Opens the current configuration directly for editing (⚠️ changes affect all events using it)
- Configuration dropdown: Lets you change to a different configuration, create a new one, set up payment notifications, or add manual entries
Click "Configuration" to access:
- Change configuration: Select a different one from the dropdown
- Create new: Make a new configuration
- Payment notification: Set producer email and payment date for automated notification
- Add manual entries: Include non-ticket revenue (merchandise, sponsorships, etc.)
Report tables
1. Collection details
A breakdown of income collected, organized by source:
Sections:
- Online: Sales via Mercado Pago/Stripe
- Ticket office: Physical box office sales
- Courtesies: Free tickets (shown for reference)
Columns:
| Column | Description |
|---|---|
| Type of locality | Ticket name (and rate name, if not General) + price |
| Localities | Quantity sold at that price |
| Total amount | Revenue from that line |
Important notes:
- Each unique price creates a separate row (same ticket sold at different prices = multiple rows)
- When a ticket has multiple rates, the rate name is shown alongside the ticket type — except for the default "General" rate, which shows only the ticket name. For example, an "Early Bird" rate on a "VIP" ticket appears as "VIP – Early Bird".
- Discounted tickets show their actual sale price
- Service charges are NOT included here
- Refunded tickets don't appear
- Ticket office entries include payment method (credit, debit, cash, etc.)
Example:
General - $20 - 50 units - $1,000
VIP – Early Bird - $50 - 30 units - $1,500
VIP – Regular - $80 - 20 units - $1,600
Ticket A - $14 (with 30% discount) - 20 units - $280
The last row shows Total income from all sources.
2. Discounts table
Shows pre-agreed deductions from the bordereaux configuration:
| Column | Description |
|---|---|
| Description | Discount name |
| Discount | Value (%, fixed amount, or ticket count) |
| Amount | Calculated deduction |
Last row: Discounts total
3. Payouts table
Shows the revenue split:
| Column | Description |
|---|---|
| Description | Party name (Venue, Producer) |
| Percentage | Configured split % |
| Amount | Calculated payout |
Last row: Total (net for payouts)
4. Expenses table
After the revenue split is calculated, you can add post-split expenses charged to either the producer or the venue. These appear in a dedicated expenses section of the report.
What are post-split expenses?
Post-split expenses are costs deducted from a party's share after the revenue split has already been applied — for example, production costs charged to the producer, or venue-specific fees charged to the venue.
How to add post-split expenses:
- Click Configuration
- Select Add manual entries (or the equivalent expenses option)
- Enter the expense description, the amount, and which party it is charged to (producer or venue)
- Save — the report updates immediately
The expenses section shows each expense line with its description, the charged party, and the amount. The last row shows an Expenses subtotal.
Effect on net payouts:
Once expenses are added, the net payout amounts for the producer and venue are updated to reflect the deductions. The final figures shown for each party are their shares after both the revenue split and any post-split expenses have been applied.
5. Balance table
Final reconciliation:
| Row | Description |
|---|---|
| Takings amount | Total collected |
| Discounts amount | Total deductions |
| Producer amount | Producer's net share after expenses |
| Venue amount | Venue's net share after expenses |
| Result | Always $0 (balanced) |
Manual entries
Click Configuration → Add manual entries to include non-ticket revenue:
- Merchandise sales
- Sponsorships
- Bar/food revenue
- Other income sources
These appear in the income table and are included in calculations.
Payment notifications
Set up automatic payment notifications:
- Click Configuration
- Enter producer email
- Set payment date
- The producer receives an email with payment details on that date
When a bordereaux due email is sent, it includes the full breakdown — including any post-split expenses — so all recipients see the complete picture of final payouts for both the venue and the producer.
Best practices
Before the event
- Create and assign bordereaux configuration during event setup
- Agree on all discounts and splits with parties beforehand
- Test the configuration with sample numbers
After the event
- Generate final report once all sales are closed
- Add any manual entries (merch, sponsors)
- Add post-split expenses if applicable before sending payment notifications
- Export to PDF for signatures
- Print two copies for both parties
Documentation
- Keep signed copies for accounting
- Export to XLSX for your records
- Use payment notification for formal payment communication
FAQs
Each unique price creates a separate row. Different rates, discount codes, or price changes all create separate lines. This gives you a detailed breakdown of exactly what was sold at each price point.
Service charges are used to cover payment processing fees, Fanz platform fees, and general transaction costs. The bordereaux shows only the ticket price totals (what the buyer paid for the ticket itself), not the service charges, since those cover operational costs separate from the venue/producer split.
You'll see separate rows for each price. For example, if "General" was $20 for the first 50 sales then changed to $25, you'll see two rows: "General - $20" and "General - $25" with their respective quantities and totals.
Each rate appears as its own row with its specific price. If "VIP" has an Early Bird rate at $50 and a Regular rate at $80, you'll see two separate lines — "VIP – Early Bird" and "VIP – Regular" — each with the quantity sold at that price. The rate name is omitted only when it's the default "General" rate.
Discounted tickets show their actual sale price, not the original price. If a $100 ticket was sold with a 30% discount, it appears as a $70 row. This reflects the real revenue collected.
Ticket office sales are grouped separately and include the payment method (credit card, debit card, cash, transfer, etc.) as part of the description. This helps reconcile cash vs. card payments at the venue.
Post-split expenses are costs deducted from the producer's or venue's share after the revenue split is calculated. Use them for agreed deductions that apply specifically to one party — for example, a production cost charged to the producer or a cleaning fee charged to the venue. They appear as a separate expenses section in the report, and the net payouts update automatically to reflect the deductions.
Yes. When a bordereaux due email is sent, it includes the full expenses breakdown alongside the final net amounts for the venue and the producer, so all recipients see the complete picture of what each party receives.
The Edit button opens the currently assigned configuration directly so you can modify it. Keep in mind that edits affect all events using that configuration. The Configuration dropdown is separate and lets you switch to a different configuration, create a new one, set up payment notifications, or add manual entries — without immediately editing the current configuration.