Skip to main content
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