Difference between revisions of "How to connect ExcelReportLink to multiple data files"
Jump to navigation
Jump to search
(Created page with "== Overview == ExcelReportLink can report on and even consolidate multiple data files together. == How to connect ExcelReportLink to multiple data files == To setup ExcelR...") |
|||
Line 13: | Line 13: | ||
# Click on the '''Manage Data Files''' button; | # Click on the '''Manage Data Files''' button; | ||
# When prompted to take a backup, choose yes and follow the prompts relating to the backup process; | # When prompted to take a backup, choose yes and follow the prompts relating to the backup process; | ||
# Click on the '''Add Data File''' button. | # Click on the '''Add Data File''' button and setup your additional data file. | ||
=== Notes === | === Notes === |
Revision as of 18:57, 21 January 2015
Overview
ExcelReportLink can report on and even consolidate multiple data files together.
How to connect ExcelReportLink to multiple data files
To setup ExcelReportLink to report on multiple data files, follow these steps.
- Start ExcelReportLink;
- When prompted to run a Get Data, click Cancel;
- From the main menu, click on 30. Settings and choose Data Files;
- Click on the Manage Data Files button;
- When prompted to take a backup, choose yes and follow the prompts relating to the backup process;
- Click on the Add Data File button and setup your additional data file.
Notes
The steps involved to setup a specific data file depends on your accounting package. Refer to the following articles.
- Connecting ExcelReportLink to MYOB AccountRight 19.10 or Lower
- Connecting ExcelReportLink to MYOB AccountRight Live 2013 or Higher
- Connecting ExcelReportLink to QuickBooks
- Connecting ExcelReportLink to Xero