Invoice Generator with Customer & Product Database
An invoicing system for a skincare wholesaler. Invoices are created from customer and product databases, saved, searched, reloaded and printed, and a best-selling report is updated from the invoice items.
- Industry
- Wholesale Distribution
- Deliverable
- Invoicing System.xlsm
- Built with
- Excel VBA, Database design
Before
Invoices were created in separate files and best sellers were counted manually.
After
Invoices come from customer and product databases, can be searched and reloaded, and update a best-selling report.
More like this
Related projects
Multi-Company Invoicing System
Security Services
Recurring service invoicing for several companies from one file. Invoices are saved to a database, PDFs are generated individually or for a whole month, and summary…
View project
Cost & Savings Progression Model
Telecom / Hardware
A scenario model that projects component costs and savings as hardware moves from analog to IP over time. One button recalculates four scenarios using the ramp…
View project
Hotel & Restaurant Management System
Hospitality
A complete hotel system inside Excel. Rooms are shown on a building map with live status colours, and the restaurant module handles table bookings, orders, menu…
View project