How do I reconcile my account with CPC or Lanka IOC?
For station managers, accountants · By the Petro team · Last reviewed
The short answer
Get the supplier's statement of your account for the period and set it beside your own supplier ledger. Tick off each invoice against a delivery you received and recorded, each payment against the supplier's receipt of it, and each credit or debit note on both sides. What is left will be timing (a payment the supplier has not yet applied, a delivery invoiced late), a quantity or price difference on a load, or a mistake on one side. List each one, agree it with the supplier's dealer accounts office, and correct whichever side is wrong.
Why reconcile with the supplier at all?
Your fuel supplier is usually your largest creditor and your largest cost. A load invoiced twice, a payment applied to the wrong dealer code, or a credit note never received can be worth more than a month's profit. Many stations pay in advance or against a credit limit, so an unagreed balance can also mean an order is held back when you need fuel.
Agreeing the balance every month keeps the differences small and recent, while the delivery notes and bank records are still at hand.
What do I need?
- The supplier's statement of account for the month, or an extract of your account from the supplier's dealer portal if you have one.
- Your own supplier ledger for the same dates.
- The delivery notes and invoices for every load, with the dip before and after each delivery.
- The bank statement showing each payment to the supplier, and the supplier's receipts.
- Any credit or debit notes, and correspondence about loads that were short or wrong.
What are the steps?
- Agree the opening balance. Start from last month's agreed figure. If last month was never agreed, go back to the last month that was.
- Invoices. Tick each invoice on the statement against your ledger, by invoice number, date, product, litres and value. Check each against the delivery you actually received into the tank.
- Payments. Tick each payment on the statement against your ledger and the bank statement. Note any payment you made that the supplier has not yet shown, and the date it left your bank.
- Credit and debit notes. Tick these on both sides. A credit note the supplier shows but you have not recorded is income you are missing; one you recorded but the supplier has not issued is not yet yours.
- List what is left. Each remaining item goes on a list with its date, value and the reason: timing, quantity, price, duplicate or unknown.
- Agree and correct. Send the list to the supplier's dealer accounts contact. Correct your own books for your mistakes, and get a credit or debit note for theirs.
What causes differences most often?
- Timing. Payments made at month end, and deliveries invoiced on a different day from the day they arrived.
- Short or over deliveries. The invoice shows the loaded quantity, but the tank received less. Record what was received, and raise it with the supplier with the dip records as evidence.
- Price on the invoice. A load invoiced at the price before or after a revision, when it was loaded on the other side of it.
- Payments against the wrong account. A deposit made without the dealer code or reference, applied to another dealer or left unapplied.
- Duplicates. The same invoice entered twice in your books, or issued twice by the supplier.
How do I make next month easier?
Enter every delivery the day it arrives, with the supplier's invoice number, and pay against named invoices rather than in round sums. Always quote your dealer code and the invoice numbers when you pay. Keep the dip before and after each delivery with its delivery note, so a short load can be proved. And agree the balance with the supplier in the first week of every month, not only when a problem appears.
Frequently asked questions
- The supplier says I owe more than my books show. Who is right?
- Neither, until the difference is listed and explained. Most differences are timing and clear on their own. Pay what both sides agree is due, and settle the rest item by item with evidence.
- How do I prove a short delivery?
- With the dip taken before unloading, the dip taken after it had settled, the tank's calibration chart and the delivery note, signed by the person who received the load. Raise it with the supplier at once; a claim raised weeks later is much harder to settle.
- Should advance payments sit in the supplier's account?
- Yes. An advance paid before a load is invoiced is a debit balance on the supplier's account until the invoice arrives and the payment is matched to it. Do not record it as a purchase.
How Petro handles this
In Petro, supplier invoices show their outstanding amount and status, payments are made against named invoices one at a time or spread across the oldest invoices with Supplier Payments Bulk, and returns come off what you owe on the original invoice. Payment Reconciliation matches unallocated supplier payments to invoices, and the Supplier Ledger Summary and Accounts Payable reports give each supplier's opening balance, invoices, payments and closing balance to compare with the supplier's statement.
See purchasing 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.
