How to Convert GTBank Statement to Excel — 3 Steps
1
Download from GTWorld App or Internet Banking
Log in to GTWorld or ibank.gtbank.com and download your account statement PDF
2
Upload & Convert
Upload the PDF above — GTBank statements are usually not password-protected
3
Download Excel or CSV
Get a clean .xlsx or .csv with Date, Narration, Debit, Credit, and Balance columns
How to Download Your GTBank Statement PDF
Via GTWorld App
- Open the GTWorld app on your smartphone and log in
- Tap your account card or go to Accounts
- Tap Statement or Account Statement
- Set your Start Date and End Date (up to 12 months per request)
- Tap Generate → Download PDF
- The PDF is saved to your phone's downloads or can be shared directly
Via GTBank Internet Banking
- Visit ibank.gtbank.com and log in with your User ID and Password
- Click Accounts in the top menu
- Click Account Statement
- Enter From Date and To Date and click Generate Statement
- Click Download PDF to save your statement
Via GTBank Email or Branch
GTBank also sends monthly account statements to your registered email address. For stamped and certified statements (required for embassy visa applications and mortgage documentation), visit any GTBank branch with your account number and a valid government-issued ID. Note that certified statements attract a fee.
About GTBank — Guaranty Trust Bank
Guaranty Trust Bank (GTBank) is one of Nigeria's leading commercial banks, founded in 1990 and listed on both the Nigerian Exchange Group (NGX) and the London Stock Exchange (LSE). Regulated by the Central Bank of Nigeria (CBN), GTBank serves over 23 million customers with a network of branches across Nigeria and international offices in Ghana, Kenya, Rwanda, Tanzania, Uganda, Côte d'Ivoire, Cameroon, and the United Kingdom.
In 2021, GTBank transitioned to a holding company structure, with the banking subsidiary now operating under the name Guaranty Trust Bank Limited within the Guaranty Trust Holding Company (GTCO). The GTWorld app — GTBank's flagship mobile banking platform — is one of the highest-rated banking apps in West Africa and allows customers to download statements, make transfers, pay bills, and manage cards directly.
Supported GTBank Account Types
- GTBank Current Account — standard current account for individuals and businesses, supports cheque issuance and debit orders
- GTBank Savings Account — regular naira savings account with monthly interest
- GTBank FlexiSave Account — flexible savings with bonus interest tiers
- GTBank KidsAccount / TeenSave — children's and youth savings accounts
- GTBank Domiciliary Account — USD, GBP, and EUR accounts for forex transactions, SWIFT receipts, and international transfers
- GTBank Business Account — current accounts for SMEs and corporates
- GTBank Ghana — GHS (Ghanaian cedi) statements from Guaranty Trust Bank Ghana
- GTBank UK — GBP statements for GTBank UK account holders
What the Conversion Looks Like — Before & After
| Before → After Comparison |
|---|
| Raw PDF (GTBank Statement) |
Clean Excel Output |
| 01-Jun-2026 SALARY/DANGOTE INDUSTRIES LTD/REF2606010032 450,000.00 720,440.00 |
Date: 2026-06-01
Narration: SALARY — DANGOTE INDUSTRIES LTD
Credit: ₦450,000.00 Balance: ₦720,440.00 |
| 05-Jun-2026 MOBILE TRANSFER/ADEYEMI OLUWASEUN/REF GTMO001 80,000.00 640,440.00 |
Date: 2026-06-05
Narration: MOBILE TRANSFER — ADEYEMI OLUWASEUN
Debit: ₦80,000.00 Balance: ₦640,440.00 |
| 15-Jun-2026 USSD AIRTIME/AIRTEL NG/REF USSD226150019 5,000.00 635,440.00 |
Date: 2026-06-15
Narration: USSD AIRTIME — AIRTEL NG
Debit: ₦5,000.00 Balance: ₦635,440.00 |
Why Nigerians Convert GTBank Statements to Excel
🌍 Visa Applications and Travel
For Schengen visa applications from Nigeria, UK Standard Visitor visas, US B1/B2, and Canadian visas, Nigerian embassies and consulates require 3 to 6 months of bank statements. GTBank is one of the most accepted Nigerian banks at all major embassies. Convert to Excel to quickly verify your average daily balance meets the financial threshold required by each visa category.
🏠 Mortgage and Home Loans
GTBank's own HousingLoan product, NHF mortgages through FMBN, and commercial mortgage applications all require 6 months of bank statements. Converting your GTBank statement to Excel helps you quickly verify income regularity, compute the debt-to-income ratio lenders assess, and prepare supporting financial documentation.
💼 Business and FIRS Tax Filing
Nigerian businesses and sole proprietors use GTBank statements to prepare FIRS tax filings, compute VAT, track deductible business expenses, and respond to bank reconciliation queries from auditors. Convert monthly GTBank statements to Excel for import into accounting software like QuickBooks, Sage, or Zoho Books.
💵 Domiciliary Account Tracking
GTBank domiciliary account holders use our converter to track USD, GBP, and EUR incoming SWIFT transfers — crucial for FEMA compliance in Nigeria and for reconciling foreign currency income from overseas clients and diaspora remittances.
Frequently Asked Questions
How do I download my GTBank statement?
Via GTWorld app: Login → tap account → Statement → set dates → Download PDF. Via GTBank Internet Banking (ibank.gtbank.com): Login → Accounts → Account Statement → set dates → Generate → Download PDF. You can also request a certified statement at any branch.
Is there a password on GTBank statement PDF?
GTBank statements downloaded from the GTWorld app or Internet Banking are typically not password-protected. Emailed statements may use your date of birth in DDMMYYYY format or the last 4 digits of your BVN as the password. Contact GTBank on 0700-GTBANK-8 (0700-482-6268) if unsure.
Is GTBank statement accepted for visa application?
Yes. GTBank is a CBN-licensed Nigerian bank and its statements are accepted at all major embassies and consulates in Nigeria. For most embassies, original certified PDFs (not Excel) should be submitted. The Excel is useful for personal verification of your balance before your embassy appointment.
Can I convert GTBank domiciliary account statement?
Yes. GTBank USD, GBP, and EUR domiciliary account statements are fully supported. Upload the PDF and our converter extracts all foreign currency transactions into clean Excel format, making it easy to track SWIFT receipts and outgoing transfers.
How do I get a certified GTBank statement?
Visit any GTBank branch with your account number and a valid government-issued ID (NIN slip, National ID, Driver's Licence, International Passport, or Voter's Card). Request a certified bank statement — it is printed, stamped, and signed by a bank officer. A fee applies; contact your branch for the current rate.
Can I import GTBank statement into QuickBooks?
Yes. Convert your GTBank PDF to Excel using our free tool. Then import the CSV into QuickBooks Online (via Bank Feeds → Upload CSV) or use it to manually reconcile transactions. Map Date, Narration, Debit, and Credit columns during the QuickBooks import wizard.
Does the converter work for GTBank Ghana?
Yes. GTBank Ghana (Guaranty Trust Bank Ghana) statements in GHS (Ghanaian cedi) are supported. Upload the PDF and our converter extracts all transactions into clean Excel format.
How accurate is GTBank statement conversion?
For digital GTBank statement PDFs from the GTWorld app or Internet Banking, accuracy is 99%+. All columns — Date, Narration, Debit, Credit, and Balance — are extracted faithfully. Verify against the original PDF for official use.
Ready to Convert Your GTBank Statement?
100% free · No signup · Works for Naira and Domiciliary accounts · Instant download
Convert Now — It's Free →