KashfbankBank Statement Converter
DashboardPricingBanksBlog
Get started
HomeBanksQatar National Bank (QNB)Accountants
Qatar

QNB Statement to Excel for Qatar Accountants

QNB holds the majority of Qatari corporate banking. If you run a CA or audit practice in Doha, every client folder contains a QNB statement. Stop retyping it into Excel by hand.

Convert client statements

Qatar's accounting profession and the QNB statement

Qatar's accounting profession is smaller than Saudi or UAE but punches above its weight. The Big 4 dominate audit and tax advisory for the larger corporates and government-linked entities. Boutique firms and Qatari CA practices cover SMEs, free-zone companies in QFC and QSTP, and the family-business segment. Across all these tiers, QNB is the most common banking relationship — its corporate market share gives accountants a consistent input format to work with.

The 10% corporate tax on foreign-owned profit, the absence of VAT (so far), and the strong AML/KYC reporting culture mean the bank statement is central to compliance work. QNB's bilingual Arabic-English PDF is high quality, 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.

What the export looks like for accounting software

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

QNB's reference codes — NAPS, Q-Pay, SWIFT BIC, internal transaction IDs — are preserved in the Description column. This matters for matching against client-supplied supporting documents and for testing controls during audit fieldwork. A NAPS transfer to a vendor is not the same transaction as a card payment to the same vendor; the channel prefix tells the story.

Multi-subsidiary, multi-currency, and Big 4 workflows

Qatari corporates often hold accounts at QNB Qatar plus QNB AlAhli in Egypt or other regional subsidiaries. Each issuing country's statement is its own document with its own currency and format. Kashfbank treats them separately so your audit trial balance does not accidentally pool Egyptian and Qatari revenue.

  • QNB Qatar (QAR), QNB AlAhli Egypt (EGP), QNB Turkey (legacy, archived) — each as its own client file
  • Government-sector counterparty transfers — flagged for related-party disclosure if applicable
  • Letter of credit and trade finance entries — preserved with reference numbers for audit
  • FX conversion lines on multi-currency accounts — original currency retained on each row

Qatar National Bank (QNB) statement format

High-quality text-layer PDF with QNB Group branding. Bilingual Arabic-English. QAR balance column updates with each transaction. Account header: IBAN, account type, statement period, customer segment. Q-Pay and NAPS references appear for domestic transfers. SWIFT references for international.

LabelMeaning
راتبSalary credit (WPS)
تحويل NAPSQ-Pay / NAPS domestic transfer
تحويل خارجيOutward international transfer
سحب ATMATM withdrawal
دفع بطاقةDebit/credit card payment

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 QNB statement from QNB Mobile Banking or QNB Internet Banking for Business. For corporate tax work, this is annual. For monthly bookkeeping, it is monthly. For audit fieldwork, it is 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, set the Category column to the client's chart (Revenue, Cost of Sales, Operating Expense, Payroll, Bank Charges, FX, Related Party). For Big 4 audit, map to the audit account groupings instead. The first client takes 20 minutes; subsequent months are 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, ACL, or the firm's Excel-based sampling templates. The original QNB 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 handle QFC (Qatar Financial Centre) entities versus mainland Qatar entities?

Both bank at QNB and both produce the same QNB 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.

Can Kashfbank distinguish a NAPS internal transfer from a SWIFT international wire on the same statement?

Yes. NAPS, Q-Pay, and other domestic Qatari rail entries carry domestic references. SWIFT inbound and outbound wires carry the originating or beneficiary bank's BIC. Both are tagged distinctly in the Category column so your related-party and AML reviews can isolate cross-border flows.

What about QNB's investment-banking arm? Are brokerage statements supported?

QNB's standard retail and corporate banking statements are the primary format Kashfbank handles. Brokerage and asset-management statements use a different structure (holdings, transactions, P&L) and are not the same workflow. Use the corporate banking statement for cash-side accounting.

Other use cases for Qatar National Bank (QNB)

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 National Bank (QNB) overviewQatar banks guide

Convert Qatar National Bank (QNB) 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

QARUSD

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