Reports to Export EFT details

In this topic, Orchid describes how to use a custom report to export the EFT Details and import csv files into another database.

This applies to EFT Vendors/Suppliers and EFT Customers.

There are two main options to import EFT details: 

  1. Use custom reports, described below.

    Note:

    The Custom Reports option has two main advantages: 

    • All the EFT fields are included in the report (and therefore in the export), you don't need to add them one by one.

    • The report includes the EFT File format name, required to import. The custom view only includes the EFT File ID.

  2. Create custom views in Accounts Payable > Vendors/Suppliers or in Accounts Receivable > Customers menu

Key Steps to import the package

Step 1: Saved the attached file to the local folder and unzip the XML file.

File to download: Custom Reports Package

Step 2: Go to Customization Services (or Platform Services) > All > Customization tools > Custom packages

Step 3: Select Add / New package

Step 4: In the Customization package location, select Choose File, find the Orchid EFT Fields Report Package.xml XML file and select Import.

Step 5: The file appears in the Packages page.

Step 6: The custom reports are now available in Platform Services > Custom Reports.

Note: You can also access the Orchid EFT Vendor report in Accounts Payable > Custom Reports and the Orchid EFT Customer report in Accounts Receivable > Custom Reports.

 

Using the custom reports - Vendor/Supplier example

Tip:

Because the fields depend on the EFT format you use, it is best to enter one record manually for your bank's file type, export the records. You can then update the csv file and import back on Sage Intacct.

Step 1: Run the report, select Export and choose CSV. This is the only file format to import into Sage Intacct.

Tip: You can amend the report to add filters or prompt for parameters at runtime (e.g. by Vendor currency or Vendor type).

Step 2: Choose Download the file. The file is saved to the download folder.

Step 3: Open the file and update accordingly.

When the file is updated, save the file as CSV type.

Importing Details

Step 1: In Accounts Payable > Vendors, Click on Import button, Choose the File, select the import file and click on Import.

Step 2: As per Sage Intacct functionality, the status of the import is displayed on the screen and an email is sent to the nominated email address.

Tips and Troubleshooting

Refer to Tips when Importing EFT details