The ticket ledger lists every ticket sold in a period — one row per ticket — with its money and the exact tenders that paid for it. It is built for whoever keys ticket sales into the accounting software, and for reconciling the cash drawer and the card payout.

Go to Admin → Venues → [your venue] → Reports → Ticket ledger.

Filters

| Filter | What it does | |---|---| | Range | Which sales to list, by sale date in the venue's time zone. Quick picks: Today (the default), Yesterday, Last 7 days, Month to date, Prior month. Choose Custom dates… to pick a From and To day (both included). | | Performance | Only tickets for one performance. | | Tender | Only orders paid at least partly with that tender. A split cash + gift card order appears under both Cash and Gift card, with all of its tickets. | | Seller | Only sales rung up by one staff member (type part of their name). | | Include imported history | Also list tickets imported from your previous ticketing system. They are off by default because they are already in your books. |

Columns

| Column | What it shows | |---|---| | Sold at | Date and time of the sale, in the venue's time zone | | Order | The order number (for online and card sales, the card payment id) | | Ticket | The ticket id — one row per ticket | | Event / Performance | The show and the date and time of the performance | | Seat | Section, row and seat, or the general admission tier | | Patron / Email | Who bought the ticket. Door walk-ups without a receipt show "Walk-up" | | Unit price | The ticket's face price | | Discount / Discount code | Promo, membership or other discount on this ticket, and the code used | | Fees / Tax | This ticket's share of the order's service and card fees and its sales tax | | Donation | This ticket's share of a donation added at checkout | | Other | Add-ons and any order-level difference, so the row always adds up | | Total paid | What was tendered for this ticket — the sum of its tender lines | | Net to venue | The venue's ticket revenue on this ticket (the payout basis) | | Pricing | Plus fees — fees and tax are charged on top of the unit price. All-in — fees and tax are already inside the unit price, shown so you can split them out | | Tender | How the ticket was paid, for example Cash $20.00 + Gift card ****1234 $19.00 ($31.00 left) | | Seller | The staff member who rang up the sale (blank for online sales) | | Register | The door POS device that took the sale | | Channel | Online, Box office or Door POS | | Status / Status detail | Sold, Refunded, Refund pending or Exchanged, with the date, how a refund was paid back, and a link to the other ticket of an exchange | | Imported / Imported face value | Marks imported history (only when included). Imported rows never carry money in the other columns |

Every row adds up: Total paid = Unit price − Discount + Fees + Tax (on plus-fee pricing) + Donation + Other, and it equals the sum of the row's tender lines. When an order has several tickets, its fees, tax and tenders are shared across the tickets to the cent, so the rows of an order always add back to the order.

How tenders are shown

| Tender | Example | Notes | |---|---|---| | Cash | Cash $27.00 | | | Card | Visa ****4242 $48.70 | Card brand and last 4. "(tap)" marks door Tap to Pay, "(keyed)" a card keyed at the box office. Sales made before card details were recorded show just "Card" | | Gift card | Gift card ****7K2Q $30.00 ($20.00 left) | The last characters of the gift card code and the balance left on it right after this order | | Check | Check #1042 $30.00 | The check number when staff entered one | | Comp | Comp or Comp ($20.00 face value) | A ticket given away. No money changes hands; the amount is face value comped beyond any recorded discount | | Exchange credit | Exchange credit $40.00 from order … | The value carried over from the ticket it was exchanged from, plus any extra paid by card or cash |

Summary tiles

The tiles above the table total the listed rows: Tickets, Gross, Discounts, Fees, Tax, Net, and one tile per tender — Cash, Card, Gift card and Comp always, plus Check, Exchange credit and Other when used. Refunded since is the money returned so far on the listed orders.

The tender tiles add up to Gross − Discounts + Fees and tax on plus-fee sales + Donations.

Reconciling the cash drawer

1. Run the ledger for the day (or pick Yesterday the next morning) and set Tender to Cash.
2. Compare the Cash tile with the cash counted in the drawer. The Cash tile includes the cash part of split orders.
3. For a drawer per person or per device, add the Seller filter, or sort the XLSX by the Register column.

Reconciling card payouts

The Card tile is the card money charged on the day's sales. The card processor pays that out a few days later, less processing fees and any refunds, so the bank deposit will not match the tile exactly. Use the Payment reference column on the XLSX Tenders sheet to match individual charges, and Payout reconciliation to tie each deposit to its orders.

Refunds and exchanges

A ticket stays on the ledger under the day it was sold, with its original amounts, even after it is refunded or exchanged. Its Status changes and Status detail shows when and how. Run the ledger for the sale date to see the original sale; the Refunded since tile shows how much of those sales has been given back.

Exports

• CSV — the table as shown, money with two decimals.
• XLSX — two sheets: Ticket ledger (the table) and Tenders, with one row per tender line per ticket: tender type, amount, card brand and last 4, gift card and balance left, and the payment reference.

Gift certificate sales and membership sales are not tickets, so they are not on this ledger.

QuickBooks Desktop journal

Under the ledger, QuickBooks Desktop journal turns the day's sales into one balanced general journal entry — including that day's gift card sales and refunds — that you can import into QuickBooks Desktop instead of keying the day by hand. See QuickBooks Desktop: importing the daily journal.