KashfbankBank Statement Converter
DashboardPricingBanksBlog
Get started
HomeBanksCommercial Bank of Dubai (CBD)Tax Preparation
UAE

CBD Statement to Excel for UAE Tax Prep

9% corporate tax since June 2023. 5% VAT since 2018. Trade finance, DEWA, and FTA remittances — all extracted cleanly from your CBD PDF.

Convert for tax prep

What the FTA needs from a CBD statement

The FTA does not require statement submission with the corporate tax or VAT return. It requires retention for seven years and production within five business days of an audit request. A clean Excel is what your tax agent uses for the actual preparation.

Commercial Bank of Dubai is popular with mid-market Dubai businesses. The statements are bilingual Arabic-English, AED-denominated, with strong merchant reference coverage. CBD's trade finance arm means many SME statements carry letter of credit and trade-line entries that need careful categorisation.

Trade finance and VAT lines on CBD

Trade finance entries on CBD statements use reference codes rather than merchant names. They need their own chart-of-accounts category — not lumped with operating expenses. Letter of credit settlements may appear as separate debit and credit rows for the same underlying transaction; the descriptors carry the LC reference number so they can be matched.

FTA VAT remittances appear as ONLINE TRANSFER or DIRECT DEBIT rows with FTA in the descriptor. Kashfbank preserves the full descriptor so prior-period payments are easy to filter and sum.

What to extract

Revenue, supplier debits, trade finance, FTA remittances — the four heavy categories for a CBD business account.

  • All inbound revenue credits (ONLINE TRANSFER, SALARY TRANSFER)
  • Supplier payments with input VAT — pair with the invoice
  • Trade finance and LC settlement rows — separate category
  • DEWA, Salik, telecom — operating expense lines

Commercial Bank of Dubai (CBD) statement format

Digitally generated PDF. Bilingual Arabic-English headers and column labels. AED denominated. Dates DD/MM/YYYY. Account summary at top: opening balance, total debits, total credits, closing balance. Detailed merchant references including POS, ATM, and online transfer identifiers in description field.

LabelMeaning
POS PURCHASECard payment at merchant POS
ATM CASH WITHDRAWALATM cash withdrawal
SALARY TRANSFERWPS salary credit
ONLINE TRANSFERInternet banking transfer
DIRECT DEBITAutomatic mandate payment

UAE 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

Request the CBD statement

From CBD NOW Mobile or your branch, pull the statement covering the CT year or VAT quarter. Save the PDF.

2

Upload to Kashfbank

Bilingual rows are extracted with their original descriptors. The account summary block at the top is excluded from the transaction row set.

3

Map to FTA categories

Use the Category column: Revenue, Supplier (with VAT), Supplier (no VAT), Trade Finance, VAT Remittance, Utility, Other. Trade finance is the one CBD-specific bucket to watch.

4

Export and retain

Download the CSV. Keep the original PDF for the seven-year FTA 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

How does Kashfbank handle CBD's trade finance entries?

Trade finance rows are extracted with their LC reference codes preserved in the descriptor and tagged with a Trade Finance Category value. They are kept separate from operating expense rows so the chart-of-accounts mapping in Zoho Books or Xero stays clean.

Does CBD split 5% VAT on supplier payments?

No. The bank line carries the gross amount. The 5% split sits on the supplier invoice. Kashfbank tags FTA remittance rows separately so your prior-period VAT payments are easy to sum.

Does the account summary at the top of the CBD statement appear in the export?

No. We exclude the summary block from the transaction row set. Including it would produce phantom 'transactions' for opening balance, total debits, and total credits. The summary is preserved in the file metadata for reference.

Will the export import into Zoho Books UAE VAT edition?

Yes. Date, Description, Debit, Credit columns match Zoho's bank statement import template. The Category column needs a one-time map to your client's chart of accounts on first import.

Other use cases for Commercial Bank of Dubai (CBD)

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.

Commercial Bank of Dubai (CBD) overviewUAE banks guide

Convert Commercial Bank of Dubai (CBD) 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

AED

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