Creating payroll/AP EFT files

<< Click to Display Table of Contents >>

Navigation:  Quick Start Tutorial > Create the EFT File  >

Creating payroll/AP EFT files

To create an EFT batch for payroll / expense / AP 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 Set Due Date:

Set the Due Date here. If the folder has the Zero Amounts set to "Yes", The Scheduler automatically sets the parameter.

Set Date:

Enter the Due Date to process all the transactions.

Prepare - Payroll

The screen shot here indicates the following:


1.Prepare an EFT batch for the Employee Payroll Folder.

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

3.Set Due Date. The Scheduler will determine if a transaction will be included in the EFT batch based on a non zero ($0.00) Period Amount entered in the Client Information panel.

4.The Scheduler will set the Due Date for all selected transactions to 01-Sep-2016.


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 - Payroll Ready


1.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.
Prepare -Payroll Preview

2.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 of all the transactions 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.