FANZ
FANZ

Documentation

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:

  1. Select an existing configuration from the dropdown
  2. Or click "Create" to make a new one
  3. Click "Assign configuration to event"

Creating a configuration

See Bordereaux settings for detailed instructions. Quick overview:

FieldDescription
NameConfiguration name for reference
Venue %Percentage of net going to venue
Producer %Percentage of net going to producer
DiscountsPre-agreed deductions (fixed amount, %, or ticket quantity)
IP OwnerIntellectual 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

ButtonFunction
PrintPrint the report
Generate PDFDownload as PDF
Export XLSXDownload as Excel spreadsheet
EditEdit the assigned configuration
ConfigurationChange 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:

  1. Change configuration: Select a different one from the dropdown
  2. Create new: Make a new configuration
  3. Payment notification: Set producer email and payment date for automated notification
  4. Add manual entries: Include non-ticket revenue (merchandise, sponsorships, etc.)

Detail | Summary

Above the report there is a Detail | Summary control. It opens on Detail.

Summary groups sold tickets by name and charged price, across every payment method except courtesies and free tickets. The row shows that name, not the rate, the discount, or the channel. Courtesies are one line after the sold total. The show header stays, and the IP owner, discounts, manual entries, the split, and expenses are left out.

Print, Generate PDF, and Export XLSX follow the view you have open. A summary file has summary in the name.

Configuration for this function only

The event configuration applies to every function. When you edit it from this function, Save for this date only keeps a copy of its own. That copy says Applies to this date only. Use the event's configuration discards it, and the date is calculated with the event's configuration again.


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:

ColumnDescription
Type of localityTicket name (and rate name, if not General) + price
LocalitiesQuantity sold at that price
Total amountRevenue 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:

ColumnDescription
DescriptionDiscount name
DiscountValue (%, fixed amount, or ticket count)
AmountCalculated deduction

Last row: Discounts total

3. Payouts table

Shows the revenue split:

ColumnDescription
DescriptionParty name (Venue, Producer)
PercentageConfigured split %
AmountCalculated 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:

  1. In the event's Bordereaux tab, scroll to the Expenses section
  2. Click Add expense
  3. Fill in Name, Amount and Charged to (Producer or Venue)
  4. Click Create — 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.

A post-split expense is always charged to a single party. If both parties pay for it, add it as a discount instead (see the next section).


Shared expenses between venue and producer (discounts)

In the bordereaux, a discount is a shared expense. Discounts are subtracted from gross takings before the split, so each party absorbs the expense in proportion to its percentage. With a 50/50 split each party pays half; with a 70/30 split the expense is shared 70/30.

Use them for costs both parties pay: venue marketing, press, industry passes, shared technical costs, etc.

How to add a shared expense:

  1. In the event's Bordereaux tab, click Edit (next to the configuration selector). You can also do it from Settings → Bordereaux → the configuration's ⋮ menu → Edit
  2. In the Discounts section, click New discount
  3. Enter the expense Name (e.g. "Venue marketing")
  4. Under Discount type, choose Fixed amount and enter the amount. You can also use Percentage (of total sales) or Tickets (number of tickets at the highest rate)
  5. Click Create, then Save

The expense shows up in the report's Discounts table and the venue and producer payouts are recalculated.

Important: discounts are part of the configuration, so they affect every event that uses it. If the expense only applies to one event, create a configuration for that event (with the same split) and add the discount there.

A shared expense isn't assigned to either party: the discount already splits it between both. Only if your split isn't 50/50 and the agreement is to pay exactly half each, add it as two post-split expenses of half the amount each: one charged to the Producer and one charged to the Venue.

5. Balance table

Final reconciliation:

RowDescription
Takings amountTotal collected
Discounts amountTotal deductions
Producer amountProducer's net share after expenses
Venue amountVenue's net share after expenses
ResultAlways $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.

Manual entries are income: they don't accept negative amounts. To subtract a cost, use a discount (if both parties pay it) or a post-split expense (if only one party pays it).


Payment notifications

Set up automatic payment notifications:

  1. Click Configuration
  2. Enter producer email
  3. Set payment date
  4. 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 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.

Add it as a discount in the bordereaux configuration: Edit → Discounts → New discount → type Fixed amount. Discounts are subtracted before the split, so both parties pay the expense according to their percentage (half each with a 50/50 split). You don't need to assign it to a party or add it twice.

Yes. Add it as a discount, not as a post-split expense: Edit → Discounts → New discount → type Fixed amount → Create → Save. The discount is subtracted before the split, so the producer and the venue pay it according to their percentage; with a 50/50 split it's divided equally. Add expense is only for expenses paid by one of the two parties.