If you run a P&L report in QuickBooks and notice that the numbers don't match those in ConnectBooks, follow these troubleshooting steps:
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.
By following these steps, you can effectively troubleshoot and resolve discrepancies between sales data in QuickBooks and ConnectBooks.