QIB statement to Excel

Qatar Islamic Bank adds a Reference column to its statements, between the description and the amounts. StatementEasy keeps it as its own column next to the date, description, debit, credit and balance, and checks every balance.

Download your QIB statement

1. Sign in to the QIB app or QIB Internet Banking.
2. Open the account and choose Statement.
3. Download the PDF.
4. Drop it into the converter above.

QIB columns in your sheet

On the statement	In your sheet
Reference	Reference, its own column
Debit / Credit	Money out / money in
Balance	Checked on every row

Matching payments to invoices

Search the sheet for a customer’s reference to see which invoices are paid; the CSV or OFX export carries the references into accounting software.

Financing instalments

Car and home financing instalments recur every month; the Recurring sheet totals them for the year.

Zakat and year-end balances

If you calculate zakat, the Monthly sheet gives the balance at the end of every month of the year. The converter does not work out zakat for you, but it puts the numbers in one place.

Asking the bank about a payment

Quote the reference from the sheet and the bank can find the transaction at once, without a long description.

An example line

14/03/2025 OOREDOO POSTPAID FT25073XK2 315.00 9,210.45 becomes reference FT25073XK2, money out 315.00, balance 9210.45.

Last tested October 2026. StatementEasy is not affiliated with Qatar Islamic Bank (QIB).