Importing EFT transactions

<< Click to Display Table of Contents >>

Navigation:  Quick Start Tutorial > Create the EFT File  >

Importing EFT transactions

The Scheduler searches the EFT Folder(s) selected for importing transactions. Be sure you've placed your import files as per the Import file location instructions.

There are 3 option methods to create an EFT batch from import file(s).

Scheduler Import:

The Scheduler will read file(s) that follow the app Import Specifications.

ACH Import:

Many US accounting systems produce ACH 94 (American Clearing House) EFT files. The Scheduler will extract all the important bits to create your bank specific EFT file.

Custom Import:

If R.B. Anderson Ltd. has written a plug-in for The Scheduler to read your text file(s). This option will be automatically selected.

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

2.Select the following from the list boxes:


From the 3 options above.

Transaction Set Due Date:

The Scheduler will read the Due Date in the import files. If there is none, or the format is wrong, the Set Date entered will be used.

Set Date:

Enter the default Due Date to process the transactions,

Scheduler Import

The screen shot here indicates the following:


1.Prepare an EFT batch for the Import Transaction Folder.

2.Import the transactions using The Scheduler Import Specifications.

3.Set Date. If there is no dates in the import file, The Scheduler will use this date as the Due Date for the transactions.

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 - Import 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 import file; and repeat this process.
Prepare - Import 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 file 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\TRANSMIT.TXT in the image above).


The Scheduler now guides you to the next step in the EFT preparation process: Generating EFT notifications.