How do I reconcile my data from my PetExec QuickBooks export?


While PetExec tech support cannot reconcile your data from PetExec to QuickBooks, we do recommend the following.

PetExec defines "invoices" in QuickBooks as "orders without payments".  "Payments" are your balanced orders  with payments.

PetExec will include the order ID in the data files for Invoice and Payment Files. If you are having difficulty balancing, we recommend reviewing data by order number within PetExec.  

Keep in mind the following:

  • Orders can be modified and/or deleted in PetExec.  If an order is modified  or deleted after a data export file is uploaded into QuickBooks, the order in PetExec will no longer match the data from the prior export file.
  • When trying to reconcile, it may be helpful to note the date on the PetExec order, the date of the file export was completed and uploaded in QuickBooks, and any order modifications or deletions.
  • You can review orders from the PetExec menu under Order Processing-->Modify Orders.   You can search by owner name first name, last name, email address or order number.
Last Modified: Wednesday, December 05, 2018 at 04:39 PM