Finances: Difference between revisions

From All Hands Active Wiki
Jump to navigation Jump to search
JoshW (talk | contribs)
No edit summary
JLDohm (talk | contribs)
 
(28 intermediate revisions by 7 users not shown)
Line 1: Line 1:
[[Category:Finances]]
{{Outdated}}
We need to make sure all of our finances are in order. As such, we have scheduled a meeting with Lynne Chaimowitz
[[Category:Responsibility]]
This page should serve to document how we keep track of finances at AHA. This is necessary for running AHA.


=Basic Expenses=
This is the responsibility of the Finances committee, and the Treasurer.
[[Finances:What]] = Basic breakdown of what we spend money on


=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.


=Result / Status of meeting=
* Deposit cash/checks into our bank account
==She Recommended==
* Keep Freshbooks accounting accurate
# Immediately find a corporate / tax attorney so that we can:
* Make sure all our bills are paid
#* Review Purchase Agreement, primarily for the purpose of making sure our accounting methods are kosher w/501c3 desires.desires
* Make monthly reports for the board/members/public
#* Make sure that we are kosher with current status of State & Federal Filings
* Make financial projections, so we can properly plan/budget
#** Our Articles of Incorporation were accepted on January 10th, 2010, according to the stamp (see link at bottom)
* Handle all financial filings (taxes)
# Immediately begin work on filling out IRS 501c3 Forms
* Keep this documentation accurate and helpful!
#* She did say it's better to file properly the first time. Don't rush & send in something shitty.
#* She is willing to help out with this - probably cost $
# Get D&O Insurance figured out
# Make sure we have basic accounting information for 2010, 2011, 2012. (Pretty solid on 2011 and 2012)


=Accounting=
This is crucial! Accurate accounting lets us file taxes, make projections, track invoices, be transparent about our finances, and generally function.


==A fun conundrum==
==== Getting Started ====
* We are in a limbo spot of actually being a for profit corporation, with the intent of become a 501c3 Non profit. The IRS gives you ~3 years to figure this out.


* If we file annual income tax forms right now, we would be filing them as a for profit corporation
# Log in to quickbooks (https://app.qbo.intuit.com/app/homepage) (credentials available in vaultwarden)
** Filing annual income tax forms as a for profit corporation makes it much harder to then apply to become a non profit 501c3.
# View transactions    ----    Transactions>Bank Transactions
# Update transactions.....wait.... reload page


* If we don't file any annual income tax forms within 3 years from our initial incorporation date (January 2010), the IRS gets upset.
==== Reconciling membership dues ====


* Turnaround time for 501c3 forms is typically >6 months from when we submit it to the IRS.
# 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)


* If our intent is to become a 501c3 Non Profit, we need to get the submission process started ASAP, and turned in within the next couple weeks.
==== Adding New Members ====


* If our intent is to become a <some regular for profit corporation>, we need to file annual income forms & more ASAP.
# 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


==Responsibilities we need filled yesterday==
# 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.
# Someone to find a reputable Corporate/Tax Attorney to communicate our situation with
# If provisional members are not paying, and have not come to the space for two months, change their customer type to "former member"
# Someone to start trudging through the IRS 501c3 Application Process: http://www.irs.gov/charities/article/0,,id=96109,00.html
# Someone to put together 2010, 2011, and 2011 P&L / income vs. expenses, bank statements, etc.


==== Match Transfers to Bank Account ====
Transfers between accounts are matched so that they are not recorded anywhere as an expense or income


=Notes setup prior to meeting=
# Switch back to Transactions > Bank Transactions and then select Paypal
==She requests==
# Find transactions labeled "Withdrawl to bank account" and click Match
# Existing financial records
#* 2012 - We can provide access to Quickbooks Online
#* 2011 - Basic breakdown listed below
#* 2010 - Unknown
# Strategic documents that would be helpful in defining how we set up your accounting records
#* Income
#** Memberships
#** Classes / Workshops
#** Donations
#** Time on PCs (Starting June 1st)
#* Expenses
#** Rent
#** Utilities
#** Physical Space Improvements
#** Staff (Independent Contractors at the moment)
#** Tools
#* Fiscal Sponsorship
#** Provided by [http://www.schoolfactory.org The School Factory]
#** One donation of $1,000 in 2011? The School Factory takes 10%, we received $900.<br/><br/>
# A list of skill sets and responsibilities that you and/or volunteers are in charge of
#* Jenn & Josh: Currently assign / categorize items into Quickbooks Online for General AHA Income
#** No accounting background.
#* Jess: currently updated Quickbooks Pro 2010 for Time on PC Income (Digital Ops)
#** No accounting background, but has been handling the Ops data entry for a few years now.


==== Other Paypal Transactions ====


