Order Tracker

This order tracker system is a full suite to track any type of orders from customers in excel. You can keep track of each payment done to each order as well as print receipts, analyze data, update order status, and track transactions made. All this with the power ,flexibility, and versatility of excel.

The system features a lock system where sheets get protected so for example only admins can enter data into the sheet manually. Whoever is using it can only enter data via the VBA form.

System highlights

• Form style order entry with auto order number generation
• Track delivery dates
• Track revenue
• Track items you sell the most or less
• Print out receipts
• Cancel orders and track status on each
• Store customer information (telephone & email)