|
The Create EFT File button and EFT format radio buttons are enabled only if you've reviewed the Transmission Detail Report.
If there are errors or omissions in the batch, click the Erase Batch task button and make your corrections. No client information is altered or deleted.
If all is correct, click the Create EFT File task button. The Scheduler does the following:
1.creates the bank specific EFT file in the format selected. 2.creates a history record of each transaction in the EFT file for this file creation number. 3.increments the file creation number for each folder selected. 4.creates a companion Excel CSV (Comma Separated Value) file. See specifics below. |
The last step in the EFT file preparation is to optionally prepare and send EFT Notifications to your clients.
Important Note: User knowledge of navigating Windows file folders is required to locate the EFT transmit file created. RB Anderson Ltd. cannot provide any Windows training. Use the information in the section below as a guideline.
The Scheduler creates an Excel CSV (Comma Separated Value) file in the EFT folder location indicated on the "Transmission Detail Report". The file name is EXP-{eft file name}.CSV where {eft file name} is printed on the report.
Sample:
"ID","LAST NAME","FIRST NAME","AMT","COMMENTS"
"A02375","Arsenault","Carl",43.05,"Painting"
"A03940","Ahuja","Andrew",52.50,"Last Payment"
"A04851","Aylesworth","Marcus",60.90,"Special"
Contact Us if you require additional information in the file. We can write a "custom export" routine to match your specifications.
Windows navigation sample
|
The Transmission Detail Report indicates the following:
1.File location: C:\Users\Robin\Documents\RBA\CIBC\EFT 2.File name: TRANSMIT.TXT
Now ... Open "My Computer" or a Windows Dialog screen and with your Transmission Detail Report follow the sample report... |
|
The dialog shows the "Documents" folder which is a nice Windows provided shortcut to C:\Users\Robin\Documents |
|
Documents show the folders there ... now navigate ... C:\Users\Robin\Documents\RBA |
|
C:\Users\Robin\Documents\RBA\CIBC |
|
C:\Users\Robin\Documents\RBA\CIBC\EFT |
|
... and there is your TRANSMIT.TXT file to upload to the bank. |
