Convert GTBank statements to Excel

GTBank statements often use Withdrawals and Lodgements columns with long GTWorld, NIP and NEFT references. ClearlyLedger turns the PDF into accountant-ready Excel or CSV while preserving the narration needed for reconciliation.

Last updated 2026-06-05

What GTBank-specific extraction does ClearlyLedger handle?

The converter maps Lodgements to credits, Withdrawals to debits and keeps value-date or reference text attached to the correct row.

GTWorld mobile transfer details, sender phone numbers and NIP references are useful audit context, so they are kept in the exported description instead of discarded.

When should I use Excel versus CSV output?

Use Excel for audit packs, cash-flow review and lender evidence. Use CSV when importing transaction rows into Xero, QuickBooks or another bookkeeping workflow.

Balance checks help catch dropped page-boundary rows before download.

Does ClearlyLedger verify the balance on every GTBank export?

Yes. ClearlyLedger checks that the opening balance plus Lodgements minus Withdrawals reconciles to the closing balance printed on the statement. A file that fails this check is flagged before download rather than exported with a silent gap.

This catches the case where a page-boundary row or a wrapped GTWorld reference line gets misread as part of the previous transaction.

Is my GTBank statement data kept private?

Your GTBank PDF is processed in memory and deleted within 60 seconds of upload. No transaction data is stored in a database or used to train AI models.

All transfers are TLS-encrypted in transit.

Guaranty Trust Bank source profile used by this guide

Printed statement structure: PDF with Date, Narration, Value Date, Withdrawals, Lodgements, Balance

Source conventions: DD/MM/YYYY dates, ₦ NGN amounts, and 5–30 pages.

GTBank observations to sample during review

  • Founded in 1990, GTBank restructured in 2021 into GTCO (Guaranty Trust Holding Company), splitting the banking business out from its payments, pension and asset-management subsidiaries under one holding company — a structure several other large Nigerian banks have since copied
  • Amounts use Nigerian numbering — values over 1 million common for NGN
  • Narration includes NIP (NIBSS Instant Payment) and NEFT references
  • Lodgements column used instead of Credits/Deposits
  • GTWorld mobile transfer entries include sender phone number in narration

These GTBank details identify the rows most likely to need inspection after extraction. Review the first and final transaction, each PDF page boundary, and any row affected by the observations above before using the spreadsheet in an accounting import.

Related workflows

Continue from this guide into the matching converter, accounting import, security, or country hub pages so crawlers and readers can follow the full workflow.

Frequently asked questions

Can ClearlyLedger convert GTBank lodgements to credits?

Yes. GTBank's Lodgements column is exported as Credit, while Withdrawals become Debit.

Are GTWorld and NIP references preserved?

Yes. The parser keeps mobile transfer and NIP reference details in the Description field for reconciliation.

Related ClearlyLedger resources

Use these canonical pages to compare formats, verify data handling, and move from PDF extraction into accounting review.

Loading interactive converter… Try ClearlyLedger free