Quickbooks: Difference between revisions
From Pumping Station One
No edit summary |
|||
| Line 13: | Line 13: | ||
** 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 == | |||
* Frequency: Weekly | |||
* There is a top level expense category for each of the area host responsibilities, each of which contain subcategories: | |||
** Expenses | |||
** Tools | |||
** Supplies & Materials | |||
Revision as of 13:16, 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
- There is a top level expense category for each of the area host responsibilities, each of which contain subcategories:
- Expenses
- Tools
- Supplies & Materials
