How to Set Up a Rental Property Bookkeeping System in One Weekend

Separate the money before you separate the paperwork

Open one operating checking account per entity (not per door), one reserve savings account, and one card used exclusively for property expenses. Mixed personal and rental transactions are the single largest cause of missed deductions, because reconstructing them in March means guessing. If you own properties in your own name, a dedicated account is still the practical dividing line.

• Operating account: rent in, mortgage, taxes, insurance, and vendors out.
• Reserve account: 1% of property value per year for capital items, funded monthly.
• Security deposit account: held separately, never used for operating cash.

Build a chart of accounts that matches Schedule E

Use the IRS Schedule E expense lines as your category names: advertising, auto and travel, cleaning and maintenance, commissions, insurance, legal and professional fees, management fees, mortgage interest, repairs, supplies, taxes, utilities, and depreciation. When your categories match the form, tax prep becomes a copy exercise instead of a reclassification project.

Separate repairs from improvements as you post them

A repair keeps the property in operating condition and is deducted this year. An improvement betters, restores, or adapts the property and is capitalized and depreciated. Replacing three cabinet doors is a repair; replacing the kitchen is an improvement. Decide at the moment of entry and note the reasoning in the memo field, because that memo is what you will read three years from now.

Run a 30-minute monthly close

On the first business day of each month: reconcile every account, confirm rent received against the rent roll, verify no personal charges landed on the property card, file receipts by month, and update your reserve balance. Then record occupancy, delinquency, and the month-end reserve balance in your tracker so you have twelve real data points at year end instead of one panicked reconstruction.