Why your Centrex deal book and your QuickBooks disagree by six figures

Your CRM says one number. QuickBooks says another. The difference is $187,000 and nobody can explain it. Here's what's actually causing it.

A merchant cash advance funder we work with had a six-figure problem he had been ignoring for almost a year.

The platform he used to track every deal (Centrex, in his case) said his outstanding deal balance was $4.2 million as of October 31. His QuickBooks said it was $4.387 million. The two systems disagreed by $187,000, and nobody on his team could explain why.

Every month, the gap got slightly worse. Every month, the controller said he’d “look into it.” Nobody actually did, because looking into it required reconciling six months of deals one by one, and there was always something on fire that week.

The gap was not theft. It was not fraud. It was the standard set of small reconciliation errors that build up in any MCA back office that is running two parallel sets of books. The fix is mechanical. But it has to actually happen.

Why two sets of books exist in the first place

In a typical MCA shop, the deal data lives in the servicing platform. Centrex, LendSaaS, Onyx, MCA Suite, take your pick. The platform tracks every funded deal, every daily payment that gets pulled from the merchant, every payoff, and every default. It knows exactly how much is still owed back to you.

The accounting books live in QuickBooks. They track everything else. Bank accounts, operating expenses, payroll, payouts to capital partners, commissions to the brokers who source deals.

The two systems are supposed to agree on the outstanding deal balance. They almost never do, because the deal platform speaks one language and QuickBooks speaks another, and somewhere in the middle is a daily journal entry that is supposed to translate between them.

When that translation is sloppy, six figures of error compound over a year.

Where the $187,000 actually came from

Once we sat down with the controller and reconciled deal by deal, the $187,000 was four things.

Bad deals not written off in the books. Eleven deals had stopped paying over the past six months. The platform had marked them as a loss. QuickBooks still showed them at full value. Net difference: $94,000.

Broker commissions that should have come back. When the funder paid a broker their commission on a deal that later went bad, the broker was supposed to give some of it back. The platform tracked it. QuickBooks didn’t record it. Difference: $31,000.

A capital partner’s share that got counted twice. A capital partner was funding 40 percent of certain deals. Their share was recorded both as money owed to them and as a reduction in the deal balance. Same number, two places. Difference: $42,000.

Routine paid-off deals never cleared. Five deals had been paid in full and closed in the platform. The bookkeeper never made the corresponding entry in QuickBooks to clear them. Difference: $20,000.

Add them up and the $187,000 was fully explained.

Cause	Amount
Bad deals never written off in QuickBooks	$94,000
Broker commissions that should have come back	$31,000
Capital partner’s share counted twice	$42,000
Paid-off deals never cleared	$20,000
Total reconciling items	$187,000

Not theft. Not fraud. Just six months of skipped journal entries.

Why this matters more than it looks

A funder living with a six-figure gap between the deal book and the accounting books has three problems, in increasing severity.

Cash flow forecasting becomes impossible. If your outstanding deal balance is wrong by $187,000, every projection that uses it is wrong by some unknown amount. How much capital you can deploy. How much you owe partners. Whether you’re meeting the rules of your line of credit.

Audits and lender reviews get rocky. If an auditor asks for a portfolio reconciliation, the $187,000 gap becomes a problem they have to write up. That report makes raising the next line of credit harder.

You make bad funding decisions. If bad deals aren’t being recognized when they go bad, the performance of recent deals looks better than it actually is. You think your underwriting is working when it might not be. Six months later, after a few more bad rounds of deals, the truth surfaces.

What real MCA reconciliation looks like

For our MCA clients, the platform-to-QuickBooks comparison happens monthly, not annually. Three steps every close.

One. Pull the outstanding deal balance from the servicing platform on the last day of the month. Pull the matching number from QuickBooks. Compare totals.

Two. If they don’t tie, run a deal-by-deal export from both systems and find the gaps. The four causes above account for 90 percent of normal monthly drift. Anything outside that gets flagged for the controller.

Three. Post the journal entries to clear the gaps. Bad deals get written off. Broker commission claw-backs get booked. Capital partner shares get straightened. Paid-off deals get cleared.

When the close is done, both systems agree to the dollar. Your reserve for likely loan losses runs off a real number. Your portfolio performance reports reflect what’s really happening. The packages you send to investors and lenders all tie out.

The whole process takes about six hours a month if you’re caught up. Twenty hours if you’re not. Letting it slide for a year, like the funder in our story did, turned a routine month-end into a two-week project.

Best practices for MCA back-office accounting

A few habits that keep the platform and QuickBooks talking to each other:

Compare the platform deal balance to the QuickBooks balance every month, not annually. Catching a $20K drift in March is easier than untangling a $187K gap in December.
Write off bad deals in QuickBooks the same month the platform marks them as a loss. Lag is what builds six-figure gaps.
Record broker commission claw-backs the same period the deal goes bad. The two events are linked. Treat them that way in the books.
Track each capital partner’s share as money you owe them, separately from the deal balance. Never net them together. That’s how dollars get counted twice.
Run a loan-loss reserve calculation quarterly, broken down by when each batch of deals was funded. Updating only at year-end means your balance sheet is wrong eleven months out of twelve.

Three questions worth asking

If you run an MCA shop and you’re not sure where your books actually stand, three questions to take to whoever handles your accounting:

As of the last close, did the deal balance in our platform tie to the deal balance in QuickBooks?
How are bad deals written off in the books, and how often?
Are broker commission claw-backs being recorded when deals go bad?

If those answers come back uncertain, you have a gap building, just like the funder in this story did. The fix is a process, not a software upgrade.

If you want a second pair of eyes on yours, send your most recent deal balance from the platform alongside the matching balance from QuickBooks. We’ll tell you whether the books are tying or where the cleanup needs to start.