Extract Suica & PASMO Travel History — Stations, Fares & Balance from App Screenshots
The Suica and PASMO apps have no export button — every ride stays trapped in a scrolling mobile list. Transcribing one week of rides into an expense sheet takes roughly 30 minutes; screenshot extraction fills the same rows in about 5 seconds per screenshot.
5-10s per screenshot · Up to 99% accuracy on printed text
Five Fields Every Suica & PASMO Ride Row Carries
Every ride in the Suica or PASMO app is already a structured row — station, fare, balance — but there's no way to get it out. With Custom Column Extraction, you type the field names and the AI reads each row straight from the screenshot.
The station where you tapped in — shown on the left side of the ride row, in kanji.
The station where you tapped out — joined to the entry station by an arrow in the same row.
The fare deducted for the ride — or ¥0 for rides inside your Commuter Pass (定期券) zone, which still need logging.
The date of the ride — the expense report needs this per row, and the app shows it in the row header.
The running balance shown after each ride — the only way to verify the fare math before you submit.
The Data Is Already Structured — the Apps Just Won't Let It Out
Every Suica or PASMO ride is stored as a clean row: entry station, exit station, fare, balance. The problem was never the data — it's that the official apps have no export, and every workaround so far either needs the physical card or a ticket machine.
No Export Button — Anywhere
The Suica app, PASMO app, and Apple Wallet all display your ride history as a scrolling list. None of them offer a CSV or spreadsheet export. On r/japanlife, the standard advice is still "You can print out your expenses at a ticket machine. Make sure you use a JR machine for Suica or the correct machine for Pasmo" — a paper slip you then type into Excel by hand.
The Official Path Has Hard Limits
JR East's own FAQ caps printable history at 100 entries within 26 weeks, and the on-screen list shows only about 20. Rides older than that need a formal personal-information disclosure request — paperwork, for registered cards only. Miss the window and the records are simply gone.
NFC Reader Apps Need the Card — and See Even Less
Apps like Suikakeibo read the physical card over NFC, but the IC chip itself only holds the most recent ~20 records, and Japanese IC cards don't record trips covered by a commuter pass at all. As one JNS forum user put it, "you have to read them regularly or data is lost."
Start From What You Already Have — the Screenshot
No NFC card, no ticket machine, no company expense system. Upload the screenshot of the ride history you're already looking at. Custom Column Extraction reads each row by what the fields mean — entry station, exit station, fare, balance — not by where they sit in the layout.
One Arrow Line Becomes Two Columns
The ride row 東京→新宿 is a single visual line. Define Entry Station (入場駅) and Exit Station (出場駅) as separate columns and the AI splits it correctly — keeping 新宿 as 新宿, because your Expense Reimbursement form (交通費精算書) needs the kanji station names as-is.
The Whole Month in One Batch, Ready to Submit
Screenshot every page of the history before it's overwritten, upload them together, and the AI merges them into one spreadsheet — entry station, exit station, fare, ride date, running balance, one row per ride. Export to Excel, CSV, or push straight into Google Sheets for your monthly 交通費精算 submission.
From a Scrolling Ride List to a Submittable Expense Sheet
If you're preparing a monthly transportation expense report and your rides live in the Suica or PASMO app, here's what happens when you drop a screenshot into the tool.
Capture the Ride History
Open the Suica or PASMO app's ride history (SF利用履歴), screenshot the visible rows, and scroll down to capture older pages. A clean full-resolution screenshot works best — JPG, PNG, or WebP all fine. One screenshot per screenful, and batch them together.
Name the Columns
Type the columns your expense form expects: Ride Date (利用日), Entry Station (入場駅), Exit Station (出場駅), Fare (運賃), Balance After (残高). Add an Inferred Column like Trip Purpose (options: Commute/Business/Personal) and the AI classifies each ride as it extracts — useful when your company only reimburses business trips.
Export the Sheet and Submit
The output is one spreadsheet — every ride you captured becomes a row with the kanji station names, fares, dates, and running balance intact. Export to Excel or CSV and attach it to your expense claim, or keep a rolling ledger so the 26-week history window never eats your records again.
Suica & PASMO Screenshot Extraction — When It Works and When to Look Closer
When It Works Best
Direct app screenshots at full resolution. Mobile Suica or PASMO app screenshots of the ride history screen reach up to 99% accuracy on the printed numerals and station names.
Standard kanji station names. 新宿, 東京, 渋谷 — the common stations on major lines are read reliably, and names are preserved in their original Japanese form.
Batch capture before the 26-week window closes. Screenshot each page of history and process them together — this works regardless of whether you have the physical card or an NFC reader.
When to Be Cautious
Screenshots only capture what's on screen. The app shows roughly 20 entries at a time. Older rides require scrolling and capturing more screenshots — extraction can't see past what you screenshot, so capture the window before records are overwritten.
Compressed or forwarded screenshots lose detail. Images shared through messaging apps get compressed — the AI still outperforms traditional OCR, but spot-check the extracted station names and fares.
Some ride types show abbreviated or special codes. The app marks transfers and adjustments with symbols like ＊入 or 精, and non-JR lines may show limited station detail — treat those rows as needing a manual glance before submission.
Frequently Asked Questions
Can I extract the entry and exit station when they appear on one line with an arrow, like 東京→新宿?
Yes. The Suica app renders each ride as a single row with the entry and exit station joined by an arrow. Define two columns — Entry Station (入場駅) and Exit Station (出場駅) — and the AI splits the visual line into two separate cells, keeping both names in their original kanji.
Will the station names stay in Japanese kanji for my expense form?
Yes. Station names are extracted exactly as displayed in the app — 新宿 stays 新宿, it is not romanized or translated. Japanese Expense Reimbursement forms (交通費精算書) require the kanji station names, so the extraction preserves them verbatim rather than "helpfully" converting them to Shinjuku.
My commuter pass (定期券) rides show a ¥0 fare — can those still be logged?
Yes. Rides inside your Commuter Pass (定期券) zone display a fare of ¥0 and a pass indicator, but they still need to be logged for attendance records and travel history. Define columns for Entry Station, Exit Station, and Ride Date — the AI records every row including ¥0 pass rides, and the Fare (運賃) column simply shows ¥0 for those.
Can I get the running balance after each ride as a verification column?
Yes. Both apps display the remaining Balance After (残高) next to each ride. Define it as a column and the AI extracts the running figure for every row, so you can verify the fare math — balance before minus fare equals balance after — before submitting. This catches transcription errors that would otherwise bounce back from accounting.
The app only shows about 20 recent rides on screen — how do I capture older ones?
The on-screen list shows roughly the most recent 20 entries, and JR East's printable history caps at 100 entries within 26 weeks. Screenshot extraction works on whatever is visible — scroll the history, screenshot each page, and batch-upload them together. Set a monthly capture habit before the window closes; older records otherwise require a formal personal-information disclosure request to JR East, which is a paperwork process for registered cards only.
Back to transit & commuter card screenshots overview — balance, top-up, and trip history extraction across Suica, Oyster, T-money, Opal, and 12 more systems
More transit & commute card extraction guides coming soon.