Month end with a calculator and a calendar
On the last Sunday of the month, you open the room calendar and a notepad. For each tenant counsellor, you count the hours in each room, check which were peak evening rates and which were daytime, remember that one of them cancelled late on the 9th, and work out whether that is chargeable under your agreement.
Then you type it all into Xero, one invoice per tenant, and email them. A week later, one tenant queries two hours they say they did not book. You go back to the calendar and cannot be sure either way.
Why the numbers never quite line up
The booking record and the billing record are two different things, maintained by hand, at different times. Anything that changes between them is a chance for an error.
- Different rates for daytime, evening and weekend hours, or for different rooms.
- Block rates for tenants who book a fixed weekly slot.
- Late cancellations that are chargeable under the agreement, and ones you chose to waive.
- Bookings moved or extended by text after the calendar was updated.
- Deposits or advance payments that need offsetting.
Each rule is easy. Applying all of them from memory, once a month, for several tenants, is where hours go missing or get billed twice.
What month-end invoicing is costing
| Symptom | What it means for you |
|---|---|
| Hours of counting | An evening a month of unpaid admin |
| Queried invoices | Awkward conversations with colleagues you share a building with |
| Under-billing | Hours used but not charged because they were not written down |
| Late invoices | Rent covered later than it should be, cash flow tighter |
| No audit trail | No clear answer when a tenant asks what an amount was for |
Your tenants are often colleagues and sometimes friends. A disputed invoice between two counsellors sharing a waiting room is uncomfortable in a way a disputed utility bill is not, and it tends to get settled by you quietly writing off the hours.
Under-billing is the cost nobody sees. An extra hour added by text on a Friday, never written into the calendar, simply never gets charged. Nobody is being dishonest. The record just was not there at month end.
How we build invoicing from the bookings
- Rates live in one place: per room, per time band, and any tenant-specific arrangement, such as a block rate for a standing weekly slot.
- Each booking is priced when it is made, so the tenant sees the cost at the time and nothing is calculated later from memory.
- Cancellations follow your room agreement: inside notice is free, late is chargeable, and you can waive any one with a note.
- At month end, a draft invoice per tenant is produced with a line for each booking: date, room, hours and rate.
- You review the drafts on one screen, then they are created in Xero or QuickBooks through the API and sent from there, so your accounts stay the single financial record.
- Payments received in your accounting system are matched back, so you can see who has paid and chase only those who have not.
If tenants pay up front for a block of hours, the system tracks the balance and draws it down per booking instead.
A month end that takes minutes
Invoices go out on the first of the month, and each one lists the bookings it covers. When a tenant queries a line, you both look at the same record, with the time it was booked and by whom.
Your accountant sees clean invoices in Xero or QuickBooks rather than a lump sum with no breakdown.
Is this your month end?
- You count tenant room hours by hand from a calendar.
- Rates differ by time of day, room or tenant.
- Tenants sometimes query hours on their invoice.
- Late cancellation charges are applied inconsistently.
- Invoices go out late because month end is a chore.