• Neon Harbor · FY ends 31 Dec
Example dashboard You're looking at a sample band's books — Neon Harbor, a made-up four-piece. Every number is real in shape and made up in fact. Nothing here can be edited or saved. Get early access →

Neon Harbor

Neon Harbor LLC · Ava · Marcus · Dey

Cash on hand

$49,750

Checking $31,500 Savings $18,250

Royalties in / month

$11,000

Distributor $6,000 · Label services $5,000

Fixed out / month

$6,500

Draw $6,000 · overhead $500

Monthly surplus

+$4,500

Building reserve, before any touring

The winter tour actually made money
Corrected · swing $86,047

Two things were wrong with the budget you were given: the income total skipped eight shows, and merch wasn't in it at all.

Budget said
−$59,116
Show side, as filed
+ 8 missing shows
−$3,070
SUM(D6:D48) stopped at row 48
+ merch net
+$30,000
$80,000 gross − $50,000 COGS
True net
$26,930
$7,720 each, not −$20,289
Is the draw funded?
Answered

Royalties in, against the $6,000 going out to all three principals.

Yes — covered 1.83× over. Royalties bring in $11,000 a month against $6,000 of draw, so the distribution is funded and the surplus builds the reserve that makes a losing tour survivable. If royalties stopped dead, $49,750 covers fixed costs for 6.2 months.
Recurring money, month by month
Royalty income against fixed costs — touring sits on top of this
$132,000/yr in
Commissions paid
From your files

Exact, across both 2026 tours.

Management 15% $51,279
Agent 10% $31,686
Business manager 4% $13,675
Off $357,863 of gross

27.0%

Twenty-seven percent of everything you grossed, to three people. The 4% is the smallest slice — and the only one whose entire job is work a system can do.

Where the tour money went
Both 2026 tours · $422,257 of expenses
From your files
Tours on file
Show side only — merch is in none of these budgets, which is why both read as losses
Open the budget
TourShowsIncome ExpensesNetMargin
Winter 2026 — Headline Run 2026-01-14 → 2026-03-08 · 47 days 32 $309,363 $368,479 $26,930 was −$59,116 6.9%
Autumn Run 2026-09-21 → 2026-09-28 · 8 days 6 $48,500 $53,778 −$5,278 -10.9%
Spotify monthly listeners
Confirmed

412,000

28-day rolling · as of 2026-10-18

One snapshot so far. The trend line appears from your second entry — add one a month and this becomes a history Spotify's rolling window won't give back.
Needs you
Found by reading your spreadsheets — that's the job the 4% is supposed to do
3 critical
Fix
The winter income total stops 11 rows short — 8 shows missing

Projected Income!D63 is SUM(D6:D48), but the shows run to row 59. San Francisco, Los Angeles, Phoenix, Santa Fe, Oklahoma City, Dallas, Austin and Houston — $78,939.06 of projected income — are not in the tour total. The Walk Out column beside it sums to row 59, so the two ranges disagree in the same row. Every commission is computed off the short number, and the headline loss is wrong: the tour is roughly break-even on the show side, not down $59,116.

$78,939
Projected Income!D63
Fix
Crew payroll tax is budgeted at zero

Musicians carry a 15% formula (G12); crew carries a hardcoded 0 (G28). On $110,450 of winter crew salary that is roughly $16,568 of employer burden missing from the budget.

$16,568
Expense Detail!G28
Fix
The insurance total drops two rows

SUM(G103:G106) stops short of Work Comp Crew (G107) and Taxes (G108). It reads $0 today so nobody has noticed — the moment a real crew comp number goes in, it vanishes.

Expense Detail!G109
Review
23 of 32 shows have no withholding applied

Nine were hand-typed at nine different rates — NC 4%, PA 3%, MA 5.6%, OH/MN/MO 2%, Ontario and BC 15%. A jurisdiction rate table settles the rest.

Projected Income!H
Review
No merch figures anywhere

Ava confirms merch is where the margin is and that it carried both tours. It appears in none of the three budgets, so every tour P&L here understates reality until it is entered.

absent from all files
Review
Production exists in one file and not the other

The Autumn Run summary has no PRODUCTION block at all, so its TOTAL EXPENSES cannot include rows that were never inserted. Two tours, two different definitions of total expenses.

Budget Summary!C48
Settings
  • Theme Mode

    Choose light or dark mode or Auto

  • Sidebar Theme

    Choose Sidebar Theme

  • Accent color

    Choose your primary theme color

  • Sidebar Caption

    Sidebar Caption Hide/Show

  • Theme Layout

    LTR/RTL

  • Layout Width

    Choose Full or Container Layout