Treasurer's Cashbook with Running Balance
Every receipt and payment, with the date, reference and who it came from or went to.
Clubs, Charities and Community · CC-687 · Log
Free hall hire income log — each booking, hours charged at your rate, invoice, deposit and payment, with arrears totalled. PDF, Excel and browser versions.
2 pages. The A4 and US Letter files are laid out identically, so neither is shrunk to fit.
Print it and write on it
Fillable PDF type and save
Spreadsheet formulas included
The fillable versions have real form fields — open them in any PDF reader, type into them and save. Printing help.
The same sheet, on screen. Totals and figures are worked out as you type, rows can be added or removed, and you can print it or download the completed version as a PDF. Everything stays in your browser — your entries are kept in this browser's own storage on this device, nothing is uploaded, and there is no account.
Every hire of the hall, and whether it has been paid. Each booking gets a line with the hours or sessions, the amount due at your own rate, the invoice number, any deposit held and what has come in, so arrears show up before the next meeting.
Treasurers and bookings secretaries of village halls, church halls, scout huts and community centres who invoice hirers and need to see who still owes money.
The printable is laid out inside a box that fits both A4 and US Letter, so the two files are identical and neither one is scaled. The fillable PDF has real form fields. The workbook uses plain formulas only — SUM, IF, COUNTIF and the like — so it opens in Excel, LibreOffice and Google Sheets without anything breaking, and every calculated cell is grey so you can see which figures it worked out.
Download the A4 or US Letter file to match the paper in your printer, open it in a PDF reader and print at 100% — not "fit to page", which shrinks the writing space. Both files leave a 14 mm margin, which clears the unprintable edge on home printers. To print the online version with your entries in it, use the Print this sheet button, which prints only the sheet and none of the page around it. More on printing.
The amount due uses the single rate in the header. If you have more than one rate, keep a separate log per rate, or overwrite the amount due in the workbook for that line and note why.
No. The deposit column records money held against damage or cleaning and is not taken off the balance. When you return or keep it, note what happened in the notes area so the cashbook matches.
From your own hall committee's hire charges. Nothing is supplied. Enter the rate you invoice at, whether per hour or per session, and the arithmetic follows it.
No. The diary shows when the hall is free; this log follows the money once a hire is confirmed. Many halls keep both and tie them together by the date and hirer.
Every receipt and payment, with the date, reference and who it came from or went to.
Every member whose subs are unpaid or part paid.
The income the committee expects, by source.
Printable sheets, workbooks and tools on the same subject.
Hold everything about one hire in a single place, so the person who took the booking is not the only person who knows what was agreed.
Leave the doorway with both sides agreeing on the times, the rooms and who locks up. It is the booking nobody wrote down that goes wrong.
Every invoice raised, what has been paid against it, and how many days overdue the rest is — with the aged debt split that tells you who to chase first.
Every sheet, binder, game and puzzle on Upkeep Papers is free to download, with no email and no account. Making them is not free: each one takes days of research, design and checking, and the site costs money to run. If something here saved you time, you can buy us a coffee. It is entirely optional: nothing is locked, and nothing changes if you don’t.
Opens PayPal in a new tab. Any amount, and nothing changes if you would rather not.