Build the AR aging report in Excel
Email Carly and she'll pull open invoices from QuickBooks, bucket them 0-30 / 31-60 / 61-90 / 90+ in the AR Aging workbook in Excel, and draft Outlook emails to every customer over 60 days late with the specific invoice numbers and amounts — so collections starts before coffee, not after the close.
What Carly does
- 01 Pull every open invoice from QuickBooks with customer + amount + due date
- 02 Bucket each invoice into 0-30, 31-60, 61-90, or 90+ days late
- 03 Write the bucketed table into the AR Aging workbook in Excel on SharePoint
- 04 For each customer over 60 days late, list the specific invoices and totals
- 05 Draft an Outlook collections email per overdue customer for one-click send
Collections starts Monday morning, not at month-end
The AR aging table is in the Excel workbook before the team logs on. Outlook drafts are queued per customer with the actual invoice numbers — no copy-paste from QuickBooks, no spreadsheet wrangling.
Email this to Carly to kick it off.
Hey Carly, Can you refresh the AR aging report for me? Pull every open invoice from QuickBooks with customer, amount, and due date, then bucket them 0-30, 31-60, 61-90, and 90+ and write the table into the AR Aging workbook in Excel on SharePoint. For every customer over 60 days late, draft an Outlook email with the specific invoice numbers and amounts so I can review and send. Keep the tone firm but friendly. Thanks!
More recipes for finance & ops teams
Match payouts to Xero bank lines, calculate variance, post anything over $50 to #finance.
Read →NetSuite + Stripe into a Microsoft Excel close package with revenue, OpEx variance, runway, and open items.
Read →Apply GL codes to the week's QuickBooks transactions and append to the Expense Ledger sheet.
Read →Ready to automate your busywork?
Carly schedules, researches, and briefs you—so you can focus on what matters.
See what people say
"Before Carly, I relied on a Calendly link, but the whole process felt impersonal and not very professional. Carly changed that by handling all the back-and-forth, so I'm no longer stuck in endless email threads trying to line up schedules.
Now Carly reaches out to candidates, shares my real-time availability, lets them pick a slot, then sends a Zoom link and drops it straight into my calendar. She sends reminders to both of us before each call, which has significantly reduced no-shows and last-minute confusion.
On top of scheduling, Carly acts like a full executive assistant, sending me my schedule the night before so I can prepare for each call. It reminds me of the old x.ai assistant, but Carly is noticeably smarter, faster, and better suited to my healthcare recruitment business."