KashfbankBank Statement Converter
DashboardPricingBanksBlog
Get started
HomeBanksMashreq BankAccountants
United Arab Emirates

Convert Mashreq Statements for SME Accounting

Mashreq packs account, card, and FX into one PDF. Kashfbank splits each into its own row so Zoho Books, Xero, and Sage import the file without remapping.

Convert Mashreq statements

Why Mashreq statements suit SME accounting

Mashreq is a daily-banking account for thousands of UAE SMEs and freelancers, especially in tech and media free zones where Mashreq Neo is the default onboarding bank. For accountants serving these clients, the Mashreq ledger typically carries the operational core: client receipts, supplier payments, payroll, VAT remittances, and DEWA or Etisalat utility direct debits. Reconciling Mashreq first usually closes the bulk of the trial balance gap.

Mashreq's integrated card spend cuts document count — the credit card debits live inside the account PDF instead of arriving as a separate file. The trade-off is that one file mixes channels. Kashfbank tags POS rows separately from account debits so card spend posts to the right expense line and never lands in revenue.

How Mashreq statements map into accounting systems

Mashreq issues a digitally generated PDF in English with DD/MM/YYYY or DD-MMM-YYYY dates. Channel codes — POS-, ATM CASH, REMITTANCE OUT, DIRECT DEBIT — sit at the start of the description. Counterparty IBAN, BIC, and branch code appear in the header. Mashreq Neo accounts use the same schema with a narrower description column, so merchant names can truncate.

CASHBACK CREDIT rows are loyalty rebates and book to other income, not revenue. The export labels them. Foreign-currency POS rows carry an inline exchange rate between the debit and credit columns; older parsers used to read that FX line as a separate amount, which broke reconciliation. Kashfbank attaches the FX to the AED transaction as a description attribute, not a row.

What to extract for the audit working paper

Pull the full transaction list with running balance, integrated card POS rows separately, supplier debits including any input VAT split, VAT remittances separately, cashback rebates separately, and SWIFT inflows separately. Cross-check the closing balance against the trial balance. Any gap is the first reconciliation item.

  • All debits and credits with date and amount for trial balance match
  • Running balance to detect missing pages or split-PDF gaps
  • Integrated card POS rows tagged for expense classification
  • VAT PAYMENT FTA debits tagged for output VAT netting
  • CASHBACK CREDIT rows booked as other income, not revenue
  • Inline FX notation preserved against the AED transaction

Mashreq Bank statement format

Modern digitally generated PDF. English dominant. Dates DD/MM/YYYY or DD-MMM-YYYY. Exchange rate shown inline for foreign currency transactions. IBAN, BIC, and branch code in header. Card spend integrated within account statement — no separate card statement. Mashreq Neo accounts may have a slightly different header layout from classic Mashreq accounts.

LabelMeaning
POS-Card purchase at point-of-sale
ATM CASHATM cash withdrawal
SALARYWPS salary credit
REMITTANCE OUTInternational money transfer sent
EXCHANGE RATEFX rate applied to foreign transaction

United Arab Emirates specifics for this use case

UAE-based accountants using Zoho Books (UAE VAT edition) need the VAT column flagged; Kashf's Category field tags ZATCA-style VAT payment rows for easy filtering.

How to do it — step by step

1

Upload one or more Mashreq PDFs

Upload the client's Mashreq statements in one session. Each file is processed independently and labeled with its source filename. Twelve monthly PDFs become twelve sheets in one bundle.

2

Verify Neo vs. classic Mashreq

Check the header — Neo statements have a narrower description column and merchant names can truncate. The row schema is the same as classic Mashreq, so the import path is identical. The original PDF stays useful for truncated merchants.

3

Reconcile running balance

The Balance column should be continuous month to month. Any gap signals a missing page or split PDF. Re-upload; Kashfbank merges chronologically. Foreign POS rows print an FX line between the amount columns — Kashfbank attaches it to the AED row, so reconciliation does not double-count.

4

Export to the accounting tool

Download the CSV. Zoho Books UAE VAT edition imports directly. For Xero or Sage, the Date, Description, Debit, Credit, Balance, Category, Currency columns map to the standard bank-feed schema.

Common challenges

  • •GCC statements in Arabic with Hijri dates requiring dual-date output (Hijri + Gregorian)
  • •Scanned statements with low OCR quality — common in older Egyptian and Lebanese bank PDFs
  • •Multi-page statements where the bank splits across quarterly or monthly PDFs requiring merge
  • •Statements with running balance gaps that signal missing pages (critical for completeness in audit)

Frequently asked questions

Can Kashfbank process multiple clients' Mashreq statements in one session?

Yes. Each upload is processed independently and labeled with its source filename. A single session can convert ten to twenty PDFs across different clients, with each downloaded as its own CSV. SME bookkeepers and tax agents can run a full month's batch in one sitting.

How does the export book Mashreq cashback?

CASHBACK CREDIT rows are loyalty rebates and tagged as Other Income. They should post to an other-income ledger account, not revenue, since they are rebates rather than trading income.

How does Kashfbank handle the inline exchange rate row on foreign POS transactions?

Mashreq prints the FX rate between the debit and credit columns. Generic parsers used to read this as a separate transaction amount, which broke trial balance reconciliation. Kashfbank attaches the FX to the AED debit as a description attribute, not a new row.

Does Mashreq Neo statement format export cleanly into Zoho Books?

Yes. Neo and classic Mashreq share the same row schema. The only difference is a narrower description column on Neo, which can truncate long merchant names. The export still maps to Zoho Books UAE VAT edition without column remapping.

Other use cases for Mashreq Bank

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.

Mashreq Bank overviewUnited Arab Emirates banks guide

Convert Mashreq Bank 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