balancing the USBank and OpenCollective accounts
Find a file
2025-04-26 13:58:43 -05:00
input version 2: fixed some issues 2025-04-20 17:39:04 -05:00
state update 2025-04-26 13:58:43 -05:00
.gitignore version 2: fixed some issues 2025-04-20 17:39:04 -05:00
checkEmail.js version 2: fixed some issues 2025-04-20 17:39:04 -05:00
createOpenCollectiveExpense.js version 2: fixed some issues 2025-04-20 17:39:04 -05:00
getOpenCollectiveTransactions.js version 2: fixed some issues 2025-04-20 17:39:04 -05:00
ignored-during-startup.csv version 2: fixed some issues 2025-04-20 17:39:04 -05:00
index.js fix CSV formatting 2025-04-20 17:58:47 -05:00
jes-expiditious-usage.csv version 2: fixed some issues 2025-04-20 17:39:04 -05:00
manual-matchups.csv version 2: fixed some issues 2025-04-20 17:39:04 -05:00
openCollectiveAddFunds.js version 2: fixed some issues 2025-04-20 17:39:04 -05:00
overview.drawio.png version 2: fixed some issues 2025-04-20 17:39:04 -05:00
package-lock.json version 2: fixed some issues 2025-04-20 17:39:04 -05:00
package.json version 2: fixed some issues 2025-04-20 17:39:04 -05:00
ReadMe.md version 2: fixed some issues 2025-04-20 17:39:04 -05:00
screenshot.png update screenshot 2023-03-31 22:40:31 -05:00

high tech automated bean counting system

This is a commandline application that processes our USBank transaction export, USBank transaction notification emails, and our OpenCollective data in order to produce CSV files of both and add any transactions that are in UsBank but aren't in OpenCollective yet.

This helps our OpenCollective remain tethered to reality, so it doesn't always display that we have way more money than we actually do.

this is a work in progress

set up OpenCollective API access

https://graphql-docs-v2.opencollective.com/access#with-a-personal-token

The Personal Token give you access to the API and is automatically authenticating you as an individual. To create one, go to your personal settings and navigate to the For developers section

For example you would go to: https://opencollective.com/forest-johnson/admin/for-developers

Then set your token as an environment variable like OPENCOLLECTIVE_TOKEN=374....snip....a98

how to run it

  1. npm install
  2. mkdir input
  3. download the opencollective transaction export. it should be named layerzero-transactions.csv. put it in the input folder now the app pulls direct from OpenCollective using GraphQL API.
  4. download the usbank transactions export for, starting from 2022-07-24 (07/24/2022) until today. it should be named something like Checking - 9979_07-24-2022_03-21-2023.csv. put it in the input folder
  5. OPENCOLLECTIVE_TOKEN=374....snip....a98 NULLHEX_ADDRESS='*****@nullhex.com' NULLHEX_PASSWORD='3....snip....g' node index.js