A defensible fleet-card reconciliation explains how the statement, original receipts and finance ledger reach their totals. Set the statement period and accounting basis first, then match each transaction and assign an owner to every remaining difference.
Start with three source records
- Download the statement and transaction export for the same account, currency and statement period from your card provider. Save the PDF statement and original export together.
- Collect merchant receipts and credit notes. Keep document references so a reviewer can locate the evidence behind a working row.
- Export the matching ledger entries, including reversals and journals posted near month-end. Keep the ledger document number and posting date.
WesBank, FNB, Standard Bank and Absa exports can use different labels. Map the columns in the file you actually received to account reference, card reference, transaction ID, transaction time, posting date, merchant, product, litres and signed amount. Record any field the export omits. Keep the original values alongside the working fields.
Reconcile the statement and then match vehicles
Use the statement's sign convention. In a simple debit-positive statement, opening balance + debits − credits − payments should equal the closing balance. Compare the export's debit and credit subtotals with the relevant statement sections before investigating an individual card. An omitted export page or an incorrectly signed credit will affect the fleet total.
Make a dated card-to-vehicle table. Keep both the masked card reference and the fleet ID. For a shared card, trace the receipt or dispatch record to identify the vehicle for that purchase. Keep fuel and other purchases in separate product groups, because one card can carry several types of spend.
Match transaction rows with a clear evidence order
- Match the transaction ID or authorisation reference first. Retain the matching source row and ledger reference.
- Where the reference is missing, compare card, merchant, transaction date and amount. Give any group with multiple possible matches a manual review.
- Link credits and reversals to their original charges. Record both entries, the reason for reversal and the net signed amount.
- Use transaction time for fleet activity and each source's posting date for finance cut-offs. Match the amount on the same gross or net basis on both sides.
Worked month-end example with a R320 gap
In this example, the fleet-card statement shows R12,140 in matched debits and the October ledger shows R11,820. The R320 difference goes onto the exception sheet. The matching receipt is dated 31 October, the card statement includes it, and finance's matching ledger document is dated 2 November. The reviewer records the three references and marks the item as a timing difference to be picked up in November's opening reconciliation.
If the November document carries a different reference or amount, keep the item open until the match is confirmed. The same R320 gap can result from an omitted receipt, a duplicate allocation or a timing difference. The evidence determines which explanation belongs in the workbook.
Build a close checklist in Excel
Use one table called CardRows for the normalised data and columns for Card, StatementMonth, Amount, LedgerRef and MatchStatus. With the account's month in B1 and the card reference in A2, =SUMIFS(CardRows[Amount],CardRows[Card],A2,CardRows[StatementMonth],$B$1) gives the signed card subtotal. Compare it with the statement subtotal before allocating spend to an asset. Use a pivot by MatchStatus to expose unmatched values and link their supporting rows.
The period is ready for sign-off when the statement ties, the matched ledger movement is explained and each open item has an owner and a review date. Keep a copy of the evidence and the exception register with the signed working file. The month-end workflow sets out the close sequence, and the sample Fleet Exception Review shows how to present an unresolved item to finance.