Mosaic · FP&A reporting case study

Custom Reports

Redesigning how finance teams build and edit reports in Mosaic

In Mosaic's Custom Reports, every edit went through a side panel, and the report didn't change until you pressed Update. I led design and research to move editing into the report itself, and report setup time dropped by about 35%.

Role
Design lead, Custom ReportsOfficial title: Senior Product Designer
Timeline
Multi-monthResearch through high-fidelity design
Research method
SME and customer sessions3 to 4 participants, prototypes and mockups
Report setup time
About 35% lessThan with the old side panel

The problem

Budget and Delta took 8 steps, ending with a wait.

Delta is Actuals minus Budget. Here is the same task done both ways.

The task: add Budget and its difference from Actuals to the May 2023 Level 3 P&L.

Before8 steps

Before, the old Custom Reports after Update: the Level 3 P&L table now shows Actuals, Budget and Delta $ for Revenue, Cost of Revenue and Gross Profit. Every change was made in the Configure side panel.
  1. Open Configure
  2. Expand Data Options
  3. Open the comparison source
  4. Pick Budget
  5. Expand Table Format
  6. Tick Delta $
  7. Press Update
  8. Wait for the update

Every change lived in a side panel. Pick a section, change a setting, press Update, wait.

After6 steps

After, the shipped report: the same Level 3 P&L with Actuals, Budget and a Delta column (Actuals minus Budget) filled in for every row, all changed in the report itself, marked Done.
  1. Add a column
  2. Pick Budget
  3. Add another column
  4. Name it Delta
  5. Type the formula
  6. Press Enter

Change it in the report.

Edit workflow

Edits happened away from the report.

Changes made in the menu were slow to show up in the report, which made quick, live tweaks frustrating.

Every change waited for Update

Data sync

Large reports were slow to sync.

Bringing large volumes of data together took time, which hurt precision in dynamic reports.

Customization limits

Layouts couldn't fit each company's needs.

The report structure was fixed, so teams couldn't shape a layout around how their company reports.

Noted in a third of feedback

What we set out to do

We set three goals for the redesign.

Feedback kept coming back to editing outside the report, so we wanted editing inline and fewer manual fixes.

  1. Goal 1

    Make setup quick

    Quick setup should cover anything from a basic cost summary to an advanced logic-based model.

  2. Goal 2

    Make reports easy to share

    PDF and CSV exports should be easy, so reports reach the whole team.

  3. Goal 3

    Add formulas and metrics

    Formulas and pre-set metrics like ROI should work on the spot for quick math, and large data should be handled fast.

My role: Design lead at Mosaic. I led design and research for Custom Reports, turning a rigid reporting tool into a flexible one with inline edits, in-report metrics and formulas, and visual styling. I owned competitor analysis, user studies, personas, wireframes and high-fidelity designs, working closely with PMs, subject matter experts (SMEs) and engineers.

  • Competitor analysis
  • User studies
  • Personas
  • Wireframes
  • High-fidelity design
  • Prototyping
  • Data-heavy UI
  • FP&A

The 30-second read

Edits moved from a panel into the report.

Adding Budget and Delta now takes 6 steps instead of 8, with no wait.

01 · What I designed

Formulas and styling
now happen in the sheet.

You edit the report where you read it, then export it to PDF or CSV.

02 · What changed

Reports took less
time to set up.

User engagement rose 25%, and exports got better styling and selective sharing.

Walkthrough · 57 seconds

In the final design, you click a cell and edit it.

I build one P&L report and export it as a PDF.

Research

We designed for two roles, planners and modelers.

Discussions and feedback showed gaps in scalability and in the interface. Planners built basic reports, and modelers ran complex projections.

Beginner user

New Planner

Design influence: Pointed to quick, visual inline edits, so everyday reporting tasks stay fast.

Advanced user

Experienced Modeler

Design influence: Guided inline styling and more versatile exports, and needed formulas and metrics built into the report.

