Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[FEAT] Create script that takes monthly financial statements and uploads to docs #23

Open
1 task done
tesla809 opened this issue May 4, 2020 · 2 comments
Open
1 task done
Labels
documentation Improvements or additions to documentation enhancement New feature or request

Comments

@tesla809
Copy link
Contributor

tesla809 commented May 4, 2020

⚠️ IMPORTANT: Please fill out this template to give us as much information as possible to consider/implement the feature.

Prerequisites

  • check this box if you have completed the following:
    • Reviewed the contributing guidelines and support files
    • Reviewed the README file for the repository you are working in
    • Searched for relevant instructions on our Discord server
    • Searched the issues of the repository you are working in to make sure one was not already filed

Summary

One paragraph explanation of the feature.
We now have financial statements. In the spirit to be transparent and have a high standard of reporting. To be transparent with the entire development team, we will publish a PDF of our financials in the .github repo under /financials.

To simplify things, we should automate this processs.

Motivation

Why are we doing this?
Transparency. We want to show our accounts in a single place. And we want to make the process of uploading things to github easy.

What use cases does it support?
Being open with our costs and funds coming in. We also want to automate this process to make life simple and reduce the steps needed for good compliance.

What is the expected outcome?
We will have a python script that takes our monthly financials when we close the books and uploads them to github.

Possible Alternatives

We can do it manually, but having an automated way makes Joy's (CPA) life easy. That way she can focus on the high-level specialist aspect of accounting, finance, and making sure the project's numbers are good.

Additional Context

N/A

@tesla809 tesla809 added the documentation Improvements or additions to documentation label May 4, 2020
@whoabuddy
Copy link
Contributor

I love the idea of keeping this simple. The biggest question I have at this stage - is the Google Doc the preferred method for creating the financial report, or is that just a format we use to share across the team?

If it is the preferred format, we can likely set up a script that retrieves the data and creates a PDF automatically. If not, we can probably skip the step of using a Google Doc entirely.

@whoabuddy whoabuddy added the enhancement New feature or request label May 4, 2020
@whoabuddy
Copy link
Contributor

Update 2019/05/04 from Joy in Discord:

for now I have an excel template for the numbers and a word template for all the notes. I just download the data from ZipBooks and then copy and paste it to the word template. It’s simple enough for me as we don’t have too many transactions or line items. It would be great if we could link Open Collective directly to ZipBooks. I think that’s the most manual process for me now. But I doubt if either platform would allow us to do so?

OpenCollective and Zipbooks both have APIs, but the latter comes with a warning it could change at any time.

OpenCollective can also send out a monthly report, but the links in the docs need to be updated (see issue here). That might be the easiest/fastest way to start, although we may need more detail from Joy on what the current "manual process" is between the two.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
documentation Improvements or additions to documentation enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants