DMG Property Reduces the Risk of Reporting Errors With MasttDMG Property Reduces the Risk of Reporting Errors With Mastt

DMG Property Reduces the Risk of Reporting Errors With Mastt

By
Anton Wu
Contributor:
James Hansen
Contributor:
Read the story
  • DMG Property moved its project reporting from Excel to Mastt after concerns that data-entry errors and broken formulas could go unnoticed until later.
  • DMG prepares its monthly payment recommendations, contractor payment certificates, and budget reports in Mastt, then sends them to clients as PDFs.
  • Project Manager James Hansen says reports look more professional with less monthly fiddling, and he is confident the data is in the correct place and maintainable.
  • New team members have been up and running within about a week, in what James calls a pretty seamless training process.

Background

DMG Property is a Perth-based property advisory firm founded in 2013. It works on behalf of owners and investors to deliver commercial, residential, land, and mixed-use developments, from advisory work through to project management.

James Hansen, a project manager at DMG, said the firm does not have a single defined project type and has a lot of very different projects on the boards.

DMG’s most common output from Mastt is a monthly payment recommendation. On the project James walked through, DMG represents the client. The team receives invoices on the client’s behalf, reviews them against what each consultant and contractor is contracted for and the work completed, and sends the client its recommendation.

It hasn't been a challenging training process. It's pretty seamless.

James Hansen, Project Manager

Challenge: Excel Reports Only a Few People Could Maintain

Before Mastt, DMG ran its project reporting in Excel. James said there was no single breaking point. The team was always looking for ways to improve its workflow, and it had concerns about the risks in its spreadsheets.

The first concern was data entry. Information could be entered incorrectly and not be caught until later. A broken formula could also go unnoticed and affect reports months afterward.

The second was maintenance. The spreadsheets could be maintained, but only by a very select part of the team.

“If you lose one of the people who can maintain it, you suddenly have a big problem.”
- James Hansen

Solution: Payment Recommendations and Budget Reports in Mastt

What drew DMG to Mastt was more security that the correct information was put in the correct places and could be checked.

“You couldn’t accidentally break a formula that was going to ruin things two months down the line without you realizing it.”
- James Hansen

James said the team transitioned quickly, and being able to bring its existing Excel data into Mastt when it started was very helpful.

DMG handles its monthly payment cycle in Mastt’s cost management module. An office administrator enters the invoice details and checks the numbers. The invoices are then reviewed and approved in Mastt before the payment recommendation goes to the client.

Reviews don’t involve downloading anything. A team member flags that an item is ready, in person or by email, and the reviewer checks it in Mastt. James put it simply:

“It’s very much just like, it’s in there now, go look at it please.”
- James Hansen

Most of what DMG sends to clients is exported from dashboards the team has set up in Mastt. For contractors, DMG also issues payment certificates. These go to the client with a budget report covering the relevant section of the budget, alongside the standard payment recommendation. Sending them as PDFs gives DMG a fixed record of exactly what it sent.

The team also takes a monthly snapshot in Mastt as a backup.

Impact: More Professional Reports and Faster Onboarding

For James, the main gains are quality-of-life improvements across reporting. Reports look more professional, and they take less work each month to get there.

“Quality of life benefits and reports looking a bit more professional, or at least not requiring as much fiddling every month to look professional.”
- James Hansen

He also has more confidence in the data itself. It is in the correct place and is maintainable, rather than relying on the few people who could maintain the spreadsheets.

The table below shows how DMG’s reporting changed with Mastt.

Reporting task Earlier approach With Mastt
Entering data Information could be entered incorrectly and not caught until later. Information goes into the correct places and can be checked.
Protecting formulas A broken formula could affect reports months later without anyone noticing. James says formulas can no longer be broken by accident.
Maintaining reports Only a very select part of the team could maintain the spreadsheets. James is confident the data is in the correct place and maintainable.
Preparing monthly reports Reports needed fiddling each month to look professional. Reports look more professional with less monthly fiddling.

Onboarding has also been straightforward. DMG has brought new people on board recently, and James said it has taken about a week at most for them to get going. There is still a learning curve for people new to Mastt, but he said no one has had issues after giving it a bit of a shot.

“There’ll be a few questions back, but then it’s kind of off to the races. It hasn’t been a challenging training process. It’s pretty seamless.”
- James Hansen

Where Mastt Fits at DMG Today

Asked what DMG would do if Mastt shut down tomorrow, James said the team would be back to Excel spreadsheets. DMG still uses Excel for smaller jobs that would not justify setting up a full Mastt project, but for everything else, James said the team is happy with Mastt for its projects.

“It’s a lot easier once it’s all in Mastt.”
- James Hansen

James also shares feedback on how Mastt could work better for the team, and he was clear about where DMG stands.

“Like I said, we really like Mastt, so always good to see it keep improving.”
- James Hansen

More customer stories

Take control of your next project

Get access to Mastt instantly and start automating work in minutes