Japanese bank statements and passbooks to Excel

Most Japanese banks offer a CSV download, but with limits: 200 rows at a time at MUFG, two months of history for a Japan Post Bank ordinary account, and CSV only on a PC at Mizuho and au Jibun Bank. Longer histories come as PDFs, branch certificates or passbook pages. Upload any of them to get dated, signed yen rows.

Currency
Japanese yen (JPY), no decimals
Dates
Year first, YYYY/MM/DD; some era years
Money columns
Withdrawal, deposit, balance
Common imports
freee, Money Forward, Yayoi

Page 1 free, no sign-up to see it; just an email to download. The whole document is one payment: $9 up to 25 pages, priced by page count above that. No subscription.

Several statements? Drop up to 100 at once: one payment for all of them, priced by their total pages.

Banks

Japanese banks and what their statements do

Major banks and Japan Post Bank 5

  • MUFG Bank

    PC downloads stop at 200 rows; Eco passbook users can request a ten-year transaction history as a PDF.

  • SMBC

    Web passbook accounts show up to 30 years from 2019 on; paper-passbook accounts show 25 months.

  • Mizuho Bank

    The Direct passbook covers ten years but has no balance per transaction and skips the last three months.

  • Resona Bank

    MyGate saves statements as CSV or PDF, with transfer names in half-width katakana.

  • Japan Post Bank

    An ordinary account shows about two months online; counters mail out up to ten years of history.

Online banks 5

  • Rakuten Bank

    Downloads reach back to account opening; periods past 24 months are prepared and kept for 30 days.

  • DOCOMO SMTB Net Bank

    Formerly SBI Sumishin Net Bank; each CSV or PDF download holds up to 999 records.

  • PayPay Bank

    PDFs come from the web statement screen, not the app, for up to ten years back.

  • Sony Bank

    No paper passbook; printouts of the online passbook mix in page headings and your own memos.

  • au Jibun Bank

    PDF only on a smartphone, CSV on a PC; the app lists the latest 300 items.

Statement layout

What Japanese statements look like

Withdrawals, deposits and whole yen

Statements and passbooks list withdrawals and deposits in separate columns beside the balance, in yen with no decimals. Each row comes out with one signed whole-number amount, and the balance is recomputed from the opening figure.

Half-width katakana descriptions

Transfer descriptions are printed in half-width katakana, such as フリコミ followed by the sender's name. They're kept exactly as printed, so matching rules you've set up in your accounting software still recognise them.

Western dates and era years

Bank downloads use Western dates such as 2026/04/01, but older printouts and branch certificates may use era years, and the 2019 change from Heisei to Reiwa falls inside many histories. Check the rows around it on the review screen.

Output and review

What you get, and what's checked

Each statement becomes rows of date, description, signed yen amount and balance, as Excel, CSV or JSON. The balance is checked from opening to closing, or for a Mizuho Direct passbook, which has no running balance, against the balances at either end. Signed in, files split by download limits are lined up so overlaps and gaps show.

Benchmark vs free tools

freee, Money Forward and Yayoi

  • freee Accounting

    In 明細のアップロード, choose the self-made CSV option. freee accepts one amount column with withdrawals negative, then asks for the date format and row order.

  • Money Forward Cloud Accounting

    Use the CSV import link for a manually managed account under 登録済一覧, for periods your bank connection doesn't reach.

  • Yayoi Accounting Next

    Upload the CSV to the 明細ボックス and assign its columns, then add journal rules so recurring transfers need less typing.

FAQ

Questions about Japanese bank statements

Can I convert passbook pages?
Yes. Scan the pages to PDF. Passbook print is small and sometimes faint, so compare the amounts and the balance with the page on the review screen.
Why convert a PDF if my bank offers CSV?
Because the CSV is limited by rows (200 at MUFG, 999 at DOCOMO SMTB Net Bank), by device (PC only at Mizuho and au Jibun Bank) or by period. Older history comes as a PDF, a certificate or a passbook.

Any bank, any country

Bank statement converter