Full persona details

New Planner (beginner user)

  • Inline edits
  • Visual tools

Way inPick a metric

  • Demographics. Junior role in finance operations, 22 to 30, new to Mosaic, handles basic reports.
  • Goals and needs. Put together basic reports quickly with visual, easy inline tools.
  • Pain points. Worries about mistakes, leans on support for complex reporting tasks, and often feels unsure about making changes alone.
  • Behaviors. Favors interactive features and friendly design, and enjoys exploring intuitive tools with practical guidance.

Experienced Modeler (advanced user)

  • Formulas and metrics
  • Inline styling
  • Export options

Way in= Formula

  • Demographics. Skilled professional, 35 to 50, core Mosaic adopter, manages complex projections.
  • Goals and needs. Build and manage detailed reports with formulas and metrics built in, for more flexibility.
  • Pain points. Limited linking options, slow processes and linking problems.
  • Behaviors. Pushed for intuitive inline styling and more versatile exports that fit many reporting needs.
Competitor analysis

I reviewed the tools finance teams already used.

In early discovery I looked at Excel, Google Sheets, QuickBooks and Tableau, the leading tools for strategic financial reporting. They left room for inline customization and data syncing, which Custom Reports set out to fill.

What I found in each tool
Microsoft Excel logoGoogle Sheets logoSpreadsheets

Excel and Google Sheets

They led basic reporting in SMBs because people knew them, but users cited poor real-time integration.

Intuit QuickBooks logoAccounting

QuickBooks

It led SMB accounting with solid reporting, but inline edits were limited and users found it rigid.

Tableau logoVisualization

Tableau

It excelled at data visualization, but high costs, steep learning curves and long onboarding put off non-technical users.

Non-technical users preferred Excel and Sheets for the basics but wanted better inline tools for models.

The insight

Beginners and experts build one report two ways.

The same sheet handles a basic cost summary and an advanced logic-based model.

Two paths into one report. The new planner picks metrics and edits the report inline, and the experienced modeler writes a formula in a column header, Delta equals Actuals minus Budget, and segments Revenue by Product. Both build the same report: a May 2023 group with Actuals, Budget and Delta, Revenue split into Subscriptions, Services and Total Revenue, then Cost of Revenue and Gross Profit.

The old flow

I mapped the flow to see where it held people up.

Only one step in the old loop was the edit itself.

Journey schematic. The old flow: open the report, open the Configure panel, change a setting, Confirm or Update, wait for the data to sync, check the table, then repeat from the Configure panel for every change. Friction points: the edit workflow at the Configure panel, data sync while waiting, and customization limits when checking the table. Alongside the map, examples of table layouts and interactions were gathered for ideas. The new path: click a cell, edit in place, see it now.

Open the full journey board in Figma

Design

Metrics, formulas, groups and segments, in place.

We showed early wireframes to stakeholders and users, and their input shaped these four.

Early wireframes (6)

In early exploration we showed wireframe ideas to stakeholders and users, and their input on inline editing and export options shaped the high-fidelity mockups.

01 · Metrics

Add metrics as rows.

Click a row's first cell and choose Metric. Check what you need in Choose a metric, and each pick lands as a row with its data.

AnswersEdits happened away from the report

Animated mini of the report. Clicking the first cell of row 1 offers Metric, Formula or Text. Picking Metric opens Choose a metric on the Income Statement category. Revenue, Cost of Revenue and Gross Profit are checked, and after Confirm each one lands as a row with its Actuals and Budget values.

02 · Header formulas

Write a formula in the column header.

Name a column and type a formula like Actuals minus Budget in its header. With real-time data sync, the whole column fills when you press Enter. Column names come up as you type, and there is no Update step.

AnswersLarge reports were slow to sync

Animated mini of the report. A new column is added from the plus rail and named Delta. Its formula is typed in the header's formula field, with column names suggested as you type: Actuals minus Budget. The column then fills at once: minus $51,990 for Revenue, $21,010 for Cost of Revenue and minus $73,000 for Gross Profit.

