Co-working Space Management System in Excel: Plans, Members, Meeting Room Bookings, Monthly Billing and Dashboard

By Ravindra Bagale · Last updated: 17 October 2026

← All Excel dashboards

Download the template: co-working-space-management-system-template.xlsx: a 8-sheet system with example data and real formulas (Read me, Setup, Members, Bookings, Billing, Occupancy, Invoice, Dashboard). Yellow cells are inputs you can type over; green cells hold formulas; blue rows are headers and totals. Replace the example data with your own and every report and the dashboard recalculate.

Made-up data: every name, amount, business and date on this page is made up for practice. Cities are used only to make the examples feel real.

1. The business story

Zoya Cowork, Nagpur, October 2026 (made-up data). Hot desk ₹6,000 a seat, Dedicated desk ₹9,000, Private cabin ₹8,000 a seat; meeting room ₹500 an hour beyond the free hours; GST 18% (an input; confirm with your accountant).

Hot desks are only 3 of 20 sold, so that is where the space has room to grow.

2. Build it sheet by sheet

Step 1. Setup: plans and rates

1. B3 as-of date, B4 billing month (01-10-2026), B5 meeting room rate (₹500 an hour), B6 GST.
2. Plans in A9:D11: Plan, Fee per seat per month, Free meeting hours per seat, Seats available.

Step 2. Members and Bookings

1. Members: Member ID, Member, Plan, Seats, Start date. F5 fee =D5*XLOOKUP(C5,Setup!$A$9:$A$11,Setup!$B$9:$B$11,0) and G5 free hours the same way from column C.
2. Bookings: Date, Member ID, Member, Start, End, Hours. C5 fills the name; F5 hours =ROUND((E5-D5)*24,2) (time calculations).
3. Pick member IDs and plans from drop-downs.

Step 3. Billing: one invoice line per member

1. D5 hours used this month: =SUMIFS(Bookings!$F$5:$F$3000,Bookings!$B$5:$B$3000,A5,Bookings!$A$5:$A$3000,">="&Setup!$B$4,Bookings!$A$5:$A$3000,"<="&EOMONTH(Setup!$B$4,0)) (SUMIFS).
2. F5 extra hours =MAX(0,D5-E5) and G5 charge =F5*Setup!$B$5.
3. H5 taxable =C5+G5, I5 GST =ROUND(H5*Setup!$B$6,2), J5 total. Extra hours are coloured amber.

Step 4. Occupancy and Invoice

1. Occupancy C5 seats sold =SUMIFS(Members!$D$5:$D$200,Members!$C$5:$C$200,A5), D5 =C5/B5 with a data bar (data bars).
2. Invoice: type a member ID in B4; rows 6 to 14 look up fee, hours, extra charge, GST and total from Billing; B15 prints the month in words. Set the print area.

Step 5. Dashboard

1. KPI cards: members, seats sold, occupancy, plan fees, meeting charges and invoiced with GST.
2. Charts: seats available and sold by plan, and meeting hours by member.

3. Formulas used

Every formula above is written in the template, so you can click a cell and see it in the formula bar. All values on this page were recalculated in LibreOffice with zero errors.

4. Common mistakes

1. Free hours per member, not per seat. A 6-seat cabin gets 6 times the hours. Multiply by seats, as in Members G5.
2. Counting next month's bookings. Future bookings sit on the same sheet. The EOMONTH condition keeps only the billing month.
3. Hours from times typed as text. "10.30" is text. Type 10:30 so (end − start) × 24 works.
4. Charging all hours. Bill only MAX(0, used − free); members notice when included hours are billed.
5. GST rounded per line and again on the total. Round GST once per invoice line, then add the lines.

5. More real examples

Example 1: Day passes. Add a Day pass plan with seats 1 and a Day passes sheet; count passes per month with COUNTIFS.

Example 2: Virtual office. A plan with 0 seats and a fixed fee for the address and mail handling.

Example 3: Event hall hire. Use Bookings for a hall with its own hourly rate column and no free hours.

Quick revision cards

Englishमराठीहिंदी

Quick revision

Each card shows formulas from this page, each with an example and its answer from the template. Scan the QR code on a card to open this lesson. All names and numbers are made up for practice.

More cards: Ravi Sir's Cards.

6. Frequently asked questions

How do I add hours for one month in Excel?

SUMIFS with two date conditions: ">="&first day and "<="&EOMONTH(first day,0).

How do I turn start and end times into hours?

=(end-start)*24, rounded to 2 decimals.

How do I charge only the extra hours?

=MAX(0,used-free)*rate. MAX stops a negative charge when hours are under the limit.

What GST applies to co-working space?

Renting commercial space is generally taxed at 18%. The template keeps the rate as an input; confirm with your accountant.

How do I see which plan is under-sold?

Occupancy: seats sold ÷ seats available per plan. Here hot desks are at 15%.

7. Quick quiz

Ten questions on this page. Sign in to save your score.