Accounts Receivable Export

The Accounts Receivable export identifies customers who have not paid their invoices, as well as the aging of all outstanding receivables.

Invoice Status Filter

All

All invoices which are not yet paid.

Pending

Invoices which are not yet due. This will be restricted to manual invoices.

Past Due

Invoices which have not been paid and are past due.

Failed

Invoices which have been marked as failed or not been collected during the Dunning period.

Processing

ACH transactions in processing state.

Date Range Filters

Created

This export will display invoices that were created during selected time range

Modified

This export will display invoices that were modified during selected time range

Column Name	Example	Description
invoice_id	336e028b12345b00b60b7845438d18b1	Invoice ID is a unique identifier for invoices within Recurly. This This id is also used in Invoices -Summary and Adjustments exports.
invoice_number	1001	This number is used on the invoice through the admin console.
account_code	smith	Account_code uniquely identifies your customers inside of Recurly. This field defaults to email address, if no specific value is provided. Account_code cannot be modified. This is the main Recurly identifier, and can be used to join multiple exports.
account_first_name	Eric	Customer first name from the account associated with the invoice.
account_last_name	Schmidt	Customer last name from the account associated with the invoice.
account_company	Bluth Industries, Inc.	Optional, this field identifies the company name provided.
account_email	[email protected]	Optional, Email address provided by the customer during signup. This email address is used for all customer communication. If no email address is provided, the customer will not be emailed, and any emails will be sent to your site's billing contact instead.
account_phone	123-456-7890	Optional, customer phone number.
billed_date	2016-01-01 10:17:02 UTC	The date on which the invoice was created.
net_terms	on-receipt	The terms of the invoice.
due_on	2016-01-01 10:17:02 UTC	The date on which an invoice is due.
status	failed	Current status of the invoice. Equivalent to invoice_state in the Adjustments export.
collection_method	automatic	The method of collection for the invoice. This will be populated with "automatic" or "manual."
days_overdue	12	A whole number of days that the invoice is overdue. If the invoice is not overdue, this field will be zero.
currency	USD	3-character ISO code for the currency on the invoice.
po_number	1234	The PO number from the invoice.
closed_date	2016-05-18 11:17:07 UTC	If applicable, the date the invoice was closed. (failed or paid)
modified_at	2016-05-18 11:17:07 UTC	The date the invoice was last modified (includes updating payment status).
invoice_subtotal	136.78	The subtotal amount of the invoice. When the tax, discount, and credits are added, this will be the total amount.
invoice_total	345.67	The total amount of the invoice
invoice_tax_amount	123.45	The total tax amount from the invoice.
invoice_discount_amount	144.58	The total discount amount from the invoice.
category	31-60 days overdue	A bucketed system to measure the aging of receivables and past due invoices. Invoices which are not yet due will be marked current, and the past due invoices will be grouped by how long they are overdue.
invoice_credits	144.58	The amount of credits on a given invoice.
invoice_balance	50.25	The balance of the invoice. This column will be null until Recurly's Credit Invoices feature is enabled on your Recurly site.
invoice_balance_modified_at	2016-05-18 11:17:07 UTC	The datetime the invoice_balance last changed due to a transaction or credit payment. This column will be null until Recurly's Credit Invoices feature is enabled on your Recurly site.