Help with Organizing Spreadsheets

[Roman Stefaniw]

Hi everyone! 

I just closed on my first duplex and I'm going through the process of organizing my money through spreadsheets. I have no previous experience with organizing money for an accountant like this and I'm getting a stumped. Basically I have 3 savings accounts I'm going to organize my PITI, water, Insurance, Prop tax, Mortgage, Main & repair, Vacancy, Cap Ex, Prop Manage & Cashflow. Im getting 1650 per month with both units.

If anyone could send me a PDF  of one of there spreadsheets or if they have any advice on how to organize this that would be great. This is probably simple for a lot of people but i'm more of a blue collar type of person and have no experience with this. Thank you!! 

[Basit Siddiqi]

Ultimately - your accountant will want information that is nicely organized so he can interpret the data to see if something is off or if something is missing. The ultimate end result of the information will be presented on your return.

Your financial institution should allow you to export the information into excel.
create a column to the right of the amount with a description "rental income", insurance expense", "repairs"

Once everything is properly categorized. use the "sumif" function in a separate tab that adds up all your banking information.