Sales & Purchase Inventory Data Model
A relational data model in Excel with customers, suppliers, products and countries. Sales and purchase orders are entered through forms, stock levels update automatically and customs duty is applied by country.
- Industry
- Trading
- Deliverable
- Inventory Data Model.xlsm
- Built with
- Excel VBA, UserForms, Data modelling
Before
Sales, purchases and stock were tracked in unconnected sheets.
After
Orders are entered through forms, stock updates automatically and customs duty is applied by country.
More like this
Related projects
Timesheet & Billing Dashboard
Legal Services
A timesheet and payout system for a small legal team. Users log in by role, workers record tasks and hours, and the admin dashboard shows billed,…
View project
Production Order Tracker
Custom Products / E-commerce
Moves custom orders through the workshop. Orders flow from the order list to production lines and then to packing as tick boxes are checked, so the…
View project
Account Reporting Tracker
Food & Beverage Brokerage
A shared tracker for account managers. Each update entered on the form is sent to the internal database, a master log file and a separate file…
View project