Home >> Case Studies
Customized Profit & Loss Report for a Major Furniture Manufacturer
Case
Study
The Problem
Hospitality Designs (HD) uses a dashboard for monthly executive reviews, but updates were too labour intensive and prone to errors. The chart of accounts and dashboard designs change during they year to adapt to strategic updates, and HD wanted a solution to adapt to these situations.
QuickBooks could not export data into a format that’s easily organized into their evolving dashboard. Each strategic update meant manually updating the original dashboard, finding and updating multiple static formulas, a process that took several hours to a whole day.
The Business
The Solution
GoodReports created a direct link to QuickBooks from Excel using a QODBC database connection.
Dynamic formulas and triggers were added to the Profit & Loss report, and a custom macro button macro allowed one-click processing. A custom table to map cost codes with departments eliminated roughly 90% of the previous manual work and allowed HD to report on criteria previously unavailable to them.
Hospitality Designs was able to produce a dashboard in minutes rather than hours, and made previously buried data visible for the CFO to analyze.
The best part is I can customize this report myself because of some new dynamic features. GoodReports saved me a lot of time and I recommend them!
