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.

tip

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

• John has one account
• Olivia has two accounts

info

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. ⚠️ Where commission is passed on to the customer, this balance should not include the commission that InDebted will collect in addition to the referred amount.
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

For Customers|Clients in the United States, the following fields are required to enable the delivery of a Notice of Assignment.

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

To support an accurate calculation of Statute of Limitations date as well as to enable the delivery of a Notice of Assignment, you must provide Originating Creditor and Current Creditor information. You only need to provide one of MerchantName or Affinity.

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 *	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.