Category Buttons > Help > Import Specifications

The Scheduler can read transaction files in the following formats. The ASCII file information required may be in a "comma delimited" or "sequential" data file. Each row must be terminated with carriage return and line feed characters.

Canadian File

Field	Description	Max Lgth	Format	Example
1.	Bank / Institution	4	Numeric	10
2.	Transit / Branch	5	Numeric	724
3.	Account Number	17	Alphanumeric	01-453939
4.	Amount	13	Numeric	100.00
5.	Cross Reference Number	15	Alphanumeric	A1545
6.	Payee/or's Name	22	Alphanumeric	R. Smith
7. *	Due Date	6	Numeric	200201
8. *	Payee/or's eMail	50	Alphanumeric	rsmith@mymail.com

US File

Field	Description	Max Lgth	Format	Example
1.	Routing Number	9	Alphanumeric	086209876
2.	Account Number	17	Alphanumeric	218954321089723
3.	Amount	13	Numeric	200.00
4.	Cross Reference Number	15	Alphanumeric	8-22A
5.	Payee/or's Name	22	Alphanumeric	N. Jones
6.	Due Date	6	Numeric	200201
7.	Payee/or's eMail	50	Alphanumeric	rjones@mymail.com
8. *	Payee/or's Address	35	Alphanumeric	1234 West 45th Avenue
9. *	Payee/or's City	35	Alphanumeric	New York City
10. *	Payee/or's State	2	Alphanumeric	NY
11. *	Payee/or's ZIP Code	10	Alphanumeric	20134-3285
12. *	ISO Payee/or's Country	2	Alphanumeric	US
13. *	Payee/or's Bank Name	19	Alphanumeric	Bank of America

•Fields 7 and 8 in the Canadian format file (6 and 7 in the US file) are optional. If no Due Date is in the file, the "Set Date" prompt in the "Prepare Task" will be used.

•Date format must be YYMMDD.

•Fields 8 to 13 are mandatory for the US ACH IAT cross border EFT file format.

•Important Note: If the Amount field of the first row has no decimal (i.e 10000), 2 decimal places are implied and subsequent rows are processed following the first row rule (i.e. 250 would become 2.50). Not the results desired!

Save the import file(s) in the appropriate EFT Folder in The Scheduler. Print the System Status Report to identify the location of the folders. For example if the EFT Folder name is "PAYROLL" and the default installation "Start In" folder was implemented, the import file would be copied to C:\RBA\MyBank\PAYROLL. The default import file name is IMPORT.CSV, but may be changed on the EFT File Information tab.

Sequential (SDF) Format Notes:

The numeric information does NOT require leading zeros and ALL information may be positioned anywhere within the field definition layout. The Scheduler will remove commas from the amount field. This accommodates some report writers that format numeric fields with punctuation.

Custom Import File

We've written plug-ins to The Scheduler to read a variety of accounting system files (raw TXT, Excel spread sheets) if users cannot produce The Scheduler import specification file. Contact Us and we'll see what we can do for you.