Cattery payment tracker – deposits, balances and what's overdue
Deposits in the diary, balances on scraps of paper, a bank transfer you can't match to anyone – money is where a busy cattery's records most often go wrong. Here's a free spreadsheet that keeps it straight, and a few habits that stop you chasing payments at the door.
Updated November 2026.
Every payment on its booking, who owes money on one list, and the balance shown when each cat goes home – no spreadsheet to keep up.
Free cattery payment tracker
Bookings with the price, deposit and dates; every payment recorded against its booking; and the status worked out for you – PAID, DEPOSIT DUE, BALANCE DUE, OVERDUE or CREDIT. A summary sheet shows money still to come in, what's overdue and what's been paid in advance for stays still to come.
Download the payment tracker (.xlsx)
No sign-up. Works in Excel, Google Sheets, Numbers and LibreOffice. Example rows use made-up names – delete them before you start.
How it works
- Bookings sheet: one row per stay – owner, cats, dates, the full price, the deposit you asked for and when it's due.
- Payments sheet: one row for every payment – deposit, balance, extras, or a refund as a minus – with the booking number.
- Status works itself out from today's date: a balance still owed once the stay has started shows OVERDUE in red.
- Summary: money to come in, overdue, deposits overdue, and anything in credit.
Habits that stop you chasing money
- Record the payment against the booking straight away – not "later", and not only in the bank.
- Ask for a reference on bank transfers – the owner's surname and arrival date – so you can match them.
- Remind owners of the balance before the stay, in the same message as the drop-off time.
- Have the amount ready at collection, with an invoice if they want one.
- Check the overdue list once a week. Small amounts forgotten add up over a year.
- Put your deposit and balance rules in your terms – see cattery deposits, cancellations and no-shows and the terms template.
Where a spreadsheet runs out
A spreadsheet only knows what you type into it. It won't stop a booking going in without its deposit, remind the owner, or show the balance to whoever's on the desk when they collect. That's when it's worth having bookings and payments in one place.
Bookings and payments together
- Every payment on its booking – deposits, balances, extras and refunds – with what's still to pay always up to date.
- Who owes money on one list, and the balance shown on Today when each cat goes home – with the invoice to print or email.
- The balance in the reminder email owners get before their stay.
- Card deposits on online requests if you want them, paid into your own Stripe account.
- Takings by month and payment method, ready for your accountant.
- Already using this tracker? Send it to us and we'll bring your bookings and customers across, free.
Questions
How do I keep track of cattery deposits and balances?
Record every booking with its full price, and every payment against the booking it's for. What's still to pay is the price less the payments – the free tracker works it out, and flags anything overdue.
When should a cattery take the balance?
Most catteries take it at collection, some at drop-off. Whichever you choose, put it in your terms, remind owners before the stay, and have the amount ready when they arrive.
What if a customer pays more than the price?
The tracker shows the booking as CREDIT. Decide whether to refund it or keep it towards their next stay, and record a refund as a minus payment.
Related: cattery deposits · free booking spreadsheet · profit calculator · cancellations and no-shows