A spreadsheet is a fine way to invoice as a DJ — right up until you’re juggling deposits and balances, touring across currencies, or chasing three late payers at once. None of that is something a spreadsheet does for you; it just gives you more cells to get wrong. Here’s an honest breakdown of where each one actually holds up. (If you’re not sure a spreadsheet or an app is even the right frame, start with the best way to invoice for gigs, which weighs every method by your gig volume and complexity.)
The comparison, gig-manager to gig-manager
| Spreadsheet | Invoicing app | |
|---|---|---|
| Setup time | Free, but you’re building it yourself | Minutes — most fields prefill from your last gig |
| Looks professional | Only as good as your template skills | Consistent, formatted PDF every time |
| Sending from your phone after a gig | Painful — pinch-zoom editing on mobile | Built for it; fill in and send in under a minute |
| Deposit vs. balance | Manual math, easy to lose track of what’s actually owed | Tracked automatically per invoice |
| Multiple currencies | You’re converting and re-labeling columns by hand | Set per invoice, no re-templating |
| Tax (GST/VAT/sales tax) | You add the line and the rate yourself, and hope it’s right | Applied automatically once your tax settings are set |
| Matching a payment to a gig | Manual — easy to lose track when three venues share a name | Invoice number + gig record tied together automatically |
| Late-payment reminders | You have to remember to check and chase | Status visible at a glance, no separate tracker to maintain |
| Cost | Free (your time is the cost) | Usually a small monthly fee |
When a spreadsheet is genuinely fine
Don’t let anyone tell you a spreadsheet is amateur hour. It’s the right tool when:
- You’re playing a handful of gigs a month, not dozens.
- You invoice in one currency, for clients in one country.
- You don’t take deposits — it’s one invoice per gig, paid in full.
- You’re comfortable rebuilding or copy-pasting the same template every time.
If that’s you, a clean tracker with the right columns (below) will keep your money organised without adding a new tool to learn.
Where it breaks down for a working DJ
The failure mode isn’t “spreadsheets are bad” — it’s that a spreadsheet doesn’t scale with the parts of DJ work that are actually complicated:
- Deposit + balance tracking. A wedding or corporate gig often means a deposit at booking and a balance after. Doing that math across dozens of rows, by hand, is where errors creep in — you either double-bill or forget to invoice the remainder.
- Touring across currencies. A Berlin gig in euros and a London gig in pounds on the same week’s calendar means re-templating columns, converting rates, and re-checking your own arithmetic every time.
- Matching payments to gigs. When three different bookings are all “Fabric” or “The Warehouse,” and a bank transfer lands with a vague reference, a spreadsheet gives you no faster way to tell which invoice just got paid than scrolling and squinting.
- Sending it from your phone, backstage. Editing a spreadsheet template on a phone screen right after you’ve loaded out is a genuinely bad experience — small cells, fiddly formatting, no live preview of what the client will actually see.
- Tax lines you have to get right yourself. GST, VAT and sales tax rates and registration fields aren’t something a spreadsheet checks for you — you’re relying on your own memory of the rule and your own formula.
What a good tracker needs either way
Whether you stick with a spreadsheet or move to an app, the underlying data is the same. At minimum, track:
- Invoice number — a unique ID per gig, so a payment can be matched back.
- Client / venue — who owes you.
- Gig date — when you actually played, separate from the invoice date.
- Amount and currency.
- Invoice date and due date.
- Date paid (blank until it is).
- Status — sent, paid, overdue.
- Days overdue — so nothing quietly slips past 30 days.
Keep the date format, currency format and client-name spelling identical on every row. Inconsistent formatting is the single biggest reason spreadsheets become unreliable to sort and filter once they’ve got more than a month or two of gigs in them.
Common mistakes either way
- Reusing invoice numbers, or skipping them entirely — this is what turns “did they pay?” into detective work.
- Logging the invoice days after you send it, which is how a tracker quietly stops matching reality.
- Not separating deposit from balance as two distinct line items, so the total looks paid when only half is.
- No weekly review of what’s overdue — the point of tracking anything is catching a late payment before it’s a chase.
Skip rebuilding it every gig
If you’re past the point where a spreadsheet is quick — deposits, multiple currencies, or just too many gigs to keep the rows honest — SettleBeat stores your rate, venue and tax settings once, then turns a finished gig into a formatted, itemised invoice with the deposit/balance and payment status tracked automatically. Play the gig; we’ll handle the invoicing →