Rather than manually copying each line of your clients’ Bank Statements into their accounting software, you can use Receipt Bank to automatically extract Bank Statement data and present it in a spreadsheet or .CSV download format.
How to Submit Bank Statements for Processing:
1. Navigate to the Client Account
2. Click 'Add Items' and select 'Add Bank Statements'.
3. Select your files by clicking on the ‘Click here to select files’ button or drag-and-dropping your file onto the green platform.
- Bank Statements from multiple accounts should not be appended together in a single upload file.
- The file should not contain statement images captured with a camera. Scans or original digital copies only.
- The file should not be made out of data from multiple sources (e.g. half the pages are scans of postal copies and half are online downloads).
- The statement should not have an excessive amount of handwriting in the numerical columns. Ticks and infrequent annotations are generally accepted.
- A list of supported banks can be found here
4. Once you’ve uploaded a Bank Statement, it will be available to view in the Collected Statements tab of the Bank page. Uploaded Bank Statements are automatically added to the processing queue, during which all of the associated Bank Statement data will be extracted. This process can take up to 2 working days to complete.
How to Download Bank Statement Data:
1. When uploaded Bank Statements have finished the extraction process, they will be moved to the Processed tab of the Bank page.
2. You can download the Bank Statement data by pressing the Download button. You can download the original bank statement that was uploaded to Receipt Bank by clicking the hyperlink in the Item ID column.
You can choose the download format for Bank Statements by navigating to the General
tab of the Account Settings
and choosing between the three available formats:
- Standard Receipt Bank Excel: Default .xlsx file with all extracted data
- Xero CSV: File format optimised for upload into Xero
- QuickBooks Online CSV: File format optimised for upload into Quickbooks Online
NOTE: If you notice errors in the data extraction of a bank statement, click 'Report Mistake'. This will resubmit the bank statement for extraction.