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.

See pricing

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

How to get your Resona Bank statement into Excel

  1. 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.
    Go to Resona 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 Resona 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 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.

    Files for QuickBooks Online

    Files for Xero

  • 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?
If you can log in to MyGate and the period is still shown, its CSV is quickest. Convert the PDF when that's what you were given, when you need statements you saved as PDF earlier, or when you want the same column layout as your other banks.
Can I convert a Resona statement that a client scanned?
Yes. Scanned PDFs are read as well as digital ones. Ask for a straight, flat scan with the whole page in frame. Afterwards, the running-balance check tells you whether every amount was read, and the review screen shows where to look if one wasn't.
Can I import converted Resona Bank rows into QuickBooks or Xero?
Yes. Review the rows, then export a QuickBooks or Xero CSV.

Convert your Resona 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 Resona Bank.