← Back to blog

Makerspace financial reporting w/ ipython

Visit this project on github here

  • Merge PayPal & Membershipworks members in a sorta intelligent way to create kinda accurate financial reports
  • Convert a PayPal transaction export into an upsert-able csv to import into membershipworks
  • Keep tabs on PayPal memberships as they become deprecated

(note, you’ll need nbconvert, pandoc, TeX to write to pdf)

…If all goes well, the output will look something like:

loaded ** paypal records loaded existing membershipworks records converted Date column to datetime objects kept * records processed between 01/01/22 and 22/11/21; discarded ** records discarded ’s Donation Payment record for, continuing… discarded ’s PreApproved Payment Bill User Payment record for, continuing… ** already in member list! continuing… discarded ’s Payment Refund record for -.00, continuing… discarded ** ’s Donation Payment record for.00, continuing… exported: ** Members!

  • ** Standard Members
  • ** Offline Standard Members
  • ** Extra Members
  • ** Offline Extra Members …to a membershipworks-readable format at ./csv/membershipworks_import.csv

Originally published at www.transscendsurvival.org

Comments

© 2026 Jess Sullivan

| RSS