Originally posted by @Mike Dymski:
Hey @Harman N. I tried converting AppFolio reports into a file format that could be uploaded into QB and that did not work. I manually key AppFolio Owner's Statement data into a standard Excel template that is prepopulated with recurring descriptions (unit numbers, rents, management fees, landscaping, dates, etc.) I tried uploading that file into QB and QB would not support it. So, I use Xero instead...and upload the Excel file (CSV). Incidentally, Xero is significantly more intuitive than QB.
Currently, I am doing this at a transaction level but may start using aggregated totals. I catch PM errors during this process; so, not sure how aggregated I can go anyway. For example, I recently noticed that the PM did not transfer a security deposit to my account for back rent after a non-paying resident moved out, did not bill back residents for utilities, forgot to reimburse a portion of carpet repair caused by a former resident's pet (PM did not withhold security deposit or have move in/move out inspection documents), etc.
It's not an elegant process but it is semi-automated.
Thanks for the input Mike! Did you move all your bookkeeping & accounting to Xero from QB? Or is Xero a complement to your QBO?
Would you mind sharing your Excel template (w/o the data) with me? I've been improving my spreadsheet a little bit each month, but right now I'm only at 4 properties / 10 units in service, and I don't think my spreadsheet would scale 5x..