The roll-up that gets built by hand every morning
In many treasuries the day starts by logging into each bank portal, copying balances into a spreadsheet and converting currencies at the day's rate. With five banks and three currencies, that's the first hour of work, and the number you end up with doesn't say which balance came from the bank, which was keyed in and which was left over from yesterday.
FLIQO brings the balances of every account into one position and keeps track of where each one came from.
Every account in one position
The position covers checking and savings accounts, in local or foreign currency, as well as petty cash held at a branch or store. Each account keeps its own currency and is converted to the company's currency at the day's rate.
The view breaks down by bank, by account type and by currency. The currency exposure shows the balance in its original currency, its equivalent and the rate used to convert it.
Available, restricted and invested, kept apart
Not all of treasury's money can be used the same way. The position splits it into three parts:
- Available: cash in operating accounts. This is the balance the forecast starts from.
- Restricted: balances in accounts set aside for a specific purpose, such as collateral. They're shown, but not added to available cash.
- Invested: surplus cash placed in investments that haven't matured yet. It comes back to cash on its maturity date.
Together, the three make up treasury's total resources. Whether an account counts as available or restricted is set on the account itself.
Where each balance comes from
Balances come in two ways: the bank statement, in standard formats such as MT940, camt.053, MultiCash or CSV, or a balance template in Excel. For each account FLIQO records the available balance, which feeds the forecast, and the ledger balance when the bank reports it.
Every balance is tagged with its source. A balance reported by the bank is never overwritten by one keyed in by hand: if someone loads the template for a day that already has the statement, the bank's figure stays and the upload flags the rows where that happened. The screen shows what share of the total balance was reported by the bank, a figure that rises as more accounts move to statement loading.
Checking the daily load
Each account is compared with its previous balance. A balance identical to the day before usually means someone forgot to load it, and a very large change is worth a second look. Both are flagged before anyone relies on the number.
From today's position to the forecast
Today's position is the starting point of the cash forecast: each account's balance plus the actual movements recorded after it.
Looking back, you can see how the actual balance moved day by day and the average balance the company held over a period, with available and restricted cash shown separately, by bank or by account.
For a group of companies
The same dashboard works in group mode: it pulls the accounts of every company into the parent's currency and measures, across the whole group, how much of the balance the banks reported. The group view also shows each subsidiary's position.
Ask Aria
You can ask Aria how much cash the company has today, how much is available and how much is restricted, how much sits in each currency, how cash moved over the last few months, or what average balance was held in a quarter. Aria answers with the same data shown on screen, and only for the accounts the person asking is allowed to see.
Frequently asked questions
Do balances have to be keyed in?
Not necessarily. Balances can come with the bank statement or through the balance template. Manual entry is there for one-off cases, and it's tagged as such.
What if an account's balance isn't loaded one day?
The position takes that account's latest observed balance and adds the actual movements recorded after it. The daily load check flags the account that wasn't updated.
Does it handle accounts in several currencies?
Yes. Each account keeps its currency and is converted to the company's currency. The currency exposure shows the original balance, its equivalent and the rate used.
Does it work for several companies?
Yes. Each company has its own position, and in group mode you see them all together in the parent's currency.
Can you limit who sees each account?
Yes. An account can be restricted to the roles that need it, with view, operate or admin access. Anyone without access doesn't see it in the list or in the totals, and doesn't see its movements either. Company-wide figures, such as the forecast, stay complete for those with permission to see them.
Can the position go into a presentation?
Yes. The charts print the value on every slice and bar, so they can be copied into a presentation or a report without being rebuilt.