Objective

This article will go through the steps required to download your Bank Statement data as a .csv or Excel file.

Specific steps for Xero, Sage 50 and SBCA users can be found under Additional Information at the bottom of this page.

Applies To

  • Bank/Credit Card Statements after processing.

Procedure

For accounts 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.

  • Excel - A standard Excel file

  • CSV - Generally for uploading to accounts packages

Or in a specific file type formats for the following accounts packages:

  • QuickBooks (Online and Desktop)

  • Sage 50 and Sage Accounting

  • Xero

  • Plus many more:

To download the data extracted from the uploaded bank statements, click on the Download button either from the list view or the statement view pages.

Simply select the required format, and the download will begin automatically. To import this into your accounts 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?