Poor ERP Implementation Leads to Restatement by Overstock.com

Erin McCune

October 24, 2008

Overstock.com said it will restate its financial results for over five years due to problems stemming from its implementation of Oracle. Revisions to the company's 2003-2007 results probably will reduce revenue by
$12.9 million and increase cumulative net loss by $10.3 million.

Excerpt from CFO.com

 He explained that as part of a major system upgrade in 2005 that included its accounting system, one change was that instead of recording refunds to customers in batches, it now recorded them transaction-by-transaction.

"When we issue a customer refund, the refund reduces the amount of cash we receive from our credit card processors and, as a result, our financial system should reduce our accounts receivable balance," Chidester said. "After the implementation, in the instance of some customer refunds, this reduction wasn't happening, and we didn't catch it."

He said that the company uses internal "reason codes" to track the reasons it gives customer refunds. Trouble was, under the new system not all reason codes were automatically recorded. Some customer refunds required manual entry in the financial system.

"We set up automatic and manual processes so that these would be recorded," Chidester elaborated. "Unfortunately, we missed some of the manual customer refunds, and as a result, we did not record all that were occurring."

Over time, this error built up and, on a cumulative basis, eventually became material, he conceded.

Separately, the finance executive said that on a much smaller scale, the company found that the system did not reverse out shipping revenue for cancelled orders as it should have, and these $2.95 charges also added up over time.

Chidester also pointed out that these errors were partially masked by an offsetting error that made overall cost of returns appear reasonable. Over the past two years Overstock under-billed its fulfillment partners for some returns-related costs and fees, he said.

"In other words, we weren't recording some customer refunds and we weren't recouping some costs from partners on some returns," he added. "The combined result was that our returns costs looked reasonable. We have corrected the under billing problem and are initiating a process to collect a portion of the amounts owed, which we will record as we receive them."

When it comes to ERP implementations, the devil is in the details. Manual workarounds seem like a satisfactory solution to thorny problems in the midst of a project, particularly when budgets are tight and timeliness are squeezed. But beware of the long term repercussions!

Recent Payment Views

Payments Post #13: At the Intersection of Tech, Regs, and Business Partnership

Payments Post #13: At the Intersection of Tech, Regs, and Business Partnership

This month, Cici Northup joins regular contributor Justin Pituch to recap positive news in the form of fast payments growth, new fraud mitigation strategies, and evolution in cross-border transfers. All reflect, to varying degrees, the unique dynamic in the payments industry created by the intersection of technology, regulation, and new business partnerships.

read more
Payments Orchestration: What Comes Next?

Payments Orchestration: What Comes Next?

Orchestration providers have certainly come a long way, and can enable powerful capabilities and benefits for the merchants that employ them. This post explores some of the possibilities Glenbrook has been thinking about for where Orchestration (and even orchestration) can go next.

read more
Payments Post #13: At the Intersection of Tech, Regs, and Business Partnership

Payments Post #12: Lessons from Change

In this month’s Payments Post, we want to draw your attention to several recent fraud incidents that underscore the criticality of effective risk management to your business and the safety and soundness of the payments industry.

read more

Glenbrook Payments Boot CampTM workshop

Register for the next Glenbrook Payments Boot Camp®

An intensive and comprehensive overview of the payments industry.

Train your Team

Customized, private Payments Boot CampsTM workshops tailored to meet your team’s unique needs.

OnDemand Modules

Recorded, one-hour videos covering a broad array of payments concepts.

GlenbrookTM Company Press

Comprehensive books that detail the systems and innovations shaping the payments industry.

Launch, improve & grow your payments business