Step by step
Upload a statement
Upload the M-Pesa or bank statement as CSV. Kila reads it, checks its running balance, skips lines it already has and matches each line to what was recorded.
The statement is the evidence: what really came into and left your M-Pesa and bank. Upload it, and Kila checks it line by line against what was recorded, so you see what matches, what differs and what nobody recorded.
Before you start
Link to this section: Before you startDownload the statement as CSV: from the M-Pesa business portal for a till or paybill, or from your bank’s online banking. Kila does not read Excel or PDF statements yet.
Open Statements and tap Upload statements
Go to Money › Statements: “Upload statements to check them line by line against what Kila recorded, see where money came from and went, and find what nobody recorded.” Tap Upload statements.
Choose the files
Tap Choose statement files and pick one or more CSV files: “CSV (comma, tab or semicolon). Excel and PDF statements are not read yet: in Excel, save as CSV; for a PDF, download the CSV from the M-Pesa portal or the bank.” Leave Statement from on Detect: “Leave on detect: the layout says”.
Steps 2 to 5. Tap Check files
Kila reads each file by its column names and says what it found, such as Bank statement (date, narration, debit, credit, balance) · 3 lines, 3 new, with the dates it covers and the money in and out.
Read the balance check
Balances check out means each line’s balance follows from the one before, so no line is missing.
Tap Import
Kila says 1 of 1 statement read and how many new lines it took. The statement is listed with its check.
See what needs you
Kila matches each line to what was recorded: a payment with the same reference matches at once. The rest waits under To review, such as On the statement, no sale in Kila: money that came in with no matching payment.
Record a charge as an expense
On the Lines tab, tap a line, such as the bank’s ledger fee. Kila says “No recorded payment looks like this line.” Under Record it as an expense, choose the Category, such as Bank and M-Pesa charges, and Paid to, then tap Record KES 345.00 as paid. Kila says Recorded as an expense.
The file is a PDF or an Excel file
Link to this section: The file is a PDF or an Excel fileOpen an Excel statement and save it as CSV. For a PDF, download the CSV version from the M-Pesa portal or your bank.
You upload the same statement twice
Link to this section: You upload the same statement twiceKila skips the lines it already has: the file shows 0 new, and Import says “0 new lines. Some were already imported and changed nothing.” Nothing is counted twice.
Kila does not know the layout
Link to this section: Kila does not know the layoutThe columns are shown under the message, ready to choose.
Good to know
“Statement files are read once and not kept; only their lines are. Every view is recorded. Personal transactions are shown only to the owner and the people they allow.”
- Reconcile M-Pesa and bank statements: work through the lines that did not match.
- Check an account’s balance: record the statement’s closing balance.
- Statements: the feature and its plans.
Next: allocate what came in and set aside your own transfers: Reconcile M-Pesa and bank statements.