TicketLedgers
DemoYou're looking at TicketLedgers with sample data — a fictional brokerage, invented numbers. Click around freely; nothing can be changed.Want this for your business? Talk to Solstice →
Data healthwatches for silence, not just errors — a broken feed looks like a quiet day until something checks volumes
Sync heartbeat
Last sync 834h ago — the 6 AM / 1 PM crons aren't firing. Check Vercel.
Collector inbox
0 email(s) in the latest sync; 0 across the last 0.
Skybox sales
No new Skybox sales recorded in 48h — the team sells daily. Check the Skybox sync / API token.
Bank & card feeds
No balance snapshots yet — run plaid:balances or wait for the next sync.
Automatiq
No Automatiq listings line in the latest sync — step may not have run (deployed after it?).
Teach TL a new email format →A marketplace or parking provider TL doesn't read yet? Upload one of its emails, check what TL read, confirm. It reads that sender from then on.

Automated sync history

The full sync (Skybox, live stock, bank feeds, collector inbox + spam, matching) runs twice daily — 6:00 AM and 1:00 PM Central — or right now, on demand. Green means everything ran clean.

runs the full pipeline — emails (inbox + spam), Skybox, Plaid, marketplaces
Oct 12, 6:38 PMall steps clean48s · cron
skybox
  • events: 40 seen, 0 new
  • purchases: 55 seen, 0 new
  • sales: 61 seen, 0 new
plaid
  • bank: 2 accounts, 0 new transactions
emails
  • inbox: 0 new confirmations
matching
  • 0 new matches, 0 new exceptions

CSV Imports

Upload exports straight from the browser — no terminal needed. Imports are idempotent: re-uploading the same file skips rows already in the system. Order matters: Skybox first, then Reveal, so payments find their invoices.

1

Skybox UI exports

The Invoices Report and Purchases Report, exported as CSV from the Skybox UI. Creates purchases, events, inventory, sales, and invoices — plus aging exceptions for unsold cost on completed events.

2

Reveal Markets export

The Reveal export.csv. Creates payouts per remittance batch, applies payments to matching Skybox invoices, and raises exceptions for variances and unverified payments.

3

Bank statement

A CSV statement downloaded from the bank's website. Loads deposits and withdrawals for payout reconciliation — the manual fallback until the bank feed is automated. Works with most bank formats (needs a date, description, and amount or debit/credit columns).

4

Credit card statement

A CSV statement from the card used to buy tickets. Charges run straight through the fuzzy matcher against Skybox purchases — suggestions land on Reconciliation, unmatched charges raise exceptions. Card payments are recognized and skipped.

5

Receipt & payout emails

The collector inbox (auto-forwarded from all Odyssey accounts) is drained automatically every morning — or right now with the fetch button. Purchase receipts become purchases, payout reports become payouts applied to invoices, Private Tabs alerts become card charges. Manual .eml upload remains as the fallback.

Drag .eml files — or whole folders of them — anywhere in this box.

6

Settlement files

Portal downloads for marketplaces with no payout feed: the Gametime payout CSV, the SeatGeek charges CSV, and the GoTickets Seller Central payment breakdown. Format is auto-detected; each file becomes a payout applied line-by-line to invoices.

GoTickets: payouts now come from the Seller Central API on every sync (Sep 30). Only if a payment is missing: open it in Seller Central → export → save as gotickets-YYYY-MM-DD.csv (the ACH date) → upload here.

⚡

Skybox API Sync

Pulls purchases and invoices straight from Skybox — no export files. Read-only; runs through the same dedupe as the CSV imports, so re-syncing never duplicates. Use this for recent windows (days or weeks); full-history pulls should run from the terminal, which has no timeout.