09 / 15 · Business systems

Order, Invoice & Commission Management CRM

An order, invoice and commission system for running school spirit wear programs at scale.

Client
School spirit wear programs
Type
Business systems
My role
Analyst • Architect • Coder • Tester

Before

Orders for each student, with sizes, colors, logos and personalization, were tracked in spreadsheets, along with invoices, part payments and commissions.

What I built

Administrators create orders for each student and set up each product's options. Invoices are generated with line items, part payments and amounts due are tracked, and commissions are calculated automatically. A dashboard shows total orders, profit, money collected and money still owed, and school representatives have their own logins.

What it handles

  1. 01Student-level order and invoice management
  2. 02Configurable products with size, color, logo, and personalization options
  3. 03Dynamic invoice generation with line-item breakdowns
  4. 04Partial payment and amount-due tracking
  5. 05Commission calculation and profit reporting
  6. 06Real-time financial dashboard (orders, profit, collections, dues)
  7. 07Role-based access for admins and school representatives
  8. 08Notes and payment method tracking per order

Built with

  • Laravel
  • Spatie
  • MySQL
  • jQuery
  • PDF Generation

Running on spreadsheets too?

Tell me what the spreadsheet does today and what you wish it did. Messages come straight to me.

contact@arc-max.com