Worksheet Lifecycle
What is Liquidity Management?
Ripple Treasury Liquidity Management allows you to dynamically manage your cash and liquidity with increased visibility into real-time data, clarity into new opportunities, and agility for moving funds.
Worksheets
Highly configurable and dynamic worksheets provide:
Fiat (government-issued) currency positioning
Digital asset positioning
Cash forecasting
Reconciliation process
In-house banking
Recommended Transfers (Payment integration)
These worksheets support you in actively minimizing the cost and time associated with moving cash internally.
Fiat Currency and Digital Asset Positions
Positions for fiat currency and digital assets can be easily built, viewed, and analyzed using transactional data pulled from multiple internal and external sources. Your organization’s information is continually updated, empowering you to make accurate decisions in real time to help facilitate business growth and expansion.
Purpose of Liquidity Management Worksheets
Effectively, worksheets make up a premier reporting tool. They allow you to effectively manage short- and long-term cash and liquidity.
Interactive cash position worksheet screens allow you to define and create position views with drill-down capability.
Customized, unlimited fields allow you to arrange, sort, and consolidate data.
Customized views can analyze information using transactional data pulled from multiple internal and external sources (banks, ERPs, third-party data).
Compare bank statements to financial and operational expected movements and forecasts.
Create a foundation for further actions on cash via other Ripple Treasury functionality such as reconciliation and financial instruments (FI).
Information is continually updated so you can make accurate decisions in real time.
In short, this is how you can know your business's future outgoing cash amounts to make sure it has enough cash coverage to sustain operations and fund future growth.
Related Functionality
The functionality that is dependent upon or required for worksheets are:
Importance
Highly configurable and dynamic worksheets are an integral tool for cash positioning, cash forecasting, in-house banking, and the reconciliation process.
Cash management worksheets meet the following needs:
Aggregate, standardize, and categorize data from all data sources into something that is consumable by Ripple Treasury.
Manage short- and long-term cash and liquidity through interactive screens.
Store transaction data in the database in a way that it can be easily retrieved and understood.
Display transformed data in a meaningful way.
Initiate different orientations for quick analysis by date, account, or user code.
Categorize data based on how decision-makers look at it.
Isolate or combine cash holdings at different levels or by groups.
Set controls that grant or prohibit others from viewing or using various worksheets
Allow data to be sliced and diced to provide customized detail about your cash position.
Automate daily banking tasks to avoid human error.
Tag key worksheets as Favorites to access them more quickly.
Understanding Cash Allocation and Position
Worksheets are the core foundation of a Treasury and Finance Department’s workflow in Ripple Treasury. They are the primary tool to display information used to make decisions about your company’s cash allocation and position.
You get a comprehensive view of your current and future outgoing and incoming cash flows (both fiat currency and digital assets) to be able to optimize your business operations for growth. Worksheets perform this function as efficiently and flexibly as possible to meet your evolving business needs.
Simply put, your worksheets display your transformed data in nearly any format you prefer. Worksheets allow you to slice and dice transaction data to show you exactly what you need to see your short- and long-term cash positions and liquidity.
Use Cases
The following use cases cover what the vast majority of worksheets are used for. Businesses use these worksheets together to meet their business requirements, goals, and objectives.
Business requirements:
Provide customized information to assist with the fundamentals of treasury management.
Treasury professionals perform critical daily liquidity management tasks that help ensure the availability of adequate cash resources needed to sustain the company’s ongoing operational activities.
Goal:
Treasury professionals perform critical finance functions that ensure the availability of funds and information necessary to support senior management’s objectives. A treasury’s responsibility is to manage and use the cash and liquid assets as efficiently and effectively as possible.
Objectives:
Access cash to pay vendors and employees.
Prepare a cash position worksheet.
Monitor cash balances on deposit at banks and other financial institutions.
Collect, concentrate, and disburse cash.
Provide cash position forecasts.
Invest and borrow funds on a short-term basis as needed.
Research and reconcile exception items, such as unexpected bank fees, missing deposits, and uncleared checks.
Coordinate efforts with other finance areas, such as accounts receivable, accounts payable, and accounting.
Prior Day Cash Position Worksheet
When creating a Prior Day Cash Position, you will use Actual balances created from various Financial Institution files created in standard (e.g., BAI, MT940, CAMT.053) or bank-specific formats. This is because your Actuals will tell you what happened or was posted to your bank account the day before (your Prior Day). It is important to note that the Prior Day balance is the foundation for cash positioning; you need to know what actually happened in order to do anything for the current day or future.
Definition
The Prior Day cash position refers to the company's cash balance as recorded at the end of the previous business day. This includes all transactions that have been cleared and settled to that point. Prior Day balances are interpreted as your actual balances from yesterday vs. what you expected to go through yesterday (estimated balances).
Data Sources
It relies on bank statements and transaction records from the previous day. This data is obtained through bank feeds (e.g., BAI, MT940, CAMT.053) and manual entries.
Accuracy and Reliability
Since Prior Day position is based on completed transactions, it is generally accurate and reliable. However, it does not reflect any pending transactions that might clear on the current day.
Use Cases
It's useful for historical analysis, understanding cash flow trends, and reconciliation purposes. It helps in understanding how the company's cash position has changed over time.
Usage Tips
Our standard format for a Prior Day cash positioning worksheet is a single date (pivot), accounts in the columns, and activity types (user codes) in the rows.
Dates
Single date (standard)
Date range
Does it include totals by week, month, etc.?
Accounts
Listed singly
Listed in groups (account trees)
Listed by a combination of single accounts and account trees
There is no standard for this (client preference)
Labels:
Accounts can be displayed as ID, Number, or Name.
Account Trees can be displayed as ID or Name.
User Codes — User Codes define the types of activity that can happen to an account. In balance reporting files coming from banks, they are usually BAI bank codes (BAI) or SWIFT generated codes (MT940).
Listed singly
Listed in groups (user code trees)
Listed by a combination of single user codes and user code trees
There is no standard for this (client preference)
Labels:
User Codes can be displayed as ID or Name.
User Code Trees can be displayed as ID or Name.
Clients often do not use bank-generated User Codes directly for reporting purposes. They often group several bank codes into one customized label. A customized User Code will need to be created for each of these labels.
For Example:
For all balances that have a bank-generated User Code of 0142 or 0195 and have ‘FX’ in the description, replace the User Code with “FX_CR.”
For all balances that have a bank-generated User Code of 0191, 0195, 0196, or 0208, replace the User Code with “WIRE_IN.”
For all balances that have a bank-generated User Code of 0115 or 0116, replace the User Code with “LOCKBOX_CR.”
Current Day Cash Position Worksheet
When creating a Current Day Cash Position, you will use Estimated balances created from various Financial Institution files created in standard (e.g., BAI, MT942, CAMT.052) or bank-specific formats. These are what has happened during the current day, and once finalized they will be posted to your bank account and will appear on tomorrow’s prior day statement.
The current day balance is the interim cash positioning for known activity that already happened, and activity expected to happen today, but has not currently been reported by the bank. You need to know this information in order to ensure you will have sufficient funds and will not overdraw the bank accounts.
Definition
The current day cash position reflects the real-time (or almost real-time) status of your cash balance. It includes transactions that are pending or expected to occur during the current day (Estimates).
Data Sources
This involves more dynamic data than prior day because it includes pending transactions, scheduled payments, and anticipated receipts. It might integrate data from various sources, including bank feeds, transaction predictions, and manual inputs.
Accuracy and Reliability
Current day cash positioning provides a more up-to-date view than prior day; however, it can be less reliable since it includes estimated or pending transactions that may not be finalized. These estimated transactions introduce some volatility compared to prior day cash positions.
Use Cases
Current day cash positioning is crucial for making immediate financial decisions, managing daily liquidity, and planning short-term cash requirements. It helps in proactive cash management and anticipating future cash needs.
Prior day is more about historical analysis and reconciliation, whereas current day is about active cash management and forecasting.
Usage Tips
For Current Day cash positioning worksheets, you will set your default view to Estimated transactions.
This is because the Current Day / Intraday file will tell you what is happening or was posted to your bank account today which are imported as Estimated Transactions.
FI movements also come in as Estimated Transactions, therefore it's important to design how Current Day file data is reflected.
Global Cash Position by Region, Currency, Entity, or Bank Worksheet
Setting up a worksheet to see your cash position by region, currency, entity, or bank is extremely specific to how your User Codes and account trees are set up. This is why you will not see these types of worksheets created by default in the system.
These worksheets are used to see your cash position by a specific dimension (region, currency, etc.) based on what question you’re trying to answer about your cash position.
Usage Tips
Clone an existing worksheet and summarize (hide what you don’t want to show).
Once you know what you want to reflect in your worksheet, all you need to change is your accounts and User Codes.
How you group items is up to you, but make sure you’re relying on User Code Trees (use every User Code in a tree and only in that tree)
Forecast Cash Position Worksheet
Definition
The Forecast Cash Position is an estimation of the company's future cash position that projects cash inflows and outflows over a specific future time period.
Data Sources
The inputs used for forecasting include: historical data, current cash positions, and predictive models. It may include projected revenue / incoming cash, expected expenses / outgoing cash, scheduled payments, and other planned financial activities and commitments.
Accuracy and Reliability
Forecast cash positions involves more variability since it can only be as reliable as the accuracy of the underlying data and assumptions that went into creating it. Forecasting is an important tool for Treasury and Finance departments to be able to optimize their future cash position and planning. However, forecasts are often prone to revisions as new or more accurate information becomes available.
Use Cases
Forecast cash positioning is essential for strategic planning, long-term cash management, proactively identifying potential cash shortages or surpluses, and making informed investment (FI and risk) decisions.
Usage Tips
On your worksheet, Actuals should be visible and used to carry forward to a forecast because you won’t have an opening balance (use Forecast or Estimate depending on where you’re using your forecast).
Forecasts are imported as Forecasted Transactions (specific plugin); however, the FI module forecast must be initiated from the Forecast Plan to become a Worksheet Forecast.
Copyright 2025 Ripple Labs Inc.