Corporate treasury: from cash rebuilt by hand to managed liquidity

Analisi finanziaria su grafici e calcolatrice: previsione di cassa e tesoreria aziendale

Monday, before nine. In many companies corporate treasury starts here: someone in finance opens the online banking of the first bank, copies the balance into a spreadsheet, moves to the second, then the third. They retrieve the file updated on Friday, add the collections that came in meanwhile and try to work out how the month will close. By ten the figure is ready. By the time it reaches management’s desk it is already a day old.

The scene repeats itself even in companies that have invested heavily in ERP, CRM and production. The tools exist: cash remains the actual figure that someone rebuilds by hand, instead of a process the company manages.

In corporate treasury the data is not missing: it is in four different places

In most small and mid-sized companies all the financial information is there. The problem is where it sits.

Transactions are in the banks’ portals, open items in the ERP, forecasts in a spreadsheet built by the person who knows the company best, payments in a separate flow that goes through signature and authorisation. Each piece works, none talks to the others, and the summary is produced by one person as often as they can manage.

The consequences weigh more on the organisation than on technology. Visibility on cash arrives late. Forecasts rest on assumptions nobody can check. Reconciliation absorbs hours that produce no analysis. In groups with several companies the consolidated view becomes a manual sum that nobody willingly tackles more than once a month.

Three different jobs all called corporate treasury

It is worth telling them apart, because they need different tools and because many projects stop at the first.

The first is visibility: knowing at any moment how much cash there is, on which accounts, and how much is left on credit lines. It is the basic level, and a treasury platform covers it by connecting to banks through the channels made available by the PSD2 regulation.

The second is forecasting: understanding what will happen in the coming weeks. Finance people usually reason over a thirteen-week horizon, close enough to rest on real data such as the payment schedule, expected collections and scheduled payments, wide enough to see a squeeze coming before it becomes an emergency.

The third is action: payments, reconciliations, reminders, debt collection. It is the part that turns treasury from a reporting function into an operational lever, and also the one companies postpone most often.

A forecast never checked against actuals remains an exercise

Building a cash plan is relatively simple. The value comes later, when every week what was forecast is set beside what happened.

That comparison produces the information needed to decide: categories that show variances in the same direction every month, customers who pay with a constant and therefore predictable delay, items the company underestimates every month. Without that step the forecast does not improve, and after six months nobody looks at it any more.

This is where a corporate treasury platform changes the rhythm of work. The comparison between forecast and actuals no longer has to be built by hand at month end: the platform updates it at every reconciliation, reclassifies transactions into the plan’s categories and shows the variance week by week. Whoever runs finance stops defending the number and starts questioning it, because every gap comes with the list of transactions that produced it. After a few cycles the forecast incorporates the real behaviour of customers and suppliers, and the discussion in management moves from yesterday’s balance to the decisions of the coming weeks.

A customer’s delay is cash missing from the following weeks

In companies that sell to other businesses a sizeable share of cash stays tied up in working capital. As long as receivables monitoring lives apart from the forecast, that delay looks like an administrative matter. It is not.

By connecting the two, a major customer’s usual delay becomes a measurable impact on the following weeks. Reminders can be ordered by real priority rather than by invoice age, and before calling a customer you know what that collection is worth on the cash plan. The reasoning also works the other way round: when budgets, approvals and expenses look at forecast cash, the gap narrows between whoever authorises a purchase and whoever then has to find the resources to pay for it.

A case: the consolidated view that added up the wrong companies

In an analysis at a group with several operating companies, corporate treasury lived on a single spreadsheet fed by hand, with balances collected from several banks.

Management had called us because of the time that collection took every month. The real problem emerged when we connected the first banks to the platform: the consolidated view made measurable what the spreadsheet only hinted at. Some companies ended up in the same sum although they belonged to business lines the owners wanted to keep separate, and for one of them some company cards were missing, because those accounts did not expose transactions automatically.

With balances aligned on the platform, redefining the consolidation scope became a configuration task: separate lines where the owners wanted them separate, and a scheduled periodic upload for accounts without automatic feeds. The same view that brought out the anomaly is now the one the group uses to read its cash every morning.

Is the ERP module enough for corporate treasury?