03 · Groups and fills

Group columns and style them in place.

Inline styling came from the experienced modeler. Select a few headers, group them under a name like May 2023, then click the band and pick a fill from the format toolbar.

Shaped byThe Experienced Modeler

Animated mini of the report. The Actuals, Budget and Delta headers are selected together and grouped from the header menu. A band named May 2023 forms over the three columns. Clicking it opens the format toolbar, and a lavender fill is applied in place.

04 · Segments

Segment a row without leaving the report.

Open a row's menu and choose Segment metric by. Revenue opens into Subscriptions, Services and a Total Revenue row, and the rest of the report stays put.

AnswersLayouts couldn't fit each company's needs

Animated mini of the report. Revenue's row menu offers Segment metric by, and picking Product keeps Revenue as a header and opens it into Subscriptions ($578,871 actual, $625,662 budget), Services ($64,319 and $69,518) and a bold Total Revenue row ($643,190 and $695,180). Cost of Revenue and Gross Profit move down and stay as they were.

Testing

I tested designs with SMEs and customer advocates.

In each round I worked on slow menu navigation and data lag.

Who took part
I ran iterative sessions with SMEs and current customer advocates, 3 to 4 participants in all. They used interactive prototypes and high-fidelity mockups in hands-on walkthroughs.
What changed
I changed the design during the sessions, so inline formulas and metrics got easier to use and custom exports improved.

Product tour

Step through the design, one feature at a time.

The four features run in the order you'd use them to build a P&L.

Choose a metric open over the new Level 3 P&L report, its first row selected. Categories run down the left with Income Statement picked. On the right, Revenue, Cost of Revenue and Gross Profit are checked, each with a one-line description, and the footer reads 3 selected beside the green Confirm button, under the pointer.
A new column named Delta beside Actuals and Budget, its header selected. The Column popover beside it holds the name Delta, the data source choices and a formula field reading Actuals minus Bud, with the Budget column offered in the suggestion list under it.
Actuals, Budget and Delta grouped under a May 2023 band, which is selected. The format toolbar above it is open on Fill, with the lavender tint under the pointer.
The report under May 2023 and YTD as of end of May groups, with Revenue already opened into Subscriptions, Services and a bold, shaded Total Revenue row. Cost of Revenue is selected, the backslash and S key caps show Segment metric by, and the Segment by list offers Product, Department, Region and Customer.

Try it

Build a report in four steps.

Start from a simple P&L and end with a saved report, all inside the sheet.

Step 1 of 4

Add a Budget column

Put the plan next to what happened in May 2023.

Untitled reportSave
A1Select a cell to see what it holds
MetricActuals
Revenue$643,190
Cost of Revenue$201,390
Gross Profit$441,800

Results

Setup got faster, and adoption grew.

Report creation grew across Mosaic, with user engagement up 25%.

Report setup time
About 35% less report setup time
Goal 1

Make setup quick

Result

About35%less report setup time

Finance teams build reports faster.

Goal 2

Make reports easy to share

Result

ExportsBetterstyled andeasier to share

Teams shared just the data they chose, in PDF or CSV.

Goal 3

Add formulas and metrics

Result

In feedbackAheadof Excel and Sheetson efficiency

Participants praised its speed, customization and exports.

Adoption

25%more userengagement

A sign of wider use among FP&A professionals.

Looking back

What worked, and what I'd test sooner.

Early talks shaped the design, but only 3 to 4 people tested it.

What held up

I talked to SMEs and customers early.

Those talks shaped inline edits, quick customization and exports, and made building a report smoother than the old rigid setup.

What I would change

I would prototype with more people, sooner.

More early prototyping with a wider range of users would have helped me polish inline styling further.

Custom Reports · Mosaic

Thanks for reading.

I took editing out of the side panel and put it in the report, so planners and modelers build the same report without an Update step.