What Confirmation Mapper reads
Last updated 10 November 2026
The PDFs it reads
- PDF files with a text layer, as banks send them by email. Scanned confirmations are not read: there is no text recognition (OCR).
- Only the PDF files directly in the folder. Subfolders are not read.
It recognises the bank from its name printed in the confirmation, and the kind of trade from the document's title. A PDF it doesn't recognise, from an unknown bank, of an unknown kind or without text, is skipped, and the log says so.
The kinds of trade it recognises
| Confirmation of | Sheet |
|---|---|
| FX spot, including a spot from an option exercise | FXD1_C |
| FX forward | FXD1_C |
| FX swap, written as one row per leg | FXD1_C |
| FX vanilla option | FXD2_C |
| Interest rate swap or overnight index swap | IRD1_C |
| Cross-currency swap | IRD1_C |
| Swaption | IRD2_C |
| Zero coupon inflation (CPI) swap | IND_C |
| Real rate (inflation-linked) swap | IND_C |
Which of these a bank's confirmations cover depends on the bank.
Cancellations, amendments and amortizing swaps
- Cancellations are skipped: a confirmation that a trade was cancelled isn't written as a trade.
- Amendments are written as rows of their own, marked Amendment. The original trade's row, marked New, stays.
- Amortizing swaps: the amortization schedule of each leg, as printed in the confirmation, goes to an Amortization_C sheet, which is added to the workbook when a run finds one. This is in the Excel output only.
Documents that aren't trades
Banks also send documents that aren't confirmations of a trade, such as fixing notices or settlement advices. Two exception lists in the settings keep them out:
- a PDF whose file name contains one of the texts in the first list is skipped;
- a PDF whose text contains one of the phrases in the second list is skipped.
Upper or lower case doesn't matter. The lists apply to every run, from a folder and from your mailbox. By default they skip fixing notices of interest rate swaps. Each file skipped is listed in the log with the rule that excluded it.