Situation
BRAVAS is a leading national technology integrator. Focused on the luxury market, BRAVAS completes more than 3,500 residential and commercial projects across the US every year.
BRAVAS sells and supports everything from lighting, shades, and A/V to networking, security systems, and power management. BRAVAS has 20+ locations across the US.
Challenge
- The controllership and accounting team manually aggregated QuickBooks trial balances across 20+ locations during month-end close.
- Each of these instances were located on a single production server, so users across the enterprise often experienced performance issues when using the software.
- Likewise, in-house data analysts desired consolidated GL detail to maintain a 'DB of record' and build their own custom reports.
Action
- Teamed up with client’s outsourced IT to develop process to snapshot QB files and spin up BUCS-dedicated reporting server.
- Planned data refresh schedules to coincide across client’s operating locations – more of a seamless, ”unanimous” refresh and close process.
- Eliminated need for team of accountants/analysts to copy/paste trial balances to get company-level account balances.
- Established a pipeline to write consolidated GL details to a dedicated SQL DB for in-house data analysts to use.
Result
<2hr
Latency from JE post to refresh in company-level financials
15+
Hours of FP&A time saved per month
99%
Accuracy – trial balances including transaction detail
“BUCS has been instrumental in consolidating our Financial Data, allowing Bravos and Corporate Finance to provide quick and accurate information to Leadership for data-informed decision making.”
Matt Bower
Senior Data Analyst
Systems Integrated
28 QuickBooks Instances
15 iPoint Instances
2 Housecall Instances
1 FieldAware Instance
1 FieldEdge Instance
