Problem

A large construction firm had budgets in spreadsheets, actuals in QuickBooks, and estimates scattered across documents. No single source of truth. Manual reconciliation every time.

Solution

Built a daily QuickBooks sync to BigQuery, automated SQL categorization, and a real-time Glide dashboard joining budget, actual, and estimate data in one view.

Result

Leadership now has instant visibility into over and under-spending across every project. Accounting time freed up significantly.