Fare Collection Reporting — 20+ Ready Reports, No Spreadsheets
Last updated: 08.08.2026 · Technical content: SoleAkbil Engineering Team
Fare collection reporting is the layer that turns public transport revenue data into something you can present to a council, an auditor or your accountant. The Sole Akbil panel ships with more than 20 ready-made reports; all of them can be filtered by branch, run over any date range, exported to Excel/PDF, and several can be scheduled for automatic email delivery.
Why a Ready-Made Report Set?
The real value of a fare collection system is less about reading cards and more about being able to account for the money collected. Council presentations, external and internal audit, accounting reconciliation, revenue breakdowns for cooperative members — each of these wants the data in a different shape.
Instead of exporting raw data and building spreadsheets, Sole Akbil provides a separate, ready report for each of these needs. Open the report, pick the dates, print.
Features Common to Every Report
- Branch-level filtering — in multi-branch or multi-route operations each unit sees its own data.
- 1 / 7 / 30 days or a custom date range — switch periods in one click.
- Print / PDF / Excel export — output you can hand straight to accounting or audit.
- Built-in Help text for every report — what the report shows is documented inside the panel, reducing training overhead.
- Automated email scheduling — selected reports are sent periodically to defined addresses over SMTP.
Report Catalogue
| # | Report | What it is for |
|---|---|---|
| 1 | Total Revenue Report | Total money loaded per day and bank reconciliation |
| 2 | Taps Report | Breakdown of all card / phone NFC / QR taps |
| 3 | Usage Revenue Report | Revenue broken down by device and card type |
| 4 | Card Transaction Report | All transaction types in a single ledger view |
| 5 | Driver Activity Report | Shift hours and failed PIN attempts |
| 6 | Daily Refund Report | All refund transactions |
| 7 | Top-up Z Report | Official cash-register style, permanent/frozen, uniquely numbered end-of-day report |
| 8 | Failed Transactions | Rejected taps and top-ups across 12 distinct rejection reasons |
| 9 | QR Status Report | Usage status of QR tickets |
| 10 | Offline Transaction Anomalies | Inconsistencies detected during sync |
| 11 | Clone Suspicion Report (R16) | Same card used on different devices within 120 seconds — cloned card detection |
| 12 | Credit Card Tap Report | Breakdown of taps made with an EMV Credit Card |
| 13 | Top-up Sales Report | Channel-based (physical / NFC / QR) top-up analysis |
| 14 | Card Sales Fee Report | Card fee revenue that is not loaded onto the card |
| 15 | Device Tracking Report | Live status of every device in the fleet |
| 16 | User Activity Report | Who changed what in the panel — audit trail |
| 17 | Taps by Vehicle Plate Report | Per-vehicle, day-by-day tap and revenue analysis broken down by card type |
| 18 | Family Social Card Usage Report | Monthly usage limit audit |
| 19 | Blue Card Usage Report | Monthly pass / ride-credit usage tracking |
| 20 | Limited Ticket Usage Report | Package-based ride-credit tracking |
| 21 | Special Day Discounts Report | Birthday / holiday discount breakdown and total amount |
| 22 | Email Delivery Report | Delivery audit of automatically sent report emails |
Why You Can Trust the Figures
In Sole Akbil every revenue record rests on an immutable transaction ledger. Behind each figure in a report there are individual, traceable transactions; deleting or editing a record after the fact is not possible.
On top of that, the Top-up Z Report works like an official cash register: it is taken at end of day, carries a unique number and is frozen — it cannot be altered afterwards. That closes reconciliation and audit to manipulation.
Fraud and Leakage Tracking
The reports answer not only "how much did we earn" but also "where might we be losing money":
- Clone Suspicion (R16) — automatically catches suspected copied cards.
- Offline Transaction Anomalies — lists inconsistencies after offline operation.
- Failed Transactions — 12 distinct rejection reasons point to the root cause.
- User Activity Report — an audit trail of every change made in the panel.
- Driver Activity Report — shift discipline and failed PIN attempts.
Which Report for Whom?
| Municipality / council presentation | Total Revenue, Taps, Special Day Discounts, Family Social Card, Taps by Plate |
|---|---|
| Accounting / reconciliation | Top-up Z Report, Total Revenue, Credit Card Taps, Card Sales Fee, Daily Refunds |
| Internal audit / security | Clone Suspicion (R16), Offline Anomalies, Failed Transactions, User Activity |
| Cooperative / route operator | Taps by Plate, Driver Activity, Usage Revenue, Top-up Sales |
| Operations / technical | Device Tracking, QR Status, Email Delivery |
The number and content of reports reflect the current release of the Sole Akbil panel; organisation-specific report additions are evaluated within project scope.
Related pages: Sole Akbil Management Panel, what is an AFC system?, public transport system for municipalities.
Frequently Asked Questions
How many different reports are there?
The Sole Akbil panel includes more than 20 ready-made reports (22 in the current catalogue). All of them can be filtered by branch, run over 1/7/30 days or a custom date range, and exported via Print/PDF/Excel.
Can I export the reports to Excel?
Yes. Every report supports Print, PDF and Excel output, in a format you can hand directly to accounting or audit.
Can reports be emailed automatically?
Yes. Selected reports can be scheduled for automatic email delivery over an SMTP integration. Delivery status is separately tracked in the Email Delivery Report.
Why is the Top-up Z Report particularly important?
The Top-up Z Report works like an official cash register: it is taken at end of day, carries a unique number and is frozen — it cannot be altered afterwards. That makes it usable as a reference document in reconciliation and audit.
How is cloned card detection reported?
The Clone Suspicion Report (R16) automatically catches physically impossible cases, such as the same card being used on different devices within 120 seconds, and presents them in a dedicated list.
Can I see who changed what in the panel?
Yes. The User Activity Report keeps an audit trail of changes made in the panel, for corporate internal control and audit requirements.
See the Report Set With Your Own Data
Let's walk through the reports your organisation needs in a demo environment.