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 process.

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

01 | Teamed up with client’s outsourced IT to develop process to snapshot QB files and spin up BUCS-dedicated reporting server.

02 | Planned data refresh schedules to coincide across client’s operating locations – more of a seamless, ”unanimous” refresh and close process.

03 | Eliminated need for team of accountants/analysts to copy/paste trial balances to get company-level account balances.

04 | Established a pipeline to write consolidated GL details to a dedicated SQL DB for in-house data analysts to use.

Results

BRAVAS was able to accelerate month-end close and eliminate more than 15 hours of manual FP&A work every month as well as increase the data refresh frequency enabling the controllership to have the most up-to-date information across the business.

“BUCS has been instrumental in consolidating our Financial Data, allowing BRAVAS Analytics and Corporate Finance to provide quick and accurate information to Leadership for data-informed decision making.”

Matt Bower, Senior Data Analyst