Export Tools

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.

Elements Export

1. From the Setup menu, click Export Tools.

Export Tools

2. The Export Tools screen defaults to the General Ledger tab.

Export Tools

3. Click Elements to export elements.

4. From the Elements Selection tab, enter the applicable date range in the From and To text boxes.

Export Tools

5. Enter the applicable time frame in the From and To text boxes.

Export Tools

6. Select the Format in which you want to the data exported. Options include Text File (Fixed Format), Pipe-Separated Values, or HTML Preview.

Export Tools

7. Select the Document Purpose to identify your need for the exported data. Options include Standard Sync or Audit.

8. Click EXPORT.

Export Tools
Journals Export

1. From the Setup menu, click Export Tools.

Export Tools

2. The Export Tools screen defaults to the General Ledger tab.

Export Tools

3. Click Journals to export journals.

Export Tools

4. From the Journals Selection tab, enter the applicable date range in the From and To text boxes.

Export Tools

5. Enter the applicable time frame in the From and To text boxes.

Export Tools

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.

Export Tools

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.

Export Tools

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.

Export Tools
Vendors Export

1. From the Setup menu, click Export Tools.

Export Tools

2. Click the Accounts Payable tab.

Export Tools

3. To export vendors, click Vendors.

Export Tools

4. From the Vendor Selection tab, enter the applicable date range in the From and To text boxes.

Export Tools

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.

Bank Reconciliation Export

1. From the Setup menu, click Export Tools.

Export Tools

2. Click the Accounts Payable tab.

Export Tools

3. To export bank reconciliations, click Bank Reconciliation.

Export Tools

4. From the Bank Reconciliation Selection tab, enter the applicable date range in the From and To text boxes.

Export Tools

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.

Export Tools

7. Select the Format in which you want to the data exported. Options include Text File (Fixed Format) or HTML Preview.

8. Click EXPORT.

Export Tools