Cardlock Tools
1:06A settlement file from any network, totalled by site, by product and by network — and why the site totals are the ones the local schedule needs.
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 are the five that 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.
Statement Summary
1:07The four businesses inside one ten-day statement, and the four places they land on the return. Collected and paid are never netted.
Schedule A and B
0:57Prepaid tax by counterparty, both directions — and whether the month agrees with the three statements that make it up.
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
1:19A whole quarter at once. One folder in, every document checked against the others, one workbook out with the differences named and dated.
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.
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. Several of them now carry a second, shorter video on the tool’s own page — a tour of the workbook that tool actually produces.
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.