Call us now on 0141 280 8900

Toolkit

TOOLKIT

support

Hint Sheets

Investigation Toolkit Version 4

3) How to deal with HSBC statements where the debit and credit columns overlap. Download PDF
6) How to deal with Santander (Abbey) statements where the debit and credit values are printed in the same column and transactions are printed in reverse chronological order. Download PDF
9) How to deal with paper statements from Barclays bank. Download PDF
10) How to deal with statements in which some transactions appear out-of-order. Download PDF
14) How to deal with Nationwide statements where the year of the transaction date is on a separate line to the day and month. Download PDF

Investigation Toolkit Version 3

1) How to deal with statements that have a dotted line between the pounds and pence columns. Download PDF
3) How to deal with HSBC statements where the debit and credit columns overlap. Download PDF
4) How to deal with known date formatting issues, specifically Woolwich Dates (which are formatted as ddmmyy, e.g. 130309) and Excel converting dates to an American format (e.g. 4th February gets displayed as 02/04/09). Download PDF
6) How to deal with Santander (Abbey) statements where the debit and credit values are printed in the same column and transactions are printed in reverse chronological order. Download PDF
7) How to add additional transactions to the final Excel worksheet produced. Download PDF
8) How to merge multiple Excel FI Toolkit worksheets. Download PDF
9) How to deal with paper statements from Barclays bank. Download PDF
10) How to deal with statements in which some transactions appear out-of-order. Download PDF
12) How to deal with statements where the currency values are in a non-UK format. Download PDF
13) How to deal with imported Barclays statements which contain more lines than can be loaded into Excel. Download PDF
14) How to deal with Nationwide statements where the year of the transaction date is on a separate line to the day and month. Download PDF

Frequently Asked Questions

OCR - What are the recommended scanner settings?

We recommend black & white with a DPI of 300 and Group 4 compression.

OCR - How can I correct several OCR errors?

Check that the statement is accurately gridded as poorly positioned grids may cause additional OCR errors. Once the gridding is accurate and complete export to Excel. Attempt to process the statement as this will often fix many common OCR errors. Any remaining errors will need to be manually fixed.

OCR - How do I process a statement entry that spans more than one line?

Each line should be gridded separately so that each entry is on a different row. Ensure that the correct multi-row option is selected on the process window in Excel. If the credit or debit value is aligned with the top or first row then select Value aligns with top row alternatively if the credit or debit value is aligned with the bottom or last row then select Value aligns with bottom row.

OCR - How do I delete a divider grid?

To remove a single divider click the Delete Dividers in Grid icon from the tools menu and hover over the grid line until a single black line with a cross in the middle appears then click. Alternately you may find it easier to delete all column dividers using F6 and adding the dividers again manually.

OCR - How do I find the version number?

Click Help and select About Altia OCR Tool. The version number is formatted as four numbers in the format of x.x.x.xxxxx.

How do I check if I have the 32 bit or 64 bit version of Office installed?

  • Excel 2007 – This version is 32 bit only.
  • Excel 2010 – Select File -> Help -> About Excel and the version will be listed at the end of the first line in the popup window.
  • Excel 2013 – Select File -> Account -> About Excel and the version will be listed at the end of the first line in the popup window.

The Altia tab in Excel was visible and is now missing. How do I restore it?

This problem is usually caused by Excel being abruptly shut down or crashing whilst the Altia tab was completing a task. If this has happened then the next time Excel is started it will ask whether to disable the Altia Investigation Toolkit add-in. If Yes is selected then the Altia tab will no longer be visible in Excel. To prevent this occurring No should always be selected. However if you have accidentally selected Yes then it can be re-enabled by:

  •  Excel 2007 – Select the Excel Application Icon -> Excel Options -> Add-Ins -> Select Disabled Items from the Manage list -> Go -> Select Altia Toolbar (mscoree.dll) and click Enable -> Click Close -> Click OK and then re-start Excel.

If the Disabled Items list is empty then select the Excel Application Icon -> Excel Options -> Add-Ins -> Select COM Add-ins from the Manage list -> Go -> Select and check Altia Toolbar -> Click OK and then restart Excel. Dependant on the system environment this may need to be completed by a user with local administrative privileges on the PC.

 

  • Excel 2010 – Select File -> Options -> Add-Ins -> Select Disabled Items from the Manage list -> Go -> Select Altia Toolbar (mscoree.dll) and click Enable -> Click Close -> Click OK and then re-start Excel.

If the Disabled Items list is empty then select File -> Options -> Add-Ins -> Select COM Add-ins from the Manage list -> Go -> Select and check Altia Toolbar -> Click OK and then restart Excel. Dependant on the system environment this may need to be completed by a user with local administrative privileges on the PC.

 

  • Excel 2013 – Select File -> Options -> Add-Ins -> Select Disabled Items from the Manage list -> Go -> Select Altia Toolbar (mscoree.dll) and click Enable -> Click Close -> Click OK and then re-start Excel.

If the Disabled Items list is empty then select File -> Options -> Add-Ins -> Select COM Add-ins from the Manage list -> Go -> Select and check Altia Toolbar -> Click OK and then restart Excel. Dependant on the system environment this may need to be completed by a user with local administrative privileges on the PC.

When importing an electronic Barclays statement using the Barclays import I receive a ColNum error message. What would cause this?

This is because you are attempting to import a file that is not an electronic Barclays bank statement file. If you are importing an electronic Barclays credit card statement this will also receive the same error message as it cannot be processed directly by Investigation Toolkit.

Why would an electronic statement fail to load after attempting to open using electronic import?

The electronic statement data has possibly been changed, deleted or corrupted in some manner.  For an electronic statement file to be valid the following checks are made:

  • Barclay Bank Statement – the first populated row of data is validated to contain the following 3 text markers: BARCLAYS, FICHE and LEDGER
  • PayPal – the named range Print_Titles is validated to exist in the workbook and that an All Transactions sheet exists

When processing data the date values have defaulted to the current year. How is this fixed?

Check that the correct and full date is inserted into the Opening Date field of the Process window in Excel and that the Primary Date format is correctly set as either ‘Day, Month‘ or ‘Month, Day‘ to match the statement transaction date style.

How do I find the version number?

Click About on the Altia Toolbar. The version number is formatted as four numbers in the format of x.x.x.xxxxx.

Why do I receive the error message 'I am about to reload the data. This will result in the changes you have made being discarded. Continue?'

If you select Yes then the data will be reloaded and you will lose any manual changes that you may have made to the data. If you select No then the data will not be reloaded resulting in any changes that you may have made being saved. However, selecting No will mean that any changes that Excel may make also being saved, for example whole numbers being divided by 100.

We recommend that you ALWAYS click on the Altia tab before manually making changes to the data prior to processing.