Coliving Room Rental & Member Tracker: Coliving Rent Roll and Room Rental Spreadsheet

Full description

For coliving operators, house-share landlords and room rental managers who run one home of up to 30 rooms. You register your rooms, enter each member contract and log rent as it comes in. The workbook works out pro rata rent for part months, flags late and part payments, splits utility bills by nights let and room size, shows occupancy and rent roll by month, and lists the contracts that end within the next 60 days so you can renew or re-let in time.

Save with a bundle: this template is also in the Alternative Lodging Bundle, 10 templates for $29 instead of $74. All 141 templates are in the All-Access Hospitality Template Library for $79.

What is inside

• Coliving_Room_Rental_Member_Tracker.xlsx: 9 tabs, 8,892 formulas, 2 native charts, 17 drop-down or number rules.
• Settings: year, currency label, report date, rent due day, grace days, late fee, renewal window, target occupancy, rent discount alert, a utilities recharge switch and 7 drop-down lists.
• Rooms: room for 30 rooms (12 sample rows) with floor, type, size, bathroom, list rent and utility weight. Current member, contract end and rent now fill in.
• Contracts: room for 120 contracts (25 sample rows) with start, end, rent, deposit and deposit status. Status, days to end, renewal flag and a check for date errors, overlaps and rent below list calculate.
• Rent_Collection: room for 800 rent rows (108 sample rows). Rent due (pro rata for part months), due date, days late, late fee, balance and status calculate.
• Occupancy: 12 months of room-nights, occupancy, contracted rent roll, billed, collected, collection rate, late fees, move-ins and move-outs, plus nights let by room and month.
• Utilities: monthly bills for 5 utility types and each room's share by month, weighted by nights let and room weight.
• Expenses: room for 500 house costs (82 sample rows) in 11 categories with a receipt flag.
• Dashboard: 8 KPI tiles, 5 checks to clear, a list of up to 8 renewals due, net income year to date and 2 charts.
• README.txt and LICENSE-and-Terms.txt.

How it works

1. Set the report date, rent due day, grace days, late fee and renewal window on Settings.
2. List your rooms with list rent and a utility weight.
3. Enter each member contract. Use member codes if you share the file.
4. Each month add a rent row per member, record payments, utility bills and house expenses.
5. Work through the Dashboard checks: overdue rent, renewals due and vacant rooms.

Details

• Format: Excel workbook (.xlsx). No macros.
• Language: English. Currency is a label you choose.
• Software: Excel 2016 or later, or a spreadsheet program that opens .xlsx files.
• Delivery: instant digital download. Nothing is shipped.

Good to know

• All sample rooms, members, rents and costs are illustrative. Replace them with your own data.
• Tenancy, deposit, late fee and data protection rules differ by place. Verify local requirements. This is a record-keeping tool, not legal or tax advice.
• Single-user license. Do not share or resell the files.

FAQ

Does it handle members who move in mid-month?

Yes. Rent due and nights let are pro rata by days for the first and last month of a contract.

How are utility bills split?

Each room's share is the bill times its nights let times its utility weight, divided by the total for all rooms in that month.

Can I run more than one house?

The workbook holds 30 rooms. Use one copy per house, or code rooms by house in the room ID.

Does it work in Google Sheets?

It opens in Google Sheets and the formulas calculate. Check the drop-downs after import.

Is this a physical product?

No. It is a digital download. Refund terms follow the store policy at the time of purchase.