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.
98% of numbers correct on 82 hand-checked pages How we measure
How to get your SMBC statement into Excel
-
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.
-
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 SMBC 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 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.
-
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?
How far back can I see SMBC statements online?
Can I import converted SMBC rows into QuickBooks or Xero?
Convert your SMBC 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 SMBC.