How to Prevent Duplicate Toll Charges in a Turo Fleet

Duplicate tolls can enter a fleet workflow when the same provider file is imported twice, a transaction appears in multiple statements, a Toll-by-Plate notice repeats an earlier charge, or a corrected file is treated as entirely new. Prevention requires checks at both the transaction and reimbursement levels.

Prefer the provider's unique identifier, with a fallback composite key

When a provider supplies a stable transaction ID, combine it with the provider account to create the primary duplicate key — never assume IDs are globally unique across all accounts. When no stable ID exists, compare provider account, plate or transponder, travel date and time, toll location, and amount — marking close matches for review rather than deleting them automatically, since two legitimate crossings can share the same amount and location minutes apart.

Make imports idempotent, and check later notices

Reimporting the same file shouldn't create new transactions — store source-file identity, import date, row reference, and processing result, with a defined update or supersession rule for corrected files. Before entering a mailed invoice or violation, search existing account activity, since a notice may bundle transactions already imported.

Add a billing-level safeguard, and handle legitimate corrections

Even a single transaction record can be added to two reimbursement cases — track whether the charge has already been included, submitted, cancelled, or paid, and require an explicit reversal before rebilling. Providers may reverse, adjust, or repost transactions; preserve the original and link the correction rather than simply deleting history.

Audit suspected duplicates

Track how duplicates entered — repeated file, overlapping date range, statement-plus-notice, manual entry, provider correction, or software defect — and fix the cause, not only the rows. Kelviz can use provider identifiers and transaction attributes to make repeated records visible before they reach guest billing.