Which instruments does it hold?

Bank loans, revolving credit lines with their committed limits, term deposits, interest-rate swaps, the loans entities make to each other, and facilities with counterparties that are not banks. Each carries its own schedule and its own events. If your group signs a kind of contract that is not here, we add it.

How is the interest figure calculated?

From the contract: the benchmark it names, the margin on top of it and the day-count basis it states, ACT/360 on the facility at the top of this page, applied to the days between two payment dates. The result sits beside the movement that paid it, so a treasurer can compare the two instead of assuming they agree.

What happens when a rate resets?

The new fixing applies from the reset date forward and the schedule reprices from there. Earlier periods keep the rate they were actually charged at, and the reset itself is an event on the instrument with its date and its fixing, so the change can be followed rather than reconstructed.

What about our interest-rate swaps?

They are instruments in the same book, with their own schedules and their own events. The net rate on the facility a swap sits against is computed and evidenced, both legs on screen. What that swap means for your accounts is a decision for your own accountants: we show the working, we do not make that call.

Do we have to change anything in our loan documents or at our banks?

No. It reads the amortization schedules you already keep, the loan statements your banks send and the entries your ERP books, in the shape they already arrive in. Where a schedule and a bank movement disagree, the difference is shown against the instrument instead of being absorbed into it.

Financing and exposure

Your financing and your deposits live in two places today. Here they are one record.

It holds every facility the group has signed — bank loans, revolving lines, deposits, interest-rate swaps and the loans entities make to each other — each with its own schedule, its own reset dates and its own events. When a payment leaves the account, the movement lands on the instrument that owed it, so the outstanding balance is read rather than maintained.

Request a demo

Banking Loans · one facility

ACT/360

Outstanding principal

EUR 12,750,000

What is still owed under this facility today

Original principal: EUR 18,000,000
Benchmark · 3M EURIBOR: 2.412%
Contractual margin: 1.450%
All-in rate: 3.862%
Quarterly payments remaining: 17

Next paymentSep 30

Principal and interestEUR 875,836.83

The book

What is actually in a group’s financing position?

Four families of instrument, each with its own contracts and its own way of being repaid. The total says what is owed. It does not say what is still available, and a team funding a month has to see both.

The drawn book, by instrument family

What it is	Drawn · EUR
Term loans11 bilateral loans on fixed amortization schedules. Every repayment date is a row on the instrument rather than a reminder in somebody’s calendar.	EUR 27,216,000
Credit lines14 revolving lines. What is drawn is debt and what is committed but unused is headroom, and the two are never added together.	EUR 22,032,000
Confirming5 supplier finance lines, drawn as suppliers take early payment, so the balance moves with the program rather than at month end.	EUR 9,072,000
Other6 facilities that are neither a bank loan nor a line: vendor finance, leases and agreements with counterparties that are not banks.	EUR 6,480,000

Total outstanding across the book

Every facility in the book at what is outstanding today, whichever product it was drawn under.

EUR 64,800,000

Committed limits, and what is left under them

Committed limits: EUR 48,500,000; Signed on the revolving and supplier finance lines. An amortizing loan has no limit to draw against, so none of it is counted here.
Drawn against them: EUR 31,104,000; The part of the book above that sits under a limit. The rest was drawn once and is being repaid.
Available: EUR 17,396,000; Headroom is what the group could borrow, not what it owes, so it never enters the debt figure above.

The same kind of record holds the deposits the group has placed, its interest-rate swaps and the loans its own entities make to each other. A facility that is a liability in one company and an asset in another is one instrument seen from both sides, not two spreadsheets that have to be tied out.

What the group holds, placed

The placed book, by instrument

What it is	Placed · EUR
Term deposits6 deposits placed to a fixed maturity, each earning the rate its own confirmation states.	EUR 18,000,000
Money-market placements4 call and notice placements, kept liquid at a lower rate for cash the group may need back before it matures.	EUR 9,500,000

Total placed

Surplus liquidity out at interest. It is an asset, held on the same kind of record as the debt above and never netted against it.

EUR 27,500,000

Blended yield2.83%

Weighted across the placed book by amount — 10 placements with 6 counterparties.

Where the figure comes from

Where does the outstanding balance come from?

From three places that normally live apart: the contract, the entries booked against it, and the money that left the account. Here they are one instrument, and the balance is what falls out of them.

