These settings tell ConnectBooks where to put each store's numbers in QuickBooks. You set them once when you add a store. You can change them later under Stores & Files.
Channel Name
ConnectBooks puts all of this store's sales under 1 customer in QuickBooks. We create it for you and name it "CB-" plus your store's name, like "CB-My Amazon Store". Pick a different one if you want. Amazon stores on Diamond or Platinum (not Lite) pick 2: 1 for FBA and 1 for FBM.
Sales and Fee Breakdown
This sets whether QuickBooks shows your fees by product, by category, or as 1 summary. Only ConnectBooks support can change this. The default is Summary.
Item: by product. Diamond and Platinum only (not Lite).
Category: by product category.
Summary (recommended): 1 summary, no product detail.
Bank Account and Credit Card
Pick the bank account the marketplace pays you into, and the card it charges when you owe money. You can change these any time.
Accounts Receivable
This is where QuickBooks tracks money owed to you. We pick it for you. Change it only if you have more than 1.
Breakdown QuickBooks Invoices
On Diamond and Platinum (not Lite), choose how sales are grouped into invoices:
Weekly: 1 invoice a week.
By Settlement (recommended): 1 invoice per payout. If a payout crosses into a new month, it's split into 2.
Multi-Currency
Only for Amazon stores that sell in a different currency. Choose which currency to use in QuickBooks. If your QuickBooks only uses 1 currency, pick "Convert to other currency" and we'll convert it for you. If it uses more than 1, you can pick "Export with home currency".
Track Inventory
Diamond and Platinum (not Lite): "Yes" means QuickBooks tracks each product's stock. If "Yes" is greyed out, inventory tracking is off in QuickBooks. Turn it on there, then sync QuickBooks in ConnectBooks.
Gold: during setup, you pick 2 accounts:
Default Asset Account: goes down when a product sells.
Default COGS Account: goes up when a product sells.
Want only sales and fees in QuickBooks, without product costs? On the Accounting Export page, turn off the "Import Cogs to QuickBooks" switch.
Calculate Profit (Diamond and Platinum, not Lite)
Not for Shopify stores. Shows only when Track Inventory is Yes.
Gross (recommended): sales and fees on separate lines.
Net: sales after fees.
QuickBooks Item Name Mapping (Diamond and Platinum, not Lite)
How each product is named in QuickBooks:
ASIN: by the marketplace ASIN.
Sku: by the marketplace SKU.
Custom (recommended): you match each SKU to a product in QuickBooks. See How to map marketplace SKUs to QuickBooks items.
With ASIN or Sku, ConnectBooks adds a new product in QuickBooks whenever it sees one that isn't there yet.
Advanced Mapping
This shows which QuickBooks account each sale and fee goes to. We set it up for you.
First column: the sale or fee.
Second column: the account it goes to now.
Third column: pick a different account if you want.
The list shows every possible fee, even ones your store never gets. ConnectBooks only creates an account when a fee actually happens.
To change many at once with Excel, click "CSV Bulk Update". You can download our template or upload your file.
When you're done, click "Save & Complete Setup".
That's it. For more options, see "Advanced QuickBooks Export Settings Explained". Contact support with any questions.
Frequently asked questions
Where do I find these settings later?
Go to Stores & Files and click the store. On the Accounting tab, under Accounting Settings, click Settings. Most settings are on the QuickBooks tab. Track Inventory, Calculate Profit and Item Name Mapping are on the Inventory Settings tab (Diamond and Platinum plans, not Lite). Advanced Mapping has its own tab.
Why is "Yes" greyed out under Track Inventory?
Inventory tracking is off in QuickBooks. Turn it on there, then sync QuickBooks in ConnectBooks.