Quickbooks: Difference between revisions

Revision as of 13:30, 22 September 2015

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

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

@@ Line 18: / Line 18: @@
 * Frequency: Weekly
-* There is a top level expense category for each of the area host responsibilities, each of which contain subcategories:
+* Use the following categories for categorizing expenses:
-** Expenses
+** Education:
-** Tools
+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