I will build an excel inventory and customer balance tracker

Turkey

I speak English, German

Electrical and Electronics Engineering Student

I am an Electrical and Electronics Engineering student focused on PCB design, embedded systems, and engineering software. I work with KiCad, Python, C, Arduino, and STM32 to develop practical electron...
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

My Portfolio