Copy-paste templates for the monthly AR review
https://archon-partners.com/guides/ar-aging-report/

From Archon & Partners. Replace everything in [square brackets], read each one, and use it from your own accounts. Check your agreement before mentioning interest, suspension or any contract term. This is not legal or tax advice.

=== 1. Aging buckets from an invoice log ===
When: Set up once in the sheet you already use for invoices.
Subject: Due date in column G, status in column H, amount in column F

Days past due (column I):
=IF(H2="Paid", "", [as-of date cell] - G2)

Bucket (column J):
=IF(I2="", "", IFS(I2<=0, "Current", I2<=30, "1-30", I2<=60, "31-60", I2<=90, "61-90", TRUE, "Over 90"))

Total per bucket (one cell each):
=SUMIFS(F:F, J:J, "Current")
=SUMIFS(F:F, J:J, "1-30")
=SUMIFS(F:F, J:J, "31-60")
=SUMIFS(F:F, J:J, "61-90")
=SUMIFS(F:F, J:J, "Over 90")

Put the as-of date in one cell (the last day of the month) rather than using TODAY(), so the report does not change after you run it.

=== 2. Monthly AR review note ===
When: After the month closes. Keep each month's note so you can compare.
Subject: AR review as of [date]

Total open: [total]   Last month: [total]
Over 60 days: [amount] ([share]% of total)   Last month: [share]%
Matches balance sheet AR: [yes / no, difference and reason]

Over 90 days:
- [Client], invoice [number], [amount]: [next step], [owner], by [date]

61 to 90 days:
- [Client], invoice [number], [amount]: [next step], [owner], by [date]

31 to 60 days:
- [Client], invoice [number], [amount]: [next step], [owner], by [date]

Clients that moved to an older column: [names]
Odd rows fixed: [credits applied, retainers reclassified, invoices re-sent]

=== 3. Statement email for a client with several open invoices ===
When: When one client has invoices in more than one column.
Subject: [Client name]: statement of open invoices as of [date]

Hi [first name],

Attached is a statement of the open invoices on your account as of [date]:

- Invoice [number], [project], [amount], due [due date]
- Invoice [number], [project], [amount], due [due date]
- Invoice [number], [project], [amount], due [due date]

Total open: [total]. Could you check this against your records and tell me when we can expect payment? If any invoice is missing on your side, I will send a copy today.

I will call you on [day] to go through it.

[your name]
[firm name]