Petrol station shift cash reconciliation sheet
Expected cash starts with the opening float, adds cash received and subtracts cash paid out. Compare it with the physical cash count. Credit, card and mobile money sales are not cash in the till.
Download the blank worksheet (HTML, printable to PDF) ↓Check your figures
Example values are prefilled. Replace them with yours. Use a decimal point or comma, without thousands separators. Calculations stay in this browser; entered values are not saved.
Formula and worked example
Expected cash = float + cash sales + cash debt receipts − cash expenses − remittances
In NGN: 25,000 + 350,000 + 15,000 − 10,000 − 300,000 = 80,000 expected. Counting 79,500 leaves a −500 NGN variance. Keep separate evidence for the remittances.
How to use the worksheet
- Identify the shift, responsible staff and one currency. Count and sign for the opening float.
- Separate cash, card, mobile money and credit. Count each receipt only once.
- Collect evidence for expenses, refunds, credit repayments and transfers to the safe or bank.
- Count cash by denomination, calculate variance, record its explanation and sign the handover. Reconcile electronic payments separately against confirmed transactions.
The original FuelOps worksheet is free to download, print and adapt for your internal business use. Open the HTML file in a browser and choose Print or Save as PDF. It is a blank manual record, not a spreadsheet with formulas.
Scope and limits
This model covers cash movements for one shift in one currency, without foreign exchange or tax calculations. Use amounts already rounded for your currency. A variance needs review; it is not an automatic salary deduction. This internal worksheet is not a tax invoice or fiscal receipt.
Practical questions
Can I use this in Nigeria, Mali or Côte d’Ivoire?
Record the currency, for example NGN or XOF, and use one sheet per currency and shift. The arithmetic is country-independent. Supporting documents and fiscal requirements remain specific to your organisation and jurisdiction.
Where should mobile money go?
Reconcile it separately using transaction references. An electronic payment becomes physical cash only when an actual cash movement takes place, documented once.
Keep the workflow in FuelOps
FuelOps connects shifts, receipts, expenses and cash handovers, preserving responsibility and approval records.
See the related workflow →Compare offers and contact us →Read the complete shift closing guide →