KashfbankBank Statement Converter
DashboardPricingBanksBlog
Get started
HomeBanksQatar Islamic Bank (QIB)Accountants
Qatar

QIB Statement to Excel for Qatar Accountants

QIB is Qatar's largest Islamic bank and the banking choice for Sharia-compliant SMEs. Stop retyping its statements. Bulk-convert your client folder — Murabaha, Ijara, and Wakala labels preserved.

Convert client statements

Qatar's accounting profession and the QIB statement

Qatar's accounting profession is led by the Big 4 for audit and tax advisory among large corporates and government-linked entities, with boutique Qatari CPA firms covering SMEs, free-zone companies in QFC and QSTP, and the family-business segment. Among Sharia-compliant clients — and there are many in Qatar — QIB is the dominant banking relationship. Every Islamic SME folder, every Murabaha-financed Qatari trading business, and a meaningful share of expatriate Muslim professionals will produce a QIB statement at year-end.

The 10% corporate tax on foreign-owned profit, the absence of consumer VAT (so far), and Qatar's AML reporting culture mean the bank statement is central to compliance work. QIB's bilingual PDF is well-structured but it is still a PDF. Bookkeeping software, audit working papers, and tax returns all need structured data. Kashfbank does the bridge in under a minute per client and preserves the Islamic product labels that drive classification.

What the export looks like for accounting software

Kashfbank exports a standard CSV: Date (DD/MM/YYYY), Description (full QIB bilingual narration with Islamic product type), Debit, Credit, Balance, Category, Currency. The CSV maps to Zoho Books, QuickBooks Online, Xero, and Sage 50 with at most one column reorder on first import. For Big-4-led audit work in Qatar, the same CSV feeds into IDEA, ACL, and Excel sampling templates.

QIB reference codes — SWIFT BICs, NAPS references, internal transaction IDs — are preserved in the Description column. Murabaha repayments, Ijara payments, and Wakala / Mudaraba profit distributions carry their Arabic product labels intact. This is what drives correct classification: Islamic Financing for Murabaha and Ijara (financing cost), Investment Income for Wakala and Mudaraba (not revenue, not operating expense).

Bulk processing and Islamic finance categorisation

QIB-banked clients often have profit-distribution entries with a value date different from the posting date — Wakala and Mudaraba returns settle weeks after they post. Kashfbank preserves both dates. For accrual-basis audit work this is essential; for cash-basis bookkeeping it is informational. Either way, the data is in the export.

  • Each client PDF converted independently and labelled with filename
  • Murabaha and Ijara tagged Islamic Financing — financing cost, not operating expense
  • Wakala and Mudaraba tagged Investment Income — separate from revenue
  • Both posting date and value date preserved on profit distributions
  • Related-party transfers preserved with IBAN and SWIFT BIC for disclosure

Qatar Islamic Bank (QIB) statement format

Formally structured bilingual A4 PDF. Islamic product type prominently labeled in narration column. QAR balance updates after each row. Comprehensive account header: IBAN, product type (Current/Savings-Mudaraba/Investment), statement period, customer segment. Sharia board certification reference on footer.

LabelMeaning
مرابحةMurabaha financing repayment
إجارةIjara lease payment
وكالةWakala investment
راتبSalary (WPS)
تحويل فوريInstant transfer

Qatar specifics for this use case

Rules in Qatar differ — see our country guide

How to do it — step by step

1

Collect client PDFs

Have each client export their QIB statement from QIB Mobile or QIB Internet Banking for Business. For corporate tax work, this is annual. For monthly bookkeeping, monthly. For audit fieldwork, 12 months plus the year-end cut-off statement.

2

Bulk upload by client

Upload all of one client's PDFs in a session. Each file is converted independently and labelled with its filename. Multi-month merges happen in Excel after export — Kashfbank preserves the chronology, you assemble the year.

3

Apply chart of accounts

Open each CSV and set the Category column to the client's chart (Revenue, Cost of Sales, Operating Expense, Payroll, Islamic Financing, Investment Income, Bank Charges, Related Party). For Big 4 audit, map to the audit account groupings instead. First client takes 20 minutes; subsequent months 5.

4

Import to bookkeeping or working papers

Push the categorised CSV into Zoho Books, QuickBooks, Xero, or Sage. For audit work, drop it into IDEA or ACL. The original QIB PDF stays in the client folder as the source document.

Common challenges

  • •GCC statements in Arabic with Hijri dates requiring dual-date output (Hijri + Gregorian)
  • •Scanned statements with low OCR quality — common in older Egyptian and Lebanese bank PDFs
  • •Multi-page statements where the bank splits across quarterly or monthly PDFs requiring merge
  • •Statements with running balance gaps that signal missing pages (critical for completeness in audit)

Frequently asked questions

Do Qatar's record-retention rules require keeping the original PDF, the Excel export, or both?

Both. The original bank-issued PDF is the canonical source document and must be retained for the regulator-set period (typically five to seven years depending on entity type). The Excel export is a working paper. Keep them together in the client folder.

How does Kashfbank treat Wakala and Mudaraba profit distributions for revenue recognition?

They are tagged Investment Income, separate from operating revenue. Both posting date and value date are preserved in the export. Your accrual-basis client will care about the value date; your cash-basis client will use the posting date. Both are available.

Can Kashfbank distinguish a Murabaha repayment from a regular QIB service fee?

Yes. Murabaha and Ijara carry their Arabic product labels in the narration. Service fees and account charges sit in a separate category. The Category column makes both visible at a glance — financing cost versus bank fee, treated differently in any tax framework.

What about QFC (Qatar Financial Centre) entities banking at QIB?

QFC entities can bank at QIB and produce the same QIB statement format. The QFC has its own commercial law regime and tax framework, but the bank statement format does not change. Your audit or tax categorisation is what differs, not the extraction.

Other use cases for Qatar Islamic Bank (QIB)

Freelancers

Extract, categorize, and export freelance income and expenses from PDF bank statements — ready for 1099, self-assessment, or ZATCA filings.

Tax Preparation

Convert PDF bank statements to clean spreadsheets for Zakat, VAT, corporate tax, and self-assessment filings across GCC and international markets.

Loan Applications

Prepare clean, lender-ready bank statement exports that prove stable income and responsible financial behavior for personal and business loan applications.

Qatar Islamic Bank (QIB) overviewQatar banks guide

Convert Qatar Islamic Bank (QIB) Statement

Upload PDF, get Excel in seconds

Try it free

10 free credits on signup

Regulatory context

Regulator: Qatar Central Bank (QCB)

Fiscal year: Jan 1 – Dec 31

Full country guide →

Statement info

QAR

Statement language: Arabic / English

Kashfbank

Turn your bank statement into a spreadsheet in seconds.

العربيةEnglish

Product

  • Dashboard
  • Pricing
  • Banks
  • Blog
  • RSS

Resources

  • All Banks
  • Saudi Arabia Banks
  • UAE Banks
  • PDF to CSV
  • PDF to Excel
  • SAR Statement to Excel
  • AED Statement to Excel
  • Blog
  • Pricing

Legal

  • Privacy Policy
  • Terms of Service
  • Contact

© 2026 Kashfbank. All rights reserved.

Powered by AI