Download The Free Bookkeeping Workbook
The workbook includes Instructions, Inventory & Purchases, Sales & Payouts, Expenses, and Monthly Summary tabs. It is designed for operational tracking and does not replace professional accounting or tax advice.
Ticket Reseller Bookkeeping Template
Record cost basis, listing status, marketplace payout, direct fees, expenses, and monthly net results.
Download Excel WorkbookWhat Every Record Needs
| Stage | Minimum fields |
|---|---|
| Purchase | Event, date, venue, city, section/row/seats, quantity, order number, source, purchase date, cost basis |
| Listing | Marketplace, listing ID, asking price, listing date, status, in-hand date |
| Sale | Sale date, gross sale, seller fee, net payout, buyer delivery status |
| Payout | Expected date, received date, amount, discrepancy note |
| Result | Net payout minus cost basis and allocated expenses |
A Weekly Reconciliation Habit
- Match every purchase confirmation to an inventory row.
- Match every sale to the exact seats and mark other listings inactive.
- Match every marketplace payout to the sale record.
- Record refunds, cancellations, chargebacks, and unreimbursed costs.
- Review unsold inventory and upcoming delivery deadlines.
- Back up the workbook and retain original receipts.
1099-K Is Not A Profit Statement
Marketplace reporting can show gross payment volume rather than profit. Keep purchase receipts, selling fees, refunds, and operating expenses so a qualified tax professional can determine the correct treatment. Read ticket reseller taxes and 1099-K explained for the current federal overview.
Bookkeeping FAQ
Can a beginner track tickets in Excel?
Yes. A spreadsheet is often sufficient while inventory is small and one person controls buying, listing, delivery, and reconciliation.
When is a POS worth considering?
Consider a POS when duplicate listings, multi-marketplace inventory, team access, and fulfillment volume are becoming difficult to control manually.
What records should ticket resellers keep for taxes?
Retain purchase confirmations, marketplace statements, payout records, refunds, direct expenses, and business records required by applicable law. Ask a qualified tax professional about retention and classification.
Official Sources
Provider policies can change. Verify the current event, marketplace, and tax rules before acting.
Research before you risk capital
DailyTicketRankings organizes presale windows, access details, official links, resale context, and event notes into one daily brief.
View Guided Preview