Overview
SmartDocs 360 exports transaction data from PDF statements of supported banks into a pre-formatted CSV file that you can manually upload into Xero. The advantages for you are:
-
SmartDocs 360 can extract bank statement data from PDFs in seconds,
- Supports all Australian Banks
- Avoiding manual data entry into Xero.
Xero's API does not support the import of Bank Transactions, so you will be required to
1. Upload Bank Statements into SmartDocs 360
2. Review the Documents and Export to CSV
3. Import CSV file into Xero
Upload
Upload the bank statement PDFs on the Documents screen or email them using the SmartDocs email address.
The PDFs can either be the original bank-issued documents or scanned images.
- The bank statement data extraction process can take up to 2 minutes to complete, but overall, 90% of our statements are processed in under 30 seconds.
Review and Export
On the documents screen, click on the bank statement to open the statement to be reviewed.
The PDF will be displayed on the left-hand side, and the extracted data will be displayed on the right-hand side.
If you encounter any issues with the Document Extraction, please click on the feedback button on the toolbar to report them to BGL.
Along the top of the section for the extracted data, click on the Export to CSV button.
If the entity is connected to Xero, then the dropdown will pre-select "Xero CSV"; otherwise, you may need to select this manually. Select the Export button.
Import into Xero
If the entity is connected to a Xero ledger, an Import into Xero link will display at the top of the document. Click on this to go directly to the import CSV page in Xero (otherwise, click here for instructions.
In Xero, select the file that was exported from SmartDocs 360 and click Next.
The first time you import a CSV bank file to Xero, you’ll need to assign each column in the import file to a bank statement field. Then click on Complete Import.