Account Upload

Uploading Accounts

You can create new customers and accounts, and you can update existing customers and accounts via Account Upload. We strongly advise you to aggregate multiple accounts by customer. This provides your customers with concise communications and consolidated payment options drastically improving your collections performance.

This document is updated to require additional fields to be completed to support accurate calculation of Statute of Limitations date, as well as for complete Notice of Assignment details.

To get started, download a sample file with the following customers.

• John has one account
• Olivia has two accounts

Filename convention: YYYY-MM-DD-hh-mm-ss.csv

Header	Format	Description
AccountRef *	String, unique constraint	Unique value representing the account in your system. Use the same reference for updating existing accounts.
StatementOfWorkID *	String	The Statement of Work to assign this account to. Once assigned, this value cannot be changed.
DueDate *	String date formatted as YYYY-MM-DD	Date when the account was due for payment. This is used for allocating payments to the account with the oldest due date.
ChargeOffDate	String date formatted as YYYY-MM-DD	Date when the account was charged off
DateOfLastPaymentReceived ⚠️	String date formatted as YYYY-MM-DD	Date when the last payment received from customer was processed. Can be blank if not applied. ⚠️ This date must be before referral time
OutOfStatuteDate	String date formatted as YYYY-MM-DD	Date when the statute of limitations expires.
DelinquencyDate	String date formatted as YYYY-MM-DD	Date when the account first became delinquent. This value cannot be changed.
Balance ⚠️	Integer representing a monetary value in cents, e.g. 100 means $1.00	The amount to collect for this account. ⚠️ This value must be greater than zero when creating new accounts and it will be ignored when updating existing accounts. For updating this value, see Transaction Upload.
CustomerRef *	String, unique constraint, cannot contain any PII	Unique value representing the customer in your system. Use the same reference for updating existing customers.
Title	Constant, e.g. Mx	Customer's title. See all Customer Titles below. Invalid values will be ignored so the customer and account are still created successfully, provided all other validations succeed.
FirstName *	String	When the customer has a last name, their last name is required for regulatory compliance.
MiddleName	String	When the customer has a last name, their last name is required for regulatory compliance.
LastName	String	When the customer has a last name, their last name is required for regulatory compliance.
DOB SOON will be Required	String data formatted as YYYY-MM-DD
Emails	String delimited by semicolon, e.g. joe@abc.com; joe@def.com	For regulatory compliance, at least two of the following must be provided: date of birth, email, phone, address. Further, invalid values will be ignored so the customer and account are still created successfully, provided all other validations succeed.
Phones	String delimited by semicolon, including country code, e.g. +61444555666; +61999888777	For regulatory compliance, at least two of the following must be provided: date of birth, email, phone, address. Further, invalid values will be ignored so the customer and account are still created successfully, provided all other validations succeed.
AddressLine1	String, required when any address field is provided	For regulatory compliance, at least two of the following must be provided: date of birth, email, phone, address. Further, invalid values will be ignored so the customer and account are still created successfully, provided all other validations succeed.
AddressLine2	String, optional	For regulatory compliance, at least two of the following must be provided: date of birth, email, phone, address. Further, invalid values will be ignored so the customer and account are still created successfully, provided all other validations succeed.
City	String, required when any address field is provided	For regulatory compliance, at least two of the following must be provided: date of birth, email, phone, address. Further, invalid values will be ignored so the customer and account are still created successfully, provided all other validations succeed.
State	String, required when any address field is provided, except for the United Kingdom and New Zealand	For regulatory compliance, at least two of the following must be provided: date of birth, email, phone, address. Further, invalid values will be ignored so the customer and account are still created successfully, provided all other validations succeed.
Postcode	String, required when any address field is provided	For regulatory compliance, at least two of the following must be provided: date of birth, email, phone, address. Further, invalid values will be ignored so the customer and account are still created successfully, provided all other validations succeed.
Country	String, required when any address field is provided	For regulatory compliance, at least two of the following must be provided: date of birth, email, phone, address. Further, invalid values will be ignored so the customer and account are still created successfully, provided all other validations succeed.

Balance Breakdown

If you charge interest or fees, we recommend you to provide your customers with the following breakdown which helps avoiding disputes. The total amount should add up to the account Balance.

Download a sample file with Balance Breakdown.

Header	Format	Description
BalancePrincipal	Integer representing a monetary value in cents, e.g. 100 means $1.00	The principal amount owed as of referral time. This value cannot be changed.
BalanceInterest	Integer representing a monetary value in cents, e.g. 100 means $1.00	The amount accrued in interest as of referral time. This value cannot be changed.
BalanceFees	Integer representing a monetary value in cents, e.g. 100 means $1.00	The amount accrued in fees as of referral time. This value cannot be changed.

Itemization

If you operate in a jurisdiction that requires a Notification of Assignment to be sent, the following fields are mandatory:

