When your Amazon Advertising account is linked in ConnectBooks, ConnectBooks pulls the spend for each product from Amazon and brings in your Sponsored Products costs split by class.
This works when all of these are true:
The store is an Amazon store.
Class tracking is on. This needs QuickBooks Desktop or QuickBooks Online Advanced, or an override from our support team.
"Import advertising by item class in QuickBooks and wash it out" is ticked in the store's settings.
Enable Net Wash is not ticked.
Ad spend taken out of the settlement is imported as 1 total amount with "Amazon fees" as the class.
We recommend that you also record your credit card spend for Amazon Sponsored Products with the same "Amazon fees" class. This makes your reports clearer.
Note: ConnectBooks doesn't record ad charges paid by credit card, because most sellers use different cards.
ConnectBooks also brings in a separate "wash" invoice with your settlement data. This is an invoice with a $0 balance that brings in your ad spend split by class.
How the wash invoice works
First come the per item lines: 1 line for each item advertised in that period, each with the Sponsored Products item. Each per item line shows that item's ad spend as a negative amount, with that item's class in the class column. The date range is in each line's description.
After those comes the total (wash) line: the Sponsored Products item with a positive amount for the total ad spend. Its class is "Amazon fees".
The invoice balance is $0, because the total line cancels out the per item lines.
Frequently asked questions
Why don't I see the wash invoice?
Check that the store is an Amazon store, class tracking is on (this needs QuickBooks Desktop or QuickBooks Online Advanced, or an override from our support team), "Import advertising by item class in QuickBooks and wash it out" is ticked, and Enable Net Wash is not ticked.
Does ConnectBooks record ads I paid by credit card?
No. Record those yourself with the "Amazon fees" class.