Difference between revisions of "Quickbooks"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
== [[PEX]] Reconciliation == | == [[PEX]] Reconciliation == | ||
+ | * Frequency: Weekly | ||
+ | |||
* Log into Quickbooks and navigate to Transaction->Banking and select the PEX account | * Log into Quickbooks and navigate to Transaction->Banking and select the PEX account | ||
** Note the date of the last transaction | ** Note the date of the last transaction |
Revision as of 18:31, 16 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