Rakuten Bank Statement to Excel or CSV

Rakuten Bank lets you download 入出金明細 as CSV or PDF all the way back to account opening, free of charge. Periods within 24 months and up to 3,000 records arrive at once; older ones are prepared and kept for 30 days. If what you saved was the PDF, or you have a mailed 取引履歴明細証明書, upload it here to get the rows back as a spreadsheet.

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 Rakuten Bank statement into Excel

  1. Download the PDF statement from Rakuten Bank online banking

    • Log in to Rakuten Bank on a PC, or open the Rakuten Bank app or smartphone site.
    • Open the 入出金明細 (transaction history) screen; in the app, tap 「直近24ヶ月以内の全てのお取引のご確認はこちら」 and then 「ダウンロード依頼」 at the bottom, which opens the browser.
    • Set the 「照会期間」 (period) and press 「CSV形式でダウンロード」 or 「PDF形式でダウンロード」; on the app and smartphone site, confirm with 「ダウンロード依頼をする」.
    • Save the statement for the period you need as a PDF.
    Go to Rakuten 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 Rakuten 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 Rakuten Bank statements

A list, not a certificate

Since December 2021 the PDF download has been a list-format history rather than the certificate format. It's a plain table, which converts cleanly. The certificate itself, the 取引履歴明細証明書, is issued on paper only, requested by phone and mailed; scan it and it converts too.

3,000 records at a time

Immediate downloads stop at 3,000 records. For more, Rakuten asks you to split the period or request it as a prepared download. Split downloads mean several PDFs; upload them together and the converter flags any overlap or gap between them.

Long histories, long files

A download back to account opening can run to many pages. Wrapped descriptions are joined to their transaction, and the balance is followed from the first row to the last, so a dropped or doubled line shows up as a mismatch rather than slipping into your books.

Prepared downloads expire after 30 days

Periods older than 24 months are prepared after you request them and can be downloaded for 30 days from that day. Save the PDF as soon as it's ready; if the window lapses, you'll have to request it again before there's anything to convert.

Output and review

From Rakuten Bank PDF to your books

Accounting tip

freee会計 resumed automatic sync with Rakuten Bank in December 2023 and also accepts uploaded statement files. If you upload converted months and then switch on sync, set the sync start date to the day after your last uploaded transaction, so nothing is counted twice.

  • 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

Rakuten Bank statement questions

Is the Rakuten Bank PDF download the same as a certificate?
No. Since December 2021 the downloaded PDF is a list-format history, not the 取引履歴明細証明書. If you need the official certificate, request it by phone; it's mailed in about a week to ten days. Both versions convert here.
Can I download Rakuten Bank statements from the app?
The app has no download function of its own. It hands you over to the smartphone site, where you request CSV or PDF and confirm with 「ダウンロード依頼をする」. The PDF from there converts here like one downloaded on a PC.
Can I import converted Rakuten Bank rows into QuickBooks or Xero?
Yes. Review the rows, then export a QuickBooks or Xero CSV.

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