WORKBOOKRECEIVABLES AGING
BUILDER
createWorkbook()SHEETS
2OOXML PARTS
10 filesFEATURES
8DATASET
small64 open invoices with days late and buckets computed in TypeScript, an aging pivot by customer filtered by collector, and a doughnut of receivables by age.
schema.ts
Open invoicesA1:K67, frozen at B3
click a cell to inspect itfx
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
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
Accounts receivable as of 31 October 2026
Invoice
Customer
Collector
Issued
Due
Amount
Paid
Open
Days late
Bucket
Last note
INV-26-4105
Bauch - Fadel
Priya Nair
13 Oct 2026
12 Nov 2026
17,900.00
0.00
17,900.00
0
Current
Disputed: duplicate line
INV-26-4110
Jast Inc
Ana Ruiz
13 Oct 2026
12 Nov 2026
40,000.00
16,000.00
24,000.00
0
Current
Paid partially, chasing balance
INV-26-4111
Hoppe and Sons
Tom Becker
13 Oct 2026
12 Nov 2026
41,400.00
0.00
41,400.00
0
Current
Paid partially, chasing balance
INV-26-4113
Rempel - Schmidt
Priya Nair
23 Oct 2026
22 Nov 2026
19,000.00
7,600.00
11,400.00
0
Current
Promised payment end of week
INV-26-4118
Mills Inc
Priya Nair
23 Oct 2026
22 Nov 2026
28,100.00
0.00
28,100.00
0
Current
AP contact on leave
INV-26-4123
Senger - Hartmann-Medhurst
Tom Becker
05 Oct 2026
04 Nov 2026
2,200.00
0.00
2,200.00
0
Current
Sent reminder #2
INV-26-4126
Wiza - Willms
Ana Ruiz
13 Oct 2026
12 Nov 2026
6,500.00
2,600.00
3,900.00
0
Current
Waiting for PO number
INV-26-4129
Funk, Hartmann and Koelpin
Priya Nair
03 Oct 2026
02 Nov 2026
5,200.00
2,080.00
3,120.00
0
Current
Promised payment end of week
INV-26-4132
Rempel - Schmidt
Ana Ruiz
17 Oct 2026
16 Nov 2026
32,600.00
0.00
32,600.00
0
Current
Disputed: duplicate line
INV-26-4143
Rempel - Schmidt
Tom Becker
17 Oct 2026
16 Nov 2026
17,000.00
0.00
17,000.00
0
Current
Waiting for PO number
INV-26-4148
Mills Inc
Ana Ruiz
26 Oct 2026
25 Nov 2026
24,200.00
9,680.00
14,520.00
0
Current
Waiting for PO number
INV-26-4150
Reilly-Dickinson - Romaguera
Tom Becker
07 Oct 2026
06 Nov 2026
13,600.00
5,440.00
8,160.00
0
Current
Waiting for PO number
INV-26-4155
Mills Inc
Tom Becker
20 Oct 2026
19 Nov 2026
16,800.00
0.00
16,800.00
0
Current
Waiting for PO number
INV-26-4163
Dooley, Larkin and Welch
Ana Ruiz
09 Oct 2026
08 Nov 2026
20,100.00
0.00
20,100.00
0
Current
INV-26-4104
Rempel - Schmidt
Tom Becker
01 Sep 2026
01 Oct 2026
16,900.00
0.00
16,900.00
30
1-30
INV-26-4108
Rempel - Schmidt
Ana Ruiz
01 Sep 2026
01 Oct 2026
40,300.00
0.00
40,300.00
30
1-30
Disputed: duplicate line
INV-26-4128
Mills Inc
Tom Becker
02 Sep 2026
02 Oct 2026
37,700.00
0.00
37,700.00
29
1-30
Waiting for PO number
INV-26-4151
Schmidt, Yost and Littel
Ana Ruiz
03 Sep 2026
03 Oct 2026
23,400.00
0.00
23,400.00
28
1-30
Paid partially, chasing balance
INV-26-4114
Ondricka, Braun and Funk
Tom Becker
05 Sep 2026
05 Oct 2026
20,200.00
0.00
20,200.00
26
1-30
Paid partially, chasing balance
INV-26-4112
Wehner, Purdy and Morar
Tom Becker
06 Sep 2026
06 Oct 2026
18,400.00
0.00
18,400.00
25
1-30
INV-26-4106
Bauch - Fadel
Priya Nair
07 Sep 2026
07 Oct 2026
33,700.00
0.00
33,700.00
24
1-30
Promised payment end of week
INV-26-4116
Rempel - Schmidt
Priya Nair
07 Sep 2026
07 Oct 2026
34,200.00
0.00
34,200.00
24
1-30
Promised payment end of week
INV-26-4117
Hoppe and Sons
Priya Nair
07 Sep 2026
07 Oct 2026
25,700.00
10,280.00
15,420.00
24
1-30
Paid partially, chasing balance
INV-26-4109
Dooley, Larkin and Welch
Priya Nair
10 Sep 2026
10 Oct 2026
23,800.00
0.00
23,800.00
21
1-30
INV-26-4127
Dooley, Larkin and Welch
Ana Ruiz
10 Sep 2026
10 Oct 2026
20,000.00
0.00
20,000.00
21
1-30
Paid partially, chasing balance
INV-26-4101
Mertz Inc
Tom Becker
12 Sep 2026
12 Oct 2026
7,800.00
0.00
7,800.00
19
1-30
INV-26-4141
Rempel - Schmidt
Priya Nair
13 Sep 2026
13 Oct 2026
21,500.00
0.00
21,500.00
18
1-30
Sent reminder #2
INV-26-4156
Ondricka, Braun and Funk
Tom Becker
19 Sep 2026
19 Oct 2026
18,300.00
0.00
18,300.00
12
1-30
Paid partially, chasing balance
INV-26-4135
Schmidt, Yost and Littel
Tom Becker
22 Sep 2026
22 Oct 2026
9,600.00
0.00
9,600.00
9
1-30
Sent reminder #2
INV-26-4142
Funk, Hartmann and Koelpin
Priya Nair
23 Sep 2026
23 Oct 2026
27,400.00
0.00
27,400.00
8
1-30
Sent reminder #2
INV-26-4139
Mayert, McGlynn and Windler
Ana Ruiz
27 Sep 2026
27 Oct 2026
7,100.00
0.00
7,100.00
4
1-30
AP contact on leave
INV-26-4103
Rempel - Schmidt
Priya Nair
28 Sep 2026
28 Oct 2026
36,200.00
0.00
36,200.00
3
1-30
AP contact on leave
INV-26-4119
Mertz Inc
Priya Nair
28 Sep 2026
28 Oct 2026
22,500.00
9,000.00
13,500.00
3
1-30
Promised payment end of week
INV-26-4158
Mayert, McGlynn and Windler
Tom Becker
28 Sep 2026
28 Oct 2026
41,700.00
16,680.00
25,020.00
3
1-30
Waiting for PO number
INV-26-4145
Reynolds, Roberts and Koelpin-Kuhn
Ana Ruiz
30 Sep 2026
30 Oct 2026
9,400.00
0.00
9,400.00
1
1-30
INV-26-4144
Mills Inc
Tom Becker
02 Aug 2026
01 Sep 2026
15,100.00
0.00
15,100.00
60
31-60
Promised payment end of week
INV-26-4122
Reynolds, Roberts and Koelpin-Kuhn
Tom Becker
03 Aug 2026
02 Sep 2026
16,100.00
6,440.00
9,660.00
59
31-60
AP contact on leave
INV-26-4107
Schmidt, Yost and Littel
Tom Becker
04 Aug 2026
03 Sep 2026
23,000.00
0.00
23,000.00
58
31-60
Promised payment end of week
INV-26-4102
Hoppe and Sons
Ana Ruiz
05 Aug 2026
04 Sep 2026
13,100.00
0.00
13,100.00
57
31-60
Paid partially, chasing balance
INV-26-4120
Senger - Hartmann-Medhurst
Ana Ruiz
08 Aug 2026
07 Sep 2026
4,900.00
0.00
4,900.00
54
31-60
AP contact on leave
INV-26-4124
Wiza - Willms
Tom Becker
11 Aug 2026
10 Sep 2026
18,500.00
7,400.00
11,100.00
51
31-60
Disputed: duplicate line
INV-26-4147
Wehner, Purdy and Morar
Ana Ruiz
12 Aug 2026
11 Sep 2026
26,800.00
0.00
26,800.00
50
31-60
Waiting for PO number
INV-26-4136
Bauch - Fadel
Tom Becker
19 Aug 2026
18 Sep 2026
27,900.00
0.00
27,900.00
43
31-60
AP contact on leave
INV-26-4130
Ondricka, Braun and Funk
Priya Nair
25 Aug 2026
24 Sep 2026
40,800.00
0.00
40,800.00
37
31-60
Disputed: duplicate line
INV-26-4134
Dicki Inc
Tom Becker
27 Aug 2026
26 Sep 2026
22,100.00
8,840.00
13,260.00
35
31-60
AP contact on leave
INV-26-4149
Dooley, Larkin and Welch
Priya Nair
31 Aug 2026
30 Sep 2026
20,200.00
0.00
20,200.00
31
31-60
Paid partially, chasing balance
INV-26-4152
Reilly-Dickinson - Romaguera
Ana Ruiz
05 Jul 2026
04 Aug 2026
26,500.00
10,600.00
15,900.00
88
61-90
Waiting for PO number
INV-26-4146
Reilly-Dickinson - Romaguera
Ana Ruiz
06 Jul 2026
05 Aug 2026
25,300.00
0.00
25,300.00
87
61-90
Disputed: duplicate line
INV-26-4100
Ondricka, Braun and Funk
Ana Ruiz
07 Jul 2026
06 Aug 2026
30,800.00
0.00
30,800.00
86
61-90
Sent reminder #2
INV-26-4137
Senger - Hartmann-Medhurst
Priya Nair
07 Jul 2026
06 Aug 2026
28,700.00
11,480.00
17,220.00
86
61-90
Promised payment end of week
INV-26-4153
Wiza - Willms
Ana Ruiz
15 Jul 2026
14 Aug 2026
21,800.00
0.00
21,800.00
78
61-90
Promised payment end of week
INV-26-4162
Hoppe and Sons
Tom Becker
16 Jul 2026
15 Aug 2026
29,500.00
0.00
29,500.00
77
61-90
INV-26-4138
Wiza - Willms
Ana Ruiz
17 Jul 2026
16 Aug 2026
39,200.00
15,680.00
23,520.00
76
61-90
Paid partially, chasing balance
INV-26-4131
Hoppe and Sons
Priya Nair
18 Jul 2026
17 Aug 2026
1,900.00
0.00
1,900.00
75
61-90
Paid partially, chasing balance
INV-26-4157
Wiza - Willms
Ana Ruiz
20 Jul 2026
19 Aug 2026
11,600.00
0.00
11,600.00
73
61-90
AP contact on leave
INV-26-4154
Mayert, McGlynn and Windler
Ana Ruiz
21 Jul 2026
20 Aug 2026
7,400.00
0.00
7,400.00
72
61-90
Sent reminder #2
INV-26-4121
Dicki Inc
Tom Becker
22 Jul 2026
21 Aug 2026
14,000.00
0.00
14,000.00
71
61-90
Disputed: duplicate line
INV-26-4161
Wehner, Purdy and Morar
Priya Nair
22 Jul 2026
21 Aug 2026
22,200.00
0.00
22,200.00
71
61-90
AP contact on leave
INV-26-4159
Feest, Bartoletti and Labadie
Priya Nair
25 Jul 2026
24 Aug 2026
27,100.00
0.00
27,100.00
68
61-90
INV-26-4125
Schmidt, Yost and Littel
Ana Ruiz
26 Jul 2026
25 Aug 2026
37,800.00
0.00
37,800.00
67
61-90
AP contact on leave
INV-26-4133
Dooley, Larkin and Welch
Priya Nair
28 Jul 2026
27 Aug 2026
32,700.00
0.00
32,700.00
65
61-90
Sent reminder #2
INV-26-4140
Senger - Hartmann-Medhurst
Ana Ruiz
18 Apr 2026
18 May 2026
36,700.00
0.00
36,700.00
166
90+
Sent reminder #2
INV-26-4160
Wiza - Willms
Tom Becker
09 May 2026
08 Jun 2026
16,400.00
6,560.00
9,840.00
145
90+
AP contact on leave
INV-26-4115
Mertz Inc
Priya Nair
27 Jun 2026
27 Jul 2026
39,600.00
0.00
39,600.00
96
90+
1,458,100.00
146,360.00
1,311,740.00
Cell in the file