CDTFA filing without the spreadsheet.

What CDTFA filing actually involves

A California sales-tax filing for a typical c-store has three categories on the return:

1. Inside-store taxable sales at the local rate (state base 7.25% + local district add-ons typically bringing the total to 7.75–10.25% depending on city).
2. Inside-store exempt sales, primarily SNAP/EBT food purchases, which are exempt from sales tax.
3. Fuel sales, reported separately and subject to excise taxes (CA state, federal, and sometimes county). After the 2026 repeal of the tax-on-tax application, the calculation is cleaner but the reporting requirement remains.

For each category, you report gross sales, taxable amount, and tax due. The reconciliation is against your POS sales reports, which need to match your bank deposits, which need to reconcile back to your EOD records.

Where the spreadsheet method falls apart

The traditional approach: pull POS reports per category, hand-key into a spreadsheet, manually subtract refunds, manually reconcile against deposit records, manually fix the inevitable mismatches, then transcribe the totals into the CDTFA filing portal. Three failure modes appear consistently:

• Category mapping drift. A SKU gets reclassified mid-period (taxable to exempt or vice versa) and the spreadsheet doesn't catch the change. Filing is wrong; audit finds it 18 months later.
• Tax-on-tax errors. Fuel sales pre-2026 carried sales tax computed on a base that already included excise tax. Operators commonly mis-applied. Even with the 2026 repeal, three years of back-filings can still get re-examined under audit.
• Late filing because the spreadsheet broke. The single most common cause of late-filing penalties in our customer base. Manual processes fail.

What automated filing actually does differently

A back office that handles CDTFA filing correctly does four things:

1. Categorizes every transaction at the time of sale. Each SKU has a tax category baked in; each tender type (cash, credit, EBT) routes correctly. No spreadsheet remapping.
2. Computes effective rate by store. Per-store local district rate applied automatically. No mental math for multi-store operators.
3. Reconciles continuously, not at period-end. POS → bank → EOD reconciliation runs every day, so by filing day the totals already match.
4. Generates the filing pack with supporting transactions. One PDF per period with the filing totals and every transaction that contributed to them. If CDTFA asks a question, the answer is one query away.

Common questions auditors ask

From conversations with multiple operators who've been audited, the recurring question patterns:

• Why is your exempt-sale ratio higher than peer stations? Usually answered by EBT volume. Have the EBT data ready.
• Show me the SKU-level breakdown for [specific period]. Answered with a SKU export from your back office. If your records are spreadsheet-based, expect a multi-day scramble.
• Reconcile your reported sales against your bank deposits. Should match within $10 per period. If you can't reconcile, the auditor assumes underreporting.
• What was your category mapping policy for ambiguous SKUs (e.g., prepared food vs. groceries)? Document it once; cite the documentation when asked.

The 2026 tax-on-tax repeal, what changed and what didn't

California repealed the application of sales tax to the excise-tax component of fuel sales effective January 1, 2026. In practice, the per-gallon retail price still includes excise tax, but sales tax is now computed only on the pre-excise base. The change saves operators administrative complexity (no more tax-on-tax reconciliation) and modestly reduces customer-facing pump prices.

What didn't change: the reporting requirement, the per-category breakdown on the CDTFA filing, the audit risk profile, the deadlines. The repeal makes filing slightly less error-prone; it doesn't make filing optional.