Menu

Tools

Explore

JP · NRI · .CSV

SMBC NRI AccountGoogle Sheets

Non-Resident Indian accounts NRE (Non-Resident External) and NRO (Non-Resident Ordinary) accounts held by Indian nationals living abroad. SMBC statement PDFs are downloadable via SMBC Direct or the SMBC Online Service. Both personal and corporate account statements are supported.

Loading converter...

Secure Financial Data Processing

SMBC NRI Account GOOGLE_SHEETS Notes

Non-Resident Indian accounts NRE (Non-Resident External) and NRO (Non-Resident Ordinary) accounts held by Indian nationals living abroad. Includes foreign currency inward remittances, SWIFT credits, and Indian rupee debits. NRI account PDFs include foreign currency transaction references alongside INR amounts and may show both the foreign currency amount and the INR equivalent. MintConvert captures both amounts where available.

Japan Context NRI Account

In Japan, bank statements are required for Kakutei Shinkoku (individual income tax return) filed with NTA and for corporate tax and consumption tax (Shohi-zei) filing. Primary use case for nri account holders: FEMA compliance documentation, double taxation relief claims, ITR-2 filing for NRIs, and repatriation documentation. Compatible with Freee Accounting and MoneForward Cloud.

Example Output

DateDescriptionDebit (JPY)Credit (JPY)Balance
2024-03-15Sumitomo Mitsui Banking ATM Withdrawal2,000.0048,500.00
2024-03-18Salary Credit75,000.001,23,500.00

How It Works

  1. Download SMBC NRI PDF

    Log in to SMBC Direct → Account Information → Account Statement → Select period → Download PDF.

  2. Upload to MintConvert

    Drag and drop your Sumitomo Mitsui Banking NRI Account PDF. All pages processed in one pass.

  3. Download .CSV

    Clean GOOGLE_SHEETS in under 30 seconds JPY amounts preserved, dates normalised.

Why MintConvert

  • NRI account support NRI account PDFs include foreign currency transaction references alongside INR amounts and may show both the foreign currency amount and the INR equivalent. MintConvert captures both amounts where available.
  • JPY preserved All JPY amounts output as numeric values for Freee Accounting import.
  • FEMA compliance documentation In Japan, bank statements are required for Kakutei Shinkoku (individual income tax return) filed with NTA and for corporate tax and consumption tax (Shohi-zei) filing.
  • Fiscal year aware Japan fiscal year: April 1 – March 31 (corporate) / January 1 – December 31 (individual).
  • Privacy first Sumitomo Mitsui Banking PDF processed in-memory only never stored.
  • Instant download Under 30 seconds for most statements.

Frequently Asked Questions

How do I convert a Sumitomo Mitsui Banking NRI Account statement to GOOGLE_SHEETS?

Log in to SMBC Direct → Account Information → Account Statement → Select period → Download PDF. Then upload the PDF to MintConvert. NRI account PDFs include foreign currency transaction references alongside INR amounts and may show both the foreign currency amount and the INR equivalent. MintConvert captures both amounts where available. Download your clean GOOGLE_SHEETS file in under 30 seconds.

What is the Sumitomo Mitsui Banking NRI Account GOOGLE_SHEETS output used for?

FEMA compliance documentation, double taxation relief claims, ITR-2 filing for NRIs, and repatriation documentation. The GOOGLE_SHEETS output includes Date, Description, Debit (JPY), Credit (JPY), and Balance columns ready for Google Sheets import.

Are JPY amounts preserved in the GOOGLE_SHEETS output for NRI Accounts?

Yes all JPY amounts from your Sumitomo Mitsui Banking NRI Account statement are output as numeric values, preserving the exact figures from the original PDF.

Does MintConvert handle the unique format of Sumitomo Mitsui Banking NRI Account statements?

SMBC PDFs list JPY amounts in integer format with Japanese date notation (YYYY/MM/DD). MintConvert normalises dates to ISO YYYY-MM-DD format in the output. NRI account PDFs include foreign currency transaction references alongside INR amounts and may show both the foreign currency amount and the INR equivalent. MintConvert captures both amounts where available.

What is the Japan fiscal year for NRI Account reconciliation?

Japan fiscal year: April 1 – March 31 (corporate) / January 1 – December 31 (individual). In Japan, bank statements are required for Kakutei Shinkoku (individual income tax return) filed with NTA and for corporate tax and consumption tax (Shohi-zei) filing.

Which accounting software is compatible with the Sumitomo Mitsui Banking NRI Account GOOGLE_SHEETS output?

The GOOGLE_SHEETS output is compatible with Freee Accounting, MoneForward Cloud, OBC Bugyo, Yayoi. Upload the file to Google Drive → Right click → Open with Google Sheets. All dates and amounts will be automatically formatted for analysis.

Other SMBC Account Types