Print EFT Edit Report

Use this screen to print a report that contains any ACH file created via the Create EFT File screen.

The report includes the following information:

  • Vendor's ID, name, bank, and bank account
  • Total credit amount to the vendor's bank account
  • Vendor’s voucher number, invoice number, invoice date, invoice amount, discount taken, and amount paid
  • Vendor's ACH code
  • Debit record, if one exists
  • Total of all credits to all vendors

Information for both live and prenote EFT vendors also prints in this report.

Print this report after creating an ACH file on the Create EFT File screen but before transmitting the file to your bank. If you need to make changes to vendor bank information, do so via the Manage Vendor screen and then recreate the file. Costpoint automatically overwrites the old file with the new file, providing you use the same file name and path. Posted vouchers are not updated with changes to the vendor ID. If you change the vendor ID on the Manage Vendors screen, Costpoint will not be able to find vouchers for the new vendor ID when recreating the ACH file, and the vendor will not be paid the correct amount. Do not change the vendor ID before paying posted vouchers.

Note: When you select the 820 Transaction Set option in the EDI group box on the Create EFT File screen, the file submitted to the bank will have a different layout than the file created when one of the ACH group box options is selected. The main reason for this is the different structures in which the bank will accept submission of the file. When this scenario takes place, the following fields do not display on the EFT Edit Report:  Pay Vendor, TR CD, and Debit Amount.

See Electronic Funds Transfer (EFT) for related information.