KashfbankBank Statement Converter
DashboardPricingBanksBlog
Get started
HomeBanksArab BankAccountants
Jordan

Arab Bank Statement to Excel for Jordan Accountants

Arab Bank holds a large share of Jordanian SME banking. If your practice serves Amman businesses, every client folder has an Arab Bank statement. Stop retyping it into QuickBooks or Zoho Books by hand.

Convert client statements

Jordan's SME accounting profession and Arab Bank statements

Jordan has a strong SME accounting profession — a mix of JACPA-licensed firms, freelance accountants, and ERP partners specialising in QuickBooks, Zoho Books, and Xero implementations. The market is more SME-driven than Qatar or the UAE, with family-owned businesses, professional services firms, and trading companies dominating the client mix. Arab Bank is the most common banking relationship across these segments.

The 20% corporate tax rate, 16% GST, and progressive personal income tax mean accountants in Jordan handle both corporate and personal tax work for SME owners. The annual ISTD return is the major deliverable. Underlying that return is the bank statement — bilingual, JOD with three-decimal precision, multi-currency for trade-finance clients. Kashfbank converts the PDF to a CSV that imports directly into bookkeeping software.

What the export looks like for accounting software

Kashfbank exports a standard CSV: Date (DD/MM/YYYY), Description (full Arab Bank bilingual narration), Debit, Credit, Balance, Category, Currency. This maps to QuickBooks Online, Zoho Books, Xero, and most Jordanian-localised bookkeeping tools. For audit work, the same CSV feeds into Excel-based sampling templates and ACL/IDEA for control testing.

Arab Bank's transaction labels — SWIFT Transfer, ATM WD, POS Purchase, Salary Credit, Standing Order, LC Settlement — are preserved verbatim in the Description column. The narration field can be long, especially for international wires with full beneficiary detail. Kashfbank does not truncate; the full string carries through for matching against supplier invoices and client receipts.

Multi-currency and trade-finance workflows

Many Arab Bank corporate clients hold USD or EUR sub-accounts alongside JOD for import-export trade. Each currency exports as its own row group with the original amount. Trade-finance entries — Letters of Credit, bank guarantees, documentary collections — carry reference numbers that auditors use to trace the underlying commercial transaction.

  • JOD three-decimal precision preserved on every row (1,250.500, not 1,250.50)
  • USD, EUR, GBP sub-account currencies each in their own block
  • LC Settlement and trade-finance reference numbers preserved for audit
  • Standing Order recurring transfers flagged for chart-of-accounts mapping
  • SWIFT BIC of originator preserved for AML and related-party disclosure

Arab Bank statement format

Bilingual Arabic/English PDF, typically landscape layout. Columns: date, reference, description, debit (JOD), credit (JOD), balance (JOD). JOD amounts displayed to three decimal places per CBJ standards. Multi-currency accounts produce separate per-currency pages. Wire transfers include full SWIFT/BIC beneficiary detail in the narration field. Statements available up to 24 months via branch or online.

LabelMeaning
SWIFT TransferInternational wire transfer via SWIFT network
ATM WDATM cash withdrawal
POS PurchasePoint-of-sale card payment
Salary CreditMonthly salary deposit from employer
Standing OrderRecurring scheduled transfer (utilities, insurance, loan instalment)

Jordan specifics for this use case

Rules in Jordan differ — see our country guide

How to do it — step by step

1

Collect client PDFs

Have each client export their Arab Bank statement from Arabi Mobile or Arab Bank Online covering the period you need. For monthly bookkeeping, it is monthly. For ISTD prep, it is the full calendar year. Multi-currency holders should include all sub-account pages.

2

Bulk upload by client

Upload all of one client's PDFs in a session. Each file is converted independently and labelled with its filename. Multi-month merges happen in Excel after export — Kashfbank preserves chronology, you assemble the year.

3

Apply chart of accounts

Open each CSV, set the Category column to the client's chart (Revenue, Cost of Sales, Operating Expense, Payroll, Bank Charges, FX, Trade Finance). For ISTD prep, also tag any GST payments and ISTD remittances. The first client takes 20 minutes; subsequent months are 5.

4

Import to bookkeeping or working papers

Push the categorised CSV into QuickBooks, Zoho Books, or Xero. For audit work, drop it into IDEA, ACL, or your firm's Excel templates. The original Arab Bank PDF stays in the client folder as the source document.

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

How does Kashfbank handle the JOD three-decimal precision in accounting software?

Kashfbank's CSV preserves three decimals. QuickBooks Online, Zoho Books, and Xero all support JOD as a multi-currency option with three-decimal handling. Make sure JOD is enabled in your client's accounting software currency settings before import — otherwise the third decimal gets rounded silently.

Can the export feed Jordanian-localised tools like the JACPA-recommended bookkeeping packages?

Most Jordanian local bookkeeping tools accept standard CSV imports. The Kashfbank format works with the major ones. For very specific local ERPs (rare cases), a column reorder in Excel before import is the only adjustment needed.

Does Kashfbank distinguish a Letter of Credit settlement from a regular outbound wire?

Yes. LC settlements carry a specific reference structure that Arab Bank's narration includes. The Category column tags them as Trade Finance instead of generic Outbound Wire, so the audit trail to the underlying commercial transaction stays intact.

Are scanned old Arab Bank statements from the 1990s or early 2000s supported?

Modern Arab Bank PDFs are text-layer documents and read cleanly. Pre-2010 statements may be scanned image PDFs. Mistral OCR handles moderate scan quality but very degraded pages get flagged for manual review. For audit work on historical records, the bank's branch can usually re-issue a modern PDF copy.

Other use cases for Arab 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.

Arab Bank overviewJordan banks guide

Convert Arab Bank Statement

Upload PDF, get Excel in seconds

Try it free

10 free credits on signup

Regulatory context

Regulator: Central Bank of Jordan (CBJ)

Fiscal year: Jan 1 – Dec 31

Full country guide →

Statement info

JODUSDEUR

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