Instant digital downloads One payment, no subscription Works as described, or we fix it or refund you Bundles save up to 43%

Is there a ProfitDrawer spreadsheet for landlords?

Updated By ProfitDrawer

Short answer

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

All questions on ProfitDrawer Answers →

General information, not tax, legal or financial advice. Check the rules for your state and your situation.