The contract, held as a schedule: Every drawdown, repayment and reset date the facility was signed with, as rows on the instrument rather than as a document somebody has to open. Interest is computed on the basis the contract names, over the days between two payment dates.
The entries booked against it: What each entity’s ledger recorded for that same instrument, including the loans entities make to each other, where one company’s asset is another’s liability and both legs have to agree.
The movement that settled it: The bank line that paid the coupon, attached to the event it belongs to. The engine weighs the candidates, scores them, keeps the ones it rejected and shows the evidence behind the one it chose.

Loan Events · one facility

Paid on the last payment date

EUR 877,422.75

One movement on Jun 30, on the account this facility is paid from, matched to the two events below it.

Rate reset applied: 3.862%; Jun 29Applied to the schedule
Interest paid: EUR 127,422.75; Jun 30Matched to a bank movement
Principal repaid: EUR 750,000.00; Jun 30Matched to a bank movement
Next payment due: EUR 875,836.83; Sep 30Scheduled

3 movements that look like debt service are not attached to an instrument yet. They sit in the review queue, not in the balance above.

Each matched line keeps the statement line behind it: the account it left, its value date and the amount the bank actually took.

The exposures

What does a financing book expose the group to?

Three exposures come out of the same instruments, and none of them is visible one company at a time. A group that measures them entity by entity ends up hedging positions it does not have.

Read off the same instruments

Fixed-rate share: 61%; The rest reprices on its own reset dates, at the benchmark each contract names.
Largest single lender: 28%; Of the drawn book, spread across 9 lending relationships.
Currencies with a published rate: 4; Of the 5 the group is exposed to. CUP has no published market rate, so that exposure stays in its own currency and enters no group total.

Currency, after the group has netted: A facility drawn in a currency sits against the cash and the receivables the group already holds in it. The exposure is what is left once those meet; what a single entity sees on its own is not.
Interest rate, per contract and per reset date: Each facility carries the benchmark it reprices on and the day the next reset falls. A swap that pays fixed against a floating loan moves that loan into the fixed share, and both legs stay on screen.
Concentration, by counterparty: How much of the drawn book, the undrawn commitments and the deposits sit with one banking group. It only becomes visible once every entity’s facilities are in the same place.

None of the three is a report somebody assembles at the end of the month. They are cuts of the same instrument records, so they move the moment a drawdown, a reset or a repayment does.

Day to day

Who opens this, and what do they take away?

Four people, four questions, one book underneath all of them.

Treasury, before a payment date: Knows what leaves and when, down to the account it leaves from, and can see the headroom it does not have to go and ask for.
The CFO, before the board meets: Takes the group position and the concentration behind it, with the contract still attached to every line of it.
The controller, at the close: Closes against the same instrument treasury is paying from, on the interest that was actually charged rather than the interest somebody expected.
Shared services, through the month: Works the movements that have not found an instrument, instead of re-reading the ones already matched.

The modules it works with

Who it is built for

Before you ask

The questions this page gets.

01Which instruments does it hold?: Bank loans, revolving credit lines with their committed limits, term deposits, interest-rate swaps, the loans entities make to each other, and facilities with counterparties that are not banks. Each carries its own schedule and its own events. If your group signs a kind of contract that is not here, we add it.
02How is the interest figure calculated?: From the contract: the benchmark it names, the margin on top of it and the day-count basis it states, ACT/360 on the facility at the top of this page, applied to the days between two payment dates. The result sits beside the movement that paid it, so a treasurer can compare the two instead of assuming they agree.
03What happens when a rate resets?: The new fixing applies from the reset date forward and the schedule reprices from there. Earlier periods keep the rate they were actually charged at, and the reset itself is an event on the instrument with its date and its fixing, so the change can be followed rather than reconstructed.
04What about our interest-rate swaps?: They are instruments in the same book, with their own schedules and their own events. The net rate on the facility a swap sits against is computed and evidenced, both legs on screen. What that swap means for your accounts is a decision for your own accountants: we show the working, we do not make that call.
05Do we have to change anything in our loan documents or at our banks?: No. It reads the amortization schedules you already keep, the loan statements your banks send and the entries your ERP books, in the shape they already arrive in. Where a schedule and a bank movement disagree, the difference is shown against the instrument instead of being absorbed into it.

Open one facility, all the way down.

Bring the documents for one facility and the statements for the account it is paid from. You will see its schedule, its events and the movements that settled them on a single record, including whatever does not tie — which is usually the part worth seeing.

Request a demo See the whole product

A first look runs from documents and statements alone. Nothing has to be connected to your banks to do it.