In this guide 6 sections
Tie every member’s plan to one seat, a block of included meeting-room hours and a monthly tax invoice, so a change on one reaches the others. Bookings use up those hours. Anything beyond them lands on the next invoice, and access can end with the contract wherever your door hardware allows that to happen.
The Membership Plan as the Base Record
A coworking operator sells day passes, hot desks, dedicated desks, private cabins and meeting-room hours, and in Excel every product sits in a tab someone else updates. The tabs rarely agree.
A company adds two seats mid-month, and somebody bills the full month anyway because nobody told the person holding the invoice file. Mid-month changes are the usual culprit. Add-ons such as lockers, parking bays, phone booths and printing credits belong on the plan too, because each one is a small invoice line that gets forgotten.
Start from the plan instead. Each plan fixes its price, included room hours, deposit and lock-in period, and every member sits on exactly one, so seat changes join that record. The invoice is built from it later.
One Live Booking Calendar
Meeting rooms get held in a shared calendar, in a WhatsApp message to the front desk and in the receptionist’s notebook, and nobody sees all three at once. Nobody owns the truth.
Two teams meet at one door. One of them has a client.
Give every room and hot desk a single live availability view, with booking rules set per plan, so members book from the app or a browser. Nobody can double-book a room. Hours used are counted as they happen, so extra time reaches the invoice without anyone checking the notebook, the calendar or a pile of chat messages.
Month-End Tax Invoices Built From Usage
Month-end invoicing can eat a manager’s week: seat counts are copied into Excel, tax is added by hand and each payment is hunted down in the bank statement.
Billing built on the plan raises recurring invoices from seats, plan and extra room hours in one batch that you review before anything goes out. Bank transfers are matched to invoices. Unpaid ones get reminders on a schedule you choose, while invoices and receipts flow into your accounting package without being typed a second time.
Switch this on first. Door access can wait. Invoices touch every member every month, while doors touch only the day someone leaves, so billing repays the effort sooner than anything else on the list.
Enquiries, Renewals and Exits
Two gaps cost operators money quietly. A walk-in takes a tour, gets a quote on WhatsApp and never hears from anyone again, while a company’s lock-in ends unnoticed until the notice email arrives. Neither leak shows up on any report. Tickets about a jammed printer, a warm pantry fridge or a flickering booth light also need somebody responsible by Friday.
A coworking CRM logs each enquiry from tour to quote to signing, with a source and follow-up date, and contracts raise renewal alerts before the term runs out.
When a member leaves, the seat is freed, access is revoked where hardware allows it and the deposit is settled on that same record. No separate cheque register is needed.
- Enquiries by source, with tours done and seats signed
- Contracts ending in the next 30, 60 and 90 days
- Occupied seats against paid seats, by floor
- Open member tickets, oldest first
How Much Software One Small Centre Needs
One small space with a dozen steady members can run on a shared calendar and monthly invoices typed in Excel by one careful person who knows every member. Software is not needed yet.
The tipping point is usually a second floor, a second centre or corporate clients whose seat counts change every month, because that is when the tabs stop agreeing. Community managers, front-desk staff and the accountant should read from one membership ledger, not three spreadsheets, so lapsed deposits or unreturned access cards never hide in a file.
Switch it on in parts. One centre can start with bookings, invoices and the member app, importing members, contracts and unpaid invoices from its sheets and checking dues with you before the first run. Run a test month alongside Excel first.
Plan-to-invoice worksheet
A worksheet that traces one member from plan to monthly invoice: seats, included room hours, extra hours used, mid-month changes, tax and deposit. Fill it in for three real members from your own floor to see exactly where your current Excel invoicing goes wrong each month.
Open a blank worksheet to printQuestions owners ask
Does it handle more than one coworking centre?
Yes: each centre keeps its own floors, rooms and members, while the owner sees every centre together on one screen of occupancy and dues. Occupied seats are reported against paid seats, by centre and by floor, which is the number to check before you sign for another floor.
Does it work with our door access system?
Often it does, because access can be tied to membership and bookings wherever a card, biometric or app-based reader allows it to be controlled from another system. Your hardware is checked during the demo.
What should we tidy before moving across?
Gather members, their plans and seat counts, contract end dates, deposits held and unpaid invoices, because those five items drive every invoice after go-live. Tidy those and the rest follows.