Dataset - Manage Sources - Excel Connection

After selecting Add New Source from either method described in the Datasets - Manage 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 dropdown menu, otherwise select none. The name of the accounting file should represent the specific client and source. In most instances, the client name is sufficient. After completing the form select Add Source.

Account Numbering systems supported by way of import from Excel are: 

  • MYOB
  • Xero
  • Handi Ledger
  • APS
  • MAS
  • Attache

Import data From Excel

After adding the source to the Active Ledger file the information is imported using the import facility in the Excel add-in. See the knowledge article: Excel Data Import to learn how to use the importer.

Note: You need to create an Excel dataset before importing your data from Excel.

Return to: Datasets - Manage Sources

Did you find it helpful? Yes No

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