I will create an invoice and accounts receivable tracker in excel

Not sure which customers have paid and who still owes you? I will build a simple Excel tracker for your invoices, so you can see the status at a glance.

What you get:

• Invoice list with amount, amount paid and balance due
• Paid and overdue status that updates by formula
• A summary sheet with total invoiced, total paid, amount outstanding and collection rate

I am an Accounting & Finance student building my experience. Please send your invoice list (Excel or CSV) and tell me the date you want overdue status measured against.