The mapper workbook
Last updated 10 November 2026
Confirmation Mapper doesn't create a workbook of its own. It writes into a mapper workbook: a copy of an empty workbook that comes with GIAnalyzer, with a set of named sheets. The product's messages call it a "Bank Adaptors workbook".
Keep one mapper workbook for each client or portfolio, and use it for every run.
Its sheets
| Sheets | Filled by |
|---|---|
| FXD_P, IRD_P, IND_P, Listed | Position Mapper |
| FXD1_C, FXD2_C, IRD1_C, IRD2_C, IND_C | Confirmation Mapper, which adds an Amortization_C sheet when it finds an amortization schedule |
| CPI data | You: the consumer price index, which Position Mapper uses for inflation legs |
Confirmation Mapper fills the five confirmation sheets, and Amortization_C. If you run Position Mapper too, both can write into the same workbook: each fills only its own sheets.
A workbook is accepted only when it has all nine position and confirmation sheets, whichever mapper you run. Upper or lower case in the sheet names doesn't matter.
Don't rename the sheets, and don't move their heading rows. Each sheet's rows are written below its heading row, from column C, with a running number in column B.
Create your mapper workbook
- Click Map and Load Confirmations > From folder.
- If the open workbook isn't a mapper workbook, a message asks whether to open a sample Bank Adaptors workbook. Click Yes. An empty mapper workbook opens.
- Save it under your own name, in a folder on your computer or network, with File > Save As. The copy that opened is temporary: it is replaced the next time an empty one is opened.
- Click Map and Load Confirmations > From folder again.
The checks before each run
When you click the button, GIAnalyzer checks the active workbook. At the first problem it finds, it says what is wrong, offers to fix it, and stops. Once it is fixed, click the button again.
| Message | What to do |
|---|---|
| The current workbook does not appear to be a Bank Adaptors workbook… | Switch to your mapper workbook, or click Yes to open an empty one |
| The current workbook is a template. Please save the workbook locally… | Click Yes and save it under your own name |
| The current workbook is write-protected… | Click Yes to remove the protection. For a read-only file, save a copy you can write to. |
| Please save the workbook locally before proceeding. | The workbook has never been saved, or is open from a web address, such as SharePoint or OneDrive in the browser. Click Yes and save it to a folder on your computer or network. |
| Bank Adaptor or executable is missing… | Part of the installation is missing. Run the Repair Tool (see If GIAnalyzer doesn't load), or email us. |
The mapper workbook must be the active workbook when you click the button, and it must stay open until the run ends.