Heck...are people paying a few thousound dollars to consolidate Excel data!? I'll do it if that is the case! All it takes an investment in hours to create the Macros that pull the data into a template. The problem I've encountered is most corporate offices either do not have anyone to inform them that this capability exist already, or do not have an operations analyst to consolidate and publish portfolio data.

I.T. departments are all about hardware and communications they do not care to maximize software applications, so they are usually no help. My advise is to hire someone in support of operations, someone who knows excel and who knows property management in order to recognize what information a department needs and but it in a format so good business decisions and adjustments can be made.

If a department is able to accomplish centralized reporting without thousand spent on consultants you not only free up time for site staffs, but accuracy is also greatly improved. We have all heard the saying garbage in garbage out, so it's also important to set up a solid set of procedures to ensure that daily, weekly, monthly reports are accurate.

Otherwise, if you want to spend thousands...give me a call.

I agree! Getting centralized reporting capability should be a function of all PM companies, those who are using manual processes are behind the curve. Our PM software has centralized reporting functionality (if you pay for it of course), but it also has site data exchange. Site Data Exchange is a wonderful capability that allows multiple property reports to be pulled centrally all at the same time. The data in these reports can then be pulled via Macro to report templates. No manual process at the site level, just a matter to have all sites all on the same date with all tasks completed which serves not only to keep them on track, but also allows for prelimary numbers to be reviewed prior to pulling the final reports. No fancy or expensive custom work needed...but perhaps with other systems it is not possible to pull multiple property reports for multiple properties at the same time?