ATM Conveyance Calculator & Engineer Claims Management System
Free online tool for ATM engineers to automate daily conveyance calculations. Uses OSRM road distance API for accurate km calculation, generates Excel expense reports with 7 sheets, and tracks local travel claims with auto-fetch from Google Sheets.
How Our ATM Conveyance Tool Works
Enter ATM ID
Type the unique ATM ID (e.g., 02683sry). System auto-fetches address from our integrated Google Sheets database.
Calculate Road Distance
Uses free OSRM API to compute actual driving distance between your current location and the ATM. No more guesswork.
Generate Excel Report
Automatically builds a 7-sheet professional Excel file with Summary, Local Conveyance, Outstation, BPE, Sunday Calls, and Other Claims.
Why ATM Engineers Love This Tool
- ✓ Auto-fetch ATM address from Google Sheets
- ✓ Real road distance via OSRM API (not straight-line)
- ✓ 7-in-1 Excel download – Summary, Local, Outstation, BPE, Sunday, Other Claims
- ✓ Auto & Manual modes – Enter by ATM ID or manually
- ✓ Browser history – Data auto-saved, no login required
- ✓ Edit distance & ticket – Full control over entries
Frequently Asked Questions
How accurate is the distance calculation? ▼
It uses the Open Source Routing Machine (OSRM) API, which calculates the actual road distance based on OpenStreetMap data. It’s highly accurate for Indian roads and cities like Mumbai, Thane, and Ambernath.
Do I need to pay or sign up? ▼
No, this tool is completely free. It uses free public APIs (OSRM and Nominatim) and saves data only in your browser’s local storage. No login, no email required.
Can I edit an entry after adding it? ▼
Yes. Each row in the table has an "Edit" button. You can modify the date, ticket number, and distance. Edited entries are marked with a ✏️ indicator.
What Excel sheets are included in the download? ▼
The download contains 7 professionally formatted sheets: 1) Summary, 2) Local Conveyance, 3) Outstation, 4) Other Claim, 5) BPE, 6) Sunday Call, and 7) Detailed Other Claims.
🚀 Start Using the Tool Above
Just enter your ATM ID and begin calculating your daily conveyance instantly.
Scroll to Tool