Re-keying a client's CBQ year by hand is the slowest part of any Qatar engagement. Convert each Commercial Bank of Qatar statement to a structured sheet — with reference numbers intact.
Convert a CBQ statementQatar engagements involve CBQ statements that are bilingual, QAR-denominated, and carry a transaction reference number on every row. Corporate statements add departmental sub-account rows. Manual re-keying is the biggest time sink, and losing a reference number breaks the audit trail you rely on during an inspection.
Kashfbank converts each statement to a clean spreadsheet with the columns you post from — Date, Description, Debit, Credit, Balance, Category — and keeps the reference number in the Description so every posted line stays traceable to the source transaction.
The running QAR balance lets you detect a gap that signals a missing statement page — critical for audit completeness. The reference number is your tie-out key: each posted entry can be matched back to the exact CBQ transaction. Salary credits reconcile against payroll; NAPS and card debits map to the chart of accounts.
Corporate clients often have departmental sub-account rows in one statement. Kashfbank keeps each row distinct with its reference number, so you can apply grouping logic to consolidate sub-accounts without losing the line-level audit trail.
Pull every debit and credit with the QAR amount, the reference number, and the running balance for completeness testing.
Structured bilingual PDF. Transaction reference number, date, description, debit, credit, and QAR running balance. Account header shows IBAN, account type, and period. Running balance updates after each transaction, convenient for reconciliation. Q-Pay/NAPS references for domestic; SWIFT for international.
| Label | Meaning |
|---|---|
| تحويل محلي | Domestic transfer (Q-Pay/NAPS) |
| راتب | Salary (WPS) |
| تحويل خارجي | Outward SWIFT transfer |
| دفع ببطاقة | Card purchase |
| رسوم سنوية | Annual account fee |
Rules in Qatar differ — see our country guide
Collect the client's CBQ PDFs
Gather the full-period statements from the client's CBQ Mobile Banking export or branch-issued PDFs.
Bulk upload to Kashfbank
Upload the period's PDFs. Each converts independently, labelled with its source filename so you can trace which month a transaction came from.
Reconcile and tie out
Apply your chart of accounts to the Category column. Use the reference number as the tie-out key. Check the running balance for gaps before relying on the data.
Export per client
Download each as a separate CSV for QuickBooks, Xero, or Zoho Books. Keep the original CBQ PDF as audit evidence.
Common challenges
Can I convert several clients' CBQ statements in one session?
Yes. Each upload is processed independently and labelled with its source filename. You can convert 10–20 PDFs across different clients and download each as a separate CSV.
Does the export keep CBQ's transaction reference numbers?
Yes. The reference number on each row is preserved in the Description column, giving you a stable tie-out key between your posted entries and the source CBQ transactions.
My client's CBQ corporate statement has departmental sub-accounts. Does that break the conversion?
No. Each row is extracted distinctly with its reference number. You apply grouping logic in Excel afterward to consolidate sub-accounts — the line-level audit trail stays intact.
How do I detect a missing statement page during audit?
Kashfbank preserves the running QAR balance. A break in the balance sequence between two rows signals a missing page, which you can flag for completeness before relying on the data.
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.
Upload PDF, get Excel in seconds
Try it free10 free credits on signup
Regulator: Qatar Central Bank (QCB)
Fiscal year: Jan 1 – Dec 31
Full country guide →Statement language: Arabic / English