Skip to main content

Fixing Cost (cogs) Differences Between QuickBooks and ConnectBooks

What to check when COGS in QuickBooks doesn't match ConnectBooks.

If you ran a report in QuickBooks and the sales and fees match, but the Cost of Goods Sold (COGS) is different between QuickBooks and ConnectBooks, follow these steps.

If you track inventory in QuickBooks

  • Sync average cost: make sure the average cost is synced between QuickBooks and ConnectBooks.

  • Check report settings in ConnectBooks: click Customize and set Cost Type to QuickBooks Historical Cost. If you use prep costs in ConnectBooks, also select Ignore Prep Cost.

  • Check item mapping: if you changed item mapping after exporting settlements from ConnectBooks, import the settlement again with the new mapping. On the Accounting Export page, open the ... menu at the end of the settlement row and click Delete from QuickBooks. Then open the same menu and click Resend to QuickBooks.

If you don't track inventory in QuickBooks

  • Cost changes in ConnectBooks: if you changed a cost in ConnectBooks after exporting the settlement, resend the COGS from ConnectBooks. On the Accounting Export page, open the ... menu at the end of the settlement row, click Resend to QuickBooks, then click COGS.

These steps should fix most COGS differences between QuickBooks and ConnectBooks.

Frequently asked questions

Which cost type should I use to compare with QuickBooks?

If you track inventory in QuickBooks, use QuickBooks Historical Cost.

I changed a cost after exporting. Do I need to edit QuickBooks by hand?

No. Resend the COGS from ConnectBooks with Resend to QuickBooks, then COGS.

Did this answer your question?