Egypt's tax authority wants gross income, deductible expenses, and tax already paid — all visible in your QNB Al Ahli statement. Pull it into Excel in seconds.
Convert your QNB Al Ahli statementQNB Al Ahli — rebranded in 2013 from National Société Générale Bank Egypt and now part of the QNB Group — serves a wide retail and SME base in urban Egypt, with particular strength among upper-middle-class professionals and Egyptians with Gulf employment connections. The bank's multi-product accounts (current, savings, time deposit) and the QNB Group's regional presence mean statements often carry FX-to-EGP remittances alongside domestic salary and POS rows.
Egypt's tax rules are layered: 14% VAT on most goods and services, 22.5% flat corporate income tax, progressive personal income tax up to 27.5%, and 20% withholding on time deposit interest deducted at source. A converted QNB Al Ahli statement lets you separate gross income, deductible business expenses, VAT-inclusive merchant spend, and pre-paid tax in one pass.
QNB Al Ahli issues a bilingual Arabic-English PDF with QNB Group branding in the header. Columns: Date, Description, Debit (EGP), Credit (EGP), Balance (EGP). Internet banking and mobile transactions carry channel identifiers in the narration — 'IB' for internet banking, 'MOB' for the mobile app. Multi-product accounts may produce statements with section dividers per product type (current, savings, time deposit).
Time deposit interest is credited net of the 20% withholding tax. The statement shows the net amount; the gross figure required for some return calculations is the net divided by 0.80. For Egyptians with Gulf employment, USD or AED remittances arrive as inbound credits with FX-to-EGP conversion applied at the CBE rate on the value date — this is the taxable receipt for residents.
Match what the ETA expects on the personal income form, the corporate return, and the VAT return. QNB Al Ahli's statement format makes most lines extractable; FX-to-EGP remittance rows and net-of-withholding interest entries need a second look.
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 |
Egyptian corporate tax at 22.5% requires quarterly advance payments; converted statements showing quarterly income help CPAs calculate accurate installment amounts to avoid penalties.
Pull the right period from QNB Al Ahli Mobile
Egyptian personal returns cover Jan–Dec. Corporate returns may be fiscal or calendar. Request a QNB Al Ahli statement covering your full filing period. If you hold both current and time deposit products, request both — they appear in sections of the same PDF or as separate files.
Upload and confirm currency tagging
Kashfbank tags each row with its currency. EGP rows stay EGP; FX inbound rows are visible with the EGP-converted amount in the credit column. The CBE rate used by the bank for the conversion is implicit in the EGP figure — for tax purposes that is the taxable EGP amount.
Filter by category for each form
Income lines for the income section. POS مشتريات for the VAT input section. ETA outbound payments for the pre-paid tax credit. Time deposit interest with the gross-up calculation. The Excel export's Category column makes this filtering one or two clicks.
Hand off to your accountant
Share the CSV with your ETA-registered accountant. The standard column layout (Date, Description, Debit, Credit, Balance, Category) imports cleanly into the tools Egyptian accounting practices use — Bisan, MS Dynamics, QuickBooks for international clients.
Common challenges
Does QNB Al Ahli show the 20% withholding on time deposit interest?
QNB Al Ahli credits time deposit interest net of withholding — the 20% is deducted at source. To report gross interest, divide the credited amount by 0.80. Kashfbank preserves the net figure exactly as printed; the gross-up is a manual calculation that your accountant runs for the return.
I receive remittances from Qatar through QNB Group. Are those taxed in Egypt?
For Egyptian tax residents, worldwide income is taxable. Salary remittances from employment in Qatar arrive at QNB Al Ahli converted to EGP at the CBE rate on the value date. That EGP figure in the credit column is the taxable receipt. If you are a resident of Qatar and not Egypt for tax purposes, the residency rules are different — confirm your status with your accountant.
My QNB Al Ahli statement spans the 2022–2024 EGP devaluations. How does that affect the return?
Each transaction stays at its transaction-date EGP value. The ETA looks at amounts at the time each entry occurred, not at a year-end exchange rate. Kashfbank preserves the original transaction-date EGP figure on every row.
How does the export handle QNB Group header branding on the first page?
The QNB Group branding occupies the header area of the first page. Kashfbank parses through the header to reach the transaction table. The Egyptian entity name and IBAN appear in the account summary; the transaction rows themselves carry no group-branding noise.
Freelancers
Extract, categorize, and export freelance income and expenses from PDF bank statements — ready for 1099, self-assessment, or ZATCA filings.
Loan Applications
Prepare clean, lender-ready bank statement exports that prove stable income and responsible financial behavior for personal and business loan applications.
Mortgage Applications
Prepare 6–12 months of verified, structured bank statement data for mortgage underwriting — covering down payment seasoning, income stability, and GCC real estate requirements.
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