This export identifies the billing information and method of payment associated with a given account.
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.
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
Uses the "created_at" field from this export. This exports data for accounts where billing information was added during the selected time range.
Export Contents
| Column Name | Example | Description |
| account_code | 123456789, janedoe@gmail.com | 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 | 91191 | Customer billing address information. |
| billing_country | USA | Customer billing address information. |
| billing_phone | 555-2368 | Customer billing phone contact. |
| account _email | test@example.com | 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 | 2020 | 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 |
Comments
0 comments
Please sign in to leave a comment.