Fare Box Reconciliation Audit

This template covers a single audit period for fixed-route transit revenue and walks through the full reconciliation path: farebox-recorded revenue, probe data, vault count data, and the related bank deposit. It also captures chain of custody, unresolved timing differences, exception handling, and final sign-off. Use it when you need a documented revenue accountability check rather than a simple cash count. It is designed to show where the numbers came from and why they do or do not match.

Use it on the deposit and collection dates selected for the audit period, or on a recurring schedule set by your transit finance or compliance team. It is especially useful after collection runs, at month-end close, or when a variance needs investigation. If your operation has high cash volume or multiple collection units, a regular cadence helps identify repeat issues early. The template works best when the audit period is clearly bounded and source records are complete.

A finance auditor, revenue analyst, transit accounting lead, or other authorized reviewer should complete it, ideally someone independent from the collection process. The person running the audit should be able to review source documents, compare totals, and document exceptions without having to guess at missing data. If your organization uses segregation of duties, the collector, vault counter, and depositor should not be the same person. The sign-off section is meant to capture accountability, not just completion.

Yes, it supports internal control and audit documentation practices commonly used in public transit revenue operations. It aligns with the kind of evidence trail expected under general financial controls, chain-of-custody procedures, and documented exception management. If your agency is subject to public-sector audit rules, grant conditions, or internal control policies, this template helps standardize the record. It is not a legal opinion, so you should map it to your own finance and transit governance requirements.

The most common issues are missing source documents, unclear deposit timing, and unexplained differences between farebox, probe, vault, and bank totals. Another frequent problem is documenting a variance without identifying whether it came from collection, counting, posting, or deposit timing. Teams also sometimes skip chain-of-custody details, which makes later review difficult. This template is built to force those details into the record before the audit is closed.

Yes, and you should. Different transit systems may use different tolerance thresholds, route groupings, deposit timing rules, or exception categories such as equipment error, counting error, posting delay, or missing support. The template is meant to be adapted to your local controls and revenue process. Keep the structure intact so you still capture the same core evidence, even if the labels change.

A spreadsheet can calculate totals, but it often does not force the reviewer to document source completeness, chain of custody, exception ownership, and follow-up. This template turns the reconciliation into a repeatable audit record instead of a one-off calculation. That makes it easier to review trends, assign corrective actions, and support later questions from finance or oversight teams. It is better suited for controlled review than an ad-hoc worksheet.

Attach the deposit support documents, probe reports, vault count records, and any source documents needed to explain the audit period. If there is a variance, include the evidence that supports the root cause and any follow-up notes. The goal is to make the audit self-contained so a reviewer can trace the numbers without searching elsewhere. If your organization uses scanned receipts or system exports, include those as supporting files.