SMBC Statement to Excel or CSV

SMBC Direct downloads transaction history as CSV with Western-calendar dates, so for recent months the bank's own file does the job. The PDFs and paper come from elsewhere: a printed 入出金明細, a certified transaction history (預金入出金取引証明) from a branch, or statements a client scanned. Upload those here to get the same kind of table, with yen amounts and balances checked.

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 SMBC statement into Excel

  1. Download the PDF statement from SMBC online banking

    • Log in to SMBC Direct (SMBCダイレクト).
    • Open the balance and transaction history (残高・入出金明細) for the account selected on the top screen; to change the period, use 「過去の明細を照会」 below the balance and enter dates, or press 「今月」「先月」「今年」「前年」 or 「直近1年」.
    • With Web通帳 (paperless passbook) you can view up to 30 years of statements from 2019 onward; paper-passbook accounts show up to 25 months.
    • Save the statement for the period you need as a PDF.
    Go to SMBC 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 SMBC 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 SMBC statements

Web通帳 or a paper passbook

Accounts switched to Web通帳 show up to 30 years of statements from 2019 onward; paper-passbook accounts show up to 25 months online. For a client who kept the paper passbook, anything older than 25 months is in the passbook or on a branch certificate, and both can be scanned and converted.

Signed amounts, one column

SMBC's PC help notes that the minus sign in the withdrawal column is carried into the CSV. The output here goes one step further: a single signed amount per row, negative for withdrawals, so summing the column gives the net movement for the period.

Era years on older paper

Older printouts and certificates may show dates in Japanese era years, and the switch from 平成 to 令和 in 2019 falls in the middle of many histories. Dates are written as YYYY-MM-DD in the output; look over the rows around the change of era on the review screen.

Display limits per query

Online, a single query shows up to 2,000 entries for Web通帳 accounts and 300 for paper-passbook accounts. A busy account can pass that within a year, which is why long histories end up split across files. Upload them together and overlapping or missing dates are flagged.

Output and review

From SMBC PDF to your books

Accounting tip

マネーフォワード クラウド会計 imports statement CSVs into a manually managed account from データ連携 > 登録済一覧, using the CSV インポート link. Use it to add converted SMBC rows for the periods your bank connection doesn't reach.

  • 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

SMBC statement questions

Does SMBC Direct give me a PDF of my statement?
SMBC's help pages describe a CSV download and a print view for 入出金明細, not a PDF download for personal accounts. Saving the print view as a PDF, or scanning a branch-issued certificate, gives you a file that converts here.
How far back can I see SMBC statements online?
With Web通帳, up to 30 years of statements from 2019 onward; with a paper passbook, up to 25 months. Older history means the passbook itself or a certified history from a branch, which you can scan and convert here.
Can I import converted SMBC rows into QuickBooks or Xero?
Yes. Review the rows, then export a QuickBooks or Xero CSV.

Convert your SMBC 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 SMBC.