Property Management Spreadsheet for Landlords Amenity Booking Expense Tracker for Excel and Google Sheets

Description

DIGITAL DOWNLOAD. No physical product will be shipped. This Property Management Spreadsheet for Landlords Amenity Booking Expense Tracker for Excel and Google Sheets helps monetize services, giveaways and other resident amenities.  Positioned as e CRE Amenity, Housing & Product Operations Suite this 22-tab property management spreadsheet is built for landlords, leasing offices, and small commercial real estate teams who juggle far more than just rent rolls — gift cards, branded giveaways, conference room bookings, extended-stay units, in-unit concierge requests, and the operating expenses that come with running it all. Press play to see the demo.

Every tab is pre-built with working formulas, color-coded status chips, dropdown menus, and a live Dashboard with charts, so you open it, add your numbers, and it just works. Complete with a full sample and blank templates so you can start using right away. See more below:

WHAT’S INSIDE

• Product & Merchandise Inventory — gift cards, branded giveaways (tumblers, umbrellas, Yetis), digital products, with auto-calculated profit margins
• Amenity & Space Bookings — conference rooms, rooftop decks, coworking lounges, with catering/AV fees and deposit tracking Extended Stay & Corporate Housing — BNB-style short stays and long-term corporate housing, with automatic late-checkout fees  and security deposit refunds
• In-Unit Concierge Services — package delivery, dry cleaning, housekeeping, dog walking, handyman requests, with a monthly  cost-per-unit rollup
• Gift Card Redemption Log, Sponsorship & Ad Income, Loyalty &  Rewards, Storage & Parking Rentals, and a full Expense Log
• Live Dashboard — KPI cards plus three built-in charts (Revenue by Source, Product Revenue by Category, Revenue vs. Expenses)
• A complete matching set of BLANK tabs (including a Blank Dashboard) so you can start fresh with every formula already in place

WHO THIS IS FOR
Independent landlords, small property management companies, leasing offices, and commercial real estate teams who want their ancillary income and operating costs in one place — without building it from scratch or paying for expensive PM software. They will get the visibility they need to see what is working and what is not.

FORMAT & COMPATIBILITY

Delivered as an .xlsx file. Fully compatible with Microsoft Excel and Google Sheets (just upload and convert). Works on Mac, PC, and Chromebook. No macros, no add-ons, no subscription.

FAQ

Do I need Excel, or does this work in Google Sheets?

Both. Upload the file to Google Drive and open with Google Sheets, or use it directly in Excel — all formulas, dropdowns, and formatting carry over.

Is this a one-time purchase?

Yes. One payment, yours to use for unlimited properties or years, just duplicate the blank tabs for each new property.

Can I customize the categories, rates, or fees?

Yes. Every dropdown list, rate, and formula is fully editable: this is a working spreadsheet, not a locked template.

Will this replace my property management software?

It’s built to sit alongside it — for tracking the ancillary income and services (amenities, giveaways, concierge requests) that most PM software doesn’t itemize well.

Do you offer support if I get stuck?

Yes, message me and I’ll help you with any questions you may have on your set up.

Form & Ledger designs financial and operational tools for commercial real estate professionals who want their systems to look as sharp as their properties.

IMPORTANT
This is a calculation aid, not legal, accounting, or tax advice. Always confirm results against the actual lease language.

INSTANT DOWNLOAD
Your file is available as soon as payment is confirmed. This is a digital download — no physical item will be shipped.

• All sales are final due to the instant digital nature of this product.
• Instant download items don’t accept returns, exchanges, or cancellations.
• Please contact the shop about any problems with your order.
• We encourage you to message hello@formandledger.com with any questions before purchasing.

© Form & Ledger. For your own business use. Please don’t resell, share, or redistribute.

NOTE:

→Feel free to reach out with any questions

We hope you enjoy your product as much as we do.