Menu

Tools

Explore

NG · NRI · .CSV

GTBank NRI AccountGoogle Sheets

Non-Resident Indian accounts NRE (Non-Resident External) and NRO (Non-Resident Ordinary) accounts held by Indian nationals living abroad. GTBank statement PDFs are downloadable via GTWorld Online Banking. Personal and business account statements are both supported.

Loading converter...

Secure Financial Data Processing

GTBank 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.

Nigeria Context NRI Account

In Nigeria, bank statements are required for FIRS corporate tax filing, VAT returns, and as supporting documents for FIRS audits and CBN compliance. Primary use case for nri account holders: FEMA compliance documentation, double taxation relief claims, ITR-2 filing for NRIs, and repatriation documentation. Compatible with QuickBooks and Sage 50.

Example Output

DateDescriptionDebit (NGN)Credit (NGN)Balance
2024-03-15Guaranty Trust Bank ATM Withdrawal2,000.0048,500.00
2024-03-18Salary Credit75,000.001,23,500.00

How It Works

  1. Download GTBank NRI PDF

    Log in to GTWorld Online Banking → My Accounts → Statements → Select account and period → Download PDF.

  2. Upload to MintConvert

    Drag and drop your Guaranty Trust Bank NRI Account PDF. All pages processed in one pass.

  3. Download .CSV

    Clean GOOGLE_SHEETS in under 30 seconds NGN 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.
  • NGN preserved All NGN amounts output as numeric values for QuickBooks import.
  • FEMA compliance documentation In Nigeria, bank statements are required for FIRS corporate tax filing, VAT returns, and as supporting documents for FIRS audits and CBN compliance.
  • Fiscal year aware Nigeria fiscal year: January 1 – December 31.
  • Privacy first Guaranty Trust Bank PDF processed in-memory only never stored.
  • Instant download Under 30 seconds for most statements.

Frequently Asked Questions

How do I convert a Guaranty Trust Bank NRI Account statement to GOOGLE_SHEETS?

Log in to GTWorld Online Banking → My Accounts → Statements → Select account and 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 Guaranty Trust Bank 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 (NGN), Credit (NGN), and Balance columns ready for Google Sheets import.

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

Yes all NGN amounts from your Guaranty Trust Bank NRI Account statement are output as numeric values, preserving the exact figures from the original PDF.

Does MintConvert handle the unique format of Guaranty Trust Bank NRI Account statements?

GTBank PDFs use a clear Debit/Credit column layout with NGN amounts. MintConvert maps these directly to standard numeric Debit and Credit output columns. 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 Nigeria fiscal year for NRI Account reconciliation?

Nigeria fiscal year: January 1 – December 31. In Nigeria, bank statements are required for FIRS corporate tax filing, VAT returns, and as supporting documents for FIRS audits and CBN compliance.

Which accounting software is compatible with the Guaranty Trust Bank NRI Account GOOGLE_SHEETS output?

The GOOGLE_SHEETS output is compatible with QuickBooks, Sage 50, Zoho Books, VFD. Upload the file to Google Drive → Right click → Open with Google Sheets. All dates and amounts will be automatically formatted for analysis.

Other GTBank Account Types