# The Challenge

Before Coefficient, extracting and consolidating financial data from QuickBooks was a **nightmare of manual work.**

Each month, CFO Mike Lynch **spent up to 10 days** downloading reports, re-uploading data into Excel models, and fixing broken formulas caused by even minor journal entries.

Attempts to modernize using Power BI and Power Query failed. They were **too complex**, required specialized expertise, and easily broke when data changed.

### Before Coefficient

- **10-day month-end close** process
- Frequent **reporting errors** that impacted credibility
- Significant **time lost on data prep instead of analysis**

# The Solution

Thornton Capital implemented **Coefficient** to automate financial data syncs directly from QuickBooks into Excel-based models.

The setup was completed in minutes and required no engineering. Mike’s team kept using their familiar templates.

**With Coefficient, the firm now:**

- **Pulls live data** from 16 QuickBooks files into standardized templates
- **Refreshes reports automatically** instead of re-downloading data
- **Makes corrections in real time** and sees updated results in seconds
- **Produces consolidated P&L and balance sheets** across all entities effortlessly

# The Result

**Month-end close cut from 10 days to 3 days**  
**20+ hours saved monthly**, freeing the CFO for strategic work  
**Consistent, accurate financials** across 16 ledgers  
**Faster board reporting and decision-making**  
**Zero dependency on external tools or technical experts**

# The Connected Sheets Stack

- [QuickBooks - Finance / Accounting](https://coefficient.io/integrations-google-sheets/quickbooks)
- Use Cases
- [QuickBooks consolidation](https://coefficient.io/quickbooks/consolidated-financial-statements)
- [QuickBooks reporting](https://coefficient.io/quickbooks/quickbooks-online-reports)

**Thornton Capital** is a single-family office that manages the complete financial operations of several families – spanning real estate, public equities, private investments, and family operations. **With 16 separate QuickBooks files**, the firm’s finance team faced growing complexity in consolidating data, producing reports, and maintaining accuracy across accounts.

### Interview Highlights

“Coefficient helped us cut month-end close for our clients from **10 to 3 days**. What used to take weeks of manual work now happens in a few clicks.”

“Coefficient is the **single greatest return on investment** I’ve made this year. It paid for itself within weeks.”

“We use Excel templates just like before but now they **refresh automatically from QuickBooks**. I can fix a journal entry, hit refresh, and have updated financials in seconds.”

700,000+ happy users