Bank of Jordan statement to Excel

Founded in 1960 and present on both banks of the Jordan, Bank of Jordan gives every transaction a reference code, printed in its own column between the narrative and the amounts. Shopkeepers, clinics and small trading firms in Amman and Irbid use that code to know which customer paid what.

The converter carries the code into a separate column of your spreadsheet, reads three-decimal dinar amounts like 22.500 without rounding, and confirms each running balance against the previous line.

Download your Bank of Jordan statement

1. Sign in to the Bank of Jordan app or online banking.
2. Open the account and choose Statement.
3. Download the PDF.
4. Drop it into the converter above.

Bank of Jordan columns in your sheet

On the statement	In your sheet
Reference	Reference, its own column
Debit / Credit	Money out / money in
Balance	Checked on every row

Who paid, and for what

A CliQ payment from a customer arrives with a code; type it into Excel’s search box and the invoice it settles is found in a second. Exported to OFX, the codes travel with each line into your accounting tool.

Heating in January, cooling in August

Amman’s electricity bill peaks twice a year. The Recurring sheet lists every JEPCO bill with its date, so both peaks — and the annual total — are visible at once.

Statement line, sheet row

23/03/2025 ORANGE JORDAN BILL FT2508217 22.500 1,742.090 becomes reference FT2508217, money out 22.500, balance 1742.090.

Last tested October 2026. StatementEasy is not affiliated with Bank of Jordan PLC.