How to Convert GTBank Statements to CSV or Excel

Quick Answer: To convert a GTBank (Guaranty Trust Bank) statement PDF to CSV or Excel, log in to GTBank Internet Banking or the Habari app, download your statement as PDF, then upload it to [QuickBankConvert](/) — free, browser-based conversion with no data sent to any server.

Why GTBank Customers Need Statement Conversion

GTBank (now rebranded as Guaranty Trust Holding Company — GTCO) is one of Nigeria's most prominent commercial banks, serving millions of retail customers, SMEs, and corporates across West Africa. GTBank is known for its technology-forward approach, with the Habari super-app and robust Internet Banking. Despite this, statement downloads for personal accounts remain PDF-only — a gap that creates real friction for Nigeria's growing digital economy.

The demand for CSV and Excel-format bank statements in Nigeria is high and growing. Entrepreneurs applying for loans from fintechs or microfinance banks need clean 6-month statement exports. Accountants processing client books for FIRS (Federal Inland Revenue Service) compliance need importable transaction data. Freelancers earning in foreign currency need to reconcile USD or GBP transactions with their NGN expenses. E-commerce sellers on Jumia or Jiji need monthly transaction summaries for business tracking.

Manual data entry from GTBank PDFs is slow, error-prone, and unnecessary. QuickBankConvert converts GTBank statement PDFs to clean CSV or Excel files in seconds — handling Nigerian naira formatting, GTBank's column layout, and the transaction description codes that are specific to Nigerian banking.

How to Download Your GTBank Statement

Downloading via GTBank Internet Banking (Desktop)

1. Go to ibank.gtbank.com and log in with your GTBank credentials.
2. Select your account from the dashboard.
3. Click on Account Statement or View Transactions.
4. Select your date range (typically up to 12 months available online).
5. Click Download or Print Statement and save as PDF.

Callout — E-Statement via Email: GTBank sends monthly e-statements to your registered email address. These PDF attachments arrive automatically and can be used directly with QuickBankConvert — no need to log into Internet Banking for monthly statements you're already receiving.

Downloading via Habari App (Mobile)

GTBank's Habari app provides account management and statement access on iOS and Android:

1. Open the Habari app and log in.
2. Tap Accounts and select your account.
3. Tap Statement and choose your date range.
4. Download the statement as PDF and transfer to your computer for conversion.

GTBank Branch Statement Request

For statements beyond the online history window (typically more than 12 months), visit any GTBank branch with valid ID and your account details. Request a certified account statement. Processing time is typically 2–5 business days and may involve a fee.

Converting GTBank PDF to CSV or Excel

Step 1: Open QuickBankConvert

Visit [QuickBankConvert.com](/) in any browser. No registration required, no software to install.

Step 2: Upload Your GTBank PDF

Drag and drop your downloaded GTBank statement PDF onto the upload area. QuickBankConvert processes the file entirely in your browser — your transaction history is never sent to a server.

Step 3: Preview the Extracted Data

Review the preview of extracted transactions. Check that dates, transaction descriptions (including USSD codes, NIP transfers, and POS references), and NGN amounts are parsed correctly.

Step 4: Choose Your Output Format

• CSV — Best for importing into Sage, QuickBooks, or Nigerian accounting platforms like AccountEdge
• Excel (XLSX) — Best for direct analysis, pivot tables, or budget tracking in Microsoft Excel or Google Sheets

Step 5: Download and Open

Download your converted file and open it in your preferred application.

Callout — NGN Currency in Excel: After conversion, Naira amounts appear as plain numbers. To apply NGN formatting in Excel: select the amount column, press Ctrl+1, choose Currency, and type ₦ in the symbol box (or use the Custom format ₦#,##0.00). This formatting is cosmetic and doesn't affect your data.

GTBank-Specific Formatting Challenges

Transaction Description Codes

GTBank statement PDFs include transaction reference codes that are specific to Nigerian interbank systems — NIP (NIP transfers), USSD (mobile banking codes), POS terminal IDs, and GTCollect references. These appear as part of the Narration/Description field and are preserved as-is during conversion. They're valuable for audit trails and reconciliation.

Date Format

GTBank statements commonly use DD-Mon-YYYY format (e.g., 05-Aug-2024) or DD/MM/YYYY. QuickBankConvert correctly identifies both formats.

Naira Comma Formatting

Nigerian Naira amounts in GTBank statements use standard Western comma grouping (e.g., ₦1,250,000.00) rather than lakh notation. This is consistent with most international converters, but the ₦ symbol and "NGN" currency code need to be stripped for clean numeric output.

Debit/Credit/Balance Column Layout

GTBank current and savings account statements use this structure:

Date | Narration | Reference | Value Date | Withdrawal | Lodgment | Balance

QuickBankConvert preserves this column structure, outputting Withdrawal (debit) and Lodgment (credit) as separate columns — matching the GTBank original.

Foreign Currency Accounts

GTBank offers Dollar Flex accounts and Euro savings accounts. Statements for these accounts list amounts in USD or EUR and convert normally — no currency conversion is performed. If you need NGN equivalents, you'll need to add a conversion column manually using the exchange rate applicable on each transaction date.

GTBank Export Format Comparison

Importing into Nigerian Accounting Tools

Sage Business Cloud (Nigeria)

Sage is widely used by Nigerian SMEs and accounting firms. After converting your GTBank statement to CSV with QuickBankConvert, use Sage's bank import function to upload the CSV and map the Date, Description, Debit, and Credit columns. Sage handles NGN natively.

QuickBooks Online

QuickBooks Online supports CSV imports under Banking → Upload from File. Map columns and QuickBooks will auto-categorize transactions it recognizes. This is a popular choice for Nigerian tech startups and e-commerce businesses.

Wave Accounting

Wave is free accounting software popular among Nigerian freelancers and solopreneurs. It supports bank statement CSV imports via Accounting → Transactions → Import. Map your GTBank CSV columns to Wave's expected format (Date, Description, Amount).

Google Sheets for FIRS Documentation

For individuals and sole proprietors preparing for FIRS audits or self-assessment tax filings, Google Sheets is a flexible option. Import your converted GTBank CSV, add a category column, and use SUMIF to total income and expenses by category for your annual tax return.

Use Case: Loan Application Statement Requirements

One of the most common reasons Nigerian GTBank customers need statement conversion is loan applications. Fintechs like Carbon (PayLater), FairMoney, Branch, and traditional banks often require 6-month bank statements in PDF or CSV format for credit assessment.

While the PDF is sufficient for submission, having a CSV or Excel version lets you:

• Quickly verify that your average monthly balance meets the lender's minimum requirements
• Calculate your average monthly income (credits) and expenses (debits) before applying
• Identify large irregular transactions that might need explanation to the lender
• Create a clean transaction summary to attach to your application

Converting your GTBank statement to Excel before a loan application gives you a data advantage that helps you present your financials clearly.

Bottom Line

Converting GTBank statement PDFs to CSV or Excel is straightforward: download from GTBank Internet Banking or Habari, then convert with [QuickBankConvert](/) for clean, structured output. The process takes under two minutes.

GTBank PDFs include Nigerian-specific formatting — NIP and USSD transaction codes, NGN currency, and Withdrawal/Lodgment column layouts — all of which QuickBankConvert handles correctly. The output works in Excel, Google Sheets, Sage, QuickBooks Online, and Wave.

Whether you're an SME owner tracking expenses, a freelancer preparing tax returns, or a professional applying for a loan, converting your GTBank statement from PDF to spreadsheet format gives you the data control you need.