Hint Sheets
| Description |
File |
Size |
| 1) How to deal with statements that have a dotted line between the pounds and pence columns. |
 |
174 Kb |
| 3) How to deal with HSBC statements where the debit and credit columns overlap. |
 |
200 Kb |
| 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). |
 |
330 Kb |
| 6) How to deal with Abbey statements where the debit and credit values are printed in the same column and transactions are printed in reverse chronological order. |
 |
427 Kb |
| 7) How to add additional transactions to the final Excel worksheet produced |
 |
286 Kb |
| 8) How to merge multiple Excel FI Toolkit worksheets |
 |
797 Kb |
| 9) How to deal with paper statements from Barclays bank. |
 |
1524 Kb |
| 10) How to deal with statements in which some transactions appear out-of-order. |
 |
1472 Kb |
| 12) How to deal with statements where the currency values are in a non-UK format. |
 |
425 Kb |
| 13) How to deal with imported Barclays statements which contain more lines than can be loaded into Excel. |
 |
849 Kb |
| 14) How to deal with Nationwide statements where the year of the transaction date is on a separate line to the day and month. |
 |
588 Kb |