Real-time treasury data in Excel

Excel is still the control tower for many treasury teams. The challenge is that cash data is often outdated the moment it’s exported from bank portals, and rarely structured the way treasury actually needs it.

Instead, our customers are using OData – a secure live data connection – to stream combined balance information from hundreds of bank accounts directly into Excel.

But the real value is what they can send through that connection.

In FinanceKey, the output isn’t fixed. Thanks to our advanced features like pivoting and nested filters, finance teams can define exactly what the dataset should look like before it ever reaches Excel.

For example:

• Show only operational accounts, excluding escrow or restricted cash
• Convert all balances into a reporting currency in real time
• Group entities by region or business unit
• Filter out zero-balance accounts
• Create separate live links for liquidity or FX exposure

No IT tickets. No manual work in Excel.

It’s as simple as generating a link in FinanceKey and pasting it into your spreadsheet.

The result? Live, treasury-grade data – remixed exactly as you need it.

Think of yourself as a bank data DJ.