Objective

This article will go through the steps required to download your Bank Statement data as a CSV or Excel file. For accountancy packages not listed with a specific format, if there is an import function in your package, most will accept a .csv or Excel file of the data.

Specific steps for importing bank statement data to Xero, Sage 50 and SBCA can be found under Additional Information at the bottom of this page.

Applies To

  • Bank/Credit Card Statements

Procedure

To download your extracted bank statement data:

  1. Click on the Download button either from the list view or the statement view pages.

  2. A menu will open, prompting you to select the File Type. There are specific formats for some integrations, but generally a CSV file should suffice for most imports.

  3. You will also have the option to select a Date Range of statements to be downloaded. This is useful if you are going back to the same account/project to download certain statements later in a period.

  4. Click Download, and the file will automatically download to your PC.

To import this into your accountancy package, simply use the import tool there and select the saved file from your PC. 

If you are downloading for a specific accounting package to import the data there, once downloaded, do not open the file before importing it to your accounts package. The downloads are mapped specifically to each accounting package which can change if opened (e.g, opening the file in Excel can change the date format from that required by the accounts package to your local date format which will cause the import to fail). 

Additional Information

Xero, Sage 50 and SBCA (Sage Accounting) users can click one of the corresponding articles below for specific steps on exporting Bank Statement data:

Did this answer your question?