Multi-Company Invoicing System
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 sheets track paid and unpaid invoices per customer.
- Industry
- Security Services
- Deliverable
- Invoicing Template.xlsm
- Built with
- Excel VBA, PDF export
Before
Recurring invoices for several companies were prepared one file at a time.
After
All companies are invoiced from one file, PDFs are generated one by one or for a whole month and paid status is tracked.
More like this
Related projects
Baseball Roster & Lineup Generator
Sports
Creates fair fielding lineups for a youth baseball team. Positions are randomised inning by inning while the equalizer rules make sure every player sits, catches and…
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
Bill of Materials Cost Comparison
Manufacturing
Compares part costs across product models from a grouped bill of materials. Raw data is imported and a results matrix shows quantity, cost and platform for…
View project