Reconciliation broken
Why a QuickBooks reconciliation stops balancing — changed or deleted cleared transactions, forced adjustments, duplicate feeds — and how to diagnose it.
OpenCalifornia · QuickBooks Reconciliation
California QuickBooks reconciliation — books that match reality.
A QuickBooks ProAdvisor reconciles your California file — every bank, card, and loan account — plus the state liability accounts a bank reconciliation never touches: CDTFA sales tax tied to each return by location, and the EDD payroll taxes tied to each quarter. One-time catch-up or an ongoing monthly cadence. Fixed-fee, all 58 counties.
Monthly bookkeeping: $500–$2,500+ a monthWhat sets the price
If your file needs our paid diagnostic first, its fee is credited in full against the cleanup. Either way, you get a fixed fee in writing before any work starts.
State rule
California rule: EDD requires a DE 9 and a DE 9C every quarter, and the DE 9 reconciles the quarter’s reported wages to the taxes paid; the books’ UI, ETT, SDI and PIT liabilities clear to zero once the quarter’s deposits are made. Source: EDD required filings.
§ The short version
California QuickBooks reconciliation matches every bank, card and loan account in your own QuickBooks file to its statements, then ties the CDTFA sales-tax liability to the return and the EDD payroll liabilities to each quarter’s DE 9. Run it once to get current, or inside monthly bookkeeping at $500–$2,500+/mo.
They took something that felt overwhelming to me as a first-year business owner and made it simple.
What stood out the most was TechBrot Inc’s attention to detail.
Intuit QuickBooks Certification Level 2 and QuickBooks Workforce Certification,
§ 01 · The state accounts
The California accounts a reconciliation has to tie.
Bank and card accounts tie to statements. These California accounts tie to the state’s own returns and filings instead, so they are checked against those, period by period.
| Account | Reconciles to | When it will not tie, check |
|---|---|---|
| Sales tax payable (CDTFA) | The CDTFA return for each period on your assigned frequency, by location, and the payments made against it | Tax recorded at one rate for a location CDTFA lists at another; a quarterly prepayment booked to expense instead of against the liability; a period with tax in the books but no return filed |
| UI and ETT payable (EDD) | The quarter’s DE 9 and the employer contributions paid for it | A payment applied to the wrong quarter; a payroll item rate that does not match the rate EDD assigned |
| SDI and PIT withheld (EDD) | The deposits made on your SDI and PIT schedule, and the DE 9 total | A deposit recorded as an expense rather than against the liability; a late deposit that lands in the next quarter |
| Gross wages, by employee | The DE 9C, which reports each employee’s wages for the quarter | Wages paid outside payroll, or one employee’s pay split across two payroll items |
| FTB annual tax and LLC fee | The FTB payments made for each tax year | The $800 paid and expensed in one year but accrued again in another |
Reconciliations that will not tie
When a bank or card reconciliation keeps reopening, the cause is usually process rather than California: cleared transactions edited after the fact, balances forced with adjustment entries, or feed transactions added without review. Those causes and their fixes are on why QuickBooks reconciliation keeps failing.
When a California liability account will not tie, start with the right-hand column above: the gap is in how a payment or a rate was recorded against the state filing, and it is fixed in the period it happened, not plugged with an adjustment.
The reconciliation itself follows the national QuickBooks reconciliation method; the state’s other filings are on the California page. Your reconciliation is prepared by a senior bookkeeper who works in your software, or by a signed specialist practice when your books need one, with every close reviewed by a Certified QuickBooks ProAdvisor before it reaches you. TechBrot does not prepare or file tax returns; we work with your CPA or EA. TechBrot is not Intuit and does not provide Intuit product support.
§ 02 · California tax realities reconciliation keeps tied
Three California facts reconciliation keeps straight.
A California reconciliation isn’t complete until these tie — especially the sales-tax liability.
$800
California’s $800 FTB franchise tax
FTB: every LLC doing business or organized in California pays an $800 annual tax, and an LLC with more than $250,000 of California income also pays an LLC fee. Reconciliation ties both to the FTB payments actually made, in the right tax year.7.25–11.75%
District sales tax by location
CDTFA’s rate table effective October 1, 2026 runs from 7.250% to 11.750% by city or county. The sales-tax sub-reconciliation checks that the tax recorded for each location matches the rate CDTFA lists for it, and that the liability ties to the return.AB5
AB5 worker classification
Under the ABC test a worker is an employee unless the hiring entity meets all three of its conditions. Reconciliation keeps W-2 wages and 1099 contractor payments in separate accounts, so the split your CPA reviews matches payroll; classification disputes go to your CPA or counsel.§ 03 · What California reconciliation covers
Every account — plus the CDTFA sub-reconciliation.
Reconciliation isn’t just ticking the bank feed — in California it includes tying the sales-tax liability to the CDTFA return.
01
Bank & card reconciliation
Every bank and credit-card account matched to statements, with duplicates and stale transactions cleared.Reconciliation overview
02
Loan & liability accounts
Loans, lines of credit, and liability accounts reconciled to statements and amortization, not left to drift.QuickBooks accountant
03
CDTFA sales-tax sub-reconciliation
The sales-tax liability tied to the CDTFA return by district rate and location — the California step a bank-only reconciliation never reaches.Sales tax compliance
04
Undeposited Funds cleared
The classic QuickBooks pileup — Undeposited Funds and unapplied payments — cleared and reconciled.Cleanup
05
One-time or monthly
A one-time catch-up to get current, or reconciliation built into a recurring monthly close.Monthly bookkeeping
06
A documented result
Reconciliation reports and a summary so you (and your CPA) can see the books now match reality.Financial statements
§ 04 · The scope
What we do — and what we don’t.
What TechBrot does
- Reconcile every bank, card, and loan account to statements
- Run a CDTFA sales-tax sub-reconciliation by district and location
- Clear Undeposited Funds, duplicates, and unapplied payments
- Flag deeper problems and scope a cleanup separately
- Deliver reconciliation reports and a written summary
- Build reconciliation into a monthly cadence if you want it
What your CPA does
- File California or federal income, franchise, or sales-tax returns
- Represent you before the FTB, CDTFA, or EDD
- Resolve worker-classification disputes or audits
- Provide legal or tax advice
- Step 1
Free file review
A QuickBooks ProAdvisor reviews account count and how far behind reconciliation is — at no cost. - Step 2
Written fixed-fee scope
A written scope and fixed fee within 3 business days — one-time or ongoing. - Step 3
Reconcile & tie out
Accounts reconciled to statements and the CDTFA sales-tax liability tied to the return. - Step 4
Keep it tied
Optionally roll reconciliation into a monthly close so it never falls behind again.
§ 06 · The advisory line
Automation handles the data entry. We handle the judgment.
A California file can pass every bank reconciliation and still be wrong: the sales-tax liability that never tied to the CDTFA return and the payroll liabilities that never tied to the DE 9 sit outside the bank feed. Tying them out is what makes the statements trustworthy.
From reconciled books, a monthly close keeps them tied, and advisory turns trustworthy numbers into decisions.
§ 07 · Around this page
Around California.
California QuickBooks ProAdvisor & bookkeeping
The state page: services, industries, cities and the California tax terms in one place.QuickBooks reconciliation, nationally
The national engagement this page is the California version of — same scope, same written fixed fee.Also in California
California cities
Not sure where your file stands? Start with the free QuickBooks file review · how California compares: state-by-state tax quirks.
§ 08 · Around the engagement
Before you engage anyone.
Beginning balance doesn’t match
The four causes of a shifted beginning balance, which two the Discrepancy Report can actually see, and how to tell which one you have — before anyone forces it.
Open§ 09 · Common questions
California QuickBooks reconciliation questions.
What’s the California-specific part of reconciliation?
The CDTFA sales-tax sub-reconciliation — confirming the sales-tax liability account ties to what the CDTFA return reports, by district rate and location — plus the EDD payroll liabilities tied to the quarter’s DE 9. A reconciliation that stops at the bank and card accounts never checks either, so the liability can drift until a notice arrives.
Is this one-time or ongoing?
Either. We can run a one-time catch-up reconciliation to get current, or build reconciliation into an ongoing monthly close so the accounts and the sales-tax liability never fall behind again. The free file review tells you which fits.
What if reconciliation uncovers bigger problems?
It often does — a flat district sales-tax rate, misclassified contractors, or an Opening Balance Equity mess. We flag them and scope a separate cleanup so the reconciliation engagement stays focused and predictable, rather than quietly ballooning.
How much does reconciliation cost?
Fixed-fee against a written scope, based on the number of accounts and how far behind reconciliation is. You get the exact fee in writing within 3 business days of a free file review — never open-ended hourly billing.
Do you reconcile in my own QuickBooks file?
Yes — your file, your data, in QuickBooks Online or hosted Desktop. We don’t move you into proprietary tooling, and we leave you reconciliation reports and a summary so the result is verifiable.
Do you serve my California city or county?
All 58 California counties, delivered remotely on QuickBooks. Your location changes the district sales-tax rate we reconcile to, but never the service or the ProAdvisor on your file.
How do the EDD payroll accounts get reconciled?
Quarter by quarter. EDD requires a DE 9 and a DE 9C every quarter: the DE 9 reconciles the quarter’s reported wages to the taxes paid, and the DE 9C reports each employee’s wages. We tie the books’ UI, ETT, SDI and PIT liability accounts and wage totals to those filings and flag any gap before the next quarter. UI and ETT are due quarterly; SDI and PIT deposits can be due more often.