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 invoices which are not yet paid.


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.


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


ACH transactions in processing state.

Date Range Filters


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


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

Column NameExampleDescription
invoice_id336e028b12345b00b60b7845438d18b1Invoice ID is a unique identifier for invoices within Recurly. This This id is also used in Invoices -Summary and Adjustments exports.
invoice_number1001This number is used on the invoice through the admin console.
account_codesmithAccount_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_nameEricCustomer first name from the account associated with the invoice.
account_last_nameSchmidtCustomer last name from the account associated with the invoice.
account_companyBluth 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_phone123-456-7890Optional, customer phone number.
billed_date2016-01-01 10:17:02 UTCThe date on which the invoice was created.
net_termson-receiptThe terms of the invoice.
due_on2016-01-01 10:17:02 UTCThe date on which an invoice is due.
statusfailedCurrent status of the invoice. Equivalent to invoice_state in the Adjustments export.
collection_methodautomaticThe method of collection for the invoice. This will be populated with "automatic" or "manual."
days_overdue12A whole number of days that the invoice is overdue. If the invoice is not overdue, this field will be zero.
currencyUSD3-character ISO code for the currency on the invoice.
po_number1234The PO number from the invoice.
closed_date2016-05-18 11:17:07 UTCIf applicable, the date the invoice was closed. (failed or paid)
modified_at2016-05-18 11:17:07 UTCThe date the invoice was last modified (includes updating payment status).
invoice_subtotal136.78The subtotal amount of the invoice. When the tax, discount, and credits are added, this will be the total amount.
invoice_total345.67The total amount of the invoice
invoice_tax_amount123.45The total tax amount from the invoice.
invoice_discount_amount144.58The total discount amount from the invoice.
category31-60 days overdueA 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_credits144.58The amount of credits on a given invoice.
invoice_balance50.25The balance of the invoice.
This column will be null until Recurly's Credit Invoices feature is enabled on your Recurly site.
invoice_balance_modified_at2016-05-18 11:17:07 UTCThe 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.