Daily AR Scan and Reminder Queue
Run this every morning to pull all open invoices, reconcile payment status, classify accounts by aging bucket, and queue the day's reminder emails for review.
- Pull all open invoices from QuickBooks using the accounts-receivable aging report.
- Cross-reference Stripe for any invoice tied to a card-billed customer.
- Classify each remaining open invoice into an aging bucket based on days past due: Current (not yet due), Early (1-7 days past due), Mid (8-30 days past due), Late (31-60 days past due), Critical (61-plus days past due).