Creating recurring payment EFT files

<< Click to Display Table of Contents >>

Navigation:  Quick Start Tutorial > Create the EFT File  >

Creating recurring payment EFT files

To create an EFT batch for recurring payments

1.Check the EFT Folder(s) to be included in this EFT batch

2.Select the following from the list boxes:


From Scheduler Data.

Transaction Due Date:

Select by Due Date on File.

From Date:

Enter the left goal post to determine if a transaction should be selected.

To Date:

The right goal post.

Prepare - Recurring

The screen shot here indicates the following:


1.Prepare an EFT batch for the Membership Dues Folder.

2.Select the transactions From Scheduler Data. The Scheduler will examine all the transactions in the Folder(s) selected.

3.Select by Due Date on File. Determine if a transaction will be included in the EFT batch based on the Start Date and End Date entered in the Client Information panel.

4.The Scheduler will test that a recurring EFT transaction falls within the From Date and To Date.


When all your parameters are set... click the Prepare Batch task button.


The Scheduler will whir and grind away and give the results of what it's gathered and show the results as below.

Prepare - Ready


3.Click the Preview Report task button to see the selected transactions for the EFT batch to first display the results and optionally print the transaction list collected. The Create EFT File button will only be enabled after viewing the report..
Important Note: The "Transmission Detail Report" displays all the transactions that will be included in the EFT transmission file. We recommend that this report be printed and kept as your "audit" record for the file.
If there are errors in the report, simply click the Erase Batch button; make the necessary corrections in your Client Information; and repeat this process.
EFT Preview

4.Click the Create EFT File button only if the contents of the "Transmission Detail Report" are correct. You've now committed the results to The Scheduler that you are going to upload this file to your banking platform. The Scheduler does the following:
- creates the bank specific EFT file in the format selected.
- creates a client history record for each transaction in the EFT file.
- increments the File Creation Number for each Folder selected.
- creates an Excel CSV (Comma Separated Value) file in the EFT location folder.
Second Important Note: User knowledge of navigating Windows file folders is required to locate the transmit file created (i.e. C:\Users\Your Name\Documents\RBA\CIBC\EFT\TRANSMIT.TXT in the image above).


The Scheduler now launches the next step in the EFT preparation process: Generating EFT notifications.