If you are looking for the Reportance Desktop help, please click here.

Dataset - Manage Sources - Excel Connection

After selecting add New Source from either method described in the Datasets Managing Sources knowledge article, a new source screen will be displayed, select 'Excel' from this list of available connections.

After selecting Excel the following form will appear. If your report has been exported from an accounting system which we directly support select it from the drop-down list, otherwise select none. The name of the accounting file should represent the specific client and source. In most instances, the client name is relevant. 
After completing the form select Add Source.


Account Numbering systems supported by way of import from excel: 

System
MYOB
Xero
Handi Ledger
APS
MAS
Attache



Import Data From Excel

After adding the Source to the reportance file the information is imported using the import facility in the Excel add-in. 

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.