Finances: Difference between revisions
No edit summary |
|||
(28 intermediate revisions by 7 users not shown) | |||
Line 1: | Line 1: | ||
[[Category: | {{Outdated}} | ||
[[Category:Responsibility]] | |||
This page should serve to document how we keep track of finances at AHA. This is necessary for running AHA. | |||
This is the responsibility of the Finances committee, and the Treasurer. | |||
=Responsibilities= | |||
So you want to help? You are awesome! Here's the tasks and responsibilities, and how to do them. These must happen for a happy, healthy hackerspace. Some are monthly, yearly, weekly, or as needed. | |||
* Deposit cash/checks into our bank account | |||
* Keep Freshbooks accounting accurate | |||
* Make sure all our bills are paid | |||
* Make monthly reports for the board/members/public | |||
* Make financial projections, so we can properly plan/budget | |||
* Handle all financial filings (taxes) | |||
* Keep this documentation accurate and helpful! | |||
=Accounting= | |||
This is crucial! Accurate accounting lets us file taxes, make projections, track invoices, be transparent about our finances, and generally function. | |||
== | ==== Getting Started ==== | ||
# Log in to quickbooks (https://app.qbo.intuit.com/app/homepage) (credentials available in vaultwarden) | |||
# View transactions ---- Transactions>Bank Transactions | |||
# Update transactions.....wait.... reload page | |||
==== Reconciling membership dues ==== | |||
# Select PayPal Bank. Transactions should be shown starting on the first of the month for the month you are working on. You will be looking at every paypal transaction that has not been categorized or matched with an invoice. Not all of them are dues. | |||
# Click on the description of a transaction. For membership dues, this will just be the person's name. The from/to column is filled in automatically and is probably wrong. | |||
# Invoices that match the dollar amount of the transaction will be displayed. Select the transaction that matches the month that you are working on and click "match." The transaction will disappear. If you don't see a matching transaction, leave it for later and move to the next transaction | |||
# Continue until all of the membership dues transactions for the month have been cleared. This same procedure will apply to a transaction from Bill Mayer for Ann Arbor Spark Contact a board member for more info on a few people who's names in quickbooks don't match their names in paypal (located in room info of finances chat) | |||
==== Adding New Members ==== | |||
# Check <nowiki>https://docs.google.com/spreadsheets/d/1YKJuqA21dL-cEpRsfS2VPbdQeE1pLxP8Lb4l8YQN8l4/edit?pli=1#gid=292534297</nowiki> to see if new members joined in the month | |||
# Add new members and create invoices for them by going to Sales > Pledges and clicking "Create Pledge" | |||
# Select a customer. Probably the new member has not been added to quickbooks yet. If not, select "Add new" at the top of the list. | |||
## If adding new, input the member's first and last name. Customer display name should then be automatically filled. | |||
## Input the email address from the new member form into quickbooks. | |||
## Skip all other contact information about the member | |||
## Contact a board member to find out if the new member has completed their volunteering time. Scroll down to "Customer type" and select the member type from the membership application spreadsheet, or provisional member if they have not completed their first month's volunteering. | |||
# Select the invoice date as the first of the month that the member joined. | |||
# Click below "Product/Service" to select the item that corresponds to the correct membership type. | |||
# Click Save, then press the x on the top right corner to return to the list of Pledges | |||
# If the month is over, you will need to create another invoice for the next month. Find the pledge, select the arrow on the right hand side and click "duplicate" | |||
# Change the invoice date to the next month, save, and close. | |||
# Click the gear in the upper right to bring up a menu. Under Lists, select "Recurring Transactions." Then select "New" and select "pledge from the dropdown menu. | |||
# Select the member from the customer list, and input their membership type under "product/service." | |||
# All other defaults should be fine. Click "save template" | |||
==== Check status of provisional members ==== | |||
This is important in order to know who is permitted to vote in elections | |||
# go to "Customers & Leads". Investigate the status of every member with a customer type of "provisional." If necessary, edit the customer and change their customer type to reflect their current status. You will probably have to contact board members to get this info. | |||
# | # If provisional members are not paying, and have not come to the space for two months, change their customer type to "former member" | ||
# | |||
==== Match Transfers to Bank Account ==== | |||
Transfers between accounts are matched so that they are not recorded anywhere as an expense or income | |||
# Switch back to Transactions > Bank Transactions and then select Paypal | |||
# Find transactions labeled "Withdrawl to bank account" and click Match | |||
# | |||
# | |||
==== Other Paypal Transactions ==== | |||
# Open the outstanding paypal transactions in a new tab. These should all be either expenses or payments for something other than membership. Note down or print these transactions for the current month. | |||
# | # For each inbound transaction, create an invoice by going to Sales > Pledges and using the create pledge button. | ||
# | # If the transaction is small, and the customer is not already in quickbooks, use the customer "Unknown" for this transaction. | ||
# | # Select an appropriate product or service for the transaction. More information may be available by opening the paypal transaction (open the transaction in the Transactions window and find the paypal link at the bottom). You might also match transactions by connecting events on our meetup page (<nowiki>https://www.meetup.com/AllHandsActive/events/</nowiki>) to the date of a transaction | ||
# | # Make sure that the value of the invoice matches the Gross value of the transaction you are working on, then save the invoice. | ||
# Go back to the Transactions list, select PayPal, and match all of the outstanding transactions to the invoices you created | |||
# | # Now only expenses should remain for the month you are working on. | ||
# | # Open each expense and select the correct category. Some may have a lightning bolt next to them, and a category preselected. The lightning bolt indicates that a rule has been applied, so the preselected category is probably correct. Use your judgement on categories. For purchases of tools/upgrades that are in the normal budget, use the "small tools and equipment" category. For special purchases, use the "Tool Upgrades/purchases out of budget". If a purchase is funded by a grant, select the class that correlates to the grant to keep track of the purchase. when you are done, click confirm | ||
# | # No transactions should remain in the paypal tab should remain, for the month you are working on. | ||
# | |||
# | |||
== | ==== Checking accounts ==== | ||
Categorize expenses and create invoices using the same methods as the paypal account. | |||
If there is a deposit to the bank account, either cash or checks, it will probably be listed as "DEPOSIT MEMO DEPOSIT" and needs to be dealt with differently from other transactions. | |||
# Talk to a board member to get information about the deposit | |||
# Subtract out anything from the deposit that already has an invoice (dues payments, for instance). | |||
# Subtract out and make invoices for any transactions that should be tracked to a specific person/organization. | |||
# Make an invoice from "Unknown" for the balance of the deposit | |||
# On the Transactions page, select the deposit, and switch the radio button to "match" | |||
# Since no single invoice matches the dollar value of the deposit, you can now match the deposit to multiple invoices. Input the portion of the deposit that goes to each invoice in the right hand column | |||
# scroll to the bottom and check that the difference line reads $0.00. This means that you have accounted for all of the deposit. You may now click "Match" | |||
==== Cleaning Up ==== | |||
1: Check the two savings accounts to confirm any interest payments or transfers. | |||
==== Reporting ==== | |||
# Select "Reports" on the left hand menu. The important reports are under favorites. Run an "Accounts receivable aging" report to find outstanding invoices. | |||
# For all invoices that are not in the CURRENT column, investigate them. Some invoices have not been paid due to mistakes, some automatic invoices are generated for former members, or other unique situations may arise. | |||
## For former members, delete any invoices that should not have been generated, and delete the automatic recurring invoice. The existing invoices can be deleted on the Sales > Pledges page, and the recurring invoices can be deleted through the gear on the upper right corner, then Lists > recurring transactions. Members who have left should also have their status changed to former member | |||
# Both "Statement of Financial Position" and "Statement of Activity by Month" should be run and saved. | |||
## After you run a report, scroll up and change the report period to end at the end of the month you are accounting. Information after that date is not meaningful. | |||
## Click "run report" and the report will update. | |||
## Click the export icon at the top right of the report, and select "export to PDF" | |||
## The default settings are fine. Click "Save as PDF" and get a board member to put it in the correct folder under finances in google drive. | |||
## Repeat for the other report | |||
# Update the Monthly Report <nowiki>https://docs.google.com/spreadsheets/d/1fCZ2j8G5ZXTxQlR_fnR_BoUldrVSsgBDnbztHpAYgGw/edit#gid=1222700446</nowiki> | |||
## To get a members list, view the list of customers in quickbooks and export it as an excel sheet. You may then sort by the customer type column and get the number of members of each type | |||
## Fill in the cash on hand using the Statement of Financial Position. You may run the Statement of Activity by Class report to determine changes in reserved funds | |||
## Run the Budget progress custom report to get values for the various budgets | |||
## use the helpful links worksheet to get numbers for the attendance log and get the number of classes taught from the all hands active meetup | |||
= Taxes = | |||
We currently need to file two things: income, and sales tax. Failing to file will get us fined, and is basically just burning money. File the taxes!!!: | |||
* Michigan Treasury Online: https://mto.treasury.michigan.gov (sales tax, will probably just be filling in $0 everywhere). Due by the end of February. | |||
* [https://www.irs.gov/charities-non-profits/annual-electronic-filing-requirement-for-small-exempt-organizations-form-990-n-e-postcard IRS 990N] e-postcard (assuming we are usually making under $50,000 in gross receipts): https://sa.www4.irs.gov/epostcard/. | |||
== Federal Income (form 990N) == | |||
If we have gross receipts less than $50,000 in the tax year, the form is basically "I attest that I made less than $50,000". Simple! If we make more than that (hasn't happened recently) then it gets more complicated (time to talk with the accountant). Use our records in Quickbooks to get the numbers for the paperwork. | |||
Form 990-N is due '''every year''' '''by the 15th day of the 5th month''' after the close of your tax year. For us, this is by '''May 15th'''! | |||
Note: gross receipts basically means ANY money we bring in. No deductions, no expenses. This does include grants, but does not include loans. There is a more detailed description on the [https://www.irs.gov/charities-non-profits/annual-electronic-filing-requirement-for-small-exempt-organizations-form-990-n-e-postcard IRS site]. | |||
# Go to https://sa.www4.irs.gov/epostcard/ and login using the info from [[VaultWarden]] | |||
# Click on MANAGE E-POSTCARD PROFILE | |||
# Make sure our EIN is correct, and click on CREATE NEW FILING | |||
# Select the proper EIN (there should be only one) | |||
# Answer that we haven't gone out of business (I hope!) and that we normally have gross receipts less than $50,000. | |||
# Skip the DBA names on the next form | |||
# Enter in our organization details (be sure to use official postal addresses from https://www.usps.com/) | |||
# For the principal officer, enter the name of the current treasurer, and our business info again (not their personal address) | |||
# Submit the filing! You're done! | |||
== Sales Tax (MI) == | |||
We are registered with the State of Michigan as an entity which has sales, and thus collects sales tax. This is from back when we sold snacks, pop, and things like arduinos. Sales tax is for the individual, thus we have to collect it, and pay it to the state of Michigan. *We have to file even if we have $0 in sales*. Failing to file gets us charged late fees, and sent letters from the State claiming we owe them a bunch of money. That sucks. | |||
We currently have no sales, but if we did, they should be classified as such in Freshbooks, with the sales tax collected recorded. This way we know what to pay the state at the end of the year. | |||
If we decide to never have sales, we can file to remove our classification as an entity having sales, meaning we no longer have to file sales tax reports. It's probably best to just file a simple return annually and retain the ability to sell stuff. | |||
TODO: link to tax forms, deadline info. | |||
= Budgeting = | |||
Doing all this, you should have a clear view of how much money we can count on receiving each month, and how this stacks up with our expenses. Use this to recommend courses of action for making more money, cutting costs, investing in tools, etc. This is also important for projecting our near-future finances for planning purposes. For example, are we quickly running out of money in our emergency fund? Or are we banking enough to invest in new equipment in X months? | |||
Some expenses are fixed or necessary (like rent), while others may fluctuate, like buying supplies. Similarly, some income is relatively reliable (memberships), while some fluctuates (classes, one-off events). For a conservative projection erring on the side of caution, include stable things like rent, utilities, and memberships, insurance payments. It's also worth estimating incidental expenses, since those seem to always come up. Don't count on classes or donations, since it's possible we'll have a bust month, and won't want that to ruin our budgeting. | |||
This is also important info for fundraising, because it'll give us clear goals. Are we fundraising to cover operating expenses, or are we able to fundraise to buy more equipment, or run a specific project? |
Latest revision as of 13:18, 13 March 2024
This page should serve to document how we keep track of finances at AHA. This is necessary for running AHA.
This is the responsibility of the Finances committee, and the Treasurer.
Responsibilities
So you want to help? You are awesome! Here's the tasks and responsibilities, and how to do them. These must happen for a happy, healthy hackerspace. Some are monthly, yearly, weekly, or as needed.
- Deposit cash/checks into our bank account
- Keep Freshbooks accounting accurate
- Make sure all our bills are paid
- Make monthly reports for the board/members/public
- Make financial projections, so we can properly plan/budget
- Handle all financial filings (taxes)
- Keep this documentation accurate and helpful!
Accounting
This is crucial! Accurate accounting lets us file taxes, make projections, track invoices, be transparent about our finances, and generally function.
Getting Started
- Log in to quickbooks (https://app.qbo.intuit.com/app/homepage) (credentials available in vaultwarden)
- View transactions ---- Transactions>Bank Transactions
- Update transactions.....wait.... reload page
Reconciling membership dues
- Select PayPal Bank. Transactions should be shown starting on the first of the month for the month you are working on. You will be looking at every paypal transaction that has not been categorized or matched with an invoice. Not all of them are dues.
- Click on the description of a transaction. For membership dues, this will just be the person's name. The from/to column is filled in automatically and is probably wrong.
- Invoices that match the dollar amount of the transaction will be displayed. Select the transaction that matches the month that you are working on and click "match." The transaction will disappear. If you don't see a matching transaction, leave it for later and move to the next transaction
- Continue until all of the membership dues transactions for the month have been cleared. This same procedure will apply to a transaction from Bill Mayer for Ann Arbor Spark Contact a board member for more info on a few people who's names in quickbooks don't match their names in paypal (located in room info of finances chat)
Adding New Members
- Check https://docs.google.com/spreadsheets/d/1YKJuqA21dL-cEpRsfS2VPbdQeE1pLxP8Lb4l8YQN8l4/edit?pli=1#gid=292534297 to see if new members joined in the month
- Add new members and create invoices for them by going to Sales > Pledges and clicking "Create Pledge"
- Select a customer. Probably the new member has not been added to quickbooks yet. If not, select "Add new" at the top of the list.
- If adding new, input the member's first and last name. Customer display name should then be automatically filled.
- Input the email address from the new member form into quickbooks.
- Skip all other contact information about the member
- Contact a board member to find out if the new member has completed their volunteering time. Scroll down to "Customer type" and select the member type from the membership application spreadsheet, or provisional member if they have not completed their first month's volunteering.
- Select the invoice date as the first of the month that the member joined.
- Click below "Product/Service" to select the item that corresponds to the correct membership type.
- Click Save, then press the x on the top right corner to return to the list of Pledges
- If the month is over, you will need to create another invoice for the next month. Find the pledge, select the arrow on the right hand side and click "duplicate"
- Change the invoice date to the next month, save, and close.
- Click the gear in the upper right to bring up a menu. Under Lists, select "Recurring Transactions." Then select "New" and select "pledge from the dropdown menu.
- Select the member from the customer list, and input their membership type under "product/service."
- All other defaults should be fine. Click "save template"
Check status of provisional members
This is important in order to know who is permitted to vote in elections
- go to "Customers & Leads". Investigate the status of every member with a customer type of "provisional." If necessary, edit the customer and change their customer type to reflect their current status. You will probably have to contact board members to get this info.
- If provisional members are not paying, and have not come to the space for two months, change their customer type to "former member"
Match Transfers to Bank Account
Transfers between accounts are matched so that they are not recorded anywhere as an expense or income
- Switch back to Transactions > Bank Transactions and then select Paypal
- Find transactions labeled "Withdrawl to bank account" and click Match
Other Paypal Transactions
- Open the outstanding paypal transactions in a new tab. These should all be either expenses or payments for something other than membership. Note down or print these transactions for the current month.
- For each inbound transaction, create an invoice by going to Sales > Pledges and using the create pledge button.
- If the transaction is small, and the customer is not already in quickbooks, use the customer "Unknown" for this transaction.
- Select an appropriate product or service for the transaction. More information may be available by opening the paypal transaction (open the transaction in the Transactions window and find the paypal link at the bottom). You might also match transactions by connecting events on our meetup page (https://www.meetup.com/AllHandsActive/events/) to the date of a transaction
- Make sure that the value of the invoice matches the Gross value of the transaction you are working on, then save the invoice.
- Go back to the Transactions list, select PayPal, and match all of the outstanding transactions to the invoices you created
- Now only expenses should remain for the month you are working on.
- Open each expense and select the correct category. Some may have a lightning bolt next to them, and a category preselected. The lightning bolt indicates that a rule has been applied, so the preselected category is probably correct. Use your judgement on categories. For purchases of tools/upgrades that are in the normal budget, use the "small tools and equipment" category. For special purchases, use the "Tool Upgrades/purchases out of budget". If a purchase is funded by a grant, select the class that correlates to the grant to keep track of the purchase. when you are done, click confirm
- No transactions should remain in the paypal tab should remain, for the month you are working on.
Checking accounts
Categorize expenses and create invoices using the same methods as the paypal account.
If there is a deposit to the bank account, either cash or checks, it will probably be listed as "DEPOSIT MEMO DEPOSIT" and needs to be dealt with differently from other transactions.
- Talk to a board member to get information about the deposit
- Subtract out anything from the deposit that already has an invoice (dues payments, for instance).
- Subtract out and make invoices for any transactions that should be tracked to a specific person/organization.
- Make an invoice from "Unknown" for the balance of the deposit
- On the Transactions page, select the deposit, and switch the radio button to "match"
- Since no single invoice matches the dollar value of the deposit, you can now match the deposit to multiple invoices. Input the portion of the deposit that goes to each invoice in the right hand column
- scroll to the bottom and check that the difference line reads $0.00. This means that you have accounted for all of the deposit. You may now click "Match"
Cleaning Up
1: Check the two savings accounts to confirm any interest payments or transfers.
Reporting
- Select "Reports" on the left hand menu. The important reports are under favorites. Run an "Accounts receivable aging" report to find outstanding invoices.
- For all invoices that are not in the CURRENT column, investigate them. Some invoices have not been paid due to mistakes, some automatic invoices are generated for former members, or other unique situations may arise.
- For former members, delete any invoices that should not have been generated, and delete the automatic recurring invoice. The existing invoices can be deleted on the Sales > Pledges page, and the recurring invoices can be deleted through the gear on the upper right corner, then Lists > recurring transactions. Members who have left should also have their status changed to former member
- Both "Statement of Financial Position" and "Statement of Activity by Month" should be run and saved.
- After you run a report, scroll up and change the report period to end at the end of the month you are accounting. Information after that date is not meaningful.
- Click "run report" and the report will update.
- Click the export icon at the top right of the report, and select "export to PDF"
- The default settings are fine. Click "Save as PDF" and get a board member to put it in the correct folder under finances in google drive.
- Repeat for the other report
- Update the Monthly Report https://docs.google.com/spreadsheets/d/1fCZ2j8G5ZXTxQlR_fnR_BoUldrVSsgBDnbztHpAYgGw/edit#gid=1222700446
- To get a members list, view the list of customers in quickbooks and export it as an excel sheet. You may then sort by the customer type column and get the number of members of each type
- Fill in the cash on hand using the Statement of Financial Position. You may run the Statement of Activity by Class report to determine changes in reserved funds
- Run the Budget progress custom report to get values for the various budgets
- use the helpful links worksheet to get numbers for the attendance log and get the number of classes taught from the all hands active meetup
Taxes
We currently need to file two things: income, and sales tax. Failing to file will get us fined, and is basically just burning money. File the taxes!!!:
- Michigan Treasury Online: https://mto.treasury.michigan.gov (sales tax, will probably just be filling in $0 everywhere). Due by the end of February.
- IRS 990N e-postcard (assuming we are usually making under $50,000 in gross receipts): https://sa.www4.irs.gov/epostcard/.
Federal Income (form 990N)
If we have gross receipts less than $50,000 in the tax year, the form is basically "I attest that I made less than $50,000". Simple! If we make more than that (hasn't happened recently) then it gets more complicated (time to talk with the accountant). Use our records in Quickbooks to get the numbers for the paperwork.
Form 990-N is due every year by the 15th day of the 5th month after the close of your tax year. For us, this is by May 15th!
Note: gross receipts basically means ANY money we bring in. No deductions, no expenses. This does include grants, but does not include loans. There is a more detailed description on the IRS site.
- Go to https://sa.www4.irs.gov/epostcard/ and login using the info from VaultWarden
- Click on MANAGE E-POSTCARD PROFILE
- Make sure our EIN is correct, and click on CREATE NEW FILING
- Select the proper EIN (there should be only one)
- Answer that we haven't gone out of business (I hope!) and that we normally have gross receipts less than $50,000.
- Skip the DBA names on the next form
- Enter in our organization details (be sure to use official postal addresses from https://www.usps.com/)
- For the principal officer, enter the name of the current treasurer, and our business info again (not their personal address)
- Submit the filing! You're done!
Sales Tax (MI)
We are registered with the State of Michigan as an entity which has sales, and thus collects sales tax. This is from back when we sold snacks, pop, and things like arduinos. Sales tax is for the individual, thus we have to collect it, and pay it to the state of Michigan. *We have to file even if we have $0 in sales*. Failing to file gets us charged late fees, and sent letters from the State claiming we owe them a bunch of money. That sucks.
We currently have no sales, but if we did, they should be classified as such in Freshbooks, with the sales tax collected recorded. This way we know what to pay the state at the end of the year.
If we decide to never have sales, we can file to remove our classification as an entity having sales, meaning we no longer have to file sales tax reports. It's probably best to just file a simple return annually and retain the ability to sell stuff.
TODO: link to tax forms, deadline info.
Budgeting
Doing all this, you should have a clear view of how much money we can count on receiving each month, and how this stacks up with our expenses. Use this to recommend courses of action for making more money, cutting costs, investing in tools, etc. This is also important for projecting our near-future finances for planning purposes. For example, are we quickly running out of money in our emergency fund? Or are we banking enough to invest in new equipment in X months?
Some expenses are fixed or necessary (like rent), while others may fluctuate, like buying supplies. Similarly, some income is relatively reliable (memberships), while some fluctuates (classes, one-off events). For a conservative projection erring on the side of caution, include stable things like rent, utilities, and memberships, insurance payments. It's also worth estimating incidental expenses, since those seem to always come up. Don't count on classes or donations, since it's possible we'll have a bust month, and won't want that to ruin our budgeting.
This is also important info for fundraising, because it'll give us clear goals. Are we fundraising to cover operating expenses, or are we able to fundraise to buy more equipment, or run a specific project?