Advanced Mapping lists every fee the marketplace charges you and shows which account it goes to in QuickBooks or Xero. Our accountants set the defaults, and most sellers keep them.
Where to find it
During setup, it's the last step. Click "Save & Complete Setup" when you're done.
Any time later: go to Stores & Files and click your store. On the Accounting tab, under Accounting Settings, click Settings. Then click the Advanced Mapping tab.
How fees get into QuickBooks
ConnectBooks sends sales as invoices and credit memos. These can only hold items, so each fee becomes a service item, and each service item is linked to an account.
ConnectBooks only creates items for fees that show up in your settlements. If you already have an item or account with the same name, it uses that one.
If your store sends journal entries, or you use Xero, there are no items. Each fee goes straight to an account.
The columns
Column | What it means |
Default Item / Fee Description | The item ConnectBooks uses for this fee, and the marketplace's description. |
Default Account / Account Type | The account the fee goes to by default. |
Override QuickBooks Item (or Override Account) | Pick your own item or account instead. |
New Account / Account Name | The account linked to the item you picked. |
On some plans, a Default Accounts row at the top shows your default Asset and COGS Account (and Income Account if you track inventory). On other plans, set these on the Inventory Settings tab.
Use the search box or the Account Type filter to find a fee fast.
Change where a fee goes
Best way: keep the default item, then open that item in QuickBooks and change its account. QuickBooks updates past entries that used it too.
Or: in the Override column, pick your own item (or account) and click Save.
Only items set to type Service show in the list. Other Charge or Inventory items won't appear.
Changed your mind? Click Restore Default on that row.
Many at once: click CSV Bulk Update, download the Advanced Mapping Template, fill it in, and upload it.
Frequently asked questions
I don't see my item in the Override list.
It's not a Service item. In QuickBooks, change its type to Service, or make a new Service item.
Can FBA and FBM fees go to different accounts?
Yes, for Amazon, Walmart and TikTok. On the store's QuickBooks tab (or Xero tab), click Configure Advanced Settings, tick "Set Separate Account Mapping per Fulfillment Channel", and click Save. Advanced Mapping then shows separate FBM columns.
Do I have to change anything?
No. The defaults work for most sellers.