A delivery ticket says 150 gallons went out. The driver collected a check, the office ran several credit cards, and a customer paid an old balance through the portal. By the end of the day, the bank deposit does not match the tickets, and nobody is sure whether the difference is timing, a fee, a missed payment, or a real problem.
That is why knowing how to reconcile fuel payments matters. Reconciliation is not just an accounting chore for month-end. It is the daily process that confirms money collected matches the deliveries, customer balances, payment records, card processor activity, and bank deposits behind it. Done consistently, it protects cash flow and keeps small mistakes from becoming expensive write-offs.
Start with the right records
Fuel payment reconciliation only works when each side of the transaction has a clear record. On one side, you have what was delivered or billed: printed delivery tickets, electronic tickets, will-call orders, service charges, and invoices. On the other, you have what was paid: cash, checks, ACH payments, credit cards, and any payments applied to customer accounts.
The goal is not to force every number to match on the same day. Card batches may settle a day or two later. A check may be received Friday and deposited Monday. What matters is that every payment can be traced to a customer, an amount, a date, and a method of payment.
For most fuel dealers, the basic records should include the day’s completed delivery tickets, customer invoices or account charges, payment entries, the credit card batch report, deposit slips, and the bank activity. If your office uses separate paper logs, driver envelopes, a card terminal report, and accounting software, gathering these records is usually the hardest part of the process.
Reconcile fuel payments in the order they happen
The cleanest workflow follows the path of the money. Start at the customer account, move through the payment method, then confirm the deposit or settlement. Trying to start with the bank statement often creates unnecessary detective work, especially during a busy heating season.
Match payments to the customer ledger
First, review each payment posted that day. Confirm the customer name, payment amount, payment date, and payment method. Then make sure it was applied to the correct invoice or open balance.
This is where common office errors show up. A payment may be posted to the wrong customer with a similar name. A $500 check may be entered as $50. A payment intended for a past-due balance may be applied to a new delivery instead. The bank may still receive the right amount, but the wrong customer account will create collection calls and confusion later.
For COD deliveries, compare the amount collected with the ticket total. If a driver collected less because of a pricing question, a partial delivery, or an approved arrangement, note the reason immediately. An unexplained short payment should not sit on the account until someone remembers what happened three weeks later.
Tie delivery tickets to invoices and charges
Next, make sure completed tickets made it into billing. This step is easy to overlook when the dispatch board, ticket printing, and customer records live in different places.
Compare the total deliveries completed against tickets returned or electronically closed. Look for tickets that have gallons but no invoice, invoices with no completed ticket, canceled deliveries that were accidentally billed, and credit adjustments entered without a clear explanation.
Keep in mind that not every ticket should equal a payment. Budget customers, charge accounts, and automatic delivery customers may receive fuel now and pay later. The point is to confirm that the ticket was billed correctly and that any payment was applied according to the customer’s terms.
Balance cash and checks before making the deposit
Cash and checks should be counted and recorded before they are taken to the bank. If drivers return payments, use a simple handoff process: identify the driver, list each check or cash amount, and have the office verify the total. A signed driver settlement sheet can save a lot of arguments when a payment goes missing.
The deposit total should equal the sum of the cash and checks recorded for that deposit. If it does not, do not just enter a plug number to make the books balance. Check for a check held for deposit, cash used for a small purchase, a duplicate entry, or a payment that was posted but never received.
Using cash from collections to pay an expense is especially risky. Even when the expense is legitimate, it breaks the trail between customer payment, deposit, and accounting record. Deposit collections intact, then pay expenses through the normal business process.
Reconcile credit card batches, not just individual payments
Credit cards require a separate check because the amount charged to customers is usually not the amount deposited in the bank. Processing fees, refunds, chargebacks, and delayed settlements create differences that need to be recorded correctly.
At the end of the day, compare the total card payments posted to the card processor’s batch total. Then compare that batch to the settlement amount that reaches the bank. If the processor deducts fees before funding, the difference is a merchant processing expense, not an unexplained shortage.
For example, if customers paid $4,000 by card and the bank receives $3,880, the $120 difference may be card fees. Record the full $4,000 against customer accounts, record the fee as an expense, and reconcile the $3,880 deposit to the bank. Posting only $3,880 in customer payments leaves $120 incorrectly outstanding on customer balances.
Refunds and chargebacks deserve prompt attention. A refund should be tied to the original customer payment and documented with the reason. A chargeback needs follow-up before it becomes an aging balance nobody owns.
Handle timing differences without hiding them
Not every difference is an error. A deposit made after the bank cutoff may appear the next business day. Weekend card transactions may settle Monday. An ACH payment can show as received in one system before it clears the bank.
Track these items as timing differences with enough detail to clear them later. Write down the amount, date, customer or batch reference, and expected settlement date. Then review the list every day. A timing difference that has not cleared after several days is no longer just a timing difference – it needs investigation.
This is also why daily reconciliation is easier than waiting until month-end. A dispatcher, driver, or office employee can usually explain a $200 difference from yesterday. Thirty days later, the details are gone and the customer may have already been told their account is paid.
Use one system to reduce double entry
Manual reconciliation becomes harder every time information is copied from one place to another. A ticket is written by hand, then entered into dispatch software, then re-entered into a payment terminal, then entered again in accounting. Every handoff creates another chance for a number, customer, or date to be wrong.
A fuel-specific operating system can keep delivery history, customer balances, ticket information, and payment activity connected. Degree Days Online is built around the daily workflow of a fuel dealer, including payment processing and QuickBooks Online integration, so the office is not trying to stitch together unrelated tools at the end of each day.
Software does not eliminate the need to review deposits and card batches. It does make exceptions easier to find. When the ticket, payment, and customer record are in the same workflow, staff can spend less time hunting through folders and more time resolving the items that actually need attention.
Set clear ownership and a daily cutoff
One person should own the final review, even if several people collect and enter payments. In a small operation, that may be the owner or office manager. In a larger office, it may be the bookkeeper. The key is that everyone knows who checks the day’s totals and who follows up on exceptions.
Set a practical cutoff time. Drivers need a clear deadline for returning checks, cash, and paperwork. The office needs a routine for closing card batches and recording deposits. If a driver returns after the cutoff, record those collections as the next day’s activity rather than mixing them into a deposit already reconciled.
A short daily review can cover completed tickets, payments posted, cash and checks received, card batch totals, deposits made, and unresolved differences. That is enough to keep the books current without turning every afternoon into an accounting project.
When a payment does not match, treat it as a work item with an owner and a deadline. Small, documented follow-up is far better than hoping the next bank statement will somehow explain it.