How to Troubleshoot Discrepancies Between QuickBooks and ConnectBooks

Run the Profit and Loss (P&L) report by customer in QuickBooks.

Since ConnectBooks imports each store's data into a separate customer, this lets you compare one store at a time to find the issue.

Verify all Settlements are in QuickBooks:

Ensure all settlements for the period in question are exported into QuickBooks, Confirm that even settlements spanning across two months are accounted for. For instance, if you're comparing January's report, ensure a settlement that started January 28th to February 10th is exported to QuickBooks when reviewing the full month of January.

To check for pending unexported settlements, select "Include open settlements" on the Accounting Export page.
​

Check Report Settings in ConnectBooks:

Ensure the report in ConnectBooks is set to "Posted Date." If it's set to "Order Date," switch it to "Posted Date" since the data in QuickBooks is based on the posted date.
​

​

Check for Open Balances:

Check for any open balances for the relevant customer in QuickBooks. The balance should always be zero. If there are any, resolve them accordingly or contact ConnectBooks support.
​

Ensure Settlements Were Not Manually Deleted in QB:

Verify that no settlements were manually deleted in QuickBooks. Check that all payments are reconciled and accounted for.
​

Ensure the settlement that includes the monthly storage fee is exported to QuickBooks.

This fee is usually billed the following month and backdated in QuickBooks and on the P&L report to the prior month (unless your account settings specify otherwise). If the settlement hasn’t been exported yet, the fee will appear in your ConnectBooks P&L but not in QuickBooks — which can cause the two reports to show different totals.
​

Manually Uploaded Fees:
Any fees you upload manually within ConnectBooks are reflected in the ConnectBooks P&L but are not exported to QuickBooks, leading to variances between the two systems.