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 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 happen to 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 button will display at the top of the document. Click Import into Xero to go directly to the import CSV page in Xero (otherwise, click here for instructions. 

When selecting Import into Xero, a list of active bank accounts will be displayed. Choose the relevant bank account to be redirected to the corresponding bank account in Xero.

In Xero, select the exported file 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.

Note: If the Import into Xero button is not visible, check for active bank accounts in the connected Xero account. This option will only appear if there are active bank accounts in the Xero organisation.