Browse categories
Explore
Fiverr Pro
English
$
USD
I will create a custom excel invoice and payment tracker
About this Gig
top losing track of unpaid invoices in messy spreadsheets.
I will build a custom Excel invoice and payment tracker for freelancers and small businesses, with a clean layout and formulas tailored to your workflow.
Depending on your package, your Excel workbook can include:
- Invoice register with clients, amounts and due dates
- Payments log, including partial payments
- Automatic paid and outstanding balance calculations
- Paid, Part paid, Pending and Overdue statuses
- Summary dashboard with monthly charts
- Basic checks for missing or inconsistent data
You will receive an editable .xlsx file with simple instructions. I test calculations with sample data before delivery.
Please note: This is a manually updated Excel workbook, not bank-connected accounting software. Automatic emails, online synchronization and accounting or tax advice are not included.
Message me before ordering if you have an existing spreadsheet, special formulas or a larger workflow.
Platform:
Excel
Development technology:
Excel
FAQ
Can I enter more invoices after receiving the file?
Yes. The number of configured rows depends on the package. I will show you how to enter data correctly and can quote separately for larger workbooks.
Does the file track partial payments?
Yes, in the Standard and Premium packages. Multiple payments can be linked to a single invoice using the invoice ID.
Does the tracker automatically calculate unpaid balances?
Yes. Once you enter invoices and payments in the provided input fields, Excel calculates paid amounts and remaining balances.
Does it connect to my bank or send payment reminders?
No. This is an offline, manually updated Excel workbook. Bank integration, online synchronization and automatic email reminders are not included.
Can you customize the columns or the dashboard?
Yes. Send me an example or a list of requirements before ordering. The scope and quote depend on the complexity.
Will you use my real financial information in portfolio screenshots?
No. Portfolio samples use fictional data. If you share business records, only send the information necessary for the order and remove sensitive details where possible.
