I will build an excel inventory and customer balance tracker
Electrical and Electronics Engineering Student
About this Gig
Still tracking stock and customer balances in a notebook or in scattered spreadsheets? I will build one clear Excel file around the way your small business works. No new software to learn.
The file can include stock in and out with current quantity, low stock alerts, customer and supplier balances, payments and due dates with overdue warnings, and monthly totals for sales, collections, purchases and payments.
Good for wholesalers, spare parts shops, repair services and similar small businesses.
How we work: You send your current file or a sample page and tell me what you need. We agree on the scope, then I build the file. You test it with sample data and I explain how to use it in writing.
Please message me before ordering so I can confirm your needs fit this package. The file uses standard formulas, without macros. It does not replace official invoicing or accounting software.
Platform:
Excel
Development technology:
Excel
Expertise:
Formatting
•
Formulas
•
Functions

