Japan Post Bank (Yucho) Statement to Excel
Yucho Direct's CSV download is handy, but an ordinary 総合口座 shows only about two months online. Anything older means the passbook itself, or a transaction history requested at a counter and mailed to you. Scan either to PDF and upload it here: you get dates as YYYY-MM-DD, deposits and withdrawals as signed yen amounts, and a check on the running balance.
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.
98% of numbers correct on 82 hand-checked pages How we measure
How to get your Japan Post Bank statement into Excel
-
Download the PDF statement from Japan Post Bank online banking
- Log in to Yucho Direct (ゆうちょダイレクト).
- Press 「入出金明細照会」 in the menu, then 「表示条件を変更」; choose 「入出金」 as the type and 「日付を指定」 as the period, and press 「表示する」.
- Online history covers up to 2 months for ordinary (総合口座) accounts and up to 20 years for Yucho Direct+ accounts (statements from March 2021).
- Save the statement for the period you need as a PDF.
-
Upload it here
Scans and phone photos work too.
-
Download Excel, CSV, or QuickBooks and Xero CSV
Check the rows against the statement, then export.
Sample result
Your Japan Post Bank statement in Excel
Made-up sample rows, not a real statement.
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| 2026-01-02 Salary - Example Employer Ltd | Salary - Example Employer Ltd | 250,000 | 350,000 | |
| 2026-01-05 Card payment - Sample Grocery Co | Card payment - Sample Grocery Co | 12,000 | 338,000 | |
| 2026-01-09 Rent - Placeholder Properties | Rent - Placeholder Properties | 120,000 | 218,000 | |
| 2026-01-14 Transfer from savings | Transfer from savings | 30,000 | 248,000 | |
| 2026-01-20 Utility bill - Demo Energy Co | Utility bill - Demo Energy Co | 8,000 | 240,000 | |
| 2026-01-27 Card payment - Fictional Coffee Co | Card payment - Fictional Coffee Co | 1,500 | 238,500 |
Statement notes
What to know about Japan Post Bank statements
Two months, 15 months or 20 years
How far Yucho Direct reaches depends on the account: up to two months for a 総合口座, 15 months for a 振替口座, and up to 20 years, from March 2021 onward, for a ゆうちょダイレクト+ account with no paper passbook. Nothing before your Yucho Direct application date is shown.
Counter histories go back ten years
At a counter you can ask for a history of deposits and withdrawals up to ten years back; the results are mailed later, and there's a fee per passbook covered. That paper is usually what you'll scan and convert for the older years.
Passbook pages convert too
A scanned passbook page is read like any other PDF. Passbook printing is small and sometimes faint, so compare amounts and the 現在高 balance on the review screen with the page itself, particularly where a line was printed long after the one above it.
Lining up with Yucho's own CSV
Yucho Direct's CSV has 受入金額 and 払出金額 columns plus two detail fields, 詳細1 and 詳細2. The converted file has one signed amount and one description, so if you compare the two in a sheet, subtract 払出 from 受入 to compare like with like.
Output and review
From Japan Post Bank PDF to your books
Accounting tip
In マネーフォワード クラウド会計, a manually managed account under データ連携 > 登録済一覧 has a CSV インポート link. Bring converted passbook and counter-history rows in there for the months that fell outside Yucho Direct's online window.
-
Checked before export
Opening balance plus transactions is checked against the closing balance. Duplicate or missing periods are flagged.
-
Export formats
Excel, CSV, JSON, or QuickBooks and Xero CSV.
-
Private workspace
HTTPS uploads, kept private until you ask support to delete them.
FAQ
Japan Post Bank statement questions
Yucho Direct already gives me CSV files. Do I need this?
Does the ゆうちょ通帳アプリ keep older statements?
Can I import converted Japan Post Bank rows into QuickBooks or Xero?
Convert your Japan Post Bank statement to Excel
Page 1 free, no sign-up to see it; just an email to download.
More Bank Statement Converters
pdf2text is independent and not affiliated with or endorsed by Japan Post Bank.