Guaranty Trust Bank Statement to Excel Converter

ClearlyLedger converts Guaranty Trust Bank (Nigeria) PDF statements into clean Excel and CSV files. This guide covers the common GTBank pdf layout, DD/MM/YYYY dates and NGN amounts. Exports are released only when verification checks pass. Most GTBank statements (5–30 pages) finish in under 60 seconds with no signup required for your first file.

Last updated 2026-08-07

Read the GTBank source layout correctly

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

Date notation: DD/MM/YYYY. Money notation: ₦ NGN. Observed statement size: 5–30 pages.

Amounts are in Naira with a period decimal; session/reference IDs in the narration are retained.

Fields and row patterns found in Guaranty Trust Bank PDFs

The profile uses the bank-specific observations below as review checkpoints. They describe the source document rather than making a generic promise about every PDF:

  • GTBank checkpoint 1: Amounts use Nigerian numbering — values over 1 million common for NGN
  • GTBank checkpoint 2: Narration includes NIP (NIBSS Instant Payment) and NEFT references
  • GTBank checkpoint 3: Lodgements column used instead of Credits/Deposits
  • GTBank checkpoint 4: GTWorld mobile transfer entries include sender phone number in narration

Review the GTBank extraction

A typical Guaranty Trust Bank file runs 5–30 pages. Confirm its DD/MM/YYYY dates, NGN signs, first and final transactions, and page boundaries. Balance review is especially important on this layout. Amounts use Nigerian numbering — values over 1 million common for NGN. The PDF remains the source; the spreadsheet is the reviewable working copy.

  1. Upload the Guaranty Trust Bank PDF.
  2. Inspect the documented GTBank row patterns.
  3. Reconcile the NGN transaction math.
  4. Download verified GTBank Excel or CSV data.

Use the GTBank output in Nigeria

Excel suits source-document review and coding. CSV suits mapped imports into Sage, QuickBooks, Zoho Books or another bookkeeping system. Those routes preserve the DD/MM/YYYY interpretation and NGN values established from the Guaranty Trust Bank source.

GTBank privacy and retention

The GTBank PDF is processed in memory and deleted after conversion. The GTBank transaction data is not used to train AI models. TLS protects the upload in transit, while the workflow is designed around Nigeria's NDPA 2023 for Nigeria account holders.

GTBank conversion FAQ

Which GTBank statement layouts can ClearlyLedger convert?

Guaranty Trust Bank statements typically arrive as PDF with Date, Narration, Value Date, Withdrawals, Lodgements, Balance. ClearlyLedger's GTBank profile reads that layout, plus scanned and password-protected exports, and reconstructs Date, Description, Debit, Credit and Balance columns.

How does ClearlyLedger handle GTBank-specific quirks?

This guide highlights common GTBank statement characteristics — for example: Amounts use Nigerian numbering — values over 1 million common for NGN. The conversion is released only after its verification checks pass.

Can I import a converted GTBank statement into Sage?

Yes. Export to CSV and import into Sage, QuickBooks, Zoho Books or any tool that accepts a transaction file. The DD/MM/YYYY dates and NGN amounts are normalised so the import maps cleanly.

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