Header	Format	Description
ItemizationDate	String date formatted as YYYY-MM-DD	The date on which the account was itemized. This value cannot be changed.
ItemizationDateBalance	Integer representing a monetary value in cents, e.g. 100 means $1.00	The balance of the account as of the itemization date. This value cannot be changed.
ItemizationDateType	String	The type/description of the date on which the account was itemized. This can be one of the following values: charge_off_date: the date the debt was charged off, last_payment_date: the last date a payment was applied to the debt last_statement_date: the date of the last periodic statement or written account statement, or invoice provided to the consumer by a creditor , transaction_date: the date of the transaction that gave rise to the debt. It is the date that the good or service that gave rise to the debt was provided or made available to the consumer judgment_date: the date of a final court judgment that determines the amount of the debt owed by the consumer. This value cannot be changed.
ItemizationDateAccountNumber	String	Account Number at Itemization Date - The account number associated with the debt on the Itemization Date, or a truncated version of that number.
FeesSinceItemization	Integer representing a monetary value in cents, e.g. 100 means $1.00	The amount accrued in fees between the itemization date and time of referral. This value cannot be changed.
InterestSinceItemization	Integer representing a monetary value in cents, e.g. 100 means $1.00	The amount accrued in interest between the itemization date and time of referral. This value cannot be changed.
PaymentsAndCreditsSinceItemization	Integer representing a monetary value in cents, e.g. 100 means $1.00	The amount accrued in payments and credits between the itemization date and time of referral. This value cannot be changed.

Product Information

This information may be used for different use cases like BNPL Merchants, Credit Card and Loan Labels. This helps your customers remember their purchase or agreement which in turn improves your collections performance.

Download a sample file with Product Information.

Header	Format	Description
ProductVendor	String	The name of the business or entity where the purchase was made and accepts the payment. It's the name under which the transaction is processed and appears on the credit card statement of the cardholder. For example, if you make a purchase at a store called "ABC Mart," "ABC Mart" would be the merchant name that appears on your credit card statement for that transaction
ProductName	String	Name of the product or service such as the good purchased with BNPL.
ProductAmount	Integer representing a monetary value in cents, e.g. 100 means $1.00	The purchase or service amount agreed upon.
ProductAgreementDate	String date formatted as YYYY-MM-DD	Date when the purchase or service agreement has taken place.

Client Display Name

If your company operates under multiple brands or branches and each customer is familiar with a different name, you can customise the name to be displayed for each customer which helps setting up the context for collections.

Download a sample file with Client Display Name.

Header	Format	Description
ClientDisplayName	String	Your brand or branch name to be used in all communications as a replacement for your company name, specifically for this customer.

Creditor And Merchant Information

You now must provide Orginating Creditor and Current Creditor information to support accurate calculation of Statute of Limitations date, as well as for complete Notice of Assignment details.

Download a sample file with Originating Creditor.

Header	Format	Description
OriginatingCreditorLegalName *	String	The entity that made or underwrote the loan.
OriginatingCreditorAccountRef *	String	Unique value representing the account within the scope of the Originating creditor.
ItemizationDateCreditor *	String	The name of the creditor to whom the debt was owed on the Itemization Date.
CurrentCreditorLegalName SOON will be Required	String	The name of the entity to whom the debt is currently owed.
MerchantName ⚠️	String	Name of a business or entity that is co-branded with the issuer of the credit line. For example, where a credit card issued by ABC Bank is co-branded, with XYZ Store, "XYZ Store" is the merchant name. ⚠️ You must only provide one of MerchantName or Affinity.
Affinity ⚠️	String	Name of a business or entity that is affiliated with the issuer of the credit line. For example, where a consumer’s credit card issued by ABC Bank includes a logo for the College of Columbia, "College of Columbia" is the affinity name. ⚠️ You must only provide one of MerchantName or Affinity.

Customer Titles

Title
Dr
Madam
Master
Miss
Mr
Mrs
Ms
Mx

Preferred Language

This is a feature designed to provide language preferences for users within the United States. The PreferredLanguage field allows users to specify their preferred language for communication within the United States.

This feature supports two languages: English US and Spanish US.

Supported Countries The preferred language feature is available only for clients within the United States.

Language Options This feature supports two languages:

• English US must be indicated as en-US
• Spanish US must be indicated as es-US

Account Creation The PreferredLanguage field can be set during the initial account upload process. You can indicate a customer's preferred language by providing one of the following values:

Header	Format	Description
PreferredLanguage	String	The PreferredLanguage is an optional field, if not provided during account creation the default language will be set to English US.

Scenario-Based Behaviours

• Accounts uploaded without specifying the PreferredLanguage attribute will default to English (United States).
• If the PreferredLanguage attribute is included but left empty, the system will default to English (United States).
• Specifying en-US as the PreferredLanguage sets the language to English (United States).
• Specifying es-US as the PreferredLanguage sets the language to Spanish (United States).
• If a value like en-CA is provided, an error will be flagged during the upload with the message: locale is not supported: invalid-language.
• After account upload is complete, the PreferredLanguage attribute cannot be updated.