Arrears example.xlsx

	A	B	C	D	E	F	G
1	Account Number	Customer Name	Date	$ Amount of 30 - 59 Days in Arrears	$ Amount of 60 - 89 Days in Arrears	$ Amount of 90 - 119 Days in Arrears	$ Amount of Over 120 Days in Arrears
2	10001	John	Mar-23
3	10001	John	Apr-23	30			10
4	10001	John	May-23	20	30		10
5	10001	John	Jun-23	10	20	30	10
6	10001	John	Jul-23	40	10	20	40
7	10001	John	Aug-23	50	40	10	60
8	10001	John	Sep-23	10	50	40	70
9	10001	John	Oct-23	20	10	50	110
10	10001	John	Nov-23	30	20	10	160
11	10001	John	Dec-23	40	30	20	170
12	10001	John	Jan-24	10	40	30	190
13	10001	John	Feb-24	20	10	40	220
14	10001	John	Mar-24	30	20	10	260
15	10001	John	Apr-24	10	30	20	270
16	10001	John	May-24	20	10	30	290
17	10002	Peter	Mar-23
18	10002	Peter	Apr-23	200
19	10002	Peter	May-23		200
20	10002	Peter	Jun-23			200
21	10002	Peter	Jul-23				200
22	10002	Peter	Aug-23				200
23	10002	Peter	Sep-23				200
24	10002	Peter	Oct-23	100			200
25	10002	Peter	Nov-23	200	100		200
26	10002	Peter	Dec-23	300	200	100	200
27	10002	Peter	Jan-24	100	300	200	300
28	10002	Peter	Feb-24	200	100	300	500
29	10002	Peter	Mar-24	100	200	100	800
30	10002	Peter	Apr-24		100		900
31	10002	Peter	May-24				900
32	10003	Sue	Mar-23
33	10003	Sue	Apr-23
34	10003	Sue	May-23
35	10003	Sue	Jun-23
36	10003	Sue	Jul-23
37	10003	Sue	Aug-23
38	10003	Sue	Sep-23				1000
39	10003	Sue	Oct-23				500
40	10003	Sue	Nov-23				100
41	10003	Sue	Dec-23
42	10003	Sue	Jan-24
43	10003	Sue	Feb-24
44	10003	Sue	Mar-24
45	10003	Sue	Apr-24
46	10003	Sue	May-24
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