Arrangement files

Notification of arrangements set up direct with the client.

❗️

Please name your file as: YYYYMMDD-arrangement.csv e.g. 20210811-arrangement.csv

• Arrangements set up direct with the client should be reported to Ophelos to remove the customer from receiving communications.
• Failed or cancelled arrangements should be reported to Ophelos to add the customer back into receiving communications. To report a failed or cancelled arrangement then the row should contain account_number with is_cancelled = True

📘

Download the template here ↓

YYYYMMDD-arrangement.csv

Data format

Header	Required	Data Type	Format/Example	Description (if required)
account_number	Yes	string	abc12345	client account reference number
amount	Yes	decimal	40.12	value of each payment instalment
frequency	Yes	string	Monthly	Frequency of payments. One of: Weekly, Biweekly, Monthly
first_payment_date	Yes	date	YYYY-MM-DD
e.g. 2021-12-31	Date the first payment is due
payment_method	No	string	Card	Payment method used. One of: Card, Direct Debit,
is_cancelled	No	bool	True	Used only when reporting a failed or cancelled arrangement.