Categorize Template.xlsx

	A	B	C	D	E	G	H	I
1	Enter	Enter	Enter			Fill in this table and insert extra rows in table as required
2	Date	Amount	Bank Description	Vendor	Category	keyword	vendor	category
3	8/1/2024	-$23.00	AMPL	Ampol	Car	ampl	Ampol	Car
4	8/3/2024	-$16.00	COL	coles	food	col	coles	food
5	8/6/2024	-$25.00	B&W	Black and White Cabs	Transportation	grilld	Grilled	Takeaway
6	8/9/2024	-$41.00	UBR	Uber	Transportation	Netflx	Netflix	Entertainment
7	8/12/2024	-$48.00	Petbrn	Petbarn	Pets	Pet	Petbarn	Pets
8	8/15/2024	-$25.00	Grilld	Grilled	Takeaway	B&W	Black and White Cabs	Transportation
9	8/18/2024	-$38.00	Netflx	Netflix	Entertainment	ubr	Uber	Transportation
10	8/21/2024	-$65.00	UBR	Uber	Transportation	Wol	Wolworths	food
11	8/24/2024	-$39.00	AMPL	Ampol	Car
12	8/27/2024	-$32.00	COL	coles	food
13	8/30/2024	-$20.00	Wol	Wolworths	food
14	9/1/2024	-$11.00	AMPL	Ampol	Car
15	9/3/2024	-$46.00	COL	coles	food
16	9/6/2024	-$45.00	B&W	Black and White Cabs	Transportation
17	9/9/2024	-$27.00	UBR	Uber	Transportation
18	9/12/2024	-$36.00	Petbrn	Petbarn	Pets
19	9/15/2024	-$43.00	Grilld	Grilled	Takeaway
20	9/18/2024	-$57.00	Netflx	Netflix	Entertainment
21	9/21/2024	-$23.00	UBR	Uber	Transportation
22	9/24/2024	-$41.00	AMPL	Ampol	Car
23	9/27/2024	-$42.00	COL	coles	food
24	9/30/2024	-$26.00	Wol	Wolworths	food
25	10/1/2024	-$55.00	AMPL	Ampol	Car
26	10/3/2024	-$46.00	COL	coles	food
27	10/6/2024	-$45.00	B&W	Black and White Cabs	Transportation
28	10/9/2024	-$27.00	UBR	Uber	Transportation
29	10/12/2024	-$36.00	Petbrn	Petbarn	Pets
30	10/15/2024	-$43.00	Grilld	Grilled	Takeaway
31	10/18/2024	-$11.00	Netflx	Netflix	Entertainment
32	10/21/2024	-$60.00	UBR	Uber	Transportation
33	10/24/2024	-$41.00	AMPL	Ampol	Car
34	10/27/2024	-$42.00	COL	coles	food
35	10/30/2024	-$26.00	Wol	Wolworths	food
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