A complete 10-tab Excel system for managing accounts receivable, tracking collections activity, logging payments, and closing outstanding balances — built for small businesses, freelancers, and service companies.
Real-time metrics — total outstanding, collected YTD, collection rate, aging summary. Everything auto-updates.
Track every account. Days outstanding and aging buckets calculate automatically from invoice date.
Document every call, email, and contact attempt. Track outcomes, promises to pay, and follow-up dates.
6 professional letter templates included — from friendly reminder to final demand with legal language.
Set up structured installment agreements. Track payments made, balance remaining, and missed payments.
Word-for-word phone scripts and letter templates that get debtors to respond and pay.
Enter the code you received to download the Collections & AR Tracker instantly.
Don't have an access code? Email comerciantellc@gmail.com to gain access.
Invalid access code. Please check and try again.
Your Collections & AR Tracker is ready to download. Open it in Microsoft Excel or Google Sheets.
⬇ Download Collections & AR TrackerExcel (.xlsx) · Compatible with Microsoft Excel & Google Sheets