KashfbankBank Statement Converter
DashboardPricingBanksBlog
Get started
HomeBanksQNB Al Ahli (Egypt)Mortgage Applications
Egypt

QNB Al Ahli Statement to Excel for Mortgage Underwriting

Egypt's mortgage market runs on the CBE initiative for subsidised home finance. QNB Al Ahli is a participating lender. A 12-month statement is the foundation of the file. Convert it to Excel and walk in prepared.

Convert your QNB Al Ahli statement

Why QNB Al Ahli mortgage applicants prepare the statement carefully

Egypt's mortgage market is underdeveloped relative to its population. The Central Bank of Egypt's mortgage initiative, with subsidised rates for housing units up to EGP 2.5M and certain income tiers, has expanded retail mortgage access — but underwriting standards remain rigorous. A 12-month bank statement, employer letter, and property valuation are the minimum file.

QNB Al Ahli participates in the CBE mortgage initiative. The bank reviews the 12-month statement for stable monthly income, manageable existing obligations, a down payment that has been in the account long enough to look like savings rather than a hidden loan, and absence of repeated overdraft incidents. Post-EGP-devaluation, lenders re-examine income in real terms; stable salary credits are weighted heavily.

How QNB Al Ahli statements present the underwriting signals

QNB Al Ahli issues a bilingual Arabic-English PDF with the QNB Group header. Columns: Date, Description, Debit (EGP), Credit (EGP), Balance (EGP). For a mortgage, the underwriter wants three things: a stable income stream, manageable existing obligations, and a documented down payment seasoned in the account for at least 60 days.

Salary credits over 12 months prove income. FX-to-EGP remittances from Gulf employment are a particularly strong signal for QNB Al Ahli applicants because of the QNB Group's regional presence — many of the bank's mortgage customers are Egyptian expatriates remitting their Gulf salaries home. Recurring debits prove or rule out existing loans. Large credits that funded the down payment need to be traceable back at least 60 days, with a documented source (savings transfer, asset sale, family gift letter).

What to extract for the mortgage file

Mortgage underwriting in Egypt pulls a specific set of signals from the statement. Income, debts, balance trend, and the source of the down payment.

  • Down payment source: trace large credits 60+ days back, document the origin
  • Monthly Salary credits over 12 months, averaged for the income calculation
  • FX-to-EGP remittances — supplementary or primary income for Gulf-employed applicants
  • Existing loan instalment debits — included in the instalment-to-income ratio
  • Average monthly closing balance — buffer beyond the proposed mortgage instalment
  • Clean cheque record — no returned cheques or NSF charges in the period

QNB Al Ahli (Egypt) statement format

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.

LabelMeaning
IB TransferTransfer executed via QNB Al Ahli internet banking
MOB TransferTransfer executed via QNB Al Ahli mobile app
POSPoint-of-sale purchase
Time DepositFixed deposit placement or maturity credit
SalaryMonthly salary credit

Egypt specifics for this use case

Rules in Egypt differ — see our country guide

How to do it — step by step

1

Request 12 months from QNB Al Ahli Mobile

Open QNB Al Ahli Mobile or internet banking and request a statement covering the last 12 months. Some lenders accept a printed version from the branch with the bank's stamp — request that if your file needs it. Multi-product accounts (current, savings, time deposit) appear in sections.

2

Upload and verify the down payment row

Drop the PDF into Kashfbank. The Excel export tags rows by category and preserves bilingual narration. Find the row where the down payment funds arrived. The date must be at least 60 days before the application — this is the seasoning rule.

3

Calculate the instalment-to-income for the new mortgage

Sum every existing monthly instalment in the Excel. Add the proposed new mortgage payment. Divide by net monthly income. The total must fit within the lender's ratio cap. The CBE mortgage initiative has its own income tiers and property price caps — check eligibility before applying.

4

Prepare the CBE initiative documentation if you qualify

If you are applying under the CBE mortgage initiative, the bank statement is the foundation but the initiative scheme requires additional documents — income certification, property valuation, employer letter, ID. Talk to the QNB Al Ahli mortgage desk about the eligibility tier. The statement evidence is the same; only the additional paperwork differs.

Common challenges

  • •Gift funds: large family transfers in GCC markets that must be documented as non-repayable gifts
  • •Bonus income: year-end bonuses that inflate one month's statement and don't reflect sustainable income
  • •Self-employed applicants with fluctuating monthly revenue requiring 24-month instead of 12-month history
  • •Multi-currency down payment accounts (savings in USD, mortgage in AED) requiring rate-adjusted proof

Frequently asked questions

I work in Qatar and remit my salary to QNB Al Ahli. Does that count as income for an Egyptian mortgage?

Yes. Regular FX-to-EGP remittances from Gulf employment are accepted as primary or supplementary income by Egyptian mortgage underwriters, particularly at QNB Al Ahli given the QNB Group's Qatar headquarters. The Excel export shows each remittance with date, originator detail in the narration, and the EGP credit amount. The underwriter averages the EGP equivalents over 12 months for the qualifying income.

How does QNB Al Ahli verify the down payment did not come from a loan?

The underwriter looks at the 12-month statement for the large credit that funded the down payment. If the credit is dated more than 60 days before the application and matches a documented source (a maturing savings or time deposit transfer, a remittance accumulation, a documented gift), it is accepted. If a large credit appeared within the 60-day window with no clear source, the underwriter will ask questions.

Does the export handle the QNB Group header branding without confusion?

Yes. The QNB Group branding occupies the header area; Kashfbank parses through it to reach the transaction table. The Egyptian entity name and IBAN are in the account summary; the transaction rows themselves are clean.

Post-devaluation, my salary increased in nominal EGP. Does the underwriter use the latest figure or an average?

Most Egyptian mortgage underwriters use a 12-month average of the documented salary credits, sometimes weighted toward the recent months to reflect current earning capacity. Post-devaluation salary increases that show in the recent months may be heavily weighted, but the older lower figures pull the average down. The bank is looking for sustained earning capacity, not just the latest payslip.

Other use cases for QNB Al Ahli (Egypt)

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.

QNB Al Ahli (Egypt) overviewEgypt banks guide

Convert QNB Al Ahli (Egypt) Statement

Upload PDF, get Excel in seconds

Try it free

10 free credits on signup

Regulatory context

Regulator: Central Bank of Egypt (CBE)

Fiscal year: Jul 1 – Jun 30 (government); Jan–Dec (private sector)

Full country guide →

Statement info

EGP

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