==Our questions==
# 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.
# What forms should we be submitting to the:
# For each inbound transaction, create an invoice by going to Sales > Pledges and using the create pledge button.
#* City
# If the transaction is small, and the customer is not already in quickbooks, use the customer "Unknown" for this transaction.
#* State
# 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
#* Federal<br/><br/>
# Make sure that the value of the invoice matches the Gross value of the transaction you are working on, then save the invoice.
# What payments should we be submitting to the:
# Go back to the Transactions list, select PayPal, and match all of the outstanding transactions to the invoices you created
#* City
# Now only expenses should remain for the month you are working on.
#* State
# 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
#* Federal<br/><br/>
# No transactions should remain in the paypal tab should remain, for the month you are working on.
# Should we have separate Bank Accounts for Gaming Center vs. Maker Income?<br/><br/>
# Does out current QB Online process seem all right?
# What exemptions do we qualify for as a domestic nonprofit?
# How will filing requirements change if we pursue 501c3-ship?
# What standardized resource can we refer to in the future?


==Information:==
==== Checking accounts ====
* [http://www.dleg.state.mi.us/bcs_corp/dt_corp.asp?id_nbr=70632W&name_entity=ALL%20HANDS%20ACTIVE State of Michigan Articles of Incorporation]
Categorize expenses and create invoices using the same methods as the paypal account.


==2010 P&L - Basic Breakdown==
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.
<pre>
Income $
Expense $
Inc: Membrships $2410  Income from Monthly Dues
Inc: BF2010    $      Income from Classes taught by AHA outside of All Hands Active
Inc: Donations $     
Inc: Unknown $     


Total Income: $2410
# 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"


Exp: BF 2010 $      Bright Futures Classes (Independent Contractor Payouts)
==== Cleaning Up ====
Exp: Rent $
1: Check the two savings accounts to confirm any interest payments or transfers.
Exp: Util $
Exp: Unknown 2 $      (I believe these are from checks)
Exp: Improving  $      General Lowes, Meijer, Stadium Hardware purchases
Exp: Unknown $      Ask Josh to see AHA 2011 Google Doc for better breakdown)
Exp: Electronic $      Electronics - Sparkfun orders, Jameco, etc.
Exp: Insurance $
Exp: Donation $      GEMSI for Bilal
Exp: Web Host  $      Slicehost
Exp: Food $      Food for volunteer events
Exp: Marketing $      Kolossos, Kinkos, etc.
Exp: Subscrip.  $      Intuit, Amazon Prime, Events Manager for Web site
Exp: Gas $
Total Expenses $


Net Income: $
==== 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


</pre>
= Taxes =


==2011 P&L - Basic Breakdown==
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!!!:
<pre>
Income $20247.94
Expense $17465.62
Inc: Membrships $7016.28  Income from Monthly Dues
Inc: BF2011    $9395    Income from Classes taught by AHA outside of All Hands Active
Inc: Donations $900      Nine Tuna Donation ($1,000, School Factory takes 10%)
Inc: Unknown $2936.66  A lot of this is probably from other classes taught at AHA, unaccounted for membership income, possibly indiegogo ($610) fundraising etc.)


Total Income: $20247.94
* 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/.


Exp: BF 2011 $7500    Bright Futures Classes (Independent Contractor Payouts)
== Federal Income (form 990N) ==
Exp: Rent $3150
Exp: Util $1750
Exp: Unknown 2 $1410    (I believe these are from checks)
Exp: Improving  $1054.98  General Lowes, Meijer, Stadium Hardware purchases
Exp: Unknown $652.34  Ask Josh to see AHA 2011 Google Doc for better breakdown)
Exp: Electronic $496.61  Electronics - Sparkfun orders, Jameco, etc.
Exp: Insurance $330.5
Exp: Donation $258      GEMSI for Bilal
Exp: Web Host  $240      Slicehost
Exp: Food $227.2    Food for volunteer events
Exp: Marketing $192.85  Kolossos, Kinkos, etc.
Exp: Subscrip.  $180.45  Intuit, Amazon Prime, Events Manager for Web site
Exp: Gas $22.39
Total Expenses $17465.32


