Once your Bank or Credit card statement data has completed processing in AutoEntry it is possible to export that data directly into Sage Business Cloud Accounting. This feature is available in the UK and Ireland, Canada and the USA for SBCA Plus, Standard and Start subscriptions. Please note, this feature is not available in Australia or South Africa at this time.
How does this work?
This can be done from within the Inbox or when viewing the Statement data. Here's a video going through the process and more details below:
Firstly, there is a re-design for the inbox layout. From the left, the page now shows:
The project name top left and the date it was last updated
View icon to view the extraction details
Account number as extracted from the uploaded statements
Sage Bank Account dropdown to select the connected SBCA bank account
Date Range/Notes - showing the date range of the statements processed
Files - Number of files uploaded to that account
Pages - Number of pages uploaded
Export to Sage - to export the data directly to SBCA
Export History - An audit trail and status notification of previous exports to SBCA
Download - option to download the data locally
Trash Can - to delete that account, including all the extractions already completed for that account
Download accounts to the top right will download all the data in all the accounts within that project.
How to export your Bank Statement data
When viewing the inbox, in order to export the data through to SBCA, first, simply select the bank account from the dropdown menu that you wish to export the data to.
Click the Export to Sage button to the right.
This will now open a calendar pop-up window. All available dates are selected by default, but if required you can reduce the data by selecting new dates. In the example below, data that has previously been exported to SBCA is shown in blue italics (May 3rd to 8th).
Once the dates are selected, click on Export to Sage at the bottom right. A pop-up will appear to confirm the transaction dates being exported and the Sage bank account they're being exported to. Clicking Export to Sage on this screen confirms that these details are correct and exports the data to Sage. Of course, if any of the selections are incorrect you can Cancel the export and re-select the correct data/bank account.
Once exported, you can click the Export History option to view the status of the export. The data can take 1 to 2 minutes to complete. Once completed, a red icon will appear on the Export History button to indicate an update and the history will show that the transactions are ready for review in Sage.
When viewing the extracted data, the very same process as above of selecting the account, exporting to Sage and selecting the dates, is followed. The options are located at the top of the extraction.
How does this look in Sage?
The exported transactions are shown on the Bank Account tile. The number of transactions does not update until you click on them.
Clicking on the Transactions link opens the incoming bank transactions list where you can then Match, Create or Transfer transactions as normal:
And that's it! Your statement data has now been exported to Sage Accounting.
Jan 24, 2023, 9:27 AM