The Export Tools screen allows users to export data from the General Ledger (Elements and Journals) as well as from Accounts Payable (Vendors and Bank Reconciliation data) for synchronization or audits.
1. From the Setup menu, click Export Tools.
2. The Export Tools screen defaults to the General Ledger tab.
3. Click Elements to export elements.
4. From the Elements Selection tab, enter the applicable date range in the From and To text boxes.
5. Enter the applicable time frame in the From and To text boxes.
6. Select the Format in which you want to the data exported. Options include Text File (Fixed Format), Pipe-Separated Values, or HTML Preview.
7. Select the Document Purpose to identify your need for the exported data. Options include Standard Sync or Audit.
8. Click EXPORT.
1. From the Setup menu, click Export Tools.
2. The Export Tools screen defaults to the General Ledger tab.
3. Click Journals to export journals.
4. From the Journals Selection tab, enter the applicable date range in the From and To text boxes.
5. Enter the applicable time frame in the From and To text boxes.
6. Select how you want the selected date range applied to journals using the Filter By radio button. Options include Transaction Date or Journal Date.
7. Select the Document Purpose to identify your need for the exported data. Options include Standard Sync or Audit.
8. To export a specific Journal Source, select the source from the provided pull-down. The pull-down defaults to All.
9. To export a specific Journal Type, select the type from the provided pull-down.
10. Select the Format in which you want to the data exported. Options include Text File (Fixed Format), Pipe-Separated Values, or HTML Preview.
11. Click EXPORT.
1. From the Setup menu, click Export Tools.
2. Click the Accounts Payable tab.
3. To export vendors, click Vendors.
4. From the Vendor Selection tab, enter the applicable date range in the From and To text boxes.
5. Enter the applicable time frame in the From and To text boxes.
6. Select the Format in which you want to the data exported. Options include Text File (Fixed Format), Pipe-Separated Values, or HTML Preview.
7. Select the Document Purpose to identify your need for the exported data. Options include Standard Sync or Audit.
8. Click EXPORT.
1. From the Setup menu, click Export Tools.
2. Click the Accounts Payable tab.
3. To export bank reconciliations, click Bank Reconciliation.
4. From the Bank Reconciliation Selection tab, enter the applicable date range in the From and To text boxes.
5. Enter the applicable time frame in the From and To text boxes.
6. To pull bank reconciliations for a specific bank, select the Bank from the pull-down. The Bank pull-down defaults to All banks.
7. Select the Format in which you want to the data exported. Options include Text File (Fixed Format) or HTML Preview.
8. Click EXPORT.
