Order & Delivery Tracker with Late Order Alerts (Excel & Google Sheets)
Track every customer order from received to delivered, and catch late orders before your customers complain.
What's inside:
- Orders: customer, channel, amount, payment status, delivery status, courier and tracking number
- Promised delivery date and days taken calculate automatically
- Late orders (past the promised date and not delivered) turn red
- Dashboard: total orders, sales, on-time delivery rate, average delivery days and unpaid amount
- Orders by status and a monthly chart
- Start Here guide and example data
Details:
- Room for 3,000 orders
- Any currency
- Works in Microsoft Excel and Google Sheets
- Formulas are protected so they can't be broken by accident
Who it's for: online sellers, Instagram and WhatsApp shops, and small businesses that deliver orders.
Licence: for use by one business. Please don't share or resell the file.
Questions? Message me through this shop and I'll help.