Examples
Invoice Table Example
eDays Overdue column manually added with formula:
IF(
Not(Paid) AND [Due Date] < Today(),
Today() - [Due Date],
""
)
Grouped by Customer column
Invoices
Customer
Invoice
Due Date
Total Amount
Paid
Days Overdue
Invoice PDF
Sonnenschein Family Store
1
1037
3/1/2022
$362.07
1260 days
0969 Ocean View Road
1
1036
3/1/2022
$477.50
1260 days
Cool Cars
2
1004
2/17/2022
$2,369.52
1038
5/7/2022
$489.71
1193 days
Mark Cho
1
1035
3/1/2022
$314.28
1260 days
Sushi by Katsuyuki
3
1017
2/13/2022
$80.00
1019
2/27/2022
$80.00
1262 days
1018
2/20/2022
$80.00
1269 days
Rondonuwu Fruit and Vegi
1
1034
2/28/2022
$78.60
1261 days
Geeta Kalapatapu
1
1033
2/28/2022
$629.10
1261 days
Amy's Bird Sanctuary
2
1021
2/7/2022
$459.00
1282 days
1001
2/26/2022
$108.00
Travis Waldron
3
1032
2/26/2022
$414.72
1263 days
1013
2/17/2022
$81.00
1009
2/26/2022
$103.55
Jeff's Jalopies
1
1022
2/7/2022
$81.00
1282 days
55 Twin Lane
1
1005
2/20/2022
$54.00
1269 days
Red Rock Diner
1
1023
2/27/2022
$70.00
1262 days
Paulsen Medical Supplies
1
1015
2/27/2022
$954.75
1262 days
Barnett Design
1
1012
2/15/2022
$274.50
1274 days
Weiskopf Consulting
1
1010
2/27/2022
$375.00
1262 days
John Melton
1
1007
2/4/2022
$750.00
1285 days
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.