All Forum Posts by: Simon W.
Simon W. has started 47 posts and replied 1288 times.
Post: Any bookkeeper recommendations for properties in Maryland?

- Real Estate Consultant
- Lehigh Valley PA & New York City
- Posts 1,339
- Votes 650
Quote from @Warren Y.:
I'm looking for bookkeeping for about ~20 properties. 95% are LTR. Most have mortgages. We need help managing statements from mortgages, hoas, and taxes. We have a backlog of about ~1000 transactions that need to be classified according to the statements. Are there software tools to help with this or a bookkeeper that's recommended?
Hey Warren,
backlog of 1000 transactions are a bit much, but the better question is, what year(s) are those transactions in? This would be a world of difference.
20 properties isn't too bad. It is probably best to true-up until Q1-Q3 for the mortgage principals vs interest and taxes.
What platform are you working with? If none, probably the next best thing for accounting purposes is just quickbooks online plus.
Feel free to DM me if you need assistance.
Post: Business bookeeping for real estate investing

- Real Estate Consultant
- Lehigh Valley PA & New York City
- Posts 1,339
- Votes 650
Quote from @Emily R.:
I want to organize my business books better to be able to quickly apply for loans, LOC, share with an accountant, file taxes, etc. I have 1 property in my LLC and I'm about to buy 1 more within it. Both will be managed by my PM who uses Buildium. I want to be able to pull statements quickly for my LLC that looks similar to the one I get from Buildium for my business that includes my mortgage, insurance, repairs to property (that happen before I hand them off to the PM), rental license fees, general business expenses like for my virtual mailbox & registered agent, etc. I essentially want to be able to marry the data easily from Buildium to quickly so I get a full financial view of my business. Would QuickBooks be my best bet or is there something else that would fit my needs better?
Buildium won't sync with QB so it doesn't really matter. QB will work as long as the person entering the data correctly. Also, syncing the bank feeds to your banks and credit card would be where you need to figure out. QB handles pretty much all types of bank & credit card sync. Other platforms such as Xero is a hit or miss.
Post: Bank Reconciliations- Bookkeeping Tips

- Real Estate Consultant
- Lehigh Valley PA & New York City
- Posts 1,339
- Votes 650
reconciliation on a daily basis is overkill
Post: Good Accountant Needed

- Real Estate Consultant
- Lehigh Valley PA & New York City
- Posts 1,339
- Votes 650
Quote from @Monish Anand:
Hi,
I need to connect with an accountant who truly understands the Short Term Rental industry. I am struggling to understand why my business is losing so much money. My books aren't clean and I am spending hours recategorizing things. Please contact me or point me to your best person. Thank you so much. As appreciation i will upvote your post and anything else I can offer you
You may want to get someone that understands how the books should look and clean it up for you before hiring a CPA. Having your CPA to clean up your books is going to be very costly.
Post: Good Accountant Needed

- Real Estate Consultant
- Lehigh Valley PA & New York City
- Posts 1,339
- Votes 650
@Monish Anand there are plenty of professionals here that can help you.
I recommend looking through their posts to see if anything they say seems to fit you.
Some of us can do the bookkeeping side of what to categorize and also have the knowledge on how to read your financials and not just act like robots lol
STR is a specific niche so there is going to be a lot transactions. Are you self-managing or do you have a PM that handles that? Or hybrid?
One of my clients does STR and he has some PM handling and there are some properties he is personally managing. You would need someone that understands the difference on how to record the funds when the PM sends the money on a monthly basis.
Post: How to track transactions and digitize records?

- Real Estate Consultant
- Lehigh Valley PA & New York City
- Posts 1,339
- Votes 650
I do not think Buildium sync with QB.
As for the OP—you run the PM so you have full access to Buildium? If so, why not just sync the statements there so it can track all the expenses that you use Stessa to track?
Post: Banking options for rentals

- Real Estate Consultant
- Lehigh Valley PA & New York City
- Posts 1,339
- Votes 650
Quote from @Jim Windgassen:
Quote from @Nicole Heasley Beitenman:
I can't speak to it for banking or property management, but I don't recommend it at all for bookkeeping. It's not a true double-entry accounting system. I use Xero for myself and my clients, and I use Keycheck for property management.
I should mentioned I currently only manage MTRs, though. I used RentmindMe for years with my LTRs--no complaints!
Nicole - How does Xero compare to using QuickBooks ? I have been using QB for many years, but I am getting fed up with the annual fee model which has really gone up.
As a proadvisor for both Xero and QBO lol I can say it is a hit or miss. Both platforms are constantly adding features but that also means price will go up.
Xero is a fractional of the price. Not all bank accounts can be pull from your bank. If you use the typical banks and credit cards, you shouldn't have a problem.
As an accountant, the journal entry is a big factor, Xero doesn't do a good job of it. Can't do journal entries against any cash account. They explained it but I don't think it is a good reason.
QBO is raising the pricing starting 8/1 so there's that.
Xero works if you don't mind the extra steps to do things you are used to doing in QBO.
Post: Anyone using DoorLoop, ManageCasa, etc for small rental portfolios?

- Real Estate Consultant
- Lehigh Valley PA & New York City
- Posts 1,339
- Votes 650
AppFolio is definitely the top contender out of the list.
I consult and act as a fractional CFO for PMs and most of them uses AppFolio. I was also a CFO for a PM company that was using AppFolio since the start of AppFolio. However, it is expensive and they do have a minimum unit requirements.
Check out Buildium, I have some clients using them as well.
Post: I want to learn how to self-manage one SFH remotely. How did you learn?

- Real Estate Consultant
- Lehigh Valley PA & New York City
- Posts 1,339
- Votes 650
not worth it for the course.
It is only one SFH so if the property is in good condition, you probably won't even have much maintenance involved.
bookkeeping, just make sure you have record of the income, receipts for the expenses and capital improvements. you can give this to your CPA at year end.
you just need to make a list of vendors that you will need just in case of emergency at 2am in the morning plumbing problems and others.
Post: PM accounting practices

- Real Estate Consultant
- Lehigh Valley PA & New York City
- Posts 1,339
- Votes 650
I have been doing real estate accounting for 20+ years. The PM side of accounting and the investor side of accounting.
Owner Held should not be part of the Net Income.
The numbers in "Other Items" has a delta of $900 so not sure what is going on there.
The $4630 owner payout typically is a payout from the prior month.
I would need to actually see the Cash Flow statement to make sense of things.
I would assume the Management Agreement has a reserve amount.