How to Organize ETC Usage Reports as PDF and CSV in Japan
A guide to downloading, organizing, and using ETC toll data as PDF certificates and CSV files
What Are ETC PDF and CSV Reports?
The official ETC usage inquiry service allows you to download toll data as PDF usage certificates and CSV data files. PDFs are useful for expense claims and record-keeping. CSV files can be imported into accounting software. However, each download requires manual login.
PDF Usage Certificate Benefits
- Official usage certificate accepted for expense claims
- Shows date, entry gate, exit gate, and toll amount
- Can be printed as physical documentation
- Japan Toll Receipts delivers these automatically by email
CSV Data Benefits
- Import directly into Japanese accounting software (freee, Money Forward Cloud, Yayoi / 弥生会計, Kanjo Bugyo / 勘定奉行, TKC)
- Automatic monthly and annual total calculations
- Filter and sort data for specific periods
- Cost analysis by team, department, or vehicle
Manual Download vs Automated Delivery
Manually downloading from MEISAI takes about 15 minutes per session. With Japan Toll Receipts, reports arrive automatically — no login needed. That saves over 13 hours per year (15 min × 52 weeks).
Importing CSV into Accounting Software (freee / Money Forward)
The Japan Toll Receipts CSV is built around the minimum fields Japanese accounting tools expect (date / amount / memo / category). The column layout below mirrors what freee and Money Forward look for when importing manual statements.
| JTR CSV column | freee field | Money Forward field |
|---|---|---|
| 利用日 / Date | 取引日 | 日付 |
| 料金 / Amount (JPY) | 金額 | 金額 |
| 区間 / Route (入口IC→出口IC) | 摘要 | 支払先・内容 |
| Card last-4 | memo | memo |
| Expense category (optional) | Account (manual) | 経費科目 |
The accounting category you pick (e.g. 旅費交通費 / 車両費) depends on your firm's policy and tax advisor. JTR is an independent service that focuses on producing import-friendly data — it does not provide tax advice.