Mizuho Bank Statement PDF to Excel or CSV
Mizuho Bank's Direct passbook (みずほダイレクト通帳) is a ten-year record for paperless e-口座 accounts, but it has a quirk: no balance after each transaction. It also leaves out the latest three months, which sit on the 入出金明細照会 screen instead. Upload the PDFs here to get one transaction table, with dates as YYYY-MM-DD and withdrawals negative.
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 Mizuho Bank statement into Excel
-
Download the PDF statement from Mizuho Bank online banking
- Log in to Mizuho Direct (みずほダイレクト) on a PC, or log in to the Mizuho Bank app.
- On a PC choose 「みずほe-口座・ダイレクト通帳」 under 「確認する」 at the top and open 「みずほダイレクト通帳明細照会」 (in the app: 「お客さまメニュー」 > 「みずほe-口座・ダイレクト通帳の申込」); pick the account in 「照会口座の指定」 and the period in 「ご照会期間の選択」.
- Choose 「PDFダウンロード」, or 「CSVダウンロード」 on a PC. The last three months are not in the Direct passbook: tap the 「入出金明細照会」 message, pick the account, and use the 「ダウンロード」 button left of the statement title.
- 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 Mizuho 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 Mizuho Bank statements
No running balance in the Direct passbook
Mizuho says the Direct passbook has no function for checking the balance per transaction. Without it, a row-by-row check isn't possible, so the converted rows are checked against the balances at the start and end of the period instead. Keep a balance figure from the statement screen or a 残高証明書 to hand.
The last three months live elsewhere
The Direct passbook stops three months back. The current month and the two before it are downloaded from 入出金明細照会 as a separate PDF, or CSV on a PC. Upload both PDFs and the period check confirms they meet without a gap or an overlap.
CSV on a PC, PDF on a phone
Mizuho offers CSV only on a PC; on a smartphone or in the app the download is a PDF. If you handle the books from your phone, or a client sends what they saved on theirs, convert the PDF here to get the rows in Excel or CSV.
For e-口座 accounts only
The Direct passbook is available only to みずほe-口座 holders who apply for it, and an e-口座 can't be combined with a paper passbook. For a paper-passbook account, older history comes from the passbook or a 取引明細証明書 from a branch, both of which can be scanned.
Output and review
From Mizuho Bank PDF to your books
Accounting tip
弥生会計 Next has a 明細ボックス where you can upload statements, including any CSV file (任意のCSVファイル取込). Import the converted Mizuho rows there and set up 仕訳ルール, so recurring transfers need less typing each month.
-
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
Mizuho Bank statement questions
Why doesn't my Mizuho Direct passbook PDF show a balance?
Can I get older Mizuho statements without an e-口座?
Can I import converted Mizuho Bank rows into QuickBooks or Xero?
Convert your Mizuho 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 Mizuho Bank.