Skip to content
StatementPilot

Nigeria

Convert bank statements in Nigeria

Statement formats, date and amount conventions and accounting imports for banks in Nigeria.

Quick answer

StatementPilot converts statements from any bank in Nigeria into Excel, CSV, QBO, OFX or QIF. Dates default to DD/MM/YYYY, amounts are read in naira (NGN), and exports are ready for QuickBooks Online, Zoho Books, Sage.

Banks in Nigeria

How statements in Nigeria are laid out

Nigerian statements list Trans. Date, Value Date, Narration, Debit, Credit and Balance and often include stamp duty and SMS alert charges.

Amounts and dates

Amounts use 1,234.56 with separate Debit and Credit columns; transfer narrations include NIP references.

The usual date format is DD/MM/YYYY. When a statement is ambiguous we use the statement period and other rows to decide the order.

Account identifiers

Accounts are identified by a 10-digit NUBAN.

Accounting software

The most common destinations in Nigeria are QuickBooks Online, Zoho Books, Sage, Excel. Every export format is included on every plan.

Why statements still matter

Statements are routinely required for visa, loan and tenancy applications.

Frequently asked questions

Does the converter support NGN statements?

Yes. Amounts in naira are read with the local number format and the currency is carried into Excel, OFX and QBO exports.

What if my bank in Nigeria isn't listed?

Upload it anyway — there are no bank templates. The reconciliation check confirms whether every transaction was captured.

Which date format will my export use?

Excel and OFX use real dates. For CSV and QIF you can choose MM/DD/YYYY or DD/MM/YYYY at export time; DD/MM/YYYY is typical in Nigeria.

Convert your first statement in under a minute

20 free pages every month. No credit card. Every export format included.