I will create an excel invoice tracker
About this Gig
Keep track of your invoices and see what has been paid, what is outstanding and what is overdue.
I will create a custom Excel invoice tracker for your small business or freelance activity.
Your package includes:
- One editable Excel workbook with up to 3 sheets.
- Invoice register with client, invoice number, amount and due date.
- Payment tracking with paid, unpaid and overdue status.
- A simple dashboard showing total invoiced, collected and outstanding.
- Up to 5 custom formulas, with formatting to highlight overdue invoices.
- Brief instructions for using your workbook.
- 2 revisions within the original agreed scope.
The workbook can be prepared in English or Spanish.
This service covers creating the tracker. Manual entry of existing invoices, macros, external integrations and tax advice are not included.
Please share your Excel version, preferred language and required fields. For additional features, contact me before ordering so we can agree on the scope.
Platform:
Excel
•
Google Sheets
•
Microsoft Office
Development technology:
Google Apps Script
•
Excel
Expertise:
Forms
•
Functions
•
Dashboard
•
Cleaning
FAQ
What do you need to get started?
Your Excel version, preferred language, currency and the fields you want to track. You can also share an example with fictional data.
Will I receive an editable Excel file?
Yes. You will receive an editable .xlsx workbook with formulas, a simple dashboard and brief instructions. Macros and external integrations are not included.

