Quickbooks: Difference between revisions
From Pumping Station One
No edit summary |
No edit summary |
||
| Line 18: | Line 18: | ||
* Frequency: Weekly | * Frequency: Weekly | ||
* Use the following | * Use only the following expense categories for area host and votes transactions: | ||
** Education (books, fees for 3rd party classes, online subscription fees) | ** Education (books, fees for 3rd party classes, online subscription fees) | ||
** Equipment Purchases (non-portable equipment/tools, software, associated licensing or maintenance subscriptions) | ** Equipment Purchases (non-portable equipment/tools, software, associated licensing or maintenance subscriptions) | ||
** Maintenance (break-fix and non-subscription routine maintenance costs/supplies/materials) | ** Maintenance (break-fix and non-subscription routine maintenance costs/supplies/materials) | ||
** Supplies | ** Supplies (normal operations consumables) | ||
** Tools (small and portable, reusable equipment) | ** Tools (small and portable, reusable equipment) | ||
* In Quickbooks, assigning a department to a transaction is optional, however, budgetary reports for area are generated by filtering by department so it is important to always select the department corresponding to the transaction as follows: | * In Quickbooks, assigning a department to a transaction is optional, however, budgetary reports for area are generated by filtering by department so it is important to always select the department corresponding to the transaction as follows: | ||
| Line 28: | Line 28: | ||
** CNC | ** CNC | ||
** Cold Metals | ** Cold Metals | ||
** Electronics | |||
** Kitchen | |||
** Hot Metals | ** Hot Metals | ||
Revision as of 14:09, 22 September 2015
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 expense categories for area host and votes transactions:
- Education (books, fees for 3rd party classes, online subscription fees)
- Equipment Purchases (non-portable equipment/tools, software, associated licensing or maintenance subscriptions)
- Maintenance (break-fix and non-subscription routine maintenance costs/supplies/materials)
- Supplies (normal operations consumables)
- Tools (small and portable, reusable equipment)
- In Quickbooks, assigning a department to a transaction is optional, however, budgetary reports for area are generated by filtering by department so it is important to always select the department corresponding to the transaction as follows:
- Votes
- CNC
- Cold Metals
- Electronics
- Kitchen
- Hot Metals
