Finances: Difference between revisions

From All Hands Active Wiki
Jump to navigation Jump to search
← Older editNewer edit →
VisualWikitext
Mike (talk | contribs)
46 edits
No edit summary
Mike (talk | contribs)
46 edits
Remove super-old inaccurate info. Use the edit history if you really want to dig into the archives.
Line 137: Line 137:


TODO: link to tax forms, deadline info.
TODO: link to tax forms, deadline info.
= Old Stuff (Again) =
1) Get access to the following documents:
* [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
* [https://docs.google.com/spreadsheets/d/1nmBlOhzfKyTFV-xRB_3NdgiWyUTeuFgAT4F9FEB6juQ/edit?usp=sharing Instructions for updating our Finances]
3) This is all done (primarily) on the HP Touchscreen Computer currently located by the Craft Section!
=Policies=
==Reimbursement==
'''<$25 expenses'''
* 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)
* 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=
==Recurring Bills==
This is not a complete list!
# Rent: $1,311.28 Check written out to MTBU, to be delivered by the 3rd of every month to University Towers at 536 S Forest Ave, Ann Arbor, MI 48104
## That amount will increase every year. The amount of $1,311.28 is valid from ~June of 2014 to ~May of 2015. Please see a copy of our lease for payment schedules.
## Dena Isley is our point of contact there. She can be reached via: (734) 761-2680
# iQguys: $247.02 Check written out to iQguys, to be delivered by the 7th of every month to Ryan Dibble, 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=
==Monthly Financial Reports==
# [https://docs.google.com/folder/d/0B9x4RIcqwUojdjI3UFJuQ01Yekk/edit Our Finances], updated monthly!
==Where does money typically come from?==
# Credit/Debit Payments at the shop
## Tracked via Square
# Cash at the shop
## 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?==
# Membership
# Workshops / Classes
# Concessions (Snacks/Beverages)
# Donations
# Arduino Kits
=Old information below=
==Result / Status of meeting==
===She Recommended===
# 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)
==A fun conundrum==
* 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
** Filing annual income tax forms as a for profit corporation makes it much harder to then apply to become a non profit 501c3.
* If we don't file any annual income tax forms within 3 years from our initial incorporation date (January 2010), the IRS gets upset.
* Turnaround time for 501c3 forms is typically >6 months from when we submit it to the IRS.
* 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.
* If our intent is to become a <some regular for profit corporation>, we need to file annual income forms & more ASAP.
==Responsibilities we need filled yesterday==
# Someone to find a reputable Corporate/Tax Attorney to communicate our situation with
# 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.
=Notes setup prior to meeting=
==She requests==
# 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.
==Our questions==
# 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:==
* [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]
==2010 P&L - Basic Breakdown==
<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
Exp: BF 2010 $      Bright Futures Classes (Independent Contractor Payouts)
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: $
</pre>
==2011 P&L - Basic Breakdown==
<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
Exp: BF 2011 $7500    Bright Futures Classes (Independent Contractor Payouts)
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
</pre>
==2012 P&L - Basic Breakdown January 1st - April 30th==
<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
  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>

Revision as of 16:31, 26 October 2019

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. Thankfully Freshbooks makes this much easier.

You should use Freshbooks to:

  • Mark recurring invoices paid (when you deposit checks)
  • Add invoices for cash/check income (donations, classes, memberships) and mark them paid
  • Add invoices for membership subscriptions (PayPal) and mark them paid
  • Add expenses which can't be automatically imported (PayPal fees)
  • Generate monthly reports
  • Verify that deposits seen in our bank account match with income recorded in our invoices

The complicated part right now is inspecting PayPal transactions. PayPal takes their fee before sending to our bank account, so we need to examine PayPal activity to accurately account income, and PayPal fees. This generally looks like:

  1. Review that month's PayPal activity, logging payments for membership in the "Membership Subscription" invoice.
  2. All other payments are donations, those go in the "Cash Donation" invoice.
  3. Log the total sum of PayPal fees as an expense for that month.

Invoices

We use recurring invoices for corporate members, and manually create invoices for other income: cash/check income, and PayPal income. These both fluctuate, but still have to be tracked. All income must be tracked with invoices.

Membership Subscriptions

This tracks our income from non-corporate members. Each month should have an invoice for "Membership Subscriptions", with date of issue and due date set to the last day of the month. This tracks how much income we have from members. This includes all membership payment methods; cash, check, and PayPal.

