Importing Transactions

<< Click to Display Table of Contents >>

Navigation:  Category Buttons > EFT Tasks > EFT Preparation >

Importing Transactions

Use this method if you are using The Scheduler to read CSV (Comma Separated Value) or other text files to prepare your EFT batches. See the Import Specifications and the Import file location section for more information.

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.

Prepare - Import

Alter the drop down selection lists. The Scheduler assists by checking the folder type and your preferences selected when you defined the EFT File Information setup.


In the sample here:

Read a file conforming to The Scheduler Import Specifications ...

... and if there is no Due Date in the import file, set the Due Date to Apr-01-2017.


When all is ready, click the Prepare Batch task button. The Scheduler grinds through each folder selected and:

displays a summary of the task.

changes and opens up the next task button options.


Note: The form below will display if the user clicks the EFT Preparation task button and there is an EFT Tasks category button and an previously prepared batch exists.

Prepare - Import Ready

Erase Batch:

After previewing the batch, you discover there are errors in your client transactions, simply click the Erase Batch task button; make your corrections and repeat the process. No information is altered or deleted from The Scheduler.

EFT File:

If the EFT Filename Format is set to the "Default" on the EFT File Information form, you can modify the entry.

Note: Changes are posted to the configuration file.

Preview Report:

Change the sort and display options as required and click the Preview Report task button.
Note: The Create EFT File task button will only be enabled after you have reviewed your batch contents.

Now... Preview the Batch Results and verify the batch selection contents.