KCB statement to Excel

KCB statements list Txn Date, Description, Value Date, Money Out, Money In and Ledger Balance, with dates like 05 Mar 2025 — the value date printed after the description rather than next to the transaction date. StatementEasy keeps both dates in their own columns, reads Money Out and Money In as such and checks every ledger balance from the opening balance on.

Download your KCB Bank statement

1. Open KCB Mobile or KCB iBank.
2. Request an account statement for the period.
3. Save the KCB Bank statement as a PDF.
4. Drop the KCB Bank PDF into the converter above.

KCB Bank columns in your sheet

On the KCB Bank statement	In your sheet
Txn Date	Date
Value Date (after the description)	Value date
Money Out / Money In	Money out / money in
Ledger Balance	Checked on every row
Opening Balance	Start of the check, not a row

Pay Bill, Buy Goods and M-PESA

KCB descriptions keep the Pay Bill and Buy Goods numbers and M-PESA references. Search the spreadsheet for a paybill to see every payment to a school, a landlord or a utility, or open Recurring for the payments that come back each month.

Statements for a loan

Convert the last three to six months and open Insights for regular income and existing repayments; the Monthly sheet shows each month’s totals and closing balance.

KCB statements in shillings and dollars

If you hold a KCB dollar account as well as a shilling account, convert each statement on its own so the currencies are never added together; the columns are read the same way.

Last tested October 2026. StatementEasy is not affiliated with KCB Bank Kenya Limited.