How a CFO built a custom ARR dashboard in just a few hours

Claire Huang
Marketing at Rillet
Reading time
10 min
Johnnie Walker CFO Rillet MCP case study

Johnnie Walker, Director at Rooled & CFO, wanted to build a custom ARR report. One where he could define the underlying policies, inspect in even fuller detail, and reconcile reported ARR back to recognized revenue.

Using Rillet’s newly released Model Context Protocol (MCP) and Anthropic’s Claude Code, Johnnie built a custom ARR reporting engine in just a few hours. 

What he built

A local, self-contained application that:

  • Pulls live customer, contract, and invoice data directly from Rillet
  • Applies clearly defined ARR reporting policies
  • Produces detailed per-period and per-customer exports
  • Identifies inconsistencies automatically
  • Reconciles reported ARR with recognized revenue
  • Exports cleanly to Excel for validation and analysis

If something didn’t look right, Johnnie could iterate on the logic and lock the fix in with a test, treating finance logic like software.

The data shown is illustrative only .

How Rillet MCP made this possible

Model Context Protocol (MCP) allows AI tools to securely interact with external systems.

With Rillet MCP, Claude Code could:

  • Query Rillet’s APIs directly
  • Search Rillet documentation as needed
  • Generate code grounded in Rooled’s real financial data

Furthermore, this lets finance leaders focus on judgment and policy, while the AI handles the underlying data work and implementation.

The takeaway

As AI reduces the cost of building, the real advantage comes from domain expertise. Rillet MCP gives finance leaders like Johnnie the ability to turn that expertise into working systems. Fast, transparent, and fully under their control.

Read his experience here.

More from the blog

Rillet certified partners with logos

Introducing Rillet Certified Partners: A Force Multiplier for Hypergrowth Companies

Nadiv Rahman
Rillet integration with Invoice Butler

Rillet + Invoice Butler: From Invoice Creation to Cash, Fully Synced

Stephen Hedlund
Devember 2025 Product Update Announcement

January 2026 Product Update

Kristen Pascoe

Get one step closer to zero-day close

Faster close, fewer spreadsheets, real-time data.