The confirmation sheets

Last updated 10 November 2026

Sheet	Holds	Order
FXD1_C	FX spots, forwards and swaps. A swap appears as two rows, one per leg.	Newest trade date first, then by bank
FXD2_C	FX options	Newest trade date first, then by bank
IRD1_C	Interest rate swaps, overnight index swaps and cross-currency swaps	Newest trade date first, then by bank
IRD2_C	Swaptions	Newest trade date first, then by bank
IND_C	Inflation swaps	Newest trade date first, then by bank
Amortization_C	Amortization schedules: one row per step of each amortizing leg, with the percentage of the original notional repaid. Added when a run finds one.	By bank, reference, leg and date

Every row starts with the bank, the account and the client's name. Each trade keeps the bank's own reference, and is marked New or Amendment. Dates are shown as dd/mm/yyyy.

What a new run does

A new run adds to the trade sheets. A trade already in a sheet, with the same bank, account, reference and New or Amendment mark, is replaced by the newly read one. All other rows stay. So reading the same PDFs again is safe: they are written over themselves.

A trade found in two PDFs of one run is written once: the first one read.

The Amortization_C sheet is rebuilt from the confirmations of the latest run.

The position sheets and the CPI data sheet are not changed by a confirmations run.

A red FX Rate cell

On FXD1_C, a red FX Rate cell marks a deal where the notional times the printed rate doesn't give the counter amount, within one unit: the rate on the confirmation was rounded. Check the rate before you use it.