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!! 

Check the fileplace for templates like this one.

 https://www.biggerpockets.com/files/user/brandonat...

@Tim Butters Awesome, this might just be perfect. Thanks!

@Roman Stefaniw - I also have one on my site. Like your feedback on it if you have a chance. 

@Jay Helms. Yes I will check it out. That first template won't work for me actually as I'm trying to organize with 3 different accounts. That template is good for one account. 

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.

@Tim Butters Have you used that Template that you recommended to me before? Because I'm having issues with it. When i Minus the Mortgage Payment ( -723.94) for the month of February. It doubles it for some reason. 1447.88. So say i have 5000.00 in the account and I'm trying to minus the mortgage payment for the month I enter -723.94 and it automatically subtracts 1447.88 for some reason. Any help would be awesome as i have no idea how to use spreadsheets. Thank you!! 

Originally posted by @Roman Stefaniw :

@Tim Butters Have you used that Template that you recommended to me before? Because I'm having issues with it. When i Minus the Mortgage Payment ( -723.94) for the month of February. It doubles it for some reason. 1447.88. So say i have 5000.00 in the account and I'm trying to minus the mortgage payment for the month I enter -723.94 and it automatically subtracts 1447.88 for some reason. Any help would be awesome as i have no idea how to use spreadsheets. Thank you!! 

 You probably don't need to use negative amounts when entering expenses. Here's a google sheet link with the numbers you show and how they should look. 

Not sure if sharing this kind of link is allowed so PM me if you still have issues.

https://docs.google.com/spreadsheets/d/1KMUADwnO6RgLh4gi9iAKwkWwuiP6l-zo-gSLfJUa4yg/edit?usp=sharing