Net Income: $2782.32
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'''!


</pre>
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].


==2012 P&L - Basic Breakdown January 1st - April 30th==
# Go to https://sa.www4.irs.gov/epostcard/ and login using the info from [[VaultWarden]]
<pre>
# Click on MANAGE E-POSTCARD PROFILE
Income
# Make sure our EIN is correct, and click on CREATE NEW FILING
  Classes 237.27
# Select the proper EIN (there should be only one)
      AHA Classes Income....... 4.942.52
# Answer that we haven't gone out of business (I hope!) and that we normally have gross receipts less than $50,000.
      How to - 3D Print........ 71.30
# Skip the DBA names on the next form
      How to - Laser........... 47.33
# Enter in our organization details (be sure to use official postal addresses from https://www.usps.com/)
      How to Arduino........... 104.09
# For the principal officer, enter the name of the current treasurer, and our business info again (not their personal address)
      How to CNC............... 28.52
# Submit the filing! You're done!
      Learn to Solder.......... 18.82
  Total Classes $5.449.85
  Coffee Donations............ 5.00
  Laser Cutter Donations...... 13.00
  Membership Dues............. 2.641.46
  Misc Product Sales Income... 5.00
  Need to split............... 895.00
  Uncategorized Income........ 154.41
Total Income $9.163.72
Gross Profit $9.163.72


Expenses
== Sales Tax (MI) ==
  Advertising................. 93.98
  AHA Class Contracting....... 100.00
  AHA Class Supplies.......... 24.33
  Board Meeting Expenditures.. 76.73
  Bright Futures Employees.... 2.207.91
  Bright Futures Supplies..... 47.83
  Bright Futures Transportation62.40
  Dues & Subscriptions........  29.95
  Food........................ 31.48
  Insurance................... 354.50
  LASER Budget - Rental....... 151.67
  Laser Budget - Repairs...... 179.48
  Maintenance................. 32.00
  Membership Expense.......... 18.29
  Rent or Lease............... 3.000.00
  Shogun Budget............... 1.284.51
  Shogun Contractor........... 400.00
  Treasurer Spending.......... 17.95
  Uncategorized Expense....... 228.54
  Utilities................... 1.442.16
Total Expenses $9.783.71


Net Operating Income -$619.99
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.


Net Income -$619.99
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.
</pre>
 
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


Notice
Notice
OUTDATED!:
The content of this page is outdated.
If you have checked or updated this page and found the content to be suitable, please remove this notice.

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

  1. Log in to quickbooks (https://app.qbo.intuit.com/app/homepage) (credentials available in vaultwarden)
  2. View transactions ---- Transactions>Bank Transactions
  3. Update transactions.....wait.... reload page

Reconciling membership dues

  1. 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.
  2. 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.
  3. 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
  4. 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

  1. Check https://docs.google.com/spreadsheets/d/1YKJuqA21dL-cEpRsfS2VPbdQeE1pLxP8Lb4l8YQN8l4/edit?pli=1#gid=292534297 to see if new members joined in the month
  2. Add new members and create invoices for them by going to Sales > Pledges and clicking "Create Pledge"
  3. 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.
    1. If adding new, input the member's first and last name. Customer display name should then be automatically filled.
    2. Input the email address from the new member form into quickbooks.
    3. Skip all other contact information about the member
    4. 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.
  4. Select the invoice date as the first of the month that the member joined.
  5. Click below "Product/Service" to select the item that corresponds to the correct membership type.
  6. Click Save, then press the x on the top right corner to return to the list of Pledges
  7. 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"
  8. Change the invoice date to the next month, save, and close.
  9. 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.
  10. Select the member from the customer list, and input their membership type under "product/service."
  11. 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

  1. 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.
  2. 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

  1. Switch back to Transactions > Bank Transactions and then select Paypal
  2. Find transactions labeled "Withdrawl to bank account" and click Match

Other Paypal Transactions

  1. 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.
  2. For each inbound transaction, create an invoice by going to Sales > Pledges and using the create pledge button.
  3. If the transaction is small, and the customer is not already in quickbooks, use the customer "Unknown" for this transaction.
  4. 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
  5. Make sure that the value of the invoice matches the Gross value of the transaction you are working on, then save the invoice.
  6. Go back to the Transactions list, select PayPal, and match all of the outstanding transactions to the invoices you created
  7. Now only expenses should remain for the month you are working on.
  8. 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
  9. 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.

  1. Talk to a board member to get information about the deposit
  2. Subtract out anything from the deposit that already has an invoice (dues payments, for instance).
  3. Subtract out and make invoices for any transactions that should be tracked to a specific person/organization.
  4. Make an invoice from "Unknown" for the balance of the deposit
  5. On the Transactions page, select the deposit, and switch the radio button to "match"
  6. 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
  7. 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

  1. Select "Reports" on the left hand menu. The important reports are under favorites. Run an "Accounts receivable aging" report to find outstanding invoices.
  2. 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.
    1. 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
  3. Both "Statement of Financial Position" and "Statement of Activity by Month" should be run and saved.
    1. 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.
    2. Click "run report" and the report will update.
    3. Click the export icon at the top right of the report, and select "export to PDF"
    4. 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.
    5. Repeat for the other report
  4. Update the Monthly Report https://docs.google.com/spreadsheets/d/1fCZ2j8G5ZXTxQlR_fnR_BoUldrVSsgBDnbztHpAYgGw/edit#gid=1222700446
    1. 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
    2. 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
    3. Run the Budget progress custom report to get values for the various budgets
    4. 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!!!:

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.

  1. Go to https://sa.www4.irs.gov/epostcard/ and login using the info from VaultWarden
  2. Click on MANAGE E-POSTCARD PROFILE
  3. Make sure our EIN is correct, and click on CREATE NEW FILING
  4. Select the proper EIN (there should be only one)
  5. Answer that we haven't gone out of business (I hope!) and that we normally have gross receipts less than $50,000.
  6. Skip the DBA names on the next form
  7. Enter in our organization details (be sure to use official postal addresses from https://www.usps.com/)
  8. For the principal officer, enter the name of the current treasurer, and our business info again (not their personal address)
  9. 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?