With Stripe, you can manually export and import them into Cello. This feature is especially handy when you need to conduct some tests before enabling full automation.

​
Generating a Stripe Customer Export

After you’ve enriched the Stripe Customer with the right metadata, you’re ready to export it as a .csv file. To do so: Stripe Customers Overview page
  1. Navigate to Customers > Overview, and then click Export.
  2. Specify the details for the export:
    • Date range: If you’re submitting reports weekly or even more frequently, you can always opt for Last 7 days. Cello is designed to avoid importing duplicates.
    • Columns: You only need to include ID and Created (UTC). If cello_ucc has been added to the Customer metadata, it will always be added as a column in the exported file.
Stripe customer export configuration The exported .csv file for a Stripe Customer Export might look like this: Example Stripe customer export CSV

​
Generating a Stripe Payment Export

Stripe allows you to export payments as a .csv file. To do so: Stripe Payments All Payments page
  1. Go to Payments > All Payments, choose Successful, and then click Export.
  2. Specify the details for the export:
    1. Date range: Just as with the customer export, you can opt for Last 7 days if you’re submitting reports frequently. Cello will prevent duplicate imports.
      1. Columns: The data we suggest including in the report are: ID, Description, Created (UTC), Amount, Currency, Converted Amount, Fee, Tax, Converted Currency, Customer ID.
Stripe payment export configuration