Deduction Management System
Trade-spend platform that standardises imported invoices, reports on promotion performance and chases claims until paid.
- Date
- Apr 2024
- Role
- Tech Lead
- Engagement
- 3,507 hrs
The challenge
Trade deductions arrived as thousands of invoices in different formats. The client couldn't see which promotions paid off or which claims were still unpaid.
What we built
- Invoice templatesA templating engine for creating different invoice layouts.
- Pattern recognitionInvoice number patterns identify each invoice's category.
- Bulk importEvery invoice imported and standardised in one pass.
- Promotion reportsComplex reports on how each promotion performed.
- Claims trackingClaims categorised and followed up until paid back.
How it works
- Invoices are imported
- Number patterns assign categories
- Data is standardised
- Reports reveal promotion performance
- Claims are chased until repaid
Highlights
- 3,507 hours and still running
- Messy invoices become clean, reportable data
- Smarter promotion decisions from real numbers
Tech stack
- Laravel
- Vue.js
- MySQL
- PHP
