You can use the download option to export your bank statement data as a CSV or Excel file. Multiple formats are available allowing you to re-import the file into an accounting software.
📎NOTE: If a specific format isn't available, you can export a csv file and adjust it to the required import format manually.
Click the three dots on the Inbox or the statement view page, then click Download.
A menu opens, prompting you to select the File Type. There are specific formats for some integrations, but generally, a CSV file is fine for most imports.
Select a Date Range.
To select a full 12-month range, use the date picker to explicitly set the start and end dates (e.g., January 1 to December 31). This ensures all transactions within the selected year are captured.
Click Download, and the file automatically downloads to your PC.
To import this into your accountancy package, use the import tool there and select the saved file from your PC.
Click the three dots on the Inbox or the statement view page, then click Download.
A menu opens, prompting you to select the File Type.
There are specific formats for some integrations, but generally, a CSV file is fine for most imports.
Select a Date Range.
Click Download, and the file automatically downloads to your PC.
To import this into your accountancy package, use the import tool there and select the saved file from your PC.
⚠️CAUTION: After downloading it to import into your accounting software, don't open the file before you import it. Mapping is software-specific and opening in other programs can lead to formatting changes that cause import issues.
If you face an issue while importing due to this, you can re-download the file from AutoEntry and attempt the import again. If you still receive errors after this, contact your accounting software's support team.
Handling Duplicate Statements
If you have uploaded duplicate bank statements, follow these steps to process and download them correctly:
In the Uploaded Files section, identify the first instance of each statement you need.
Click Process Anyway for one line per statement to avoid duplicates.
Once processed, locate the files in your Inbox.
Use the three dots menu to download each file, selecting CSV as the file type and setting the appropriate date range.
Related guides
Xero, Sage 50 and Sage Accounting (Sage Accounting) users can click one of the corresponding articles below for specific steps on exporting Bank Statement data: