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.
98% of numbers correct on 82 hand-checked pages How we measure
How to get your Rakuten Bank statement into Excel
-
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.
-
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 Rakuten 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 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.
-
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?
Can I download Rakuten Bank statements from the app?
Can I import converted Rakuten Bank rows into QuickBooks or Xero?
Convert your Rakuten 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 Rakuten Bank.