Case studies

Real problems, fixed.

A sample of recent engagements. Details are described generically to protect client confidentiality — happy to speak to the specifics of similar problems on a call.

Reporting & analytics · Systems integration

Cin7 → Zoho Analytics reporting & bonus-calculation pipeline

The problem

Sales, product cost and margin data lived in Cin7, but leadership had no reliable, real-time view of business performance — and salesperson bonus calculations were done manually against exported spreadsheets, a slow process prone to error and dispute.

What we built
  • An automated data pipeline from Cin7 into Zoho Analytics, replacing manual exports
  • A reporting layer covering sales invoices, product costs and margin by product, customer and period
  • A calculation layer that automatically computes salesperson performance metrics and bonus amounts from the underlying transaction data
Result

Leadership gets an always-current view of business performance without waiting on manual reporting, and bonus calculations are now consistent, auditable and no longer a manual monthly task.

Systems integration · Workflow automation

Automated purchase order creation for inbound freight

The problem

Purchase orders for inbound stock had to be reconciled by hand against a scattered set of interim documents from shipping companies — freight invoices, customs paperwork and related charges — each in a different format, arriving at different times.

What we built
  • An automated process that ingests the various shipping-company documents (freight costs, customs charges and related fees)
  • Logic to consolidate these interim documents into a single, correctly-costed purchase order per shipment
  • Automatic creation of the purchase order in the client's system, ready for approval rather than manual data entry
Result

Inbound stock costing is now consistent and largely hands-off, removing a recurring manual reconciliation job and reducing costing errors on landed inventory.

Payroll & compliance

Multi-state employee entitlements & payroll interpretation engine

The problem

A national employer operating across multiple states needed an ongoing, defensible way to calculate what it owed employees — not a one-off report, but a running calculation model that stayed correct as employment conditions, state jurisdictions and pay periods changed.

What we built

Working directly with the client's payroll and legal teams, we built a calculation model covering the full range of an entitlements and payroll interpretation engine, including:

  • Long service leave accrual and eligibility, calculated per the relevant rules in each state the company operated in (state LSL rules vary significantly across Australia)
  • Annual leave and personal/carer's leave accrual, including leave loading where applicable
  • Ordinary hours, overtime and applicable penalty rates, allowances and casual loading
  • Public holiday entitlements and pay treatment
  • Termination payments — unused leave payouts, notice period and final pay calculations
  • Cross-checks against superannuation guarantee obligations arising from calculated pay
  • An audit trail for every calculated figure, so payroll and legal could trace any entitlement back to the underlying rule and input data
Result

An ongoing, auditable entitlements calculation the client's payroll team runs and trusts, built and signed off in consultation with their legal team, and documented well enough for the client's own staff to maintain.

Have something similar?

Tell us what's breaking — we'll tell you if it's a fit.