Confirmation Mapper guide

Last updated 10 November 2026

Confirmation Mapper reads the PDF trade confirmations your banks send, and writes the trade terms in one standard format: as sheets in an Excel workbook, or as CSV or JSON files.

It runs on your own computer, from Excel: Map and Load Confirmations on the GIAnalyzer tab. It reads the PDFs in a folder you choose, or first collects them from your mailbox. The mailbox connection runs from your computer to your own mail server: Gamma Impact holds no credentials and sees none of your mail.

What you need

• GIAnalyzer installed in desktop Excel for Windows: Confirmation Mapper runs from the GIAnalyzer tab. See Installing GIAnalyzer.
• 64-bit Windows. GIAnalyzer's functions also run on 32-bit Windows; Confirmation Mapper doesn't.
• A licence that includes Confirmation Mapper. It is licensed separately: a Full GIAnalyzer licence doesn't include it. Without it, the Map and Load Confirmations button is greyed out. See Activating your licence.
• To read from a mailbox: a Microsoft 365 mailbox, or a mail server that accepts IMAP. Microsoft 365 needs a one-time app registration by your IT administrator.

A run, step by step

1. Put the PDF confirmations into one folder, or set up your mailbox once in the settings.
2. Open your mapper workbook in Excel.
3. Click Map and Load Confirmations > From folder and choose the folder, or From Inbox.
4. In the Bank Adaptor window, choose Excel, CSV or JSON, and click Start.
5. When it finishes, close the window. The confirmation sheets now hold the trades from those PDFs.

In this guide

• The mapper workbook: the workbook Confirmation Mapper writes into, and the checks before each run.
• Mailbox settings: connecting to Microsoft 365 or IMAP, and choosing which emails are read.
• What Confirmation Mapper reads: the PDFs and kinds of trade it reads, and what it leaves out.
• Running Confirmation Mapper: from a folder or from your mailbox, the run window and the output formats.
• The confirmation sheets: what each sheet holds, and what a new run does to it.
• Hiding client details: output you can share without the account numbers and client names.
• Logs and troubleshooting.

Confirmation Mapper reads the confirmations of the banks it has been set up for. To find out whether your banks' confirmations are supported, or to see it read confirmations like yours, ask for a demonstration.