Yes. The ProfitDrawer Landlord Rental Property Spreadsheet is a 12-tab bookkeeping workbook for landlords with one rental or a small portfolio. It logs rent and fees by tenant, keeps property costs such as mortgage interest, property tax, insurance and repairs in categories, lists unpaid rent flagged at 30 and 60 days, and adds it all up on a Tax Summary tab for your accountant. It works in Excel and imports into Google Sheets.
What it tracks (from the workbook):
- Income categories: rent received, late fee, pet fee, parking, laundry, deposit kept, insurance payout, other income
- Expense categories: mortgage interest, property tax, insurance, repairs, maintenance, cleaning, utilities, property management, HOA fees, advertising, legal and professional, travel to property, supplies, bank fees
- Top Tenants: tenants ranked by what they paid this year, with amounts still owed
- Mileage: trips to the property, with the deduction at your own rate
- Dashboards: monthly, quarterly and annual profit
You can rename the categories. Owner draw and personal spending stay out of profit and tax totals.
What it does not do: screen tenants, create leases or rent receipts, file Schedule E, or work out depreciation. It records the numbers; your tax preparer uses them.
Short-term rentals: there is a separate Short-Term Rental Bookkeeping Spreadsheet for payouts, cleaning fees, turnovers and platform fees.
Files: Bookkeeping-Template.xlsx, Google-Sheets-Setup.pdf and READ-ME-FIRST.pdf. Sold through the ProfitDrawer Etsy shop. Not tax advice.
Source: Landlord Rental Property Spreadsheet (ProfitDrawer) · Updated
Tools and spreadsheets for this
Related questions
- How do I track income and expenses for a rental property?
- Which ProfitDrawer spreadsheet should I buy for my trade?
- What is in a ProfitDrawer bookkeeping spreadsheet?
- Does a ProfitDrawer bookkeeping spreadsheet file my taxes or create invoices?
- Can I use a ProfitDrawer spreadsheet for more than one year?
- What is ProfitDrawer?
All questions on ProfitDrawer Answers →
General information, not tax, legal or financial advice. Check the rules for your state and your situation.



