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
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.
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
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
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
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.
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.
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."
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.
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.
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.
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 MtM | Bank statement | Legacy vendor / terminal | BlueGamma | |
|---|---|---|---|---|
| Independent of you & the bank | No — you built it, you mark it | No — the counterparty marks its own trade | Yes | Yes — third-party platform, broker-sourced data |
| Hypothetical derivative | Rebuild it yourself, maintain it forever | Never provided | Possible, if you know the terminal well | Set up as a second swap; revalues monthly off the same curve |
| Amortising notional | Manual schedule, easy to break | Bank's schedule (theirs, not checkable) | Supported, steep learning curve | Paste the profile from Excel; PV01 per swap |
| Match the bank's close time | Whenever you last pasted rates in | By definition — it is their close | Snapshot times exist but easy to mismatch — an hour off shows up in the mark | Valuation date and time selectable; ~30-sec data refresh |
| Inputs behind the number | Whatever was last pasted in | Rarely shared — "we lack that transparency" | There, if you know where to look | Curve inputs and fixings downloadable — "you're able to trace how the calculation was done" |
| Key-person risk | High — 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 tool | Web app + Excel add-in; anyone on the team can rerun the mark |
| Audit evidence output | A spreadsheet with your name on it | The counterparty's PDF | Screenshots / exports you assemble | Downloadable 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 trade | Thousands 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.
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.
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
FAQs
Auditors don't formally "approve" data vendors — what they test is where your number came from, whether it's independent of both you and your counterparty, and whether you can show the methodology and curve inputs behind it. As one senior treasury consultant put it, auditors expect teams to "get the truth from a renowned market data provider… they want a single source of truth." A valuation from an independent third-party platform, with a documented methodology, downloadable curve inputs and a dated PDF report archived each month, is a far stronger evidence trail than a self-built spreadsheet or the bank's own statement. Several BlueGamma customers adopted the platform specifically ahead of a Big Four or top-tier audit.
Yes. BlueGamma's swap mark-to-market tool supports amortising swaps — you paste the notional profile straight from Excel and the schedule updates. You get the MtM, PV01 and forecast payments for the exact amortisation profile, across SONIA, SOFR, EURIBOR and 30+ currencies, without paying for a terminal costing thousands a month.
Set the hypothetical up as a second swap in the mark-to-market tool with the critical terms of the hedged debt, and label it "hypothetical" in the reference field. Each month-end you revalue both the actual and the hypothetical off the same curve, and the difference feeds your effectiveness measurement; where testing needs marks as of multiple historical dates — a common ask from Big Four valuation teams — the Excel add-in prices the same trade across several as-of dates in one sheet. BlueGamma gives you the MtMs; the dollar-offset or regression workings live in your own workpapers.
The usual culprits are timing and conventions, not the data: the bank marks at its own close (e.g. London 5pm) while you pulled a curve at a different time, or a payment date, day count or compounding convention is set slightly differently. Even two desks on the same premium terminal can disagree — one treasury lead described how "slightly different fixing times" produced "slightly different forward implied rates — and that drove me nuts." In BlueGamma you set the valuation date and time to match the bank's close and align the schedule details; a sensible tolerance is around a basis point of PV01, and a persistent gap beyond one to three basis points is worth querying with the bank.
For liquid interest rate swaps, the underlying data originates with the brokers and exchanges — BlueGamma's data is sourced directly from a leading regulated interdealer broker, the same source the major terminals use — so the raw market data is the same; each provider then builds its own curves. Customers who have run side-by-side comparisons typically see differences of a couple of basis points or less, and audit valuation specialists who cross-check against a premium terminal note that even the big vendors "differ across maturity lines" — which is why the check is tolerance-based, not to-the-penny. BlueGamma bootstraps its own curves in-house rather than using out-of-the-box libraries, and the underlying inputs and fixings are downloadable for your audit file.
No — and that's deliberate. BlueGamma produces the valuations (actual swap, hypothetical derivative, MtM, PV01) that feed your hedge accounting; the journal entries, OCI allocation and designation memo stay in your own accounting workflow. Most treasury teams prefer it that way: the platform is the independent number, their workpapers are the accounting. If you'd rather outsource the whole thing, budget accordingly — advisory teams report hedge accounting engagements running €20,000–40,000 per instrument.
A BlueGamma single-currency starter licence is a flat monthly subscription that includes the swap pricer, mark-to-market tool, curves and unlimited downloads — there are no per-valuation or per-download fees, so daily revaluation costs the same as monthly. A 14-day free trial lets you set your actual swap up and check it against your bank's statement before paying anything.
Yes — you select both the valuation date and the time of day, so if your bank marks at London close, you value at London close, not whenever you happened to open the file. This is the single most common reason independent valuations "disagree" with bank statements, and it disappears once the timestamps line up. Data refreshes roughly every 30 seconds during market hours, and prior-day close marks are available for teams that reconcile collateral or run end-of-day valuations.
If you have exactly one swap — "literally the only thing I need it for is a smell check on the fair value of a swap price, quarterly, for two years," as one listed-company finance team put it — the realistic options are asking your bank (not independent, and "asking banks for favours" gets old), outsourcing to an advisory or Big Four team (expensive per instrument), or a platform subscription. BlueGamma's single-currency licence is a flat monthly subscription with unlimited revaluations, and the 14-day free trial lets you confirm it reconciles with your bank's statement before paying. Building it yourself in Excel is free until it isn't — one valuation firm found its DIY model roughly £50k off because a spot rate was used where a forward belonged.
Coverage spans 30+ currencies: SONIA, SOFR (including compounded-in-arrears with lookback conventions), EURIBOR, and yen swaps on TONA or TIBOR, alongside benchmarks like CORRA, BBSW, NIBOR, JIBAR and SAIBOR. The honest limitation: purely domestic benchmarks with no traded forward market — a local minimum-lending-rate leg, for example — can't be built as a market-implied forward curve by any provider. If your swap references a niche index, load it during the free trial and check the curve exists before you commit.
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.
Related use cases
Other jobs the same teams run on BlueGamma.