Easy/Beginner Excel Bookkeeping Document?

[Holly Yankus]

Hi,

I am a new REI this year! Woohoo! I have a SFH and a duplex. (We are living in one side of the duplex for a year, so I technically only have 2 rentals right now). I am going crazy trying to figure out the best way to get started with bookkeeping. I am going to have a lot of backlogging to do as far as tax prep goes because we didn't realize we would be owning rentals until August of this year. I have a business account, but as of now, only rent and mortgage is going in and out of the account because we do not have enough cash flow to cover all the rehab we are doing. I thought about buying quickbooks, but I'm worried it won't work right since we are using our personal account for expenses right now. Judging from other posts, a simple excel document will work well for 2 rentals. I'm just having trouble finding one and figuring out how to use it. I saw one advertised on here, but it seemed very complicated to me. Anyone have an easy/beginner one that would be good for me? Also, any recommendations for short online classes or youtube videos on bookkeeping would be great. I'm somewhat numbers/accounting savvy, but that's definitely not where my expertise is.

[Daniel Hyman]

@Holly Yankus Congratulations on becoming a REI! Have you seen this thread?

https://www.biggerpockets.com/forums/51/topics/29795-excel-spreadsheet-for-expenses-tax-prep

[Holly Yankus]

Exactly what I was looking for! Thanks @Daniel Hyman.