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 Related Articles.
How to download your extracted bank statement data
Click the Download button either from the list view or the statement view page.
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. Please note if you are located in the US, you will need to select one of the US Dates options from this list!
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.
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).
Xero, Sage 50 and SBCA (Sage Accounting) users can click one of the corresponding articles below for specific steps on exporting Bank Statement data:
Nov 3, 2022, 10:14 AM