Deep Dive · Databricks

How Much Did That Order Actually Make? Retail Finance Turns to AI

Customers buy online, pick up in store, return to a different location—and one sale fragments into several messy ledger entries. Databricks built Genie as finance's AI sidekick: first, figure out what that order really earned; then, keep an eye on trapped cash and decide when discounts are actually warranted.

Main Story Databricks Blog · 2026-07-14 · Sarah Duffy Case Study Unilever × Genie Product Databricks Genie

Based on Databricks' official blog and Unilever's public case study. All figures, user counts, and industry forecasts follow the source material; the numbers in the profit waterfall are illustrative, designed to clarify the concepts rather than represent any specific store's ledger.

01 The ProblemOmnichannel + Agents outpace finance
02 The ShiftGenie: a finance buddy who knows the business
03 Three QuestionsTrue profit → Cash → Full price
04 The ResultUnilever: days → minutes

The Problem: The Easier You Make It to Buy, the Harder It Is to Count

Forget the product name for a second. This article is about one thing first: the path a purchase takes is so tangled now that the money quietly leaks away along the way. By the time the report is done, the floor has changed again.

Here's the most common example:

You order a jacket in the mobile app and choose "ship from a nearby store, delivered tonight." Three days later it doesn't fit, so you return it to a different store. To you, that's just "bought it, returned it." To the company's books, it splits into at least three headaches:

① Where did it ship from?Shipping from a store usually costs more than from a central warehouse (staff pick the item, inventory gets tied up). The same jacket can net the company very different amounts depending on the fulfillment path.
② Who eats the return?The money came in through the app, but the jacket came back to a different store. Revenue is booked to e-commerce, while the return cost lands on the store—the two sides don't reconcile, and finance ends up with a headache.
③ Who changed the price?Promotions aren't always triggered by a human hitting a button. Systems and AI adjust prices automatically. The plan says "don't discount too hard," but the system may have already run another round. By the time the weekly report surfaces, the discount has already happened. Industry forecasts suggest that by 2028, roughly 15% of daily business decisions will involve this kind of automated decisioning (Gartner, forecast basis). The pace only quickens—monthly reconciliation will fall further and further behind.
Channel fulfillment return volatility and the profit line that must be defended
Gray line: orders, shipments, and returns change every hour, like an erratic heartbeat. Red line: what finance really needs to defend—"what did this order actually earn?" Customers enjoy the gray line; the company fears the red one breaking.

Tap Through It: How One Item's Booked Profit Erodes, Layer by Layer

Click through the four steps. The numbers are illustrative, showing how "planned a lot → actually kept less" happens.