Personal Mortgage vs LLC - Bookeeping and Accounting Question

[Brian Whitney]

Hi All, 

Last year I did my first BRRRR on a duplex, which I refinanced in my name. I'm finishing a 3 unit BRRRR and will most likely put this one into an LLC. I would like to separate my name from the duplex and start setting up a "company".

In regard to the duplex, I have a personal checking accounting that all of the money runs through and I keep track of all the income/expenses on a Google Sheets document. As I look forward to refinancing my next property, I'm having questions about the book keeping. 

Do you all keep 1 checking account and then spreadsheets to determine where the money in that account belongs?  For example: Account has 20k: Property 1 spreadsheet 5k, Property 2 5k, Property 3 5k, Property 4 5k.  

If 1 property is financed in my name and the 2nd is in an LLC do I need 2 accounts to avoid "co-mingling" funds?

If that is the case, do you open a separate account for each LLC? Seems like overkill to me, but what do I know.

Any input on how you structure your finances would be awesome. 

Thanks in Advance, 

Brian