From your register to QuickBooks Online
Every gas station POS or back office has to get its daily totals into QuickBooks Online somehow. Some stores type them in, some import a file and some use a connecting app. This page explains the three routes, what each one needs checking, and how to know the books agree with the bank. We do not sell any of the systems.
Works with your POS, back-office & accounting stack
Your register or back office totals the day, and those totals are entered by hand, imported from a file or sent by a connecting app, depending on your setup. Whichever route you use, each total must land in the right account, be posted once, and be checked against the bank.
By the FuelCFO team. Where this page describes a vendor's product, the details come from the vendor's own public descriptions and can change, so confirm them with the vendor. Figures in diagrams are illustrative.
QuickBooks Online does not run your register and does not know what you sold. It only knows what is put into it. How your totals get there is what people usually mean by a QuickBooks integration, and it differs from store to store. We work from the reports your system already produces and your QuickBooks file, we do not set up or change the connection, and we are not part of QuickBooks, Intuit or any POS vendor. Confirm what your own setup can do with your vendor.
The simplest route is someone reading the daily report and entering the totals. It needs no extra software, but it depends on one person doing it every day. A missed day or a mistyped figure goes straight into the books, so this route needs a regular check against the bank.
Many systems can export a report that QuickBooks can load in a batch. It is faster than typing and keeps each load in one place. The risks are a file loaded twice, a file that maps a department to the wrong account, and a month that was never loaded at all.
Some stores use an app that moves totals across automatically. This saves time, but it can fail quietly. If a day does not arrive, or a department lands in the wrong account, nobody sees an error. The books are simply wrong until someone compares them with the bank.
None of the three records card fees, matches deposits to settlements, or decides how lottery and sales tax should be treated. Those are decisions about the books, and they are the part a bookkeeper owns. A smooth connection with the wrong mapping is still wrong, only faster.
Mapping means deciding which QuickBooks account each department, tender and fee goes to. Fuel, store sales, lottery and sales tax each need their own place. A good map is written down, so a new employee or a new accountant can follow it, and a change in your system does not quietly change your books.
To see the three routes side by side, go to the route table. To see where each one fails, go to where it goes wrong. For a worked example of one day travelling through a register, a back office and QuickBooks, read the integration walk-through. To set up or repair a sync, see how to sync PDI, how to sync Modisoft, PDI sync not working and Modisoft sync not working. If you want a team to own it, what we do covers the service.
Each department, tender and fee gets a named QuickBooks account, written down in plain words.
We count the days posted against the days your system closed.
Deposits and card settlements are matched to what was posted, and each gap gets a reason.
Card fees, lottery, sales tax and chargebacks are recorded in the books.
If a report name or a department changes, we update the map and note it.
We ask how totals reach QuickBooks today: by hand, by file or through an app.
The check we run depends on the route. A hand-entered store needs a close look at missed days and typing. An app-connected store needs a close look at silent failures.
You do not need to change anything. We work with the route you already use.
Every business day is checked against what was posted.
A day posted twice inflates income by that day's sales. A day missing leaves a hole of the same size. This count is quick and explains more mismatches than any other test.
Missing days are listed the same week, while there is still time to find the report.
Each department and tender is followed to its account.
We check that sales tax and lottery sit in liability accounts and are not counted as income, and that fuel and store sales are separate.
A department that has moved to a different account since last month is flagged.
Deposits, card settlements and fees are tied to what was posted.
Timing is separated from real differences, so a sale made on the 31st and paid on the 2nd is not mistaken for a shortage.
Fees taken before a deposit are recorded as expense, not left as an unexplained gap.
You get the closed books and a short note on what we found.
The note lists anything we could not place and any change we made to the map. If your route is causing repeat problems, we say so.
Your CPA can be copied on the same package.
What your system can do depends on your vendor and plan. Ask them which routes yours supports.
A file is loaded again or an entry repeated, and income is overstated.
A connection drops or a day is skipped, and nobody sees an error.
A department or tender is mapped to the wrong place, so a line looks too high or too low.
Sales tax and lottery are counted as sales.
Card processing fees leave the bank and no expense is booked.
A report or department is renamed and the map quietly breaks.
A deposit that lands in the next month looks like a shortage.
You want to know what is worth automating and what is worth checking.
You want to know how to tell if it is quietly failing.
You want the books to carry on without a gap.
You want to find which step is losing money.
Not sure which route you use? Tell us who does the books and we will work it out from your QuickBooks file.
A 30-minute call and about 48 hours of review, free, to see which route you use and where it leaks.
We agree where each department, tender and fee should land and put it in writing.
The first month ties every day to the bank before we carry on monthly.
Fuel totals mapped separately and matched to supplier invoices and deposits.
5 services →Store departments and lottery posted to their own accounts, whichever route brings them in.
9 services →Sales tax and pass-through money held as liabilities, not income.
4 services →Several stores mapped the same way, and the books kept steady through a system change.
3 services →FAQ
More guides on the same system, or send us a day or a month for a free review.
The usual causes when PDI and QuickBooks Online disagree, how to find the gap, and how we reconcile the two.
Read more →The usual causes, a test order to find the gap, and how the books are repaired.
Read more →The usual causes, a test order to find the gap, and how the books are repaired.
Read more →Send us a day or a month and we'll show you where the three systems disagree.
Get started →See all QuickBooks integration guides →| Every gas station software guide →
FinTruction · Construction Clients
Real US-based contractors. Same team, same operational discipline that we now bring to gas stations. Construction is a different vertical - but the muscle (multi-stream books, cost reconciliation, niche specialization) is the same one stations need.
"They didn't just record transactions and call it a day. They built a custom chart of accounts around how a remodeling company actually runs, did a full catch-up on years of bookkeeping inside QuickBooks Online, and now stay on top of my monthly bookkeeping and payroll."
Oniel Campbell
"Sahil and his team have been handling the bookkeeping and job costing for my painting business. They've done a great job cleaning up my books, using integrations to give me accurate, timely job costing and solid weekly data. Reliable, and the team is very detailed."
Dalton Mayberry
"They rebuilt the whole thing from the ground up, with real job costing, WIP, and retainage."
Carl Moore
Owner, Hearth & Haus
"They set the accounts up properly first, then cleaned up everything I never entered."
Rolian
"When I came to them I had no financial structure in place at all. No job costing, no WIP tracking, books were behind, no real way to tell if any job was actually making money. They came in, did a full cleanup, and set up job costing and WIP tracking inside QuickBooks."
Clay PearsonBook a Free Books Review
Book a free books review. We'll look at your setup, show you what's missing, and tell you exactly how we'd fix it. No pressure, no obligation.
Prefer to skip the form?
Tell us where to send it - we'll email it straight over.
Ask FuelCFO
Gas station & c-store accounting questions, answered.