KashfbankBank Statement Converter
DashboardPricingBanksBlog
Get started
HomeBanksEmirates NBDTax Preparation
United Arab Emirates

Emirates NBD Statement to Excel for UAE Tax Prep

9% corporate tax since June 2023. 5% VAT since 2018. No personal income tax. Pull what the FTA needs from your ENBD PDF in seconds.

Convert for tax prep

What UAE tax prep actually needs from a bank statement

The UAE has no personal income tax, so individuals filing on personal income do not need a statement-driven return. The work sits at the entity level: 9% corporate tax on profits above AED 375,000 since June 2023, and 5% VAT since January 2018 for businesses above the AED 375,000 annual revenue threshold. Free-zone entities (DIFC, ADGM, JAFZA, DMCC) can still qualify for 0% on qualifying income if they meet the FTA's conditions.

Emirates NBD is the source bank for a large share of UAE SMEs and freelancers. The FTA does not require you to submit a statement with the return — it requires you to keep it for at least seven years and produce it on request. A clean Excel export is what most UAE accountants ask for when preparing the CT or VAT filing.

Reading VAT, FTA, and supplier payments on an ENBD statement

Emirates NBD statements show VAT PAYMENT FTA as a distinct debit row when you remit through the FTA portal. Supplier payments that include 5% VAT will not show the split on the bank line — the bank sees the gross amount only. The split sits on the supplier invoice, which is why the statement and the invoice ledger need to reconcile.

Direct debits for utilities (DEWA), telecom (du, Etisalat), and SaaS subscriptions are labelled clearly. End-of-service gratuity payments to staff appear as standard TRF- entries; UAE labour law treats gratuity separately from salary, and the statement preserves that distinction in the descriptor.

What to extract for the CT and VAT returns

For corporate tax, you need a clean revenue figure and qualifying business expenses. For VAT, you need every output VAT supply and every input VAT debit through the period.

  • All inbound client revenue (INWARD REMITTANCE, IB- TRF, local Sarie equivalent)
  • Supplier payments where input VAT can be reclaimed (keep the invoice alongside)
  • VAT PAYMENT FTA rows — proof of remittance for the prior period
  • End-of-service gratuity payments — excluded from salary expense for CT purposes
  • FX CONVERSION lines so AED revenue from foreign clients reconciles cleanly

Emirates NBD statement format

English-dominant PDF. Dates in DD/MM/YYYY format. Multi-currency statements show AED and foreign currency amounts in parallel columns. Digital QR code on official statements for authenticity. Transaction labels prefixed with channel codes: POS-, ATM-, TRF-, IB- (internet banking). Page breaks may split single transactions across pages in long statements.

LabelMeaning
POS-PURCHASE-Point-of-sale card payment at a merchant
ATM WITHDRAWALCash withdrawal from ATM
SALARY CREDITMonthly salary deposited via WPS or direct transfer
SALIKDubai road toll deduction (Salik RFID system)
ETISALAT / duTelecom bill payment to UAE mobile operators

United Arab Emirates specifics for this use case

UAE corporate tax (9% above AED 375K, effective June 2023) requires businesses to reconcile bank deposits against revenue figures; statements are the primary source for revenue verification by the FTA.

How to do it — step by step

1

Pull the statement covering your tax period

From ENBD Mobile, request the statement covering your full CT period (typically calendar year) or VAT period (monthly or quarterly per your FTA registration). Save the PDF and upload it to Kashfbank.

2

Confirm AED and the period boundaries

Check the opening and closing dates match the FTA period. If the statement crosses two VAT quarters, Kashfbank still extracts the full file — you filter by date after export.

3

Categorise into FTA buckets

Use the Category column to group rows: Revenue, Supplier (with VAT), Supplier (no VAT), VAT Remittance, Salary, Gratuity, Other. UAE accountants typically remap these to the chart of accounts in Zoho Books or Xero on import.

4

Export and hand to your tax agent

Download the CSV. It opens directly in Zoho Books UAE VAT edition, Xero, or QuickBooks. Keep the original PDF for the seven-year FTA retention window.

Common challenges

  • •Fiscal year mismatch: Saudi Hijri vs. Gregorian calendar in statements from the same bank
  • •Pre/post-VAT transaction splitting (UAE pre-June 2023 vs. after for corporate tax)
  • •Scanned statements from older accounts where OCR confidence drops on faded print
  • •Multi-entity accounts where personal and company transactions share one IBAN

Frequently asked questions

Does the UAE require me to submit my Emirates NBD statement with my tax return?

No. The FTA does not collect statements with the return. It requires you to retain them for at least seven years and produce them within five business days of an audit request. The converted Excel makes both the filing and any future audit response faster.

How does Kashfbank handle VAT amounts on ENBD statements?

The bank line shows the gross amount paid to a supplier. The 5% VAT split sits on the supplier invoice, not the bank statement. Kashfbank tags VAT PAYMENT FTA rows separately so your prior-period remittances are easy to sum.

I am a free-zone company on 0% corporate tax. Do I still need this?

Yes. Qualifying Free Zone Persons still file a return and must keep records. The converted statement is the underlying evidence for the revenue and expense numbers in that filing.

Does the export distinguish salary from end-of-service gratuity?

Yes. Both are TRF- entries on the statement, but the descriptor labels them differently. Kashfbank keeps the full descriptor so your accountant can split salary expense from gratuity expense when preparing the P&L for the FTA.

What about Emirates Islamic accounts?

Emirates Islamic is a separate subsidiary with its own statement format. Murabaha, Ijara, and Wakala entries appear with their original Arabic labels. We do not relabel them as 'interest' — they are not interest.

Other use cases for Emirates NBD

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.

Emirates NBD overviewUnited Arab Emirates banks guide

Convert Emirates NBD Statement

Upload PDF, get Excel in seconds

Try it free

10 free credits on signup

Regulatory context

Regulator: Central Bank of the UAE (CBUAE)

Fiscal year: Jan 1 – Dec 31 (Gregorian)

Full country guide →

Statement info

AEDUSD

Statement language: 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