I will build an excel overdue invoice tracker and match your payments
Invoice Tracking and Spreadsheet Cleanup
About this Gig
See which invoices are overdue, how much is still outstanding, and who needs a follow-up this week. I build an Excel workbook you can refresh from your own records.
The full setup includes payment matching, duplicate and unmatched payment flags, an overdue invoice view, a source-total check, and a short refresh walkthrough. It covers one business, one currency, up to two Excel or CSV exports and 500 combined rows, with one revision.
Already have one invoice export with payment amounts? Message me for a smaller fixed-price pilot. I can turn it into an overdue list with remaining balances and a follow-up column.
Before ordering, send your file format, approximate row count, currency, and deadline. A few redacted example rows are enough to scope it. See the sample in the gallery for an example using fictional data.
Platform:
Excel
Development technology:
Excel
Expertise:
Formatting
•
Formulas
•
Dashboard
•
Cleaning
•
Data validation
FAQ
What files and information do you need?
Send up to two Excel or CSV exports (500 combined rows), with invoice and payment IDs, due dates, amounts, and a field linking the files. Include the currency, reporting date, and any control totals. Remove unrelated personal or bank details.

