WRK Fuels home
WRK Fuels home

Back-office reconciliation

The daily close: a reconciliation routine that actually holds

Shift reports, card settlements, deposits and fuel volumes all have to agree. Here is a routine that finds problems the day they happen, not at month end.

Published · 6 minute read

Most back-office problems are not mysteries. They are small differences that nobody looked at on the day they happened, and that became expensive by the time anyone did. A daily close routine is how you stop that.

What has to agree, every day

At the end of each business day, four sets of numbers should tell the same story:

  • The POS. What the registers and pumps say was sold, by tender type: cash, card, fleet, lottery, and any house accounts.
  • The cash. What was actually counted in each drawer and dropped in the safe, shift by shift.
  • The card processor. What your processor says it settled for that day, before fees.
  • The fuel. Gallons dispensed by product against what the tank monitor says left each tank.

When all four agree, you are done in minutes. When they do not, the difference is your to-do list.

A routine you can actually keep

1. Close each shift, not just the day. An over or short is easiest to explain when it belongs to one person and one eight-hour window. A day-level difference with three shifts in it is a guessing game.

2. Match card settlements to the day they belong to. Processors batch and settle on their own schedule. Keep a simple record of which batch covers which business date, so a weekend does not look like a shortage on Monday.

3. Match deposits to expected cash. Expected deposit is cash sales minus paid-outs and any change fund adjustments. Write down the deposit slip amount and the date it cleared. If it has not cleared in two business days, find out why.

4. Check fuel book against physical. Gallons sold should roughly match the drop in tank inventory, after deliveries. Small daily variances are normal from temperature and meter tolerance. A variance that keeps leaning one way is not normal and is worth a closer look.

5. Write down every difference, even the ones you explain. A short note such as "Shift 2 short 4.10, drawer recount found it" builds a record. Patterns show up in the notes long before they show up in the P&L.

Where it usually breaks

  • Paid-outs that never get a receipt. Cash leaves the drawer for a vendor or a repair and nobody records it. The drawer looks short, and the expense never reaches the books.
  • Lottery settlements on a different calendar. Lottery has its own weekly cycle. If you mix it into daily cash without tracking it separately, every week looks wrong.
  • Voids and no-sales nobody reviews. Most are innocent. A cluster on one shift is a question worth asking.
  • Card fees netted out of deposits. If your processor deducts fees before depositing, the deposit will never match gross card sales. Track gross, fees and net separately.

Getting help with it

The routine above works on paper, in a spreadsheet, or in a back-office system. What matters is that it happens every day and that differences get written down. If it keeps slipping because nobody has the time, that is exactly the work our Back-Office Management service takes on, using the WRK Fuels portal so you can see it done.

General guidance from operating experience. It is not legal, tax or accounting advice.