Resona Bank Statement to Excel or CSV
Resona's MyGate saves 入出金明細 as CSV or PDF. The PDF tends to be the version people keep and forward, and paper statements still turn up in client folders. Upload either here, scanned or digital, and the transactions come back as a table: dates as YYYY-MM-DD, withdrawals and deposits as signed yen amounts, and the balance checked from start to finish.
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 Resona Bank statement into Excel
-
Download the PDF statement from Resona Bank online banking
- Log in to Resona MyGate (マイゲート).
- Select 「入出金明細照会」 (transaction history).
- MyGate shows ordinary-deposit entries from December 2018 onward and from the day before your MyGate contract date; in the Resona Group app, tap 「普通預金」 at the bottom of the screen to see three or more entries.
- 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 Resona 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 Resona Bank statements
Two amount columns, one signed figure
Resona statement PDFs list the date, description, withdrawal, deposit and balance in separate columns. The converted file folds withdrawal and deposit into one signed amount, then recomputes the balance from the opening figure, so a row read into the wrong column shows up immediately.
Half-width katakana in 摘要
Transfer descriptions are often printed in half-width katakana, such as フリコミ followed by the sender's name. They come through as printed, so a rule keyed on フリコミ or on a client's kana name still matches after import.
Commas that Excel won't add
Amounts printed as 1,234,567 with no decimals paste into Excel as text more often than you'd expect. The output stores plain integers, negative for withdrawals, so a SUMIF by counterparty or by month works on the first try.
Dates in one format
Whether a statement prints dates as 2026/04/01 or in 令和 era years, the output writes YYYY-MM-DD. That keeps sorting and month filters consistent when Resona rows sit beside other banks' rows in one workbook.
Output and review
From Resona Bank PDF to your books
Accounting tip
freee会計's statement upload takes CSV files up to 5 MB; an Excel file has to be saved as .csv first. Upload the converted Resona CSV to the matching account, pick the date format, amount column and row order when prompted, then check the result screen.
-
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
Resona Bank statement questions
Should I use MyGate's CSV or convert the PDF?
Can I convert a Resona statement that a client scanned?
Can I import converted Resona Bank rows into QuickBooks or Xero?
Convert your Resona 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 Resona Bank.