Use case · Treasury & hedge accounting

The auditor wants an independent valuation of our swap — how do I get one?

It's month-end close. The swap you designated as a cash flow hedge needs a mark-to-market — and a hypothetical derivative valuation for effectiveness testing — before the postings go in. And in September, when the auditors arrive, the ask is always the same: "I see the mark-to-market value of this swap — why did you come up with this number?" They'll want the methodology, the curves and the inputs behind the mark. "I bootstrap my own curves" is not an answer they love — and neither is "the bank told us".

Last updated: July 2026 · Based on real workflows from BlueGamma customer calls

The short answer

You can produce an independent, audit-ready swap valuation — MtM, PV01, hypothetical derivative and a downloadable PDF report — in minutes, without a premium market-data terminal. Set the swap up once; revalue it every month-end. BlueGamma is an interest rate data and pricing platform used by 80+ financial institutions for swap rates, forward curves and cap pricing across 30+ currencies.

How you're probably doing it now

Four workflows come up on almost every call about swap valuations for audit — and each one has a hole the auditor will find.

Fragile

The homemade Excel MtM

Someone on the team built a spreadsheet that discounts the cash flows. It works — until the person who built it leaves, or a spot rate quietly sits where a forward rate belongs. One valuation firm that "regularly engages in swap valuations" using Excel models found a single mark roughly £50k adrift for exactly that reason. Another finance team inherited a terminal-linked workbook built by a colleague "from investment banking — who already left."

"It's always been like the mad dash to figure out, like, oh, is our mark to market Excel — is it accurate? Oh, it's off by a couple thousand."

— Commercial real estate financing team, Canadian mortgage lender
Not independent

Taking the bank's statement as gospel

"Why not just use the bank's valuation?" Because the bank is the counterparty to your trade — its mark is not an independent check on itself. Treasurers admit it out loud: "we don't track it really, we just wait for [the bank] to tell us what the valuation is." And when you ask the bank for the inputs behind its number, you rarely get them — "we lack that transparency," as one Big Four hedge accounting advisor put it. The bank's statement will also never give you the hypothetical derivative you need once the swap is designated.

"Because we've designated this, we need to run a hypothetical derivative every month, and for that we'll need a mark to market tool."

— Finance manager, UK consumer-leasing fintech
Timing mismatch

A terminal mark taken at the wrong time

Big-terminal data isn't wrong — but if your snapshot doesn't match your bank's close, the numbers won't reconcile and you'll burn hours chasing a difference that's really just a clock. Even two desks on the same premium terminal can disagree: one project-finance treasury lead described colleagues with "slightly different fixing times in their [terminals]" getting "slightly different forward implied rates — and that drove me nuts."

"What I noticed is there was slight mark to market value differences between what we were getting from [the bank] at London close of play and what the BlueGamma tool gave us… if I brought your curve back an hour or so, then they became more in line."

— Finance manager, UK consumer-leasing fintech
Expensive overkill

The £100k TMS (or the €40k-per-instrument engagement)

A full treasury management system quoted at "around £100,000 a year" — bundled with modules you don't need — is one way to get a swap valued. Except the cheaper TMS options don't always price correctly: one UK bank treasurer found theirs "don't do cross-currency swaps at all, and do interest rate swaps, but they're not doing them quite correctly." The other extreme is outsourcing: advisory teams report hedge accounting engagements running €20,000–40,000 per instrument.

"They're doing all using manual worksheets in place and this has been a bit of a pain area for most of the people. I'm not honestly aware if there is any tool which is in place."

— Hedge accounting advisor, Big Four firm (India)

How teams describe this

Verbatim, from sales and onboarding calls — lightly trimmed, names removed.

"It's mostly to give the auditors, right — to show that we verified the pricing we got from the bank, ourselves."

— Finance team, US-listed technology company

"Sometimes there is an ask from the auditors that, hey, I see the mark to market value of this IR swap — why did you come up with this number?… You give them: OK, this is the methodology being used. And these are the curves."

— Senior treasury consultant, treasury advisory firm

"What we need is not just an MtM at that point. What we need is all the inputs that have gone in determining that MtM… which we lack that transparency at that point in time, which is where they start to understand the need to have an independent valuation."

