KashfbankBank Statement Converter
DashboardPricingBanksBlog
Get started
HomeBanksFirst Abu Dhabi Bank (FAB)Accountants
United Arab Emirates

Convert FAB Statements for Audit and Reconciliation

FAB feeds Big-4 audit files and regional CFO dashboards. Multi-currency rows, SWIFT inflows, and Islamic financing lines export cleanly into Zoho Books and Xero.

Convert FAB statements

Why FAB statements need careful handling

First Abu Dhabi Bank statements show up in the largest corporate audit files in the UAE — Big-4 portfolios, sovereign-linked entity ledgers, and free-zone holding company books. The volume is the first problem: a monthly FAB statement for a mid-size corporate runs 80 to 200 rows before payroll and supplier batches are even added. Manual re-keying is not viable at that scale.

The second problem is heterogeneity. A single FAB account can hold AED, USD, and EUR sub-ledgers in the same PDF. FAB Islamic accounts use Murabaha and Wakala for financing. Pre-2017 entries from the FGB or NBAD legacy systems still surface with a different header. Kashfbank handles all three in one consistent CSV layout.

How FAB statements map into accounting systems

FAB issues English-dominant PDFs with DD/MM/YYYY dates. Transaction descriptors include the channel (POS, ATM, IB, TRF, SWIFT) and the counterparty IBAN or BIC. The export preserves these reference codes in the Description column so audit trails stay intact. Zoho Books UAE VAT edition, Xero, and Sage 50 import the CSV without column remapping.

Multi-currency rows export with original currency, AED-converted amount, and FAB's printed FX rate all on the row. SWIFT inflows and dividend credits need to be booked to separate ledger accounts — Kashfbank's Category column flags them. Interest-charged rows (or Murabaha for Islamic accounts) appear mid-statement and must be booked as finance costs, not operational expenses; the export labels these separately when detected.

What to extract for the audit working paper

Pull the full transaction list with running balance, the FX rate column for multi-currency reconciliation, VAT-bearing supplier debits, and the financing rows. Cross-check the closing balance against the trial balance — any gap is your first reconciliation item.

  • All debits and credits with exact date and amount for trial balance match
  • Running balance to detect missing pages or split-PDF gaps
  • FX rate column on every multi-currency row
  • VAT PAYMENT FTA debits tagged for output VAT netting
  • Murabaha or Wakala rows booked as finance, not operational expense
  • SWIFT inflows separated for revenue recognition checks

First Abu Dhabi Bank (FAB) statement format

English-dominant PDF. Dates DD/MM/YYYY. Account summary panel at top (opening balance, total debits/credits, closing balance). Multi-currency lines show original currency + AED equivalent. Every transaction has a unique reference number. Pre-merger FGB or NBAD statement formats may appear in older archives — headers differ but column structure is consistent.

LabelMeaning
POS PURCHASECard payment at merchant POS
ATM WITHDRAWALCash withdrawal at ATM
SALARY TRANSFERWPS salary credit from employer
SWIFT TRANSFER INInternational wire received
SWIFT TRANSFER OUTInternational wire sent

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 FAB PDFs

Upload the client's FAB statements in a single Kashfbank session. Each file is processed independently and labeled with its source filename, so 12 monthly PDFs become 12 sheets in one bundle.

2

Verify Islamic vs. conventional

Check whether the account is FAB or FAB Islamic. Financing rows for Islamic accounts are tagged as Murabaha or Wakala. Conventional FAB shows interest-charged rows. Both export cleanly but post to different ledger accounts.

3

Reconcile running balance

The Balance column should be continuous month to month. Any gap signals a missing page or split PDF. Re-upload the missing page; Kashfbank merges chronologically.

4

Export to your accounting tool

Download the CSV. Zoho Books UAE VAT edition imports the file 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' FAB statements in one session?

Yes. Each file upload is processed independently and labeled with its source filename. A single session can convert 10 to 20 PDFs across different clients, and each downloads as a separate CSV. The Big-4 portfolio model is supported directly.

Does the export distinguish FAB Islamic financing rows from interest?

Yes. FAB Islamic accounts use Murabaha and Wakala terminology that Kashfbank tags as financing entries. Conventional FAB accounts show interest-charged rows tagged as such. Both post to different ledger accounts under IFRS, and the Category column keeps them apart.

How does multi-currency reconciliation work in the export?

Each currency sub-account becomes its own sheet with its own running balance. The original currency, the AED-converted amount, and the FAB-printed FX rate all stay on the row. Audit working papers can then verify the conversion against the bank's daily rate sheet.

What if the client's FAB account predates the 2017 FGB or NBAD merger?

Those older statements use a different header layout. Kashfbank parses both formats. Some legacy descriptors carry a merger-migration tag; the row's amount, date, and balance are preserved either way, so opening balance tie-outs still work.

Other use cases for First Abu Dhabi Bank (FAB)

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.

First Abu Dhabi Bank (FAB) overviewUnited Arab Emirates banks guide

Convert First Abu Dhabi Bank (FAB) 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