Automated Cash Positioning: How To Do It Plus Tools

Written by Trovata Team
March 28, 2019

Most people have heard the expression “cash is king.” Financial transactions, which reflect a business’ operations for exchanging goods and services, are nearly always settled in cash at the end of the day.

Cash is required for the business to operate –– collecting on billings from customers after generating sales, or paying wages to employees or paying suppliers for raw materials to manufacture products.

There are three basic tools that controllers, treasurers, and CFOs all use to manage cash effectively: cash positioning, cash forecasting, and cash flow analysis. Let’s look at cash positioning and the different ways you can perform it.

What is Cash Positioning?

Cash positioning is the process of aggregating all cash and liquid financial asset balances to provide a complete picture of a company’s current state of liquidity. This involves consolidating cash balances across all banks and all bank accounts. Depending on operational complexity, this may involve using foreign exchange rates to translate cash positions denominated in non-USD currencies into USD equivalents as a common denominator for consolidation.

Why is Cash Positioning Important?

A consolidated cash position provides insights into a company’s ability to meet short-term obligations (liquidity) while informing how much cash, if any, should be invested to generate interest income (yield).

Cash moves in and out of a company’s bank accounts daily. These daily cash flows can be for a variety of things – purchasing inventory, payroll, paying travel reimbursements to employees, collecting on billings from customers for the sale of products and services, or selling stock to finance the business. The underlying movements of daily cash are always reflected in the ever- changing balances.

automated cash positioning

Cash positioning helps to identify whether or not there is enough cash in each account to cover upcoming expenses while ensuring no account has excess cash. Excess cash could be swept to a control account and invested in money market (overnight) funds to generate interest income or to pay down debt to reduce interest expense. Cash positioning helps to identify efficiencies that may reduce bank fees.

Maintaining a healthy cash balance is often a financial covenant required by lenders. Monitoring the cash position is essential to ensure compliance with debt agreements to avoid penalties imposed by lending banks.

How is Cash Positioning Done?

Currently, analysts log in to each bank portal online and download .CSV files for cash balances and transactions from all bank accounts. Each file is uploaded into Excel and formatted, often by converting text into columns. This manual process may take an hour or more each day. However, since banks in some jurisdictions are difficult to access due to regulatory or language barriers, some balances are often omitted from the process.

Daily reconciliation – Reviewing cash transactions summarized into various cash flow types – is done to ensure that cash balances are correct and all transactions were properly posted and accounted for.

How Can Cash Positioning Be Automated?

There are generally three ways to automate cash positioning, as follows:

Bank File Gateway via SFTP

Setup a file gateway with the bank and receive daily files via Secure File Transfer Protocol (SFTP) to receive balances and transactions in a standardized digital file format, such as BAI2.

This process requires IT resources from the company and can take a several weeks to setup requiring authorization forms to be completed with each bank. Additionally, once files are received, the data still have to be formatted in Excel.

Outcome: Very little automation and time savings

Legacy Treasury Management Systems (TMS)

Implementing a treasury management system allows you to fully automate cash positioning in a single dashboard with reconciliation capabilities.

However, this process is generally reserved for large corporates as these legacy systems can take 12-18 months and cost over $1 million to implement, along with annual license fees of $250 thousand or more.

Outcome: Achieves automation, but requires a long and costly implementation and expensive annual license and maintenance fees. Most companies still end up exporting data into Excel for reporting and forecasting.

API Cash Positioning – The Modern Choice

Trovata is a next-generation platform that automates cash management and daily cash positioning using open banking APIs.

It is directly integrated with banks like Wells Fargo and JP Morgan. These direct connections allow users to connect to banks in minutes and stay connected with secure access tokens via Automated Programmable Interfaces (APIs).

Cash positioning is fully automated and includes built-in business intelligence tools to visualize, analyze, report, and reconcile cash flows.

modern tools for cash position

The Bottom Line

Cash positioning is a fantastic tool that can help any company manage cash. The world is speeding up. To overcome the many challenges of managing cash, it is becoming critically important to leverage the latest in technology to automate the many, often manual, workflows in finance and treasury.

The era of Open Banking has begun, enabling companies to consume real-time insights that will introduce unprecedented value and pace to cash management and financial reporting.

Upgrading to use best-in-class predictive machine learning techniques for treasury management, accounting, and financial planning & analysis is now possible.

Paired with a full ecosystem of digital tools, including mobile, digital assistants, and next-generation financial management UX, the future is very bright for corporate finance and treasury to overcome its many challenges.

Want to see it in action? Request a Trovata demo today!

Subscribe to Newsletter