Originally posted by @Johann Jells:
Originally posted by @Bjorn Ahlblad:
@Account Closed Congrats on the property! All you need is a bank account and credit card dedicated to the property and................ Presto!
How does that answer the gentleman's question? He asked about data organization.
I think it answers the question perfectly, as half the battle is segregating costs that are applicable to the rental (and where most non-accountants have an issue). If you have dedicated accounts for the property, the chances of missing something are close to 0. If you use 1 account for everything, it makes everything a lot more complicated and harder to track.
To answer Troy's question directly, I have three properties and use Excel. Much like one of the other forum members that responded, I have a tab for each property, a tab that's a master data sheet (all backup for all properties), a linked tab that flows into a P&L/Income Statement and I match up the categories to the tax forms. I try to make it as easy as possible for my accountant to put things on the tax forms.