Thornton Capital Cuts Month-End Close from 10 to 3 Days with Coefficient
“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.”
Mike Lynch
CFO @ Thornton Capital
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
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.”
Trusted By Over 50,000 Companies
