Finances: Difference between revisions

From All Hands Active Wiki
Jump to navigation Jump to search
No edit summary
 
(14 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 is out of date. This page should serve to document how we keep track of finances at AHA.  
This page should serve to document how we keep track of finances at AHA. This is necessary for running AHA.
=For Staff=
So you want to help? You are awesome!


1) Get access to the following documents:
This is the responsibility of the Finances committee, and the Treasurer.
* [https://drive.google.com/folderview?id=0Bx1lMULI24OBZmllV1pFVUd5MWM&usp=sharing Non Public Finances]
* [https://drive.google.com/folderview?id=0B9x4RIcqwUojdjI3UFJuQ01Yekk&usp=sharing Public Finances]


2) Check out the instructions
=Responsibilities=
* [https://docs.google.com/spreadsheets/d/1nmBlOhzfKyTFV-xRB_3NdgiWyUTeuFgAT4F9FEB6juQ/edit?usp=sharing Instructions for updating our Finances]
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.


3) This is all done (primarily) on the HP Touchscreen Computer currently located by the Craft Section!
* 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!


=Reimbursement=
=Accounting=
'''<$25 expenses'''
This is crucial! Accurate accounting lets us file taxes, make projections, track invoices, be transparent about our finances, and generally function.  
* Purchase Supplies (Paper Towels, Toilet Paper, etc., stuff the shop '''needs'''.
* Get Receipt.
* Put your Name, Date, total amount you were reimbursed for, and the Company (if it's not easily visible) on the receipt.
* Put receipt in manila filing folder located behind desk/next to glass case labeled "2014 Receipts"
* Take money from register that you are being reimbursed for.


'''>$25 expenses''' (or more than we have money in the register for)
==== Getting Started ====
* Everything is the same as above except reimbursement has come via Paypal or Check to the person being reimbursed.
* * This has largely been handled by Josh or current acting treasurer.


=Expenses=
# Log in to quickbooks (https://app.qbo.intuit.com/app/homepage) (credentials available in vaultwarden)
==Recurring Bills==
# View transactions    ----    Transactions>Bank Transactions
# Rent: 1,311.28 Check written out to MTBU, delivered by the 3rd of every month to University Towers at 536 S Forest Ave, Ann Arbor, MI 48104
# Update transactions.....wait.... reload page
## That amount will increase every year. This amount is valid until ~May of 2015. Please see a copy of our lease for payment schedules.
# iQguys: $247.02 Check written out to MTBU, delivered by the 7th of every month to 228 Nickels Arcade, Ann Arbor, MI 48104
## This amount is paid until we have fully paid iQguys off, please see the purchase agreement for Digital Ops to find out when that is.
## Ryan Dibble is our primary contact: ryan dot dibble at gmail dot com if you need to contact them.
# Comcast: Automatically paid from our bank account
# Insurance: Automatically paid from our bank account on a quarterly basis


=Income=
==== Reconciling membership dues ====
==Monthly Financial Reports==
# [https://docs.google.com/folder/d/0B9x4RIcqwUojdjI3UFJuQ01Yekk/edit Our Finances], updated monthly!


==Where does money typically come from?==
# 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.
# Credit/Debit Payments at the shop
# 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.
## Tracked via Square
# 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
# Cash at the shop
# 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)
## Tracked via Square
# Paypal: One time payments
## Tracked via Paypal
# Paypal: Recurring payments
## Tracked via Paypal
# Checks
## Tracked via Square (previously was tracked at time of TCF deposit)


==What are people usually buying/paying for?==
==== Adding New Members ====
# Membership
# Workshops / Classes
# Concessions (Snacks/Beverages)
# Donations
# Arduino Kits


=Old information below=
# 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"


==Result / Status of meeting==
==== Check status of provisional members ====
===She Recommended===
This is important in order to know who is permitted to vote in elections
# Immediately find a corporate / tax attorney so that we can:
#* Review Purchase Agreement, primarily for the purpose of making sure our accounting methods are kosher w/501c3 desires.desires
#* Make sure that we are kosher with current status of State & Federal Filings
#** Our Articles of Incorporation were accepted on January 10th, 2010, according to the stamp (see link at bottom)
# Immediately begin work on filling out IRS 501c3 Forms
#* 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)


# 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"


==A fun conundrum==
==== Match Transfers to Bank Account ====
* 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.
Transfers between accounts are matched so that they are not recorded anywhere as an expense or income


* If we file annual income tax forms right now, we would be filing them as a for profit corporation
# Switch back to Transactions > Bank Transactions and then select Paypal
** Filing annual income tax forms as a for profit corporation makes it much harder to then apply to become a non profit 501c3.
# Find transactions labeled "Withdrawl to bank account" and click Match


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


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


* 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.
==== Checking accounts ====
Categorize expenses and create invoices using the same methods as the paypal account.


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


==Responsibilities we need filled yesterday==
==== Cleaning Up ====
# Someone to find a reputable Corporate/Tax Attorney to communicate our situation with
1: Check the two savings accounts to confirm any interest payments or transfers.
# 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.


==== Reporting ====


=Notes setup prior to meeting=
# Select "Reports" on the left hand menu. The important reports are under favorites. Run an "Accounts receivable aging" report to find outstanding invoices.
==She requests==
# 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.
# Existing financial records
## 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
#* 2012 - We can provide access to Quickbooks Online
# Both "Statement of Financial Position" and "Statement of Activity by Month" should be run and saved.
#* 2011 - Basic breakdown listed below
## 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.
#* 2010 - Unknown
## Click "run report" and the report will update.
# Strategic documents that would be helpful in defining how we set up your accounting records
## Click the export icon at the top right of the report, and select "export to PDF"
#* Income
## 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.
#** Memberships
## Repeat for the other report
#** Classes / Workshops
# Update the Monthly Report <nowiki>https://docs.google.com/spreadsheets/d/1fCZ2j8G5ZXTxQlR_fnR_BoUldrVSsgBDnbztHpAYgGw/edit#gid=1222700446</nowiki>
#** Donations
## 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
#** Time on PCs (Starting June 1st)
## 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
#* Expenses
## Run the Budget progress custom report to get values for the various budgets
#** Rent
## 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
#** 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.


= Taxes =


==Our questions==
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!!!:
# What forms should we be submitting to the:
#* City
#* State
#* Federal<br/><br/>
# What payments should we be submitting to the:
#* City
#* State
#* Federal<br/><br/>
# 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:==
* Michigan Treasury Online: https://mto.treasury.michigan.gov (sales tax, will probably just be filling in $0 everywhere).  Due by the end of February.
* [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]
* [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/.  


==2010 P&L - Basic Breakdown==
== Federal Income (form 990N) ==
<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
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.


Exp: BF 2010 $      Bright Futures Classes (Independent Contractor Payouts)
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'''!
Exp: Rent $
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: $
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!


</pre>
== Sales Tax (MI) ==


==2011 P&L - Basic Breakdown==
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.
<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
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.


Exp: BF 2011 $7500    Bright Futures Classes (Independent Contractor Payouts)
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.
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
TODO: link to tax forms, deadline info.


= Budgeting =


</pre>
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?


==2012 P&L - Basic Breakdown January 1st - April 30th==
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.
<pre>
Income
  Classes 237.27
      AHA Classes Income....... 4.942.52
      How to - 3D Print........ 71.30
      How to - Laser........... 47.33
      How to Arduino........... 104.09
      How to CNC............... 28.52
      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
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?
  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
 
Net Income -$619.99
</pre>

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?