Skip to content

Exports Stripe invoices and payments in DATEV format for bookkeeping

License

Notifications You must be signed in to change notification settings

jonaswitt/stripe-datev-exporter

Repository files navigation

Stripe DATEV Exporter

Requirements

  • Tested on Python 3.9
  • Dependencies listed in requirements.txt

Environment

Consider using Python's virtualenv or alternatives. To setup virtualenv initially:

virtualenv -p python3 venv

To activate in your current shell:

. venv/bin/activate

Then install dependencies:

pip install -r requirements.txt

How to Use

python stripe-datev-cli.py fill_account_numbers

Run this before download. This assigns the accountNumber metadata to each customer, this will be the account number for all booking records related to this customer. You can assign the accountNumber metadata using a different approach, if you like, but every customer (which has any transactions) needs this metadata.

python stripe-datev-cli.py list_accounts
python stripe-datev-cli.py list_accounts <file>

Outputs a CSV file with all customers, suitable to import into DATEV as master data (Stammdaten). Skip the output file argument to output to stdout. Otherwise, the file is written in Latin1 encoding.

python stripe-datev-cli.py download <year> <month>

Processes all invoices, charges and transactions in the given month. Outputs DATEV records in ./out/datev, CSV summaries in ./out/overview and ./out/monthly_recognition. Downloads PDF receipts to ./out/pdf.

python stripe-datev-cli.py fees <year> <month>

Shows a summary of all Stripe fees and contributions accrued in the given month (uses UTC, as Stripe does in their invoices, instead of the local timezone)

python stripe-datev-cli.py opos
python stripe-datev-cli.py opos <year> <month> <date>

Shows all unpaid invoices as of now, or as of the end of the given date. Useful to verify the balance of pRAP accounts at the end of a year.

python stripe-datev-cli.py preview <in_123...>
python stripe-datev-cli.py preview <ch_123...>
python stripe-datev-cli.py preview <txn_123...>

Shows a preview of all accounting records stemming from one invoice/charge/transaction. Useful to diff output when making changes to the accounting record generation logic.

About

Exports Stripe invoices and payments in DATEV format for bookkeeping

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Contributors 3

  •  
  •  
  •  

Languages