To export payments from Operate to Quickbooks Desktop Pro, please first make sure that you have configured both applications for the export, then follow the steps below. 

Step 1. Open Quickbooks and run a Trial Balances Report

This will give you the balances prior to the export. Email this to yourself and keep for post export reconciliation.

In Quickbooks go to the Report Centre > Accountant & Taxes and click on the Trial Balance report.

Step 2. Back up your Quickbooks

Prior to any export, you should always back up your Quickbooks database (in the event that the export might fail or an error determines the need to restore your data from the backup  Go to File and Create a Backup.

Step 3. Keep Quickbooks Open

Step 4. Check Account IDs and Payment GL Codes in Operate

In Operate, check that all accounts have Accounts IDs and all Payment GL codes have been entered.

Go to Operate and make sure that all of your Accounts have an account ID. 

  • Go to Member > Accounts.
  • Check the Accounts Id column to make sure that all clients have an ID. 
  • Go to Space > Products and make sure that all of your products have a GL code, by checking the corresponding column.  

NOTE: If you do not see the Account id / GL Code columns, you can add them in byediting the list view

Step 5. Run the Cash and Journals report in Operate

Go to Reports and filter for the Cash and Journals report, then run it. All Unbooked transactions will be included in the export. Keep the report as reference for reconciliation post export. 

Step 6. Conduct the export

Did this answer your question?