The Reference Docs Developer Hub

Welcome to the Reference Docs developer hub. You'll find comprehensive guides and documentation to help you start working with Reference Docs as quickly as possible, as well as support if you get stuck. Let's jump right in!

Get Started    

Accounts Receivable Export

Accounts Receivable

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.

Open

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.

Time Range Filter

Created

Invoices that were created during selected time range

Modified

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

test@example.com

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.

Accounts Receivable Export


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.