Connect your Google Ads account to automatically import advertising costs into your profit and loss reports.
Step 1: navigate to the Integrations page
In the left navigation, click Integrations, scroll to the Advertising section, and click Connect next to Google Ads.
Step 2: Authorize with Google
Click Connect Google Ads, sign in to your Google account, and click Allow to grant ConnectBooks access.
Step 3: Map your store
You'll see a table with your connected stores. For each Shopify store running Google Ads, fill in three fields:
Google Ads Customer — Select the Google Ads account linked to that store.
Mapping Rule — How ConnectBooks matches ad spend to your products:
If you are using Shopify's native Google integration → select Internal Product ID
Using a third-party feed tool → select whichever ID that tool uses to identify your Shopify products (check your feed tool's settings if unsure)
Start Date — The date ConnectBooks should start importing ad spend from.
Stores you don't advertise on Google can be left blank.
Once connected, Google Shopping ad spend appears in your Profit & Loss report by under ad spend. The ad spend will not be sent to QuickBooks, its for reporting purposes only.
Google Ads is currently supported for Shopify stores only.
Note: Only Shopping campaigns (including Performance Max retail) are currently supported — Search, Display, and other campaign types aren't supported.
See: How to Compare Google Ad Spend to ConnectBooks.