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 #17: Cutting Costs

Payments Post #17: Cutting Costs

In this Payments Post, we discuss the DOJ bringing a lawsuit against Visa that alleges the company operates an illegal monopoly in the debit card space. Does the argument have merit in our non-legal minds? And if so, what could the DOJ’s move mean for an evolving payments landscape?

read more
Payments Post #17: Cutting Costs

Payments Post #16: The Apple Drops

It’s time for another edition of Payments Post and (surprise!) we’re thinking about the Visa Flexible Credential again. Now that Apple has plans to open up the NFC chip and Secure Element to third party developers, we’re scratching our heads. Who benefits from this newfound NFC access? What opportunities can fintechs unlock? How will conventional financial institutions react? And to tie it all back, does the VFC still matter?

read more
Payments Post #17: Cutting Costs

Payments Post #15: BNPL Battles

In this month’s Payments Post, we revisit the prime use case for Visa Flexible Credential (VFC): BNPL. How are buy now pay later providers positioning themselves in the current environment, how are consumers using their tools, and how are regulators and issuers responding?

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