Running Confirmation Mapper

Last updated 10 November 2026

Confirmation Mapper reads PDF confirmations from a folder. It can also collect them from your mailbox first, and then read the folder it saved them to.

From a folder

  1. Put the PDF confirmations directly in one folder, not in subfolders.
  2. Open your mapper workbook and make it the active workbook.
  3. On the GIAnalyzer tab, click Map and Load Confirmations > From folder.
  4. Choose the folder. The last folder you used is selected for you.
  5. In the Bank Adaptor window, choose the output format and click Start.
  6. When it finishes, click OK, then Close, and save the workbook.

From your mailbox

First set up the mailbox, once, in Mailbox settings.

  1. Open your mapper workbook and make it the active workbook.
  2. Click Map and Load Confirmations > From Inbox.
  3. A "Please wait" window shows the progress while the emails are searched and their PDF attachments are saved to the download folder.
  4. With Microsoft 365, the first time, a browser window asks you to sign in to the mailbox. Choose the account.
  5. The Bank Adaptor window then opens on the download folder. Choose the output format and click Start, and continue as from a folder.

Only PDF attachments are saved; the emails themselves are not changed. A PDF with the same name as one saved before is replaced.

Use a download folder of its own. The run reads every PDF in the download folder, including those saved by earlier runs. That is safe for the workbook: a confirmation already in a sheet is written again over itself. But keep other PDFs out of that folder.

If the mailbox can't be reached, a message shows the error and asks whether to open the settings. Click Yes to check them.

The Bank Adaptor window

After you choose the folder, a window titled Bank Adaptor opens. The run takes place in this window, a program of its own; while it is open, Excel doesn't respond.

  1. The window lists the files it found in the folder: "Following N files will be processed. Press start to begin".
  2. Under Output format, choose Excel, CSV or JSON. Excel is chosen at first.
  3. Click Start. For CSV or JSON, choose the folder for the files first; if you cancel that, the run is cancelled.
  4. The button counts the files as they are read, for example "Processed files: 3 / 12", and the black panel below shows the log as it is written. You can resize or maximise the window to read it.
  5. When "Processing completed successfully. Close the application to apply changes." appears, click OK, then Close.

Excel comes back to the front. With the Excel format, the workbook is updated when the window closes: save the workbook.

Output formats

Excel. Confirmation Mapper writes into the open mapper workbook, with the dates shown as dd/mm/yyyy. What a new run does to the rows already there is on The confirmation sheets.

CSV and JSON. Nothing is written into the workbook. Confirmation Mapper writes one file per table into the folder you chose, a file only when the table has at least one row: FXD1_C, FXD2_C, IRD1_C, IRD2_C and IND_C, as .csv or .json.

  • CSV files have the same column headings as the sheets, so you can paste the rows under a sheet's headings. Dates are Excel date numbers.
  • JSON files hold one record per row, and dates as yyyy-mm-dd. Where a deal has two legs, the leg fields start with "Pay" and "Rec".
  • A deal found in two files of one run appears twice in these files; in the Excel output it is written once. Amortization schedules are written in the Excel output only.