Stripe Quickbooks Statements
Download stripe statements, in a format that works well with Quickbooks (allowing for multicurrency):
# Install globally yarn global add stripe-quickbooks-statements # Run in the folder where you want the csvs stripe-quickbooks-statements --secret {{YOUR_API_SECRET_KEY}} --from 2000-01-01 --to 2020-01-01
Parameters
Parameter | Default | Description |
---|---|---|
secret | STRIPE_KEY environmental variable | Your stripe API secret |
from | 2000-01-01 | The datetime to get items from (inclusive) |
to | 3 Days ago (at 00:00:00 in the morning) | The datetime to get items from (exclusive) |
Features
- Outputs one spreadsheet per currency (you should have one Quickbooks bank account per stripe currency that you use)
- Where stripe has converted a currency, 3 items are created, e.g. with a charge of $100 USD that is converted instantly
to £100 by Stripe:
- A charge of $100 to the USD account
- A spend money transfer of $100 from the USD account
- A receive money transfer of e.g. £82 to the GBP account
- Fee lines added appropriately (seperate from the transactions)
- Outputs CSVs in batches of 1000 lines (as this is the Quickbooks max)
Checklist
CD Feature | Provided |
---|---|
✅ | Typescript |
✅ | Linting (AirBnB + Prettier) |
✅ | Unit tests (Jest) |
✅ | Coverage check |
✅ | Github Continuous Deployment |
Built by Skyhook
This module is contributed by the team at Skyhook.