Bravas

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. Bravos has 20+ locations across the US.

Challenge

Controllership and Accounting team manually aggregated OuickBooks 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.
The team had difficulty getting all the data from disparate systems into one spot.

Action

Teamed up with client’s outsourced IT to develop process to snapshot OB 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 SOL DB for in-house data analysts to use.

Result

<2hr Latency
from JE post to refresh in company-level financials

15+ Hours
Of FP6A times saved per month

99% Accuracy
trial balances including transaction detail

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

Matt Bower

Senior Data Analyst