If you've run a report in QuickBooks and the sales and fees match, but there's a difference in the Cost of Goods Sold (COGS) between QuickBooks and ConnectBooks, follow these troubleshooting steps:
If You Track Inventory in QuickBooks:
Sync Average Cost: Ensure the average cost is synced between QuickBooks and ConnectBooks.
Check Report Settings in ConnectBooks: When running reports in ConnectBooks, select the Average Cost option. Also, if you're using prep costs on ConnectBooks, ensure that Ignore Prep Cost is selected.
Verify Item Mapping: If you modified the mapping of items in QuickBooks after exporting settlements from ConnectBooks, you’ll need to:
1. Delete the previously imported data in QuickBooks.
2. Re-import the settlement with the updated mapping to ensure accuracy.
If You Don’t Track Inventory in QuickBooks:
Cost Changes in ConnectBooks: If you changed the cost in ConnectBooks after exporting the settlement to QuickBooks, you will need to manually update the COGS in QuickBooks to match the updated cost in ConnectBooks.
By following these steps, you should be able to resolve discrepancies in COGS between QuickBooks and ConnectBooks.