Worked example · WE-09

Month end: import the statement and reconcile the bank

Accounts imports Emirates NBD's October statement (three lines) and matches each line: a customer's transfer, a bank fee and a supplier payment. The books then agree with the bank.

The case

File enbd-statement-oct-2026.csv for Emirates NBD – Current, opening balance 32,180.58, closing 24,074.58.

Statement line	Amount	Matched with
TRANSFER FROM DESERT STAR CONTRACTING	2,929.50	BRV/2026/0079
TRANSFER TO AL NOOR INDUSTRIAL SUPPLIES	-11,025.00	BPV/2026/0073
SERVICE FEE OCT	-10.50	400051 Other Bank Charges

1. Import the statement

Finance › Transactions › Bank & Cash › Import Bank Statement: the bank, the file and its File Map, then Import. The statement opens with one line per transaction.

LinesBNK1/2026/0224 – 0226 · 3 lines waiting in Bank Reconciliation

Go to Finance › Transactions › Bank & Cash › Import Bank Statement.

Then Transactions.

Then Bank & Cash.

Then Import Bank Statement.

Upload one or more statement files.

Choose the Journal (the bank). You can leave it empty when the file carries your account number.

For a CSV or Excel file, check the File Map. It fills in from the bank when the map is set there.

Click Import.

The new statement opens with one line per transaction. The lines now wait in Bank Reconciliation under To Reconcile.

2. Match the customer's transfer and book the fee

The Desert Star line is matched with its receipt BRV/2026/0079 (2,929.50). The service fee has no document: Counterpart, Account 400051 Other Bank Charges, Add counterpart, Validate.

Go to Finance › Transactions › Bank & Cash › Bank Reconciliation.

Then Transactions.

Then Bank & Cash.

Then Bank Reconciliation.

Choose the bank at the top and click To Reconcile.

Click a bank line on the left. Its amount, label and To reconcile: amount show on the right.

Check or choose the Partner (the customer or vendor).

On the Match journal items tab, find the matching item (search by reference, name or amount) and click it. It moves up into the table.

To reconcile: now shows 0.00.

Click Validate. Go on with the next line.

For a bank fee or charge with no document, click its line.

Open the Counterpart tab.

Choose the Account, e.g. Other Bank Charges. Check the Label and Amount.

Click Add counterpart.

When To reconcile: shows 0.00, click Validate.

3. Match the supplier payment

The Al Noor line is matched with BPV/2026/0073 (11,025.00, WE-05) and validated.

After3 of 3 lines reconciled · BPV/2026/0073 and BILL/2026/0080: Paid

Go to Finance › Transactions › Bank & Cash › Bank Reconciliation.

Then Transactions.

Then Bank & Cash.

Then Bank Reconciliation.

Choose the bank at the top and click To Reconcile.

Click a bank line on the left. Its amount, label and To reconcile: amount show on the right.

Check or choose the Partner (the customer or vendor).

On the Match journal items tab, find the matching item (search by reference, name or amount) and click it. It moves up into the table.

To reconcile: now shows 0.00.

Click Validate. The line moves to Reconciled; its payment and the bill read Paid.

The result

Every line of the October statement is matched: the receipt and the payment read Paid, and the 10.50 fee is booked to 400051 Other Bank Charges. The Bank Reconciliation Statement (L20) then shows no bank lines left to match.

Month end: import the statement and reconcile the bank

The case

1. Import the statement

2. Match the customer's transfer and book the fee

3. Match the supplier payment

The result

Try Gigoo Trading free for 14 days.