accounting system and deal sponsors/syndicators

accounting system and deal sponsors/syndicators

Investor · Greenville, SC · Member since 2016 · 5k+ posts · 13k+ votes

I am shopping for the right accounting software, have read all the posts on BP related to it and have PM'ed a few members.  I am using 3rd party management (they use AppFolio); so, my needs are pretty basic and do not include any management, invoicing or payroll functionality...just basic accounting and reporting.  My PM tells me and I have read on BP that AppFolio does not have robust reporting.  Below are questions regarding QB and Xero (and Wave):

Can they layer in your mortgage payment on the bottom of a P&L and calculate cash flow?

Can they calculate metrics such as CoC, IRR, cash flow per door, and ROE? Think metrics that would show up at the bottom of a trended P&L.

Reporting - Would like P&Ls and metrics by property and in the aggregate, rent rolls, balance sheet, cap ex log, annual tax reporting, budget to actual comparison (not a must have).

Do they allow budget input and budget to actual comparison by property and in the aggregate?

My question is directed at investors, bookkeepers and I also included deal sponsors and syndicators in the subject as I am curious on how you are tackling your regular reporting to investors.  I am not syndicating but I am likely looking for some of the same reporting functionality that you use.  I am curious if you get it directly out of your accounting system or if you export it to Excel and modify for investor reporting purposes.  The bookkeepers will slap me for this but since my needs are so limited, I could easily build this in Excel, use a transaction table and vlookups.

Would prefer the cloud but will use a desktop application if I have to.

Please save me from this research...ready to implement it and move on to investing.

0Reply
27 views

7 Replies

Jump to latestLatest
  • Note Buyer · Fresno, CA · Member since 2014 · 34 posts · 11 votes
    10y
    Sounds like you want to be an accountant instead of real estate investor.
  • Investor · Greenville, SC · Member since 2016 · 5k+ posts · 13k+ votes
    10y

    @Jason Gray standard reporting for debt and equity holders in commercial (and many real estate business owners)

  • Real Estate Agent · Jacksonville, FL · Member since 2016 · 46 posts · 13 votes
    10y
    Maybe it's just an easy out but I would suggest QuickBooks, receipts and a CPA.
  • Note Buyer · Fresno, CA · Member since 2014 · 34 posts · 11 votes
    10y

    Frank made my point.

    There are professionals who PLAY in the area of accounting, spreadsheets, numbers, reporting etc.

    My point was, do you want to be an accountant, or do you want to be the one finding and funding deals? 

  • Investor · Greenville, SC · Member since 2016 · 5k+ posts · 13k+ votes
    10y

    @Frank Spaulding @Jason Gray Totally understand where you are coming from and appreciate the feedback...that's the long-term plan.  I outsource everything else and the books are the one item that I want to keep in house for now.  It will only take a couple of hours a month....just need the right tool.

  • Accountant, Enrolled Agent · Grayslake, IL · Member since 2011 · 5k+ posts · 2k+ votes
    10y

    @Mike Dymski,

    You can export information to spreadsheets and include other information from any good system. Avoid Wave.

Join the conversationCreate a free account to reply, vote on answers and follow this thread.