Skip Navigation
StreetEasy Logo

Rental property recordkeeping

Started by bpcbuyerconfused
about 7 years ago
Posts: 85
Member since: Oct 2013
Discussion about
I just purchased my first rental property and created a fairly dynamic yet simplistic Excel spreadsheet to track my P&L. For any landlords on this site, how do you do your recordkeeping? Do you also use Excel or software like Quicken or Buildium? Do you outsource to an accountant? Am planning to eventually grow portfolio to 5+ doors
Response by Aaron2
about 7 years ago
Posts: 1698
Member since: Mar 2012

Congratulations on your soon-to-be real estate empire!

You should ask your accountant what software they can work with, and get their advice on how to manage your income/expense entries and tax and financial reporting entries so that allowable and non-allowable expenses are accurately identified (and to coordinate with your lawyer on potential consolidations / passthroughs if the investment properties are held in different legal entities for liability or other purposes).

Ignored comment. Unhide
Response by 300_mercer
about 7 years ago
Posts: 10570
Member since: Feb 2007

One way to do this is keep all cash flows in the same bank account which has no other cash flows besides distribution you take out. After that you download your bank cash flows into a spreadsheet in periodic basis, identity the category of each cash flow, keep the receipt ideally electronically, and pivot any way you like. That is all you need to provide to your accountant.

Ignored comment. Unhide
Response by 300_mercer
about 7 years ago
Posts: 10570
Member since: Feb 2007

Each property gets a separate bank account, check book, and credit/debit card. I find that it is the cleanest, easy to remember, reconcile and it can withstand any irs audit.

Ignored comment. Unhide
Response by bpcbuyerconfused
about 7 years ago
Posts: 85
Member since: Oct 2013

Thanks guys this is great

Ignored comment. Unhide
Response by front_porch
about 7 years ago
Posts: 5316
Member since: Mar 2008

Lease and receipts for small amounts in paper file; communications with tenant always through the same email address; rent checks, mortgage checks, maintenance payments and checks to contractor out of one checkbook. (Security deposit in separate account). Hand pile to accountant in the spring.

Ignored comment. Unhide

Add Your Comment