Automated Invoice Tracking Workbook
Budget / Salary$30–250
TypeFreelance project
LocationRemote
Posted3 hours ago
My Excel file has grown into several inter-linked sheets, yet I’m no longer certain how they connect. Each invoice is logged with its number, customer name, invoice date, due date, and total amount, and every payment is tied back to the invoice number. I now need the workbook streamlined so it handles the remaining legwork for me.
What I need you to build into the existing file:
• A payment log that lets me enter multiple payments against a single invoice and instantly shows the updated outstanding balance.
• Conditional formatting that flags any invoice past its due date with a balance still showing.
• Drop-down lists for customer names so the spelling stays consistent across the workbook.
• A dynamic monthly dashboard that rolls up payments received, outstanding balances, and a quick list of customers whose invoices have slipped overdue.
• Formulas and tables that keep all historical records intact and continue working as I add new rows.
Deliverable: an editable .xlsx that meets the above points plus a concise “how-to” note I can follow for day-to-day updates.
Please let me know your estimated turnaround time and include a brief example of similar Excel automation you’ve completed.
What I need you to build into the existing file:
• A payment log that lets me enter multiple payments against a single invoice and instantly shows the updated outstanding balance.
• Conditional formatting that flags any invoice past its due date with a balance still showing.
• Drop-down lists for customer names so the spelling stays consistent across the workbook.
• A dynamic monthly dashboard that rolls up payments received, outstanding balances, and a quick list of customers whose invoices have slipped overdue.
• Formulas and tables that keep all historical records intact and continue working as I add new rows.
Deliverable: an editable .xlsx that meets the above points plus a concise “how-to” note I can follow for day-to-day updates.
Please let me know your estimated turnaround time and include a brief example of similar Excel automation you’ve completed.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.