Skip to the page
Showing help for:
Showing help for:

Step by step

Reconcile M-Pesa and bank statements

Match each line of the M-Pesa and bank statements to what Kila recorded. Allocate money that came in to the customer who paid, set aside your own transfers and resolve what is left.

Who can do it
Accountant and Owner
Find it
Money, then Reconciliation, or search reconciliation in Kila
Time
10 minutes

Reconciliation puts the statements next to what Kila recorded: “Match what the M-Pesa and bank statements say against what Kila recorded. Money is confirmed by evidence, never by assumption.” Most lines match on their own. You deal with the rest.

The statement is in Kila: see Upload a statement.

  1. Open Reconciliation

    Go to Money › Reconciliation. The Overview shows how much matched: M-Pesa lines matched, Bank lines matched, Open exceptions and Not confirmed yet, and the payments checked against statements.

    Reconciliation at Shamba Fresh Foods: the share of bank lines matched (1) and Run matching (2).Reconciliation at Shamba Fresh Foods: the share of bank lines matched (1) and Run matching (2).
  2. Tap Run matching

    Kila tries again to match every line not yet matched: “Matching tries the receipt code first, then the same amount from the same phone within the time window”. It says Matching finished, with how many it matched.

  3. Open the statement's tab

    Tap Bank statement, or M-Pesa statement.

    Steps 3 to 5.
    The bank statement tab (3) showing Unmatched lines (4), with the transfer from Rift Fresh Distributors (5).The bank statement tab (3) showing Unmatched lines (4), with the transfer from Rift Fresh Distributors (5).
  4. Tap Unmatched

    Only the lines Kila could not match are left. A payment recorded with the bank’s reference has already matched.

  5. Open a line

    Tap it. Under Payments that could be this, Kila lists recorded payments close in time and amount, each with Match.

  6. Or allocate it to the customer who paid

    When no recorded payment is the line, use Or allocate it to a customer: “Records a payment from the customer. It clears what they owe first; anything left is held as a deposit.” Search for the customer and choose them.

    The transfer's line: payments that could be this, each with Match, then Or allocate it to a customer (6) with Rift Fresh Distributors chosen and Allocate KES 5,000.00 (7).The transfer's line: payments that could be this, each with Match, then Or allocate it to a customer (6) with Rift Fresh Distributors chosen and Allocate KES 5,000.00 (7).
  7. Tap Allocate

    The button shows the amount, such as Allocate KES 5,000.00. Kila says Allocated to Rift Fresh Distributors: PAY-… recorded.

A sweep from your M-Pesa till to the bank, or a transfer between your own accounts, is not money from a customer. Open the line and tap Set aside: “Use this for transfers between your own accounts or lines that are not sales money.” Give the Reason and tap Set aside. Kila says Line set aside: “The reason is kept with the line.”

Set this line aside: the reason Sweep from our own M-Pesa till to the bank (1) and Set aside (2).Set this line aside: the reason Sweep from our own M-Pesa till to the bank (1) and Set aside (2).

Open it and tap Flag: “It goes to exceptions as under investigation.” Say What needs checking? and tap Flag. Kila says Flagged for investigation: “It is listed under exceptions.”

On the Exceptions tab, exceptions are Unresolved, Open, Investigating or Resolved. Once you know, tap Resolve and write What you found and what was done: “Kept with the exception so the next person can follow it.” Tap Resolve: Kila says Exception resolved.

The exceptions: the flagged ledger fee, with Resolve marked 1.The exceptions: the flagged ledger fee, with Resolve marked 1.

Money went out and nothing in Kila explains it

Link to this section: Money went out and nothing in Kila explains it

Record it from its line in Money › Statements, for example as an expense: see Upload a statement.

Good to know

In the demo there is also Pull sample M-Pesa statement: “Demo only: builds a sample statement from recent payments.” Your business uploads its own statements.

Next: at month end, close the month: Close a month.

Last checked on Kila on .

Did this help?

Still stuck?

Email Kila support. Say what you were trying to do and copy the message Kila showed you, word for word.

Contact support

Choose your business

The Help Centre then shows the steps and words for your kind of business. Your choice stays on this device.