more-arw search

Q&A Forum

In dire need of good consolidation software for small but relatively complex RE Invest Group

Hello all,

I recently started at a small REIG (just under $2B AUM) that has over 50 income generating properties, operational companies, and stakes in startups/small businesses. Previously, I worked in Big 4.

Many of the properties roll up into different funds, which are owned by co-investors, trusts, and other businesses. What this means is that the company has books for all of the entities, funds, trusts, co-investors, and more. For most of the entities, they recently moved from some dated accounting software to Quickbooks (Auditors nightmare, trust me). The incoming generating properties were moved to Yardi. With that said, each individual property in Yardi also has a related set of books in Quickbooks, which is updated as cash is distributed to investors/large loans are received, etc. In sum, we're looking at >200 sets of books here across 2 ERP systems.

So how do these guys reconcile/do investor reporting? Our Director of Finance has a password protected "master" excel workbook which only HE can access, and it consists of over 500 tabs! How is the data in these tabs populated? Well, we have hundreds and hundreds of other excels that the analysts enter data into from Yardi and from Quickbooks, and which flows into his "master" file. It's a linking/reconciling DISASTER, that only one person at this company knows how to do.

My jaw dropped when I learned about the system here and immediately knew I'd have to take on the challenge of finding some way to automate the process here. While some improvements have been made thus far (ie. mapping so that someone doesn't have to hard code all these numbers in from Yardi every month), I need to take it to the next level, hence why I'm on these forums.

I need your guys' help here. What is the best consolidations/reconciling software for a company like the one I work at? I've worked a lot with Hyperion/Blackline in the past (but with much larger, much more multinational companies) and wasn't sure if they'd be the right solution for my current company.

Any suggestions? Any other solutions you'd propose to someone in my position?

Thanks ahead of time for the help PF family.

Answers

Topic Expert
Keith Perry
Title: Director of Global Accounting
Company: Agrinos, Inc.
(Director of Global Accounting, Agrinos, Inc.) |

Anon,

I'm going to piggy-back along on your question, as I have a similar set of problems.

Cheers,

Keith

1555 views

Get Free Membership

By signing up, you will receive emails from Proformative regarding Proformative programs, events, community news and activity. You can withdraw your consent at any time. Contact Us.

Business Exchange

Browse the Business Exchange to find information, resources and peer reviews to help you select the right solution for your business.

Learn more

Contribute to Community

If you’re interested in learning more about contributing to your Proformative community, we have many ways for you to get involved. Please email content@proformative.com to learn more about becoming a speaker or contributing to the blogs/Q&A Forum.