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.

See pricing

98% of numbers correct on 82 hand-checked pages How we measure

How to get your Mizuho Bank statement into Excel

  1. 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.
    Go to Mizuho Bank Online Banking
  2. Upload it here

    Scans and phone photos work too.

  3. 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.

sample-statement-2026-01.xlsx Jan 2026 · JPY
Sample bank statement rows with made-up data, amounts in JPY
Date Debit Credit Balance
2026-01-02 Salary - Example Employer Ltd 250,000 350,000
2026-01-05 Card payment - Sample Grocery Co 12,000 338,000
2026-01-09 Rent - Placeholder Properties 120,000 218,000
2026-01-14 Transfer from savings 30,000 248,000
2026-01-20 Utility bill - Demo Energy Co 8,000 240,000
2026-01-27 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.

    Files for QuickBooks Online

    Files for Xero

  • 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?
Mizuho says the Direct passbook has no function for checking the balance per transaction. The converted file therefore lists dates, descriptions, withdrawals and deposits; to reconcile, compare the totals with the balances at the start and end of the period.
Can I get older Mizuho statements without an e-口座?
Branches issue a 取引明細証明書 covering up to ten years back, sent by post a few weeks after the request. It's paper, so scan it to PDF and convert it here, checking the review screen against the original wherever the print is faint.
Can I import converted Mizuho Bank rows into QuickBooks or Xero?
Yes. Review the rows, then export a QuickBooks or Xero CSV.

Convert your Mizuho Bank statement to Excel

Page 1 free, no sign-up to see it; just an email to download.

pdf2text is independent and not affiliated with or endorsed by Mizuho Bank.