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.