How do I reconcile a fuel station's bank account?
For station managers, accountants · By the Petro team · Last reviewed
The short answer
Take the bank statement for the month and tick each line against an entry in your own books: cash deposits against the day's banking, card settlements against card sales, cheques against the payments they belong to, and payments to CPC or Lanka IOC against their invoices. Enter what is on the statement but not yet in your books, such as bank charges, interest and direct transfers from customers. What is left in your books and not on the statement should be explainable, usually cheques not yet cleared and deposits made on the last day. When those items explain the whole difference, the account is reconciled.
Why is a fuel station's bank harder to reconcile than most?
Volume and timing. A station banks cash every day or more than once a day, receives card settlements a day or two after the sale, often net of the bank's commission, takes cheques from credit customers, and makes large payments to its fuel supplier, sometimes several a week. Each of these reaches the statement on a different day from the day it is in the books, and some arrive as a single combined line covering several sales.
The aim of a reconciliation is not that the two balances are equal on a given day, because they rarely are. It is that every difference between them is a known, listed item that will clear.
What do I need before I start?
- The bank statement for the whole month, ideally as a spreadsheet file from online banking so it can be sorted and matched.
- Your books for the bank account for the same period, with every banking, card settlement, cheque, supplier payment and expense entered.
- Last month's reconciliation, with its list of uncleared items.
- The card terminal settlement reports, and the cheque register.
What are the steps?
- Start from last month's list. Tick off last month's uncleared cheques and deposits as they appear on this month's statement. Anything still not there after a few weeks needs following up.
- Cash deposits. Match each deposit on the statement to the banking recorded for that shift or day. A deposit that is short of the amount in the books is a cash difference to investigate the same day, not at month end.
- Card settlements. Match each settlement to the card sales of the day or days it covers. If the bank deducts its commission before paying, the settlement is less than the sales: record the commission as a bank charge so the card sales account clears to zero.
- Cheques received. Match each cheque deposit, and record any cheque returned unpaid as a reversal of the customer's payment, with the bank's charge for it.
- Payments out. Match supplier payments, salary payments and other transfers to the entries that recorded them.
- Statement-only items. Enter bank charges, interest, standing orders and transfers customers made straight into the account, each against the right account or customer.
- Agree the balance. Start from the statement's closing balance, add deposits in your books not yet on the statement, subtract payments in your books not yet on the statement. The result should equal your book balance.
What if it does not agree?
Work through the usual causes in order before looking for anything unusual:
- An entry posted to the wrong bank account, when the station has more than one.
- A deposit or payment entered twice, or entered with two figures swapped. A difference that divides exactly by nine often points to swapped digits.
- A card settlement recorded at the gross sales figure when the bank paid it net of commission.
- A returned cheque not reversed in the books.
- An entry dated in the wrong month.
Never post a balancing figure to make the two agree. A difference you cannot explain yet goes on the list of open items with a note, and stays there until it is found.
How often should I do it?
Every month without fail, and for a busy station, more often. Checking cash deposits and card settlements every day or every week takes a few minutes and finds a short banking while the people involved still remember the day. Many banks let you download the statement as often as you like, and once your matching is set up, the month-end reconciliation becomes a check of the few items that are left.
Frequently asked questions
- Should each card terminal settle into its own account?
- Not necessarily, but it helps if each terminal's settlement can be told apart on the statement, for example by a terminal number in the description. That lets you match each settlement to the right day's card sales without guessing.
- What do I do with a deposit I cannot identify?
- Record it in a suspense account for unidentified receipts and ask the bank for the depositor's details. It is usually a credit customer who paid by transfer. Move it to the customer once you know who it was.
- How long can a cheque stay on the uncleared list?
- A cheque you issued that has not been presented after several weeks should be followed up with the payee. A cheque you deposited that has not cleared within a few working days needs a call to the bank. Old items left on the list hide new problems.
How Petro handles this
In Petro you upload the bank statement as the CSV or Excel file the bank gives you, and bank rules you set up fill in the lines they recognise, such as bank charges, cash deposits and card settlements, for one-click approval or automatic reconciliation. The rest are reconciled by hand against an entry already in the books, as a new entry, or as a transfer between your own accounts. The Bank Reconciliation Tool then shows the book balance, statement balance and gap, and Unreconciled Book Entries lists what is still open.
See banking in PetroThis 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.
