Difference between revisions of "Quickbooks"
Jump to navigation
Jump to search
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | |||
| + | == Update Balances == | ||
| + | * Frequency: Weekly | ||
| + | |||
| + | * Log into Quickbooks and navigate to Transaction->Banking | ||
| + | * Click Update. (It may be necessary to use the left right arrows to see the status of all bank accounts) After the update, verify success by looking for the word "moments ago" on the bottom right corner of each bank account section along the top of the page | ||
== [[PEX]] Reconciliation == | == [[PEX]] Reconciliation == | ||
| Line 13: | Line 19: | ||
** browse to the *.qbo file downloaded from PEX | ** browse to the *.qbo file downloaded from PEX | ||
** Select PEX in the dropdown for account | ** Select PEX in the dropdown for account | ||
| − | |||
== Transaction Categorization == | == Transaction Categorization == | ||
* Frequency: Weekly | * Frequency: Weekly | ||
| − | * Use the following | + | * Use only the following accounts for area host and votes transactions: |
| − | ** Education | + | ** Education (books, fees for 3rd party classes, online subscription fees) |
| − | + | ** Equipment (non-portable equipment/tools >= $1000, mandatory software and associated license fees, annual maintenance subscriptions) | |
| − | ** Equipment | + | ** Maintenance (break-fix and non-subscription routine maintenance costs/supplies/materials) |
| − | ** Maintenance | + | ** Software (including license fees) |
| − | ** Supplies | + | ** Supplies (normal operations consumables, small tools, materials) |
| − | ** Tools | + | ** Tools (non-portable equipment/tools < $1000, small and portable, reusable equipment) |
| − | * In Quickbooks, | + | |
| − | ** | + | * In Quickbooks, transaction class is associated with budgets. This field is optional so make sure the correct one is assigned: |
| − | ** CNC | + | ** Administrative (catch all classification) |
| − | ** Cold Metals | + | ** Arts & Textiles Area (Area host budget) |
| − | ** Hot Metals | + | ** CNC Area (Area host budget) |
| + | ** Cold Metals Area (Area host budget) | ||
| + | ** Electronics Area (Area host budget) | ||
| + | ** General Area (Area host budget) | ||
| + | ** Kitchen Area (Area host budget) | ||
| + | ** Hot Metals Area (Area host budget) | ||
| + | ** Votes (<year>): <vote name> (items associated to specific votes) | ||
| + | |||
| + | == Reconciliation == | ||
| + | * Frequency: Monthly (60 days after month-end) | ||
| + | |||
| + | ** Close out transactions for each month | ||
| + | ** Can be changed so long as year-end reconciliation has not been performed | ||
Latest revision as of 18:44, 20 October 2015
Update Balances
- Frequency: Weekly
- Log into Quickbooks and navigate to Transaction->Banking
- Click Update. (It may be necessary to use the left right arrows to see the status of all bank accounts) After the update, verify success by looking for the word "moments ago" on the bottom right corner of each bank account section along the top of the page
PEX Reconciliation
- Frequency: Weekly
- Log into Quickbooks and navigate to Transaction->Banking and select the PEX account
- Note the date of the last transaction
- Log into PEX and export to Quickbooks: https://admin.pexcard.com/#/admin/export/quickbooks
- Select a start date that is one day after the the last transaction in Quickbooks
- Select an end date that is yesterday (never choose the current date)
- If this range is > 3 months, then do this process multiple times with smaller date ranges
- In Quickbooks
- In the upper right corner, select Update->File Upload
- browse to the *.qbo file downloaded from PEX
- Select PEX in the dropdown for account
Transaction Categorization
- Frequency: Weekly
- Use only the following accounts for area host and votes transactions:
- Education (books, fees for 3rd party classes, online subscription fees)
- Equipment (non-portable equipment/tools >= $1000, mandatory software and associated license fees, annual maintenance subscriptions)
- Maintenance (break-fix and non-subscription routine maintenance costs/supplies/materials)
- Software (including license fees)
- Supplies (normal operations consumables, small tools, materials)
- Tools (non-portable equipment/tools < $1000, small and portable, reusable equipment)
- In Quickbooks, transaction class is associated with budgets. This field is optional so make sure the correct one is assigned:
- Administrative (catch all classification)
- Arts & Textiles Area (Area host budget)
- CNC Area (Area host budget)
- Cold Metals Area (Area host budget)
- Electronics Area (Area host budget)
- General Area (Area host budget)
- Kitchen Area (Area host budget)
- Hot Metals Area (Area host budget)
- Votes (<year>): <vote name> (items associated to specific votes)
Reconciliation
- Frequency: Monthly (60 days after month-end)
- Close out transactions for each month
- Can be changed so long as year-end reconciliation has not been performed