Skip to content
Petro

How do I reconcile card machine settlements with the day's card sales?

For accountants, station managers · By the Petro team · Last reviewed

The short answer

Compare three figures for each day and each card machine: the card sales your shifts recorded, the machine's settlement or batch total, and the amount the bank credited. The machine total should match the shift records exactly. The bank credit is usually lower because the bank deducts its commission, and it often arrives a day or more later, so match each credit to the batch it pays, not to the calendar day.

Why don't the card sales and the bank credit match?

A card sale passes through three records before it is money in your account. The pumper records it on the shift. The card machine records it in its batch, which is closed when the machine is settled. The bank then pays the batch into your account, less its commission (the merchant discount), usually on the next working day or later.

Differences come from timing (a batch settled after midnight, or credits held over a weekend or holiday), from the commission, and from mistakes: a slip recorded twice, a declined transaction recorded as paid, a sale on one machine recorded against another, or a refund or void that was not recorded.

How do I match them, step by step?

  1. Settle each card machine at the same time every day, and keep the settlement printout with that day's shift records.
  2. Add up the card slips recorded on the day's shifts for each machine, and compare the total with the machine's settlement. These two should agree exactly.
  3. If they do not, compare slip by slip: look for duplicates, declined or voided transactions, and slips filed under the wrong machine or day.
  4. When the bank statement arrives, find the credit for each batch. Banks usually show the terminal or merchant number and a batch or settlement reference in the description.
  5. Check the difference between the batch total and the credit against the commission rate in your agreement with the bank.
  6. Record the commission as a bank charge, and mark the batch as settled.
  7. List any batch not yet credited and follow it up with the bank after a few working days.

What should I check when a credit is short or missing?

  • Whether the batch was actually settled. An unsettled machine holds the transactions until it is.
  • Whether the bank combined two batches into one credit, or split one batch into several.
  • Whether a customer disputed a transaction (a chargeback), in which case the bank deducts it later with its own notice.
  • Whether the commission charged is the rate in your agreement. Rates can differ by card type, and an unexpected rate is worth raising with the bank.
  • Whether the credit went to a different account from the one you expected, for example after a change of bank account.

How often should card settlements be reconciled?

Match the shifts against the machine every day, as part of closing the day. Match the machine against the bank as each statement arrives, at least weekly, and agree the whole month as part of your bank reconciliation. A missing credit found within a week is easy to chase. One found at the end of the year is much harder.

How should card sales be recorded so this is easier?

  • Record each card slip as its own payment, with the machine or card type, not as one total for the shift.
  • Keep a separate payment method or account for each card machine or bank, so each one can be reconciled on its own.
  • Record the commission when the credit arrives, so the gross card sales stay in your sales figures and the commission shows as a cost.
  • Keep the settlement printouts for the period your auditor or the bank may ask for them.

Frequently asked questions

Should card sales be recorded net of the bank's commission?
No. Record the full sale, because that is what the customer paid for the fuel. Record the commission separately as a bank charge when the bank deducts it, so you can see what card payments cost you.
Why does a card sale from Saturday arrive on Tuesday?
Banks generally credit settlements on working days, so a weekend or public holiday delays the credit. Match each credit to its batch reference rather than to the date it arrived.
What if a pumper accepted a card that was later declined?
The sale has not been paid, so it should not be recorded as a card payment. Treat the amount as still owed by the customer or, if the pumper let the customer go without payment, follow your station's agreed rule for shortages.

How Petro handles this

In Petro each card slip a pumper hands in is recorded as its own payment against the shift invoice, with its card mode of payment, and each mode of payment posts to its own account. The Mode of Payment Report shows money received by cash, card and other modes for reconciling card and bank settlements, and bank rules can match card settlement lines on an uploaded bank statement to the entries already in the books.

See payments and finance in Petro

This guide is general information for Sri Lankan fuel stations, written by the Petro team. Figures in examples are made up. For a decision about your own tax or legal position, check with your accountant or the authority named in the sources.

See Petro running on your own numbers.

Tell us how many pumps you run and how you close the day today. We come back with a walkthrough built around your station, not a generic demo tenant.

30 days free · No card needed · A guided demo · Keep everything you enter · Cancel anytime, no charge

No obligation. We reply within one working day.