Statement Summary
3:16The four businesses inside one ten-day statement taken one at a time, the four places they land on the return, and the two amounts that have to come out and be accrued. The Period Report’s job, done on a single period.
Videos
Short explainers, no sign-in needed
What the cardlock system actually is, what each of the tools does with it, and how the sales tax, excise and carbon tools fit around it.
The hardest thing you have to account for
One cardlock statement is four different businesses printed one after the other, landing in four different places on your return. How we break it down, calculate it, and turn it into accounting entries.
Tool by tool
The cardlock tools
These read what CFN and Pacific Pride send you every month. Each video says what the tool reads, what it gives you back, and the one thing people get wrong.
Schedule A and B
3:36Where the schedules actually come from — A and B pulled separately off the network’s site once a month, against three ten-day statements on a different clock. They do not always agree, so the video is clear about which one the return is built on, and what the difference is actually for.
Full Statement
0:44Three hundred pages of individual transactions into a workbook and a database table you can set against your nightly files.
Period Report
3:13Every source for the period in one place — the statements, the PT files, Schedule A and Schedule B, and the journals out of your own general ledger — all compared against each other, and one workbook out to go with the monthly or quarterly return.
The other half of the quarter
The sales tax tools
The cardlock tools tell you what came off the racks. These six take that and turn it into a California return that ties — the return itself, both allocation schedules, and the three tools that end at CDTFA’s own workbooks.
The sales tax tools
4:29One taxable figure and the three places it has to agree, the partial exemption trap that breaks both schedules at once, and the three tools that fill CDTFA’s own templates — district rates, the district tax upload and the monthly pre-tax upload.
What you actually get back
The workbooks, sheet by sheet
Every one of these tools ends in a file, and the question people ask first is what is in it. Each of these tours a real workbook — the one the tool produced when we ran it, not a drawing of one. They are on each tool’s own page too, but those need a sign-in. These do not.
The return workbook
2:43Three sheets. The form down to net tax, the partial exemptions that are taxed in full and then credited back, and the two reconciliation rows at the bottom that say whether the schedules still tie.
The Local Allocation sheet
1:19Every place of sale with its county, its taxable amount, the local tax that produces and its share of the quarter — then the three rows that prove the parts sum to the whole.
The District Allocation sheet
1:21The same taxable figure cut by district, each at its own rate — including the districts at zero, which still have to be on it or the sheet will not tie.
The rate table download
1:30Four hundred and eighty-eight rows with the dates each rate runs between, the working columns the office fills in, and why a district you know appears on it twice.
CDTFA’s workbook, filled
1:53Not our workbook at all — their Schedule A template with your district sales written into it. Which rows were filled, and the one cell to check before you upload it.
A different tax, and a different problem
Excise and carbon
Sales tax is a percentage of a price. Excise tax is cents on a gallon, paid at the rack long before anyone knows who will burn the fuel — and carbon is a report your customers have to file out of data only you hold.
Excise and carbon
4:11Who may claim excise tax back and on which form, the registered ultimate vendor claim and the two checks that sink one, the new section 6435 claim on fuel you later dyed, and the carbon report — with customer names left out if you want them left out.
Every tool on the site is on the Online Tools page. The workbook tours above are repeated on each tool’s own page, under the heading, for anyone already signed in and working.
Bring us a quarter and we will run it.
A folder of statements, the monthly schedules and a few nightly files. We will show you what your quarter actually says — and whether there is overpaid tax sitting in it.