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.