When you deposit cash/check membership payments, just add a line for them in the invoice. PayPal membership subscriptions take a little bit more work, because PayPal takes their fee _before_ they dispense the money to our bank account.

  1. Download a CSV report of that month's activity from PayPal
  2. Open the CSV report in a spreadsheet program. We'll be using LibreOffice Calc
  3. Select the first row, then autofilter with *Data > AutoFilter*
  4. Only view transactions that are membership payments
    • Type column > no "Auto Sweep", "Donation Payment" or "General Payment"
    • Make sure a payment is for a membership subscription. Some members may manually pay, and thus not have their payment in the "Subscription Payment" Type
  5. Select the "Gross" column. The Sum is automatically calculated and show in the bottom right, next to "Average"
  6. Add this sum as a line item called "PayPal" for this month

"Cash" Donations

Each month should have a draft invoice for "Cash Donations", with date of issue and due date set to the last day of the month. Every donation in a given month gets a line in here. This covers one-time events such as Penguicon, and is a bit of a catch-all.

When we deposit a donation, add a line item for it, such as "Laser Class" or "Donation". Add a payment for the invoice, since you've just deposited it. At the end of the month, no more donations can happen for that month, so it can be considered "done", start one for the next month.

If you notice online donations (directly deposited, FB, Amazon Smile, PayPal, ...), make lines them too. This can look like a deposit in our bank account from Facebook, or directly from an individual. You will need to check PayPal manually, not just look at the bank account.

  1. Download a CSV report of that month's activity from PayPal
  2. Open the CSV report in a spreadsheet program. We'll be using LibreOffice Calc
  3. Select the first row, then autofilter with *Data > AutoFilter*
  4. Only view transactions that are income that aren't membership payments
    • Type column > no "Auto Sweep" or "Subscription Payment"
    • Make sure a payment is a donation. Some members may manually pay, and thus not have their payment in the "Subscription Payment" Type
  5. Select the "Gross" column. The Sum is automatically calculated and show in the bottom right, next to "Average"
  6. Add this sum as a line item called "PayPal" for this month

Recurring Invoices (Corporate Memberships)

These are currently only for corporate memberships. They get the invoice automatically sent, and reminders if they're late on payment. When we get paid for an invoice, we mark it paid in Freshbooks. All that's necessary is updating these recurring invoices when corporate memberships change.

Billing happens differently for our corporate members. This is important because the accounting will be different for them:

  • Nostrum pays by check. Get it in the mail, deposit it. If the amount changes, change the Freshbooks invoice.
  • Spark is charged by us via Forte. We get the money automatically, and the processing fee shows up as an expense in our bank account (and is automatically imported). If the amount changes, change both the Freshbooks invoice, and the Forte recurring charge.

Expenses

Expenses are automatically imported from our bank account, but there's still some work we need to do.

  • Review imported expenses for duplicates, and make sure they're properly categorized (client/type)
  • Add expenses which must be manually created
    • PayPal processing fees

Here's one way to calculate the PayPal expenses for a month. This must be done because PayPal takes their fees out before sending to our bank account, so we don't automatically import that expense.

  1. Download a CSV report of that month's activity from PayPal
  2. Open the CSV report in a spreadsheet program. We'll be using LibreOffice Calc
  3. Select the first row, then autofilter with *Data > AutoFilter*
  4. Only view transactions that have fees
    • Type column > no "Auto Sweep"
  5. Select the "Fee" column. The Sum is automatically calculated and show in the bottom right, next to "Average"
  6. Add this sum as a PayPal Fee for this month
    • Set the Vendor to PayPal
    • Set the category as "Bank Fees"
    • Enter the total

Balancing the Books

Download a CSV of activity on our bank account for that month. We want to make sure that all money going in and out is accounted for.

  1. Download a CSV report of that month's activity from the bank
  2. Open it in LibreOffice Calc
  3. Log in to Freshbooks to review invoices/expenses
  4. Go down the transactions making sure credits are accounted for in one of that month's invoices that are marked paid, and debits are accounted for in an expense
    • Expenses should be automatic
  5. If there's a transaction in the bank account that isn't accounted for in Freshbooks, start doing detective work to figure out what's going on!
    • Sometimes there are small discrepancies because transactions only happen on business days. eg: PayPal payments at the end of the month.

Reports

At the start of each month, we should make sure the previous month's accounting is completed, and make reports on it for the board/members/public. This is easily done through Freshbooks. Do this before the board meeting, so that any financial talk that happens can be informed.

  1. Log in to Freshbooks
  2. Navigate to Reports
  3. Make a Profit & Loss report for only the last calendar month
    • Set a custom time range to the previous month
  4. Save a presentable copy. I do this by printing to a file
  5. Upload the file to our public financial reports folder for the corresponding year/month
  6. Do the same for an Expense report
  7. Do the same for any other reports we've decided to do.
  8. Send and email to the member's list with a summary of the reports, notable activity, and important take-aways, and links to the reports.

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!!!

Income

If we make 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. Use our records in FreshBooks to get the numbers for the paperwork.

TODO: link to tax forms, deadline info.

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.

Retrieved from "https://wiki.allhandsactive.org/index.php?title=Finances&oldid=5835"