Finance and compliance ยท Lesson 13 of 15

Bank reconciliation

Upload a bank or wallet statement, map its columns, run matching, and explain the line Adili can't match.

About 12 minutes

Key ideas

1

Start with the statement

Reconciliation compares your statement with Adili, line by line. Choose New reconciliation, name the source, in the example the Head Office Till, and choose the statement file: a CSV or Excel export from your bank or wallet.

2

Map the columns

Adili reads the columns from the file's headers. Every line needs a date and an amount; the direction tells money in from money out, and the reference makes a match certain. Without a direction, lines are held back rather than guessed at, until you import the statement again with its debit/credit column mapped.

3

Run matching and check the pairs

Import the rows, then Run matching, and check each pair's reference, amount and direction; in the example, four of five lines matched and the payout matched on its reference. Payouts match on the cash actually paid out after a fee taken off the payout: 980,000 for a 1,000,000 loan.

4

Explain the difference, then Finish

A line with no Adili transaction, like the 5,000 bank fee BANK-FEE-10, stays unmatched. Record the charge in your books so the account agrees, and choose Finish once every line is matched or explained.

Practice

Try it in your training organization

  1. 1. Export a CSV or Excel statement for a funding account from your bank or wallet, or make a small training one with your training payout and repayment references and one bank fee line.
  2. 2. Open Reconciliation, choose New reconciliation, enter the account in Bank or source name (in the example, Head Office Till) and attach the statement.
  3. 3. Choose Map columns and check that Transaction date, Amount, Debit / credit and Reference / transaction ID are mapped.
  4. 4. Choose Import (the button shows your number of rows, such as Import 5 rows), then Run matching.
  5. 5. Check each matched pair's reference, amount and direction, and note why any unmatched line has no Adili transaction.
  6. 6. Record any bank charge in your books, then choose Finish once every line is matched or explained.

Check yourself

Watch the video and take the quiz

Sign in to watch this lesson's video, answer its 4 questions and count it towards your certificate. Your progress is saved.

Open in my learning