Skip to content

01 / Ratiodata

B4

Rebuilt a budgeting platform planners refused to use. Adoption went from 30% to 90%.

Role
UX / Product Designer
Timeframe
2019—2021
Company
Ratiodata
Users
~30—35 finance planners & execs
01

Summary

B4 was Ratiodata’s internal platform for departmental budgeting, forecasting and plan-versus-actual comparison. It replaced a patchwork of Excel files that made budgeting slow and hard to trust.

The catch: the planners who had to adopt it liked Excel. They had years of muscle memory in it and full control over their own files. My job was to design something they would choose over a tool they already trusted.

30% 90%

Adoption after two rounds of testing and redesign

24% 73%

Tasks completed without difficulty

59.7

Round-one average SUS score, n=22

02

The problem

Budgets lived in scattered Excel files with no shared structure and no single source of truth. Consolidating across departments was manual and slow. Numbers disagreed between planners, controllers and leadership. Errors surfaced late in the budget cycle, and mismatched budgets contributed to avoidable financial losses every year.

03

My role

Sole UX and product designer on B4, owning the experience end to end for a small, senior user base. I structured the core planning flows (create, edit, review, delete) inside a compliance-heavy, SAP-integrated system, then designed and moderated two rounds of in-person usability testing with real finance planners across business units.

I used SUS and task-completion scoring to turn “people don’t like it” into a ranked list of specific interface problems, and turned session notes and quotes into concrete redesigns of the core interaction model. Part of the job was pushing back on stakeholders who wanted Excel-parity features that would have weakened accuracy and the audit trail.

04

Team and constraints

A small cross-functional squad: me on design, a product owner and business analyst, backend and SAP integration engineers, and a controller-turned-product-owner. End users were roughly 30 to 35 finance planners, department heads, controllers and executives.

The constraints shaped everything. SAP and ERP integration meant data structures and terminology arrived inherited, including terms like Innenauftrag and Kostenart. Compliance and audit-trail requirements applied to every edit. The IT environment was legacy and inflexible. And the user base was small, senior and vocal, so any friction was noticed and escalated immediately.

05

Discovery

Six core tasks per session, tested in person across business lines: create a plan, extend a multi-year contract, edit values, check history, delete an item. Participants had mixed technical comfort. Scoring combined SUS with task completion.

01

Save was invisible

“How can I save it? There is no save button, and I don’t know if it’s saved or not.” This was the single biggest source of anxiety in the tool.

02

The treeview defeated people

Planners created an item, then couldn’t find it again, even when they knew the exact cost center. One session ended with the moderator recreating the item.

03

Users didn't trust the numbers

History color coding (red for create, green for edit) wasn’t intuitive. Several participants weren’t confident an edit had actually registered.

04

People wanted Excel's safety net

Planners preferred a dedicated edit screen over inline editing even though it was slower. In their words, inline editing “can introduce errors.”

How can I save it? There is no save button, and I don’t know if it’s saved or not.

Test participant, round one, mid-task

This came up session after session, unprompted, which is why it went to the top of the redesign list rather than into a backlog.

The vocabulary worked against users too. SAP and controlling terms assumed domain knowledge that not every planner had. Field-level confusion was just as costly: several users didn’t know which fields were required, some guessed based on asterisks, and one planner typed their own name into a “Name” field meant to record the customer, because the label didn’t distinguish “your name” from “customer name.”

The screen at the centre of the problem. Testers created a planning item, then could not find it again in this tree even knowing the exact cost centre.

The cost-center hierarchy nested seven levels deep, mirroring the organisation’s real structure. A breadcrumb reading SDS > 350100 > 000 > 765 > 500 > 420 > 500404 shows the actual depth planners navigated to reach one planning item. Once inside a leaf node there was no reliable way back to a newly created sibling.

06

What 59.7 actually means

The System Usability Scale is a validated 0 to 100 benchmark used across the industry, not a number invented for this project. A score of 59.7 sits in the “OK” band: usable, but well short of “Good,” which starts at 68.

Combined with a 29% task failure rate, this told us the problems were structural rather than cosmetic, and justified redesigning core interaction models instead of making surface-level tweaks. It also gave stakeholders a defensible number to sign off against.

07

Design response

Every fix below touched the core interaction model. None of them were polish.

  • Made save state explicit

    Confirmation feedback at the point of action, so users no longer had to infer success. This was the single most-repeated complaint in round one.

  • Redesigned the tree for findability

    Expand and collapse controls, preserved scroll position, and newly created items that can reliably be found again. A session had ended with the moderator recreating a lost item.

  • Rebuilt the change log

    Replaced ambiguous color-coded icons with a readable chronological audit trail, because users couldn't tell whether an edit had registered.

  • Kept the dedicated edit view alongside inline edit

    Planners told us directly they would trade speed for control. Inline editing stayed for power users; the dedicated view stayed for everyone who wanted the safety net.

  • Clarified mandatory versus optional fields

    Renamed ambiguous labels ("Name" became "Customer") based on misreadings we watched happen in session.

The single source of truth: a year-level Income, Cost and Profit margin rollup replacing scattered per-department Excel totals.
Extending a multi-year contract, one of the six tested tasks. Each year is a separate row with its own amount and margin.
Search inside the dropdown, one of the round-two refinement requests, built into the filter controls.

A teal outline and label mark the field being edited, so the edit state is visible at a glance, and small arrows on adjacent cells show which values changed and in which direction. This detail work is what made it possible to keep a dedicated edit view without losing the safety planners asked for.

At the year level, an Income, Cost and Profit margin rollup replaced the scattered per-department Excel totals. Controllers get a defensible, auditable number before they drill into detail.

08

Validating the fix

Same six-task protocol, re-run with a comparable group of planners after implementing the redesign.

Round one versus round two

MetricRound 1Round 2
Tasks completed without difficulty24% (8/34)73% (22/30)
Tasks not completed at all29% (10/34)3% (1/30)
Reported adoption (post-workshop)~30%~90%
Average SUS score59.7 / 100Marked improvement
09

Impact

For planners, task abandonment dropped from 29% to 3%. Save state became explicit, so nobody had to guess whether an edit went through. Newly created items could be found again without moderator help, and the dedicated edit view stayed available alongside inline editing for the power users who wanted speed.

For the organisation, reported adoption went from roughly 30% to roughly 90% of the 30 to 35 person user base. Mismatched budgets had caused avoidable losses every year; with one auditable source of truth replacing scattered Excel files, that stopped. Planners, controllers and leadership finally worked from the same numbers, with a visible change history behind every value, and budget consolidation across departments got faster and cheaper.

10

What this project shows

Evidence-driven design. Raw usability sessions became a prioritised, defensible redesign, and that evidence is what let me hold the line when stakeholders pushed for different tradeoffs.

Designing for trust, not just efficiency. The biggest wins came from making state visible (saved or unsaved, changed or unchanged), not from making anything faster.

Working inside real constraints. SAP integration, compliance requirements, legacy systems, and senior users with strong habits.

Closing the loop. The project didn’t stop at shipping the redesign. A second measurement round proved the changes worked.

Note: any visual representation of B4 uses mock data, and participant names, where mentioned, are not their real ones. Some details were generalised for confidentiality.