Common Rental Spreadsheet Entry Errors and How to Check Them
Find and fix common rental worksheet mistakes: text dates, amounts stored as text, wrong property IDs, duplicates and sign errors.
Articles
Using Property IDs in a Rental Spreadsheet
Why stable property IDs prevent mixed-up rental records, how to assign them, and a simple mapping table for name changes.
A Monthly Rental Record Reconciliation Checklist
A short month-end checklist for matching rental income and expenses to bank records, with a fictional three-entry example and common mismatch fixes.
How to Organize Rental Expense Receipts
A simple folder and file-naming method for rental expense receipts, with a receipt-to-ledger check and a practical missing-receipt process.