Billing Info Export

This export identifies the billing information and method of payment associated with a given account.

Version Change Log

Version 5 - 12/3/20:

  • Added new primary_payment_method column, which will display TRUE or FALSE based on if the billing info is the primary payment method
  • Added new backup_payment_method column, which will display TRUE or FALSE based on if the billing info is the backup payment method
  • Added new billing_info_id will display the ID of the billing info

Version 4 - 5/23/2019

  • Column changes: Added 'cc_first_6' column to the end of the export

Version 3 - 4/25/2019

  • Column additions: "cc_first_6"

Version 2 - 5/24/2018

  • Column name changes to clarify between billing information and account information ("billing_" precedes "first_name", "last_name", all address fields, "phone", and "vat_number"; "account_" precedes "email" field; "cc_" precedes "last_four" field; and "expire_" precedes credit card expiration "month" and "year" fields)
  • Column additions: "ip_address" and "ip_address_country"

Account Status Filter

Open

Accounts that are not closed.

Non-subscribers

Open accounts with no active subscriptions.

Active Subscribers

Open accounts with at least one active subscription.
(Active is any subscription that is not expired).

In Trial

Accounts with at least one subscription in trial mode.

Past Due

Account with an invoice in the past-due state.

Non-Renewing

Accounts with subscriptions that won't renew after the current billing cycle (i.e. recently-canceled).

Future

Accounts with a subscription that hasn't yet started.

Time Range Filter

This export displays data for accounts where billing information was added during the selected timeframe. Uses the "created_at" field from this export. This exports data for accounts where billing information was added during the selected date range.

Export Contents

Column Name

Example

Description

account_code

123456789, [email protected]

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.

billing_first_name

JJ

Customer's first name, as supplied with their billing information.

billing_last_name

Smith

Customer's last name, as supplied with their billing information.

company

Bluth Industries, Inc.

Identifies the company name provided with customer billing information.

billing_address1

123 Main Street

Customer billing address information.

billing_address2

Suite 300

Customer billing address information.

billing_city

San Francisco

Customer billing address information.

billing_state

CA

Customer billing address information.

billing_postal_code

94107

Customer billing address information.

billing_country

US

Customer billing address information.

billing_phone

555-2368

Customer billing phone contact.

account _email

[email protected]

Customer contact info.

cc_type

visa/master/discover/
jcb/amex/diners

Identifies card type stored on customer's account.

cc_last_four

1111

Last four digits of the credit card number stored on customer's account.

expire_month

4

Expiration date of the credit card stored on customer's account.

expire_year

2014

Expiration year of the credit card stored on customer's account.

billing_ vat_number

IE213123123

(for EU companies), VAT number provider by customer.

created_at

2011-08-15

Date customer's billing information was added to the account. Used for date range filter.

updated_at

2013-09-12

Date customer's billing information was last updated on the account

Payment_method

CreditCard / PayPal/
Roku/ Amazon / Bank Account / paypal_braintree, jcb,
qiwiwallet, etc.

Identifies by which method the customer is paying

maintenance_url

app.recurly.com/account/sdasdasd

Link to the customer's hosted account maintenance URL.

ip_address

99.89.1010.0101

the ip address captured at the time billing information was entered

ip_address_count

United States

the country associated with the ip addressed captured at the time billing information was entered

cc_first_6

111111

First six numbers of the credit card used to process the transaction.

backup_payment_method

true, false

Identifies if the billing_info should be used as a backup when the initial billing_info used fails for an invoice.