Recurring - CSV Format Specifications

Created by Richard Moore, Modified on Wed, 19 Apr, 2023 at 10:14 AM by Richard Moore

CSV files uploaded to Recurring must conform to a specific format. Specifications of this format are outlined below.


Field IndexField NameField Format
1Reference_No20 characters maximum
2Customer_Ref20 characters maximum
3Reference_3*30 characters maximum
*Not supported in QuickKey batch
4Cardholdername*30 characters maximum
*Not supported in QuickKey batch (will display as "RT Batch")
5Transactioncodeapplicable transaction code
6Cardnumber16 digit card number
7Amount0.00 format
8Expiry DateMMYY (no slash)
9Authorization Number6 digit maximum
10Not used, but delimiter requiredN/A
11Recurring Indicatorenter "R" for true (no quotes), otherwise false
12Not used, but delimiter requiredN/A
13Not used, but delimiter requiredN/A
14Not used, but delimiter requiredN/A


 

Sample data:


ref_no-1,cust_ref_a,ref_3_a,John Doe,00,4111111111111111,19.95,0312,,,,,,
ref_no-2,cust_ref_b,ref_3_b,Jane Doe,04,5500000000000004,19.95,0511,987654,,,,,

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article