Situation
LongWater Opportunities is a lower-middle market alternative asset firm with Private Equity, Private Creditand Capital Solutions practices.LongWater continues to actively seek new opportunities in Construction & Infrastructure, Manufacturing, andIndustrials, among other industries. They specialize in hands-on partnership with the businesses they invest into drive growth and value creation.
Challenge
- LongWater’s Finance & Accounting team spent valuable time and resources manually pulling data from multiple QuickBooks instances and recalculating a complex, comprehensive financial package in Excel each month for their investors.
- LongWater’s reporting team also needed portfolio company-level financial reporting, which was previously compiled manually using data from each PortCo.
Action
- Provided automated general ledger and trial balance Data Feeds into Excel, which consolidated the QuickBooks instances and replaced the previously disparate raw data.
- Repurposed and recalculated all outputs of the reporting to be calculated off real-time data, allowing the LongWater team to reload all financial data sources with the click of a button.
- Created detailed, automated financial statements in PowerBI, filterable by portfolio company.
Result
10 DaysFrom connections to completed and Automated financial package
4+ Business Daysof manual time cleansing and combining data in Excel/PowerBI eliminated every month
“The BUCS Data Feed and reporting saved us several days a month gathering data from multiple sources to provide monthly reporting both internally and externally to our investors.”
Jill Cederberg
Director of Accounting
Systems Integrated
2 Housecall Instances
1 FieldAware Instance
1 FieldEdge Instance
1 SAMPro Instance