The ERP remains the reference for accounting, sales and purchasing and the payment schedule; a treasury platform sits alongside it, cross-checks accounting data with bank data and manages operational cash. It is the most common misunderstanding in first calls, and it is resolved like this: neither tool does the other’s job.

From this follows a practical consequence worth more than any feature comparison. The project’s success depends on the connections, not on the dashboards. Bank coverage must be checked bank by bank, because not all accounts expose transactions the same way, and the connection with the ERP must be tested on the company’s real data before committing.

The questions to put in writing before choosing

Whatever platform is being assessed, these are the answers worth getting in black and white.

  • Which of our banks offer automatic transaction feeds and which require a periodic upload.
  • With what latency bank data is updated, and what happens when a connection drops.
  • How accounting data arrives from the ERP in use, how often, and who maintains the connector.
  • Whether the consolidated view allows excluding companies that it makes no sense to aggregate.
  • Who sees which information, and how authorisation profiles on payments work.
  • Where bank and accounting data reside once loaded onto the platform.

The last question often takes a back seat and concerns sensitive matter: these are the company’s accounts. The treasury platforms we select process data in data centres in the European Union, with certifications from the ISO/IEC 27001 family and requirements in line with the NIS2 directive. They are the same standards Aesir Srl applies to its own infrastructure, starting from Tier IV data centres with replication to a second site: the criterion we use to choose suppliers is the one we apply to ourselves.

Where to start so that a corporate treasury project holds up in its second year

The most common mistake is starting with everything at once: all the companies, all the banks, all the modules.

The opposite route works better: phases that build on each other, each with a result that lasts.

Phase What is done What the company keeps
Scope Start from one company and the main banks A controllable area on which to test the method
Visibility Accounts connected, balances aligned every morning The financial position without manual reconstruction
Forecast Thirteen-week cash plan compared with actuals Readable variances and categories that improve over time
Action Payments, reconciliation and receivables management in the platform Reminders ordered by impact on cash

In the corporate treasury projects we run, the most demanding phase lies in defining categories and in the quality of the starting payment schedule, more than in configuring the platform. A forecast built on messy accounting data inherits that mess, and no dashboard corrects it. That is why we tackle these projects together with the ERP side when needed: our position as Gold Partner of NTS Informatica lets us work directly on Business Experience, and with other ERP systems we use the available connectors or build them, without asking the company to change system.

The indicators to watch after the first months

Three indicators soon tell whether things are working: how many hours a month are still needed to close the financial position, how far forecast cash deviates from actual cash over the last eight weeks, and how much receivables ageing is concentrated on the same names. The second counts more than the other two, because it shows whether the forecasting model is learning.

Corporate treasury does not work in isolation. Accounting data comes from the ERP, and the way the ERP feeding the accounts is set up affects the quality of the starting payment schedule; on the regulatory side, the framework of payment services on which bank connections rely is described by the Bank of Italy’s pages on PSD2. When the issue concerns the commercial follow-up of receivables, the natural link is with sales management in the CRM.

Frequently asked questions

Does bank data update by itself?

The connection runs through open banking providers under the PSD2 rules, with updates usually within a few hours. Some special accounts do not expose transactions automatically and require a periodic upload: this should be checked bank by bank during the analysis.

Do we need to change ERP?

No. The platform sits alongside the ERP already in use and retrieves its accounting data through connectors or scheduled imports.

How does corporate treasury work in groups with several companies?

The consolidated view shows total cash and lets you drill down to each company, account or bank. Business lines that make no sense to aggregate can be kept separate, as long as the scope is defined during the analysis.

How long does it take to see the first results?

Visibility on balances is the quickest part. Forecasting takes longer, because it depends on the quality of the payment schedule and on the definition of categories: these are the two activities the initial analysis focuses on.

Let’s talk

Before watching a demo of a corporate treasury platform it is worth measuring two figures the company already has: how many hours a month go into rebuilding the financial position and how far that reconstruction usually deviates from actual cash. Two numbers like these tell you in half an hour whether the topic deserves a project.

If you would like to explore the topic or assess your company’s situation, fill in the form at the bottom of the page or write to support@aesir-tech.it: we will book a free consultation and start from your numbers.

Vuoi parlarne applicato alla tua azienda?

Ti rispondiamo con l’esperienza di progetto, non con una brochure.

Request a call