Difference between revisions of "Quickbooks"
Jump to navigation
Jump to search
Line 18: | Line 18: | ||
* Frequency: Weekly | * Frequency: Weekly | ||
− | * | + | * Use the following categories for categorizing expenses: |
− | ** | + | ** Education: |
− | ** | + | Thes |
− | ** Supplies & Materials | + | ** Equipment Purchases: |
+ | ** Maintenance: | ||
+ | ** Supplies & Materials: | ||
+ | ** Tools: | ||
+ | * 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 | ||
+ | ** Hot Metals |
Revision as of 19:30, 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 the following categories for categorizing expenses:
- Education:
Thes
- Equipment Purchases:
- Maintenance:
- Supplies & Materials:
- Tools:
- 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
- Hot Metals