Case Studies

To respect client confidentiality, firm names have been changed.

Complex Computation

Martin Plumbing had a long-standing relationship with Cedar Home Construction, having provided construction services for numerous Cedar Home projects. Under their agreement, Martin would invoice Cedar for the work performed, but Cedar deferred payment. Instead, the unpaid balance would accrue interest—at one rate for the first twelve months and a higher rate thereafter. The timing of the rate increase was determined by the original invoice date.
 

Over time, managing this arrangement became increasingly burdensome. Martin’s team struggled to calculate accrued interest for each invoice, since both the start of the accrual and the rate change depend on the individual invoice date. Additionally, payments had to be applied to the oldest outstanding invoice. On one project alone, there were eighty-eight invoices and thirty-four separate payments.

This process quickly overwhelmed Martin Plumbing’s in-house accounting team. Countless hours were spent calculating interest and determining how payments should be applied. The manual nature of the work led to frequent errors and inefficiencies.
 

UGL Analytics developed a custom template that automated the interest calculations and accurately applied payments to the appropriate invoices. A task that once placed a heavy strain on internal resources was now being completed efficiently and without errors. With UGL’s solution, Martin Plumbing no longer has to spend time manually tracking balances—they now have a streamlined, accurate, and time-saving system.