Best way to analyze and project commercial RE Finances
Hey-

We are a small RE Development firm. We've been tracking deals (about 7-10 in play) in excel to track the following:

1. When invested equity or loans will be returned. 
2. Amount committed
3. Cash on hand &amp; future income
4. Income Tax Liability
5. Overall Cash Flow after tax (since the shareholders need to know if there is any phantom income from principal paydown).
6. Loan Payments
7. Rent Bumps

As we grow in size, it's becoming a lot to manage in excel. Does anyone have a software recommendation that we could use to simplify in addition to quickbooks?

&amp;#x200B;

Thank you,
[{"id": "gk9cidt", "text": "Far as I know the cost-conscious small firms all use excel.\n\nLots of options that cost a bit more though. I think Yardi branched out in to this area now, and there's ARGUS of course.", "replies": [], "depth": 1}, {"id": "gk9clc9", "text": "A combination of Argus Enterprise, Argus Developer and an accounting software like QuickBooks is probably the best approach.\n\nTry to stick to families of softwares so they're likely to communicate data.", "replies": [{"id": "gknjrl8", "text": "Does Argus actually work for development deals? I\u2019ve only used it in this context to mode the lease up and then drop it into an excel model.\n\nAlso not sure if AE changed it but DCF sucked for portfolios, the math didn\u2019t work right.", "replies": [{"id": "gknkns0", "text": "Most of the improvement from DCF to AE was related to cloud collaboration and portfolio management. Works pretty well now IMO. A few quality of life improvements would be nice but it's always been a bit tedious to use - even in the DCF days. \n\nAs for development deals, you're right that AE is not well optimized for those. Argus makes a different software that they creatively call Developer which is pretty good. It can also track a property through to cash flow in AE. I personally prefer excel models for my development pro formas but someone who's less familiar with CRE or excel modelling might prefer the more guided structure of Developer.", "replies": [], "depth": 3}], "depth": 2}], "depth": 1}, {"id": "gka1zh3", "text": "If you keep using spreadsheets, try converting them to Google Sheets. The functions are the same as Excel but it allows your team to collaborate and comment without having to copy files around. It's also easier to share data across spreadsheets.", "replies": [{"id": "gkab37x", "text": "Gross. You know you can collaborate on excel too, right?", "replies": [{"id": "gkafjot", "text": "Thanks, I wasn't aware of it until you mentioned it. It does seem a bit restrictive; all collaborators must have specific versions of Excel installed, whereas Google Sheets just needs a browser.", "replies": [], "depth": 3}], "depth": 2}, {"id": "gkdsd06", "text": "Google sheets is terribly inferior to excel", "replies": [{"id": "gkedfvv", "text": "In every way except...... no actually that too", "replies": [], "depth": 3}], "depth": 2}], "depth": 1}, {"id": "gka9art", "text": "Most use either Argus or Excel. Excel is gonna be the most flexible and powerful. You can do so much with it. Plus, with office 365 you can use online collaboration. Although, as the sheets get bigger, online gets clunky and slow. Quickbooks is pretty popular for the accounting side of things.", "replies": [], "depth": 1}, {"id": "gke5gwt", "text": "Make a form that sits on top of excel to collect and display data.\n\nCreate a custom app in airtables\n\nUse access instead of excel\n\nAll these require a bit of custom programming", "replies": [], "depth": 1}, {"id": "gkefhui", "text": "I am working on something that lets you convert your data in spreadsheets into an app to organize everything. So you will have a form to enter data and a clean interface to read all data. And all your data stays inside your spreadsheet.  \n\n\nYou don't need programming skills to build this. I can DM a Youtube video of the product if you're interested,", "replies": [{"id": "gkfs26m", "text": "I\u2019d be interested in seeing this as well.", "replies": [{"id": "gkftkgm", "text": "Could you please DM me your use case?", "replies": [], "depth": 3}], "depth": 2}], "depth": 1}, {"id": "gkesmm4", "text": "Office 360 online version  has excel so you are not restricted to version  issue.", "replies": [], "depth": 1}, {"id": "gkfr6oh", "text": "You need Realinsight.com. Exactly what you are looking for. Works for small and large firms. PM me if you want to get in touch or have questions.", "replies": [], "depth": 1}]