cashflow_analysis_dataset.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	date	opening_balance_kzt	inflow_sales_kzt	inflow_collections_kzt	inflow_other_kzt	inflow_kzt	outflow_suppliers_kzt	outflow_payroll_kzt	outflow_tax_kzt	outflow_rent_kzt	outflow_loan_kzt	outflow_other_kzt	outflow_kzt	closing_balance_kzt
2	2025-04-01	12000000	2000000	900000	150000	3050000	1700000	0	120000	0	0	700000	2520000	12530000
3	2025-04-02	12530000	2120000	980000	150000	3250000	1790000	0	120000	0	0	700000	2610000	13170000
4	2025-04-03	13170000	2240000	1060000	150000	3450000	1880000	0	120000	800000	0	700000	3500000	13120000
5	2025-04-04	13120000	2360000	900000	150000	3410000	1970000	0	120000	0	0	700000	2790000	13740000
6	2025-04-05	13740000	2480000	980000	150000	3610000	1700000	2500000	120000	0	0	700000	5020000	12330000
7	2025-04-06	12330000	2000000	1060000	150000	3210000	1790000	0	120000	0	0	700000	2610000	12930000
8	2025-04-07	12930000	2120000	900000	150000	3170000	1880000	0	120000	0	0	700000	2700000	13400000
9	2025-04-08	13400000	2240000	980000	150000	3370000	1970000	0	120000	0	1000000	700000	3790000	12980000
10	2025-04-09	12980000	2360000	1060000	150000	3570000	1700000	0	120000	0	0	700000	2520000	14030000
11	2025-04-10	14030000	2480000	900000	150000	3530000	1790000	0	600000	0	0	700000	3090000	14470000
12	2025-04-11	14470000	2000000	980000	150000	3130000	1880000	0	600000	0	0	700000	3180000	14420000
13	2025-04-12	14420000	2120000	1060000	150000	3330000	1970000	2500000	120000	0	0	700000	5290000	12460000
14	2025-04-13	12460000	2240000	900000	150000	3290000	1700000	0	120000	0	0	700000	2520000	13230000
15	2025-04-14	13230000	2360000	980000	150000	3490000	1790000	0	120000	0	0	700000	2610000	14110000
16	2025-04-15	14110000	2480000	1060000	150000	3690000	1880000	0	120000	0	0	700000	2700000	15100000
17
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