project stripe-xero-csv

rtcamp/stripe-xero-csv

Export Stripe's balance affecting transactions in a CSV file, recognisable by Xero Import CSV Statement feature.

Stripe Xero CSV Export

The php script stripe-xero.php exports all Stripe balance affecting transactions into a CSV file recognisable by Xero Bank Account's import a CSV statement feature., _(*1)

Currently it supports:, _(*2)

1. Charges
2. Refunds
3. Payouts

Usage

Preparation, _(*3)

git clone https://github.com/rtcamp/stripe-xero-csv
cd stripe-xero-csv
composer install

Edit .env file to add correct Stripe API Key., _(*4)

Finally run the script:, _(*5)

php stripe-xero.php

It will create a file stripe-xero-{date}.csv with all balance affecting transactions from your Stripe account., _(*6)

Xero will skip duplicates during import so you need to worry about previously imported transactions appearing in CSV., _(*7)

Email

The script supports emailing CSV as attachment to predefined email address. This comes handy if you are running script as a CRON job., _(*8)

As of now only Amazon AWS SES is supported., _(*9)

You need to set values of following variables in .env file:, _(*10)

• EMAIL_FROM
• EMAIL_TO
• AWS_ACCESS_KEY
• AWS_SECRET_KEY

Please make sure:, _(*11)

1. EMAIL_FROM address must be verified already in SES console.
2. You are using IAM API user to generate AWS_ credentials. SES SMTP credentials won't work.

crontab

Add a line like below for weekly emails @ Monday 10am., _(*12)

0 10 * * 1  cd /path/to/stripe-xero-csv && /usr/bin/php stripe-xero.php >> stripe-xero.log 2>&1

Known Issues and Limitations

1. Xero doesn't provide support for adding Stripe as a bank account. So we need to create a normal bank account with manual feed.
2. Stripe doesn't provide Xero friendly statements. Xero supports many formats.
3. Xero API doesn't have provision to insert bank statement lines. It's second most popular feature request pending from eternity i.e. 2009! This is main reason that you need to run this script locally and import CSV files manually.

TODO

• [ ] Add support to generate CSV for a specific duration. Something like "this month", "last month" should be enough to start with.

LICENSE

MIT, _(*13)

Does this interest you?

, _(*14)