The company

An established firm of London city centre surveyors who managed rent collection and building utilities for corporate investors.

The Problem

The previous manual process involved rekeying a report that was produced by a Unix based computer dealing with property income and expenses management system.

After month end it took 10 working days to rekey the data into an Excel spreadsheet and there were errors in transcription each month to produce the property owner’s statements. A quicker and more accurate method was needed.

The Solution

The first part of the solution delivered the data.

For the second part, control and accuracy were paramount. It delivered a printed report, the bank control account which showed opening balances, total receipts and total payments and closing bank balance.

The results were presented in Excel spreadsheet format as a property profit and loss account for each property for the month.

The Result

Manual transcription and a 10 day delay was done away with. The automated program took less than one hour to convert data and print out all the results, a task that had previously taken 10 working days.

The monthly report was now wholly accurate each and every time. The company was able to reinstate payments to building owners by the second week of the month, a great success and a leap forward in customer service!

The Benefits

A manual process that had numerous mistakes each month was now wholly accurate and produced in less than 1 day rather than 10 days.

The firm were able to compete for new customers with their improved processes.

Firms are seeking to be more efficient by reporting earlier.

All of the features and more found in this bespoke solution are available in our month end reporting tool ConsolReports which totally automates Dashboard reporting and analysis for businesses.