How to Convert First Bank Nigeria Statements to Excel

Quick Answer: To convert a First Bank Nigeria statement PDF to Excel or CSV, log in to FirstBank Online at firstbanknigeria.com, download your statement as PDF, then upload it to [QuickBankConvert](/) — instant, browser-based conversion with no data sent to any server and no account required.

Why First Bank Customers Need Statement Conversion

First Bank of Nigeria is one of the oldest and largest banks in Africa, with over 130 years of history and more than 15 million customers. Despite its modern digital banking infrastructure — including FirstBank Online and the FirstMobile app — statement downloads for personal and most business accounts are PDF-only.

This PDF-only format creates real friction for Nigerian customers who need to work with their financial data digitally:

• Entrepreneurs and SME owners applying for loans from fintechs like Carbon, Migo, or traditional CBN-licensed MFBs need clean 6-month statements in structured format
• Accountants and bookkeepers processing client transactions for FIRS compliance need importable data
• Individuals tracking personal finances who want to analyze spending in Excel or categorize transactions for budget management
• Corporate finance teams reconciling bank transactions with their ERP systems or accounting software
• Diaspora customers managing NGN accounts remotely who need digital records

Converting First Bank statement PDFs to Excel or CSV takes the data out of the printable document and puts it into a format that can be analyzed, imported, and acted upon. This guide explains the full workflow.

How to Download Your First Bank Statement

Downloading via FirstBank Online (Desktop)

1. Go to firstbanknigeria.com and click Internet Banking Login.
2. Log in with your username and password (or OTP if required).
3. From the dashboard, select your account.
4. Navigate to Account Statement or Transaction History.
5. Set your date range (up to 12 months typically available).
6. Click Download or Generate Statement and save as PDF.

Callout — Monthly E-Statement Emails: If you're enrolled in First Bank's paperless e-statement service, your monthly statements are emailed to your registered address. These PDF attachments can be uploaded directly to QuickBankConvert without logging into online banking. Check your inbox (and spam folder) for statements you may already have.

Downloading via FirstMobile App

1. Open the FirstMobile app on iOS or Android.
2. Log in and select your account.
3. Tap Statements or Account Statement.
4. Choose your date range and download the PDF.
5. Transfer the file to your computer for conversion.

First Bank Branch Statement Request

For statements older than 12 months or certified statements for official purposes (loan applications, legal proceedings):

• Visit any First Bank branch with valid government ID
• Fill out a statement request form
• Processing typically takes 3–7 business days
• Fees apply for certified statements (check with your branch for current rates)

Converting First Bank PDF to Excel or CSV

Step 1: Open QuickBankConvert

Visit [QuickBankConvert.com](/) in any modern browser — Chrome, Firefox, Safari, or Edge. No registration, no subscription needed.

Step 2: Upload Your First Bank PDF

Drag and drop your First Bank statement PDF onto the upload area. QuickBankConvert processes everything in your browser — the PDF is never uploaded to any external server, keeping your financial data private.

Step 3: Preview Extracted Transactions

A data preview will appear showing your extracted transactions. Verify that dates, transaction narrations (including NIBSS, NIP, and USSD references), and NGN amounts look correct.

Step 4: Select Output Format

• CSV — Best for importing into Sage, QuickBooks Online, Wave, or any Nigerian accounting tool
• Excel (XLSX) — Best for direct spreadsheet work, pivot tables, or budget analysis

Step 5: Download and Use Your Data

Click download and open in your preferred application.

Callout — Naira Currency in Excel: After conversion, NGN amounts appear as clean numbers. To add Nigerian Naira formatting in Excel: select the amount column, press Ctrl+1, go to Number → Currency, and type ₦ as the symbol (or use Custom format ₦#,##0.00). This is cosmetic and doesn't affect formula calculations.

First Bank-Specific Formatting Challenges

Nigerian Payment System References

First Bank statement descriptions include references to Nigerian interbank systems. Common codes include:

• NIBSS — Nigeria Inter-Bank Settlement System transfers
• NIP — NIBSS Instant Payments (interbank transfers)
• USSD — Transactions initiated via *894# or similar USSD codes
• POS — Point of Sale terminal transactions
• ATM — Cash withdrawals via ATM
• RTGS — Real-Time Gross Settlement (large value transfers)

These codes appear as part of the narration field and are preserved as-is in your converted output — valuable for audit trails.

Date Format

First Bank statements typically use DD/MM/YYYY or DD-Mon-YYYY date formatting. QuickBankConvert correctly identifies both.

Column Structure

First Bank account statement format:

Date | Transaction Description | Debit (₦) | Credit (₦) | Balance (₦)

The debit and credit columns are separate, consistent with most Nigerian bank statement formats. QuickBankConvert preserves this structure in the output.

NGN Amount Formatting

Amounts use standard comma grouping (₦1,250,000.00). The ₦ symbol or "NGN" prefix is stripped during conversion to output clean numeric values.

Opening Balance Row

First Bank statements typically include an opening balance row at the top of the statement. QuickBankConvert identifies and handles this row — it's preserved in the output as it's useful for reconciliation.

First Bank Export Format Comparison

Importing into Accounting Software

Sage Business Cloud (Nigeria)

Sage is widely used by Nigerian SMEs and accountancy firms. Import your converted First Bank CSV via Sage's bank import function. Map Date, Description, Debit, and Credit columns. Sage handles NGN natively.

QuickBooks Online

Go to Banking → Upload from File in QuickBooks Online, upload your CSV, and map columns. QuickBooks will suggest categories based on your transaction history and existing rules.

Wave Accounting

Wave is popular with Nigerian freelancers and small businesses due to its free tier. Import your First Bank CSV via Accounting → Transactions → Import. Map Date, Description, and Amount columns. Wave supports NGN.

Microsoft Excel for FIRS Returns

For self-employed individuals and sole proprietors preparing annual self-assessment returns for FIRS, Excel with a converted First Bank CSV is often sufficient. Use SUMIF formulas to total income (credits) and deductible expenses (debits) by category. Save as XLSX as your working documentation.

Special Use Case: First Bank Corporate Account Reconciliation

First Bank is a major bank for Nigerian corporates, NGOs, and government entities. Corporate finance teams often need to reconcile First Bank current account transactions with their ERP data (SAP, Oracle, Sage 300). Converting monthly First Bank PDFs to CSV enables:

• Automated bank reconciliation by importing CSVs into reconciliation tools
• ERP journal entry creation by mapping bank transactions to GL codes
• Audit documentation by providing auditors with structured transaction files
• Multi-month consolidation by merging several monthly CSVs into a single annual dataset

For organizations with high transaction volumes, converting and processing First Bank statements in Excel or CSV is significantly faster than manual reconciliation from PDFs.

Bottom Line

Converting First Bank Nigeria statement PDFs to Excel or CSV is a straightforward two-step process: download from FirstBank Online or the FirstMobile app, then convert with [QuickBankConvert](/) for clean, structured output. The entire workflow takes under two minutes.

First Bank PDFs include Nigerian payment system codes, NGN formatting, and debit/credit column layouts — all handled correctly by QuickBankConvert. The output works in Excel, Google Sheets, Sage, QuickBooks Online, and Wave.

Whether you're managing personal finances, running a business, preparing for a FIRS audit, or applying for a loan, converting your First Bank Nigeria statement from PDF to spreadsheet format gives you immediate control over your financial data.