Case Studies
Please find below examples of work performed by our team to help you understand the types of services we offer.
In each case certain information, including the client's business name, has been altered to preserve client confidentiality.
01
Debt Collection Ledger Automation (Australian Government Client)
The Problem
A government agency was manually entering 800–1,000 debt recovery records every month from its external debt collector.
The process took 2–3 full days of work from a four-person finance team and had to remain manually controlled due to strict privacy and data-handling rules.
The agency needed a solution that dramatically reduced effort while still allowing staff to maintain full human oversight.
The Solution
Crystal Logic built a controlled, on-site Excel solution that reduced a three-day task to 20 minutes.
Staff simply paste the monthly report and exported customer data into the workbook. The system:
-
automatically matches recovered payments to customer records
-
generates a clean, ready-to-import ledger
-
preserves full manual oversight for compliance purposes
Only one staff member is now required, freeing the finance team to focus on higher-value work.
02
Backdated Allowance Recalculation (Australian Mining & Equipment Dealer)
The Problem
A mining services company discovered that a clause in its Enterprise Agreement regarding Public Holiday Allowance had been under-interpreted since 2017.
As a result, 1,200 current and former employees required recalculation of allowance payments across multiple EA versions, changing rosters, changing pay rates, and shifting work patterns—spanning seven years of employment history.
Given the sensitivity and potential for dispute, the company required an independent and precise third-party assessment.
​
The Solution
Crystal Logic analysed detailed payroll reports and reconstructed each employee’s unique employment timeline—rosters, rates, work patterns, and public holiday activity.
We developed a transparent calculation model that accurately determined the correct allowance for every eligible employee under the more generous interpretation.
The company received a clear, audit-ready breakdown of the amounts owed, ensuring compliance, fairness, and risk mitigation.
03
Streamlined Job Entry System (European Waste Management Provider)
The Problem
An Italian waste-management provider was manually entering job records into a multi-sheet Excel workbook (one sheet per month).
Clerks had to repeatedly type client names, search printed reference sheets for the correct delivery address, and manually look up transportation tariffs.
As business grew, this manual process became slow, error-prone, and difficult to scale.
​
The Solution
Crystal Logic enhanced the workbook with an intuitive, error-proof entry system:
-
Client dropdown replaces manual typing
-
Dynamic address dropdown shows only the addresses linked to the selected client
-
Automatic tariff calculation eliminates reference-sheet lookups
-
Monthly delivery summaries provide instant totals per client
The result is a faster, simpler, highly reliable workflow that the client fully controls—supported by ongoing access to our world-class assistance.