We’ll need a live feed of the bank account accessible and filterable by time period on Mixpanel. This is the base for real-time access to our banking data, and connecting with accounting for real-time money, spend, and revenue analysis.

TODO:

• [x] AWS SNS Events

  • Bank account current value
  • Bank account transaction
  • Bank statement uploaded for processing
  • Bank statement done processing

• [x] AWS Queue

  • [ ] Queue of excel/csv files uploaded for processing

• [x] API Gateway

  • [ ] API endpoint to submit most recent value of bank account
  • [ ] API endpoint to receive transaction records
  • [ ] API endpoint to receive bank account statement Excel file

• [x] AWS S3

  • [ ] Store bank account statements excel sheets uploaded via api gateway in a bucket where it is pending for processing

• [ ] Google form / Notion / Airtable / Bubble app / Builder.io

  • [ ] Form to allow accountants to submit bank statements and current value to be logged into our system and published into Mixpanel

• [ ] RDS instance/Strapi/Airtable/GoogleSheet with all bank transaction records stored in Debit/Credit format to build our own accounting solution on top of (Xero alternative or Xero skin)

  • [ ] Check out the following Repo for a general direction on how we set our previous billing

  https://github.com/yii2tech/balance

• [ ] Automate bank account statement extraction through any RPA process.

Once above done, we need to work on automated reconcile function on Xero by integrating our systems with them.

We’ll be able to offer our own automated book keeping solution after testing it on ourselves.

Real-time Data

Early Evangelists