— Hedge accounting advisor, Big Four firm

"We get the mark to market notifications every day from the bank and… it's just a pain to sort of either fact-check them or keep them honest, if you will."

— VP of capital markets, US commercial real estate firm (three swaps)

"Literally the only thing I need it for is just to… do a smell check on the fair value of a swap price. Quarterly, for two years."

— Finance team, US-listed technology company (one SOFR swap)

"Their auditors also expect them to, you know, get the truth from a renowned market data provider… they want a single source of truth."

— Senior treasury consultant, on the treasury teams they advise

Set it up once, revalue every month-end

The whole workflow lives in the swap mark-to-market tool. No terminal, no bootstrapping, no chasing the bank.

1

Load your swap — amortising profiles included

Enter the trade once: currency, start date, payment dates, payment frequency, fixed rate. Amortising swaps are fully supported — paste the notional profile straight from Excel into the notional schedule and it updates. Match every critical term to the swap confirmation ("it has to be apples to apples," as one Big Four valuations reviewer put it — if the terms don't match, the mark is meaningless). Benchmarks cover SONIA, SOFR (including compounded-in-arrears with lookback conventions), EURIBOR, yen swaps on TONA or TIBOR, and 30+ currencies.

2

Add the hypothetical derivative alongside it

For hedge accounting, set the hypothetical up as a second swap mirroring the critical terms of the hedged debt, and label it in the reference field (e.g. hypothetical). Both revalue off the same curve, so effectiveness testing is a straight comparison. This matters double if you're designating late — as one Big Four advisor put it, "I've taken an interest rate swap a year prior and I'm trying to designate it today… when it is not on market, I need some of this data to be able to do that designation. Otherwise my effectiveness testing going forward will fail."

3

Match the valuation date and time to your bank's close

Pick the exact valuation date and time — if your bank marks at London 5pm, so do you. This is what makes your number reconcile with the statement instead of arguing with it.

4

Check MtM and PV01 against the bank statement

PV01 (basis point value) tells you how sensitive the mark is to rates — so a difference of "a couple thousand" becomes "less than a basis point", a number your CFO can set a threshold against. One to three basis points is a sensible tolerance; beyond that, query the bank.

5

Download the PDF valuation report and archive it

Each month-end, download the valuation report and file it with your hedge documentation — the underlying curve inputs are downloadable too, so the file traces from mark back to market data. Teams that live this monthly put it plainly: "we tend to want to be able to trace the assumption it's coming from… downloading the Excel file and saving it, and then you're able to trace how the calculation was done." When the auditor asks where the number came from, the answer is a dated report from an independent platform — not a spreadsheet only one person understands.

6

Need marks as of several past dates? Use the Excel add-in

Effectiveness testing and late designations often need the same trade valued as of multiple historical dates — "there are cases where we have to price as of multiple dates in terms of hedge testing," as one Big Four valuations team put it. The Excel add-in pulls curves and prices by as-of date directly into your workpapers, and some teams run an interim workflow with it: use the platform mark to post on time, then true up when the bank's confirmation lands.

For this job specifically — how the options compare

Not a general vendor comparison — just the monthly independent-valuation-for-audit workflow.

Homemade Excel MtMBank statementLegacy vendor / terminalBlueGamma
Independent of you & the bankNo — you built it, you mark itNo — the counterparty marks its own tradeYesYes — third-party platform, broker-sourced data
Hypothetical derivativeRebuild it yourself, maintain it foreverNever providedPossible, if you know the terminal wellSet up as a second swap; revalues monthly off the same curve
Amortising notionalManual schedule, easy to breakBank's schedule (theirs, not checkable)Supported, steep learning curvePaste the profile from Excel; PV01 per swap
Match the bank's close timeWhenever you last pasted rates inBy definition — it is their closeSnapshot times exist but easy to mismatch — an hour off shows up in the markValuation date and time selectable; ~30-sec data refresh
Inputs behind the numberWhatever was last pasted inRarely shared — "we lack that transparency"There, if you know where to lookCurve inputs and fixings downloadable — "you're able to trace how the calculation was done"
Key-person riskHigh — built by "a colleague from investment banking, who already left"None (it's the bank's problem)One shared licence often serves the whole team — a queue, not a toolWeb app + Excel add-in; anyone on the team can rerun the mark
Audit evidence outputA spreadsheet with your name on itThe counterparty's PDFScreenshots / exports you assembleDownloadable PDF valuation report, dated and archived
Cost anchor"Free" + hours every month-end (and a ~£50k error waiting to happen)Free — but priced into the tradeThousands per month for one workflow — "they just kept on putting their prices up"Monthly licence, unlimited downloads

The teams that validated their own numbers — then kept the tool

From real evaluations, 2025–2026.

Mini case — first hedge, first audit

A UK consumer-electronics leasing fintech had just executed its first amortising SONIA swap and designated it as a cash flow hedge — with the first reporting period weeks away. The finance team had built their own Excel mark-to-market tool, then used BlueGamma to validate it: the two PV01s came out within a whisker of each other, and the platform became the independent monthly number for the MtM, the hypothetical derivative and the covenant-pricing SONIA forward curve.

Mini case — a growing swap book vs a £100k TMS

A UK specialist bank with a book of roughly 20 swaps — amortising asset swaps, deposit swaps and a cross-currency position — was weighing a treasury management system quoted at around £100,000 a year, bundled with liquidity and capital-reporting modules it didn't need. "It's a growing book, and because the asset is amortised it's going to get more complex… we're going to need good data." Their treasury put the swaps into BlueGamma instead, with back office booking trades and the treasury team monitoring the marks — and ran a parallel check against the broker close before committing.

"If [our auditors] would come in and audit us in September and I go, yeah, I bootstrap my own curves and this is why we've made all these postings — it gives you less of a confidence interval than 'we've used a tool'."

— Finance manager, UK consumer-leasing fintech

"It's more chicken and egg, where we've created this swap pricing tool, but then we're obviously using your tool to validate our tool. And if your tool is off then… we're not 100% confident in what we've built. So it's using both of them to validate each other."

— Finance manager, UK consumer-leasing fintech

"We do have those more institutional clients — whether it's REITs or maybe just an extremely large private entity with several billion of real estate. They'll have a ton of swaps on hand. And if we book them for them and they have questions, we can have all the data ready."

— Commercial real estate financing team, Canadian mortgage lender

"I don't wanna be around month end trying to get all of this posted… I guess again from an audit perspective — these are all the things that feed into it."

— Finance manager, UK consumer-leasing fintech

"We get the mark to market notifications every day from the bank and… I understand how it's calculated. It's just a pain to sort of either fact-check them or keep them honest, if you will. So your site is great for that."

— VP of capital markets, US commercial real estate firm (three swaps, daily bank statements)

"There is a subset of clients that actually kind of look at independence — not wanting to rely on counterparty valuations and wanting to rely on market data for valuations."

— Hedge accounting advisor, Big Four firm (clients with 50+ live derivative contracts)

The facts that matter for this workflow

Amortising swaps
Paste the notional profile straight from Excel
PV01 on every swap
Basis point value — the number your threshold policy hangs off
PDF valuation reports
Downloadable, dated — file them as audit evidence
Hypothetical derivatives
Mirror the hedged debt as a second swap for effectiveness testing
~30-second refresh
With valuation date & time selection to match your bank's close
30+ currencies
SONIA, SOFR (compounded, lookbacks), EURIBOR, TONA/TIBOR, CORRA, BBSW, NIBOR, JIBAR, SAIBOR
Excel add-in
Price the same swap as of multiple historical dates — hedge testing in your own workpapers
Broker-sourced data
Sourced directly from a leading regulated interdealer broker — the same underlying source the major terminals use; ties out within ~1bp
Unlimited
Downloads and revaluations on a single-currency starter licence — no per-valuation fees
14-day free trial
Load your actual swap and check it against the bank before paying

FAQs

Load your actual swap. Check it against the bank. Then decide.

The 14-day trial includes the swap mark-to-market tool, amortising profiles and PDF reports — enough to run a full month-end dry run before the auditors ever ask.

Try Free for 14 Days
No card required · Full portal access · PDF valuation reports included in the trial