Sample_Bookkeeping_Cashbook.xlsx

	A	B	C	D	E	F
1	SAMPLE BOOKKEEPING CASHBOOK
2	Fictional demonstration data — prepared for portfolio purposes only
3
4	Date	Reference	Description	Income (KSh)	Expense (KSh)	Running Balance (KSh)

5	2026-10-01	RC001	Opening cash balance	KSh 10,000.00	KSh 0.00	KSh 10,000.00
6	2026-10-02	RC002	Service income	KSh 2,500.00	KSh 0.00	KSh 12,500.00
7	2026-10-03	PV001	Office supplies	KSh 0.00	KSh 850.00	KSh 11,650.00
8	2026-10-05	RC003	Customer payment	KSh 1,800.00	KSh 0.00	KSh 13,450.00
9	2026-10-06	PV002	Transport expense	KSh 0.00	KSh 400.00	KSh 13,050.00
10	2026-10-08	RC004	Service income	KSh 3,200.00	KSh 0.00	KSh 16,250.00
11	2026-10-10	PV003	Internet and phone	KSh 0.00	KSh 1,200.00	KSh 15,050.00
12	2026-10-12	RC005	Customer payment	KSh 1,500.00	KSh 0.00	KSh 16,550.00
13	2026-10-14	PV004	Stationery	KSh 0.00	KSh 650.00	KSh 15,900.00
14	2026-10-16	RC006	Service income	KSh 2,750.00	KSh 0.00	KSh 18,650.00
15	2026-10-18	PV005	Delivery expense	KSh 0.00	KSh 500.00	KSh 18,150.00
16	2026-10-20	RC007	Customer payment	KSh 2,200.00	KSh 0.00	KSh 20,350.00
17			TOTAL	KSh 23,950.00	KSh 3,600.00	KSh 20,350.00
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100