Month end with a credits spreadsheet
A private office company on a ten-desk plan gets a pool of meeting room credits each month, shared by everyone on the team. A resident desk member gets fewer credits of their own. Boardroom bookings cost more credits per hour than the small phone booths, and peak hours cost more than evenings. Some plans allow unused credits to roll over for a month, some do not.
At month end, the operations manager exports the bookings, sorts them by member and company, works out who went over their allowance and adds overage to invoices. A member disputes a charge because they booked a room they then cancelled. Another company says their credits should have rolled over.
Why credit billing is fiddly
- Different plans include different allowances.
- Rooms and times of day cost different numbers of credits.
- Credits can be personal or pooled across a company.
- Rollover and expiry rules differ between plans.
- Cancellations and no-shows may or may not consume credits under your rules.
- Members cannot see their balance, so overage is a surprise.
Membership platforms handle much of this, but setups drift as plans change and special deals are made, and exceptions end up in spreadsheets.
Sales make it harder without meaning to. To close a private office deal, the sales manager offers extra credits for the first three months, or boardroom time at the small room rate. It is agreed in an email and nobody sets it up in the platform, so the month-end spreadsheet grows another column.
What billing errors cost
Undercharged overage is income that never arrives. Overcharges lead to disputes, credit notes and members who feel nickel-and-dimed. Month end takes days of export and reconciliation. And members who cannot see their balance book less, or more, than they intended, and complain either way.
Private office companies in particular watch these charges closely. Their finance teams question every line they did not expect, and an operator that cannot explain a charge quickly starts to look careless.
The credit tracking we build
- Each plan's rules are recorded once: allowance, pooled or personal, rollover, expiry and how cancellations and no-shows are treated.
- Each room has a credit rate by time of day, and special arrangements for specific members are recorded as named exceptions, not spreadsheet notes.
- Every booking from every channel is costed in credits as it is made, and the balance updates immediately.
- Members and company admins see their current balance and usage in the app or a portal, and are told before a booking takes them into overage.
- At month end, overage is calculated from the same record and added to the invoice run in your membership platform, Xero or Stripe.
- Disputes are answered from the booking history, with the credit cost of each booking shown.
| Rule | Where it lives today | Where it lives after |
|---|---|---|
| Plan allowance | Plan setup, sometimes a spreadsheet | One rule per plan |
| Room and time rates | A price list | Rates applied at booking |
| Company pools | Worked out at month end | Balance updated live |
| Rollover | Remembered by operations | Applied automatically |
| Special deals | Notes | Named exceptions with dates |
What month end looks like after
Overage is already calculated when the invoice run starts. Members see their balance and are warned before they go over, so fewer disputes arise. The ones that do are answered from the history. And the operations manager stops rebuilding the same spreadsheet each month.
Credit data is also a view into how plans are used. If most members on one plan never use their allowance, or always go over, that is worth knowing when plans are next reviewed.
Is this your month end?
- Overage is worked out in a spreadsheet each month.
- Members dispute credit charges.
- Company credit pools are calculated by hand.
- Special deals are tracked in notes.
- Members cannot see their balance before booking.