What Data & Info Is Required
When Submitting Your Work To Us?

Bank Of Scotland - Transaction Download (CSV)

These instructions relate to a desktop PC download (i.e the mobile app will be different).

1. Once logged in, open relevant bank account, statement should now show.
2. Scroll to the end of the statement (but above the footer area) and you will see the word "Export" (just beside "Print) click "Export".
3. A small window will open up.
4. Click the radio button beside "Date Range".
5. Enter the dates (normally your vat period or financial year).
6. The dropdown "Format" will default to "Internet banking text/spreadsheet (.CSV)".
7. Click the "Export" button.

Notes

• Bank of Scotland limits you to downloading a maximum of 3 months of data at a time (or 150 transactions at a time max), therefore you may need to do multiple downloads. If possible, do overlapping dates to ensure all data is present, we can delete duplications this side.

Accessing The Download

1. Whilst in your web browser, the download will be visible at the foot of the screen.
2. You will see a file there with your bank account name, open it, save it to desktop.
3. In your email program attach the file and email to us.

# If you don't see the file at the foot of the screen try holding down CTRL and then simultaneously press "J" (this opens the download folder). Drag the file to your desktop. This should then be easier to locate when attaching the file to an email.

Barclays - Transaction Download (CSV)

These instructions relate to a desktop PC download (i.e the mobile app will be different).

1. Once logged in, on the relevant account click "Account Services"
2. Select "View transactions".
3. On the blue bar at the top select "Search".
4. Enter the date range (normally your vat period or financial year)
5. Press "Search"
6. Using your mouse right-click "Download All (PDF)"
7. Also select the option "Export As" and then "Spreadsheet…Excel".

Notes

The reason we ask for both the CSV file and the PDF for the same period is that the CSV file is imported directly into our system, but there is a niggle with Barclays CSV files in that they don’t have a running balance, which we need for verification, so the PDF file is used to cross verify the balances.

Accessing The Download

1. Whilst in your web browser, the download will be visible at the foot of the screen.
2. You will see a file there with your bank account name, open it, save it to desktop.
3. In your email program attach the file and email to us.

# If you don't see the file at the foot of the screen try holding down CTRL and then simultaneously press "J" (this opens the download folder). Drag the file to your desktop. This should then be easier to locate when attaching the file to an email.

Clydesdale - Transaction Download (CSV)

These instructions relate to a desktop PC download (i.e the mobile app will be different).

1. Log into your banking
2. Select "Transaction history" on the left tab.
3. Select ‘Show filter’ button at the top of the screen.
4. Select dates at the ‘For period’ (normally your vat period or financial year).
5. Select the red "Display" button.
6. Select the grey "More" button at the bottom of the displayed transactions.
7. Select the ‘Export’ button at the top of the screen.
8. This will take you to a new screen.
9. Click the spreadsheet tick box.

Accessing The Download

1. Whilst in your web browser, the download will be visible at the foot of the screen.
2. You will see a file there with your bank account name, open it, save it to desktop.
3. In your email program attach the file and email to us.

# If you don't see the file at the foot of the screen try holding down CTRL and then simultaneously press "J" (this opens the download folder). Drag the file to your desktop. This should then be easier to locate when attaching the file to an email.

Co-Operative Bank - Transaction Download (CSV)

These instructions relate to a desktop PC download (i.e the mobile app will be different).

1. Log in & select the account number
2. Using the date selectors, chose the "From" and "To" dates (normally your vat period or financial year).
3. Click "Go" to see the transactions.
4. Click on "Reports" on the bottom right hand side.
5. There will be 3 options, "XML", "CSV" and "PDF", select "CSV" and click "Generate Report".
6. The report will now be downloaded to your web browser download folder.

Accessing The Download

1. Whilst in your web browser, the download will be visible at the foot of the screen.
2. You will see a file there with your bank account name, open it, save it to desktop.
3. In your email program attach the file and email to us.

# If you don't see the file at the foot of the screen try holding down CTRL and then simultaneously press "J" (this opens the download folder). Drag the file to your desktop. This should then be easier to locate when attaching the file to an email.

Lloyds - Transaction Download (CSV)

These instructions relate to a desktop PC download (i.e the mobile app will be different).

1. Once logged in go to statement tab.
2. Scroll to foot of page.
3. After the last line of transactions click "Export Data".
4. (Note: There's a maximum of 150 transactions for each download, so you may need to repeat the process to export all of the entries in your chosen range).
5. Enter the date range (normally your vat period or financial year).
6. In the dropdown box under "Format" select "Internet Banking Taxt/Spreadsheet (.CSV)".
7. Click "Export".
8. After a while a box will appear prompting you to save the file. Save to desktop.

Accessing The Download

1. Whilst in your web browser, the download will be visible at the foot of the screen.
2. You will see a file there with your bank account name, open it, save it to desktop.
3. In your email program attach the file and email to us.

# If you don't see the file at the foot of the screen try holding down CTRL and then simultaneously press "J" (this opens the download folder). Drag the file to your desktop. This should then be easier to locate when attaching the file to an email.

Royal Bank Of Scotland - Transaction Download (CSV)

These instructions relate to a desktop PC download (i.e the mobile app will be different).

1. Log in & select "Statements" on left hand side.
2. On the page, under the heading "Download/Export Transactions" select the green button "Download/Export Transactions"
3. A page called "Download Your Transactions" will now appear.
4. Under the "Select Period" choose a period that covers the above dates (normally your vat period or financial year). Alternatively select "Historic Transactions".
5. Under the section "Download Package" the dropdown called "Download To" should be set to "Microsoft Excel…"
6. Click "Next" Button (If you selected "Historic Transactions" you will now be prompted to input the above dates)
7. Click "Next" Button
8. Click "Download Transactions"

Accessing The Download

1. Whilst in your web browser, the download will be visible at the foot of the screen.
2. You will see a file there with your bank account name, open it, save it to desktop.
3. In your email program attach the file and email to us.

# If you don't see the file at the foot of the screen try holding down CTRL and then simultaneously press "J" (this opens the download folder). Drag the file to your desktop. This should then be easier to locate when attaching the file to an email.

Santander - Transaction Download (CSV)

These instructions relate to a desktop PC download (i.e the mobile app will be different).

1. Log in & open the relevant bank account.
2. On the main page, to the right above the statement there is a link "Download Transactions", click this button.
3. On the next screen enter the dates (normally your vat period or financial year).
4. The "Download To" dropdown should be set to "Microsoft Excel (XLS)".
5. Click the Download Button.

Accessing The Download

1. Whilst in your web browser, the download will be visible at the foot of the screen.
2. You will see a file there with your bank account name, open it, save it to desktop.
3. In your email program attach the file and email to us.

# If you don't see the file at the foot of the screen try holding down CTRL and then simultaneously press "J" (this opens the download folder). Drag the file to your desktop. This should then be easier to locate when attaching the file to an email.