Why fragmented data is costing treasury teams more than they realise

The cash position on your desk is already out of date

Most treasury teams do not see their organisation’s true cash position. They see a version of it, assembled overnight or over several days from bank portals, spreadsheet exports and ERP extracts, with each entity reporting in its own format and currency. By the time the figures are pulled together, some accounts have already moved.

This is not a failure of effort. Treasury and finance teams work hard to bring the picture together. The problem is structural. Cash sits across many banks, many entities and many currencies, and there is no single point where it is captured consistently. Every consolidation is a manual reassembly of parts that were never designed to fit together automatically.

That gap matters more than it might first appear. Confidence in a cash figure depends on knowing where it came from and how current it is. When that chain is unclear, so is the confidence behind every decision built on top of it, from short term investment to funding a shortfall.

What fragmented visibility actually costs

The cost of poor cash visibility rarely shows up as a single dramatic failure. It shows up as a pattern of small, avoidable inefficiencies that compound over a financial year.

One entity in the group draws on a credit facility while another, in a different country, holds an uninvested surplus that nobody flagged in time. Short term borrowing costs are paid unnecessarily because the group’s true net position was not visible when the decision was made. Exposure to a single banking counterparty grows quietly because balances are viewed account by account rather than aggregated across the group.

There is a human cost too. Hours spent downloading statements, re-keying figures and reconciling by hand are hours not spent on forecasting, variance analysis or the kind of work treasury exists to do. Manual re-keying also introduces errors that are hard to catch until they surface somewhere inconvenient, such as a mismatched balance during month end close.

There is an audit dimension as well. When a reported cash position cannot be traced cleanly back to the underlying bank statement, a question that should take minutes to answer instead takes days of reconstruction. None of this stems from a lack of discipline. It stems from the fact that the underlying data was never fully assembled in one place to begin with.

The real problem is a single source of truth, not more effort

It is tempting to treat this as a reporting problem and respond with a better spreadsheet template or a more disciplined deadline. That treats the symptom rather than the cause.

The actual problem sits earlier in the chain. Cash data originates from many separate sources, each with its own format, timing and level of detail. No amount of polish applied to the final report fixes the fact that the underlying figures were pulled together by hand from disconnected places. What is needed is not a nicer looking version of a fragmented picture, but the fragmentation removed at the source, so a single, reconciled position exists before anyone opens a report at all.

How Salmon builds that single position

Salmon Treasurer’s Total Cash dashboard consolidates bank account balances, intercompany accounts, money market fund holdings, external deposits and external borrowings into one working view, converted into a single reporting currency across every entity and country in the group.

A Summary view breaks the position down by country, so a team can see at a glance where cash and exposure sit across the business. A Map view goes a step further, shading each country by the scale of its net cash position and labelling the figure directly on the map, so a concentration or a shortfall is visible before drilling into any single account. From there, the same dashboard lets a user move from the world view into a specific region, then into the underlying transaction level detail, without leaving the application or rebuilding anything in a spreadsheet.

That consolidated view is only as trustworthy as the data behind it, which is why reconciliation matters as much as presentation. Salmon’s reconciliation functionality matches forecast cash flows against actual bank statement transactions, and tagging converts each bank’s own transaction codes into a consistent set of categories the organisation defines itself. The result is a cash position that can be traced back to source, not just displayed.

Feeding that dashboard is a connectivity layer that pulls bank statements in automatically, using sFTP, API or SWIFTnet depending on what each banking partner with encryption applied in transit. In practice this means the data behind the dashboard arrives on schedule without anyone needing to log into a bank portal or re-key a statement by hand.

What this looks like on an ordinary morning

Statements have already arrived and been tagged overnight by the time the team logs in. Reconciliation has run against the previous day’s forecast, and most transactions have matched without anyone touching them. The Total Cash dashboard shows the group’s consolidated position as it stands, not as it stood two days ago, and the map view gives an immediate sense of where cash and exposure are concentrated.

A country showing an unexpectedly large borrowing balance can be clicked into directly, down to the account and transaction level, without a call to another team member to ask for a breakdown. Because the figures are built from reconciled bank data rather than manually reassembled extracts, a question from an auditor, a board member or a lender can be answered with confidence in the source, not just the number. Liquidity decisions are made against a position that is current and traceable, rather than a best available estimate.