stripe-quickbooks-statements

    1.0.5 • Public • Published

    Stripe Quickbooks Statements

    Built withtypescript version dependants license

    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.

    Keywords

    none

    Install

    npm i stripe-quickbooks-statements

    DownloadsWeekly Downloads

    2

    Version

    1.0.5

    License

    MIT

    Unpacked Size

    1.85 MB

    Total Files

    12

    Last publish

    Collaborators

    • alan-cooney