How Advanced Cash Reporting Powers Smarter Treasury Decisions

The Problem: Data Exists, But Insight Doesn't

Most treasury teams aren't short on data — they're short on the ability to make that data useful. When the webinar opened with a quick audience poll, the results were predictable: Excel dominated, followed by TMS-native reporting and third-party tools like Power BI and Tableau. The tools work, but they require significant manual effort, and the insights they produce often stay siloed within the treasury function.

"The march to real time is compressing time for everybody," said Ed Barrie. "Management is asking for information and insights and expecting responses more quickly."

A Question-Based Approach to Analytics

Chris Blow offered a practical framework that Twilio has adopted: question-based design. Rather than building dashboards and reports and hoping people find them useful, Twilio starts by asking: What questions are we getting asked every day? How are we answering them today? Can we automate that?

This approach helps avoid the common trap of over-reporting. "There's a tendency when you get into analytics and reporting that you tend to give out too much information," Chris noted. "We try to be very meaningful about what we create — limit the number of dashboards, and make sure the appropriate information goes to the appropriate level."

A CFO, for example, wants to see cash trending and overall balances — not granular entity-level detail. Collections teams need transaction visibility. FP&A wants cash flow data for planning. When the right data reaches the right audience, decisions improve across the board.

Sigma: Bringing Analytics to Life

A key part of Treasury 4's analytics layer is built on Sigma, a cloud-native analytics platform that enables treasury teams to interact with their data in a highly flexible, intuitive way — without requiring a data analyst or IT support.

Within Treasury 4's Sigma-powered environment, users can:

• Explore and interrogate data interactively — filtering by bank, entity, currency, or time period with just a few clicks
• Customize visualizations — switching between charts, tables, and other views to match how different stakeholders prefer to consume information
• Edit and configure reports on the fly — adjusting metrics, groupings, and filters without writing a single line of code
• Export and schedule delivery — pushing dashboards to stakeholders via email, dropping them into PowerPoint, or setting conditional triggers (e.g., "send this report only when a balance falls below a certain threshold")

Chris Blow highlighted how intuitive the experience has been for his team: "It's broadly dragging and dropping. Once you know where things are, it's pretty quick. You can take a column and create a brand new column using Excel-type formulas. And the ability to manipulate the visualizations attached to that data — filters, drill-downs, pop-outs — is very impressive."

For treasury teams accustomed to building complex Excel models or relying on IT to generate reports, Sigma represents a meaningful step forward: the flexibility of a custom BI tool with the accessibility of a spreadsheet.

From Reactive to Proactive Treasury

One of the most significant shifts Twilio has experienced is moving from reactive, close-the-books reporting to a more proactive approach to working capital management.

"Where am I today versus last month? What was I like this time last year? I've got a few days left in the quarter — am I comfortable? Are there certain customer payments I haven't seen?" Chris explained. "It's about better knowing your landscape, so there are fewer surprises down the road."

When data is accessible and visible across functions, something else happens too: increased scrutiny. And that's a good thing. "If something looks odd, it's not necessarily that something's wrong," Chris said. "But people are asking questions, and when you ask questions you get more interaction, and then you come to better outcomes."

The Road Ahead: Enriched Data, AI, and the Connected Treasury

Looking ahead, Twilio is focused on enriching its treasury data by connecting additional sources;  money market funds, custodian data, ERP systems like Oracle, and merchant processing platforms to build a more complete picture of cash flows across the business.

And as those data sets grow richer and more connected, the opportunity for AI and machine learning becomes real. "AI is fantastic, but it's the data that matters," Chris noted. "If you don't have good data — if it's not connected to other data sources, everything's done in a silo. And ten decisions made in a silo just aren't going to work."

Treasury 4's architecture is built with that future in mind: each customer's data lives in a dedicated SQL database on Microsoft Azure, replicated into Snowflake for reporting and analytics. Customers can even have their Treasury 4 data pushed into their own corporate Snowflake instance extending treasury data into the broader enterprise data ecosystem.

The result is a treasury function that doesn't just report on the past; it informs the future.