Egyptian accounting practices process QNB Al Ahli statements for SMEs, professionals, deposit holders, and Egyptian expatriates. Convert each PDF to a clean CSV and import into your tool.
Convert your client's statementQNB Al Ahli is one of Egypt's larger private banks by retail metrics and a common business account for SMEs and professional service firms in Cairo and Alexandria. Your client intake regularly includes QNB Al Ahli PDFs — current account, savings, and time deposit statements, sometimes combined into one multi-section file. Each section has its own column layout, and a copy-paste workflow loses the structure.
The biggest time drain in any Egyptian bookkeeping workflow is rekeying transactions from PDF into Excel or directly into the accounting tool. A QNB Al Ahli statement for an active SME can run 30 to 100 pages over 12 months. Across a practice with 20, 50, or 100 clients, the manual work is hours per month per accountant. Kashfbank converts each statement to a structured CSV in under a minute.
QNB Al Ahli's standard statement is a bilingual Arabic-English PDF with the QNB Group header on page one. Columns: Date, Description, Debit (EGP), Credit (EGP), Balance (EGP). Multi-product accounts produce section dividers per product type — current, savings, time deposit. Internet banking and mobile transactions carry 'IB' or 'MOB' codes; these are useful for channel-based categorisation in the bookkeeping tool.
FX-to-EGP remittances are common in QNB Al Ahli statements given the QNB Group's regional presence. These appear in the credit column already in EGP, converted at the CBE rate on the value date. The original currency may be referenced in the narration. For accounting purposes the EGP figure is what posts to the books; the original currency reference is useful only for invoice reconciliation.
Bookkeeping and audit working papers pull a specific set of rows from the QNB Al Ahli statement. Income, expenses, tax payments, and FX-converted inbound transfers.
Bilingual Arabic-English PDF. Columns: date, description, debit (EGP), credit (EGP), balance (EGP). Account header shows QNB Group branding, Egyptian bank name, IBAN, account type, branch, and statement period. Online and mobile banking transactions have channel identifiers in the narration ('IB', 'MOB'). Multi-product accounts may generate multi-page statements with section dividers per product type.
| Label | Meaning |
|---|---|
| IB Transfer | Transfer executed via QNB Al Ahli internet banking |
| MOB Transfer | Transfer executed via QNB Al Ahli mobile app |
| POS | Point-of-sale purchase |
| Time Deposit | Fixed deposit placement or maturity credit |
| Salary | Monthly salary credit |
Rules in Egypt differ — see our country guide
Collect 12 months of client statements
Most ETA annual returns and corporate filings need 12 months. Request the bilingual PDF from each client, or have them pull from QNB Al Ahli Mobile or internet banking. If the client holds multi-product accounts, the PDF may include section dividers — keep them together.
Upload each client file independently
Drop each PDF into Kashfbank. The file is processed independently and labelled with its source filename. Across a session you can run 10 to 20 client statements without losing track of which file is which.
Download the CSV and import into your tool
The CSV uses standard columns: Date, Description, Debit, Credit, Balance, Category, Currency. Bisan, MS Dynamics, QuickBooks (for international clients), and Zoho Books all accept this format with at most a minor date format tweak. EGP precision is preserved.
Reconcile against the trial balance
For corporate clients, run the imported transactions against the trial balance. The closing balance on the QNB Al Ahli statement should match the bank GL account at the same date. Discrepancies usually point to unrecorded bank transactions or pending entries on the books.
Common challenges
How does the export handle multi-product statements with section dividers?
QNB Al Ahli multi-product statements include section dividers between current, savings, and time deposit. Kashfbank treats each section as part of the same statement but keeps the structure visible — section headers remain in the Description column or as a marker row. For the trial balance, you typically map each section to its own GL account.
Can the practice process statements from many clients in a single session?
Yes. Each upload is processed independently and labelled with the source filename. The Kashfbank session can run 10 to 20 client PDFs without mixing data. Each export downloads as its own CSV file.
Does the export distinguish IB vs MOB channel transactions?
Yes. Channel codes (IB, MOB) appear in the Description column as the bank wrote them. For bookkeeping categorisation, you can filter the IB-tagged rows for internet banking transactions and MOB for mobile app transactions — useful for some businesses tracking digital channel activity separately.
How are FX-to-EGP remittances posted for an Egyptian SME client?
The EGP credit figure is what posts to the books — that is the bank's applied EGP conversion at the CBE rate on the value date. The original foreign-currency invoice amount and the EGP receipt may differ slightly from the invoice value depending on the rate movement between invoice date and value date; that difference is FX gain or loss, posted separately.
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: Central Bank of Egypt (CBE)
Fiscal year: Jul 1 – Jun 30 (government); Jan–Dec (private sector)
Full country guide →Statement language: Arabic / English