Most yachts track charter expenses the same way: receipts collect in a drawer or a pocket, and every so often someone sits down to punch them into a spreadsheet. It works — right up until the week it doesn't: a busy charter, spending in two currencies, three crew members holding receipts, and a guest who wants to know where the account stands today, not at the weekend. This guide is about what breaks, and what a working system looks like — whatever tool you build it with.
Why the spreadsheet breaks
The spreadsheet itself is rarely the problem. The batching is. When entries are made days or weeks after the money moved, three things go wrong at once:
- Details are lost. A crumpled receipt with a faded total, a cash payment nobody wrote down, a charge whose category is anyone's guess. Memory does not keep financial detail for two weeks.
- The balance is always stale. The number in the file says what the account looked like at the last sitting — not now. On charter, "now" is the only balance that matters.
- The work compounds. Ten minutes a day avoided becomes a full evening owed. Backlogs don't get smaller on a working boat; they get handed to the last night of the charter.
Add the practical problems — one file on one laptop, crew receipts arriving by photo, message, or not at all, currencies mixed in one column — and the system that looked fine in the marina falls apart mid-season.
What a working system needs
Whether it's paper, a spreadsheet used well, or purpose-built software, a charter expense system that survives a real season does five things:
1. Captures the expense at the moment of payment. The entry is made where the money moves — at the fuel dock, in the market, at the chandlery — not later at a desk. In practice that means the receipt is photographed and the amount, vendor and category recorded on the spot, from a phone.
2. Lets the crew feed it directly. If heads of department spend, they record their own expenses and submit their own receipts, and the captain approves rather than re-types. Any system where one person manually enters everyone else's spending has a built-in backlog.
3. Keeps every receipt attached to its entry. Not in a separate folder, not "somewhere on the phone" — attached, so that any line in the account can produce its paper in seconds. On charter this is what settles questions; after the charter it is what the final statement stands on.
4. Shows a running balance. At any moment, one number: what's left. For a charter running on an APA this is the difference between managing the account and being surprised by it.
5. Separates the pots. Charter money, owner's money, crew cash — different pockets, never mixed in one running column. A season's worth of mixed entries is nearly impossible to untangle after the fact.
The crew receipt problem, specifically
Ask any captain where expense tracking actually hurts and the answer is usually the same: collecting receipts from the crew. The fix is less about discipline than about the path of least resistance. If submitting a receipt takes a photo and ten seconds, it happens the same day. If it means keeping paper safe until someone asks for it, it happens at the end of the month, incompletely. Whatever system you run, the crew-facing side of it has to be easier than the drawer.
If you stay with a spreadsheet
A spreadsheet can hold the line on a quieter boat, if the habits above are forced onto it: entries daily, receipt photos filed by date and matched to rows, one currency per column with conversions shown, a formula keeping the running balance visible, and one person who owns the file. What a spreadsheet cannot do is capture at the point of payment or take submissions from the crew — those gaps stay, and they are exactly where the backlog grows back.
The short version
Track at the moment of payment, let the crew submit their own receipts, keep the paper attached to the entry, watch one running balance, and never mix the pots. The tool matters less than the habits — but the right tool is the one that makes the habits the easy path.