Credit Claims.xlsx

	A	B	C	D	E	F	G	H	L	M	N
1									Invoice Date	Couriers	Dates
2									Monday and Wednesday	Cool Couriers	plus 2 from dispatch date
3				Claim Date / INV					Friday	Cool Fast	plus 2 from dispatch date

4
5	APRIL 2024
6	Credit Note Number	Claim Number	Invoice Number	Invoice Date	Store	Status	Amount	Notes
7			INV-1063676					shipment on these invoices had temperature breach during transport
8			INV-1063510
9			INV-1063677
10			INV-1063508
11			INV-1063509
12	MAY 2024
13	Credit Note Number	Claim Number	Invoice Number	Invoice Date	Store	Status	Amount	Notes
14			INV-1067024				12440.71	new invoice for the withdrawal - CC0007800286E - paid
15
16
17	JULY 2024
18	Credit Note Number	Claim Number	Invoice Number	Invoice/Claim Date	Store	Status	Amount	Notes
19	CN-01284	D11195784	INV-1066836 (RD)	19/8	Coles Bondi Junction		33.08	paid
20	CN-01285	D11195746	INV-1066833	19/8	Coles Bondi Westfield		23.91	1 page with signature -- INV # a bit small in the image - sent - 4/9 - for make up, didn't accept POD
21			INV-1065997		Coles Dianella 256		12471.66	paid
22			INV-1066001		Coles Malvern 575		1246.73	paid
23			INV-1066133		Coles Southland 669		788.75	paid
24			INV-1066193		Coles Malvern 575		1909.43	paid
25			INV-1066761		Coles Elsternwick 7757		17918.87	paid
26			INV-1066901		Coles Dianella 256		6730.58	paid
27			INV-1066900		Coles Flinders Square 347		1606.59	paid
28	CN-01292	D11198899	INV-1066901 (RD)	26/8	Coles Dianella 256		360.44	paid
29	CN-01293	D11200188	INV-1067122 (RD)	26/8	Coles Edgecliff		29.01	paid 29
30
31
32
33
34
35
36
37
38	AUGUST 2024
39	Credit Note Number	Claim Number	Invoice Number	Invoice/Claim Date	Store	Status	Amount	Notes
40	CN-01286	D11197575	INV-1066931 (RD)	19/8	Coles Elsternwick		63.66	paid
41	CN-01287	D11198405	INV-1066999 (RD)	19/8	Coles Brighton		33.69	paid
42	CN-01296	D11201381	INV-1067150 (RD)	2/9 - 9/8	Coles Manuka	local	37.83	paid
43	CN-01297	D11201470	INV-1067056 (RD)	2/9 - 7/8	Coles Mermaid Waters	local	145.97	piad
44	CN-01298	D11202840	INV-1067328 (RD)	2/9 - 15/8	Coles Balaclava	local	222.66	paid
45	CN-01299	D11202929	INV-1067402 (RD)	2/9 - 16/8	Coles Bondi Westfield		60.1	paid
46	CN-01300	D11203256	INV-1067397 (RD)	2/9 - 16/8	Coles Pagewood		510.75	paid
47	CN-01307	D11203228	INV-1067424 (RD)	9/9 - 19/8	Coles Brighton	local	28.08	28.07 - paid
48	CN-01308	D11204879	INV-1067492 (RD)	9/9 - 21/8	Coles Balaclava	local	49.37	paid
49	CN-01309	D11205684	INV-1067624 (RD)	9/9 - 23/8	Coles Edgecliff		79.75	paid
50	CN-01313	D11205666	INV-1067661RD	16/9 - 26/8	Coles Bondi Westfield		27.44	sent - 23/9 - 27.42 - paid
51	CN-01314	D11206297	INV-1067772 (RD)	16/9 - 29/8	Coles Elsternwick	local	57.23	sent - 23/10 paid 57.25
52	CN-01315	D11206219	INV-1067814 (RD)	16/9 - 30/8	Coles Elsternwick	local	26.69	26.70 - paid
53			INV-1067017	5/8	Coles Maroubra 737		2042.64	paid
54			INV-1067449	19/8	Coles St Ives 5676		1282.41	paid
55			INV-1067542	21/8	Coles Dianella 256	local	6382.86	paid
56			INV-1067563	22/8	Coles Flinders Square 347	local	757	paid
57			INV-1067562	22/8	Coles Flinders Square 347	local	5796.88	paid
58			INV-1067748	28/8	Coles Flinders Square 347	local	1355.34	paid
59			INV-1067832	30/8	Coles Dianella 256	local	17232.09	paid
60
61
62	SEPTEMBER 2024
63	Credit Note Number	Claim Number	Invoice Number	Invoice/Claim Date	Store	Status	Amount	Notes
64	CN-01318	D11208204	INV-1067900 (RD)	23/9 - 2/9	Coles Bondi Westfield		21.35	paid
65	CN-01319	D11208987	INV-1067963 (RD)	23/9 - 2/9	Coles Bondi Junction		58.77	paid 58.78
66	CN-01323	D11210463	INV-1068085 (RD)	30/9 - 9/9	Coles Rosebay		107.85	paid
67	CN-01324	D11211097	INV-1068071 (RD)	30/9 - 9/9	Coles Elsternwick		29.71	paid
68	CN-01331	D11214080	INV-1068348 (RD)	7/10 - 17/9	Coles Rosebay		138.78	paid
69	CN-01332	D11214043	INV-1068359 (RD)	7/10 - 17/9	Coles Bondi Westfield		31.24	paid
70	CN-01333	D11214044	INV-1068360 (RD)	7/10 - 17/9	Coles Bondi Westfield		23.24	paid
71	CN-01334	D11215271	INV-1068501 (RD)	7/10 - 20/9	Coles Bondi Westfield		77.48	paid
72	CN-01335	D11215659	INV-1068498 (RD)	7/10 - 20/9	Coles Maroubra		40.65	paid
73	CN-01336	D11218431	INV-1068437 (RD)	7/10 - 19/9	Coles Pagewood/Eastgarden		332.14	paid
74	CN-01343	D11216284	INV-1068592 (RD)	14/10 - 24/9	Coles St Ives		31.32	paid
75	CN-01344	D11216260	INV-1068582 (RD)	14/10 - 24/9	Coles Bondi Junction		52.34	paid
76	CN-01345	D11216709	INV-1068595 (RD)	14/10 - 24/9	Coles Rosebay		12.43	paid
77	CN-01346	D11216691	INV-1068650 (RD)	14/10 - 25/9	Coles Bondi Junction		38.88	paid
78	CN-01347	D11216623	INV-1068583 (RD)	14/10 - 24/9	Coles Edgecliff		33.91	paid
79	CN-01348	D11217551	INV-1068617 (RD)	14/10 - 25/9	Coles Balaclava		22.51	paid
80	CN-01349	D11217597	INV-1068689 (RD)	14/10 - 26/9	Coles Edgecliff		38.88	paid
81	CN-01350	D11219098	INV-1068738 (RD)	14/10 - 30/9	Coles Balaclava		26.47	paid - 26.49
82			INV-1067898		Coles Pagewood/Eastgarden		859.85	paid 859.84
83			INV-1067895		Coles St Ives		3522.77	paid
84			INV-1068436		Coles Bondi Junction		3666.19	paid
85			INV-1068438		Coles St Ives		2554.84	paid
86			INV-1068643		Coles St Ives		4856.46	paid
87			INV-1068670		Coles Caulfield Village 7724		1790.08	paid
88			INV-1068741		Coles Elsternwick		10744.59	paid
89
90
91
92
93	OCTOBER 2024
94	Credit Note Number	Claim Number	Invoice Number	Invoice/Claim Date	Store	Status	Amount	Notes
95	CN-01355	D11219523	INV-1068884 (RD)	21/10 - 02/10	Coles Bondi Junction		27.89	paid
96	CN-01356	D11219458	INV-1068877 (RD)	21/10 - 02/10	Coles Edgecliff		37.83	paid
97	CN-01357	D11222337	INV-1068834 (RD)	21/10 - 02/10	Coles Balaclava		10.35	paid
98	CN-01359	D11222504	INV-1068941 (RD)	29/10 - 08/10	Coles Rosebay		30.66	paid
99	CN-01367	D11226689	INV-1069017	5/11 - 10/10	Coles Elsternwick	local	57.68	sent 10/1
100	CN-01374	D11227981	INV-1069179 (RD)	11/11 - 15/10	Coles Pagewood		17.13	paid