Update ACH Schedules

To Update ACH Schedules via Batch Upload, populate the sheet UpdateACHSchedule using the columns described below.

Property Summary Format Required Example
ProfileNumber Identifier for profile to be updated Numeric (10 digits) Yes 1234567890
Listing Name Customer's name as it should appear on schedule Alpha (0-255 chars) Yes John and Mary Doe
Frequency How often customer should be billed...
One Time Only = 0
Weekly = 52
Semi Weekly = 26
Bi Monthly = 24
Monthly = 12
Quarterly = 4
Bi Annually = 2
Annually = 1
Numeric (2 digits) Yes 12
StartDateTime Starting date of the schedule MM/DD/YYYY Yes 1/1/2010
EndingDateTime Date schedule should end MM/DD/YYYY No 12/31/2010
Amount Total amount of transaction 0.00 Yes 9.65
Currency Standard currency code Alpha (3 digits) Yes USD
Check.RoutingNumber The valid routing number of the customer's bank Alpha Numeric (9 digits) Yes 123456789
Check.AccountNumber The customer's valid bank account number Alpha Numeric (4-15 digits) Yes The customer's checking, business checking or savings bank account number
Check.NameOnAccount The name associated with the bank account Alpha Numeric (2-99 chars) Yes John Doe and Associates
Check.Address.Street Street number and name Alpha Numeric (0-99 chars) Yes 400 E. Royal Lane #201
Check.Address.City City of address Alpha (0-99 chars) Yes Irving
Check.Address.State State code of address Alpha (2 chars) Yes TX
Check.Address.Zip Postal code of address Numeric (0-10 digits) Yes 75039-2291
Check.Address.Country Standard Country Code of address Alpha (2 chars) Yes US
Check.Phone_1.Number Customer phone number Numeric (0-13 digits) No (214)555-1212
Check.Phone_1.Type Label for phone number Alpha Numeric (0-9 chars) No Home
Check.Phone_2.Number Customer phone number Numeric (0-13 digits) No (214)555-1213
Check.Phone_2.Type Label for phone number Alpha Numeric (0-9 chars) No Work
Check.Identification.IDType Type of ID being entered:
Drivers License = 1
State Non Driver = 2
Military = 3
Other = 4
Numeric (1 digit) Yes 1
Check.Identification.State State code of issueing state Alpha (2 chars) No TX
Check.Identification.Number Number or identifier of ID Alpha Numeric (2-15 digit) Yes 12345678
Check.Identification.Expiration Date of ID expires MM/DD/YYYY No 12/12/2009
Check.Identification.DOB Date of Birth on ID MM/DD/YYYY No 12/12/1965
Check.Identification.Address.Street Street number and name Alpha Numeric (0-99 chars) Yes 400 E. Royal Lane #201
Check.Identification.Address.City City of address Alpha (0-99 chars) Yes Irving
Check.Identification.Address.State State code of address Alpha (2 chars) Yes TX
Check.Identification.Address.Country Standard Country Code of address Alpha (2 chars) Yes US
CustomFields.Field_1 Optional custom field      
CustomFields.Field_2 Optional custom field      
CustomFields.Field_3 Optional custom field      
CustomFields.Field_4 Optional custom field      
CustomFields.Field_5 Optional custom field      
CustomFields.Field_6 Optional custom field      
CustomFields.Field_7 Optional custom field      
CustomFields.Field_8 Optional custom field      
CustomFields.Field_9 Optional custom field      
CustomFields.Field_10 Optional custom field      
CustomFields.Field_11 Optional custom field      
CustomFields.Field_12 Optional custom field      
CustomFields.Field_13 Optional custom field      
CustomFields.Field_14 Optional custom field      
CustomFields.Field_15 Optional custom field      
CustomFields.Field_16 Optional custom field      
CustomFields.Field_17 Optional custom field      
CustomFields.Field_18 Optional custom field      
CustomFields.Field_19 Optional custom field      
CustomFields.Field_20 Optional custom field      
CustomFields.Field_21 Optional custom field      
CustomFields.Field_22 Optional custom field      
CustomFields.Field_23 Optional custom field      
CustomFields.Field_24 Optional custom field      
CustomFields.Field_25 Optional custom field      
CustomFields.Field_26 Optional custom field      
CustomFields.Field_27 Optional custom field      
CustomFields.Field_28 Optional custom field      
CustomFields.Field_29 Optional custom field      
CustomFields.Field_30 Optional custom field