These advanced settings control how ConnectBooks sends data into QuickBooks. They affect how clean your QuickBooks file stays, how much detail you see, and how inventory and fees are handled. Changing these without understanding them can cause reporting or reconciliation issues, so we recommend reviewing them carefully or speaking with ConnectBooks support first.
Export as Journal Entries
When enabled, ConnectBooks exports your data as journal entries when possible, instead of Invoices and credit memos.
Do Not Use Group ID as Journal Ref
ConnectBooks normally uses an internal Group ID as the journal entry reference to help match exports back to reports. Turning this on allows QuickBooks to assign its own reference number instead, which some accountants prefer for consistency.
Use Platform Specific Fee Items
Creates separate fee items in QuickBooks for each marketplace, such as Amazon fees versus Walmart fees. This gives clearer visibility into where fees are coming from and improves platform level reporting.
Use Inventory Adjustments Transaction Type in QuickBooks
Exports FBA inventory adjustments changes using QuickBooks native inventory adjustment transaction type rather than journals or invoices.
Import advertising by item class in QuickBooks and wash it out
Imports advertising spend by creating a class for each item, allowing you to see ad costs by item/class in QuickBooks. The amounts are then washed out so they do not impact net profit, since advertising is usually recorded as a single total charge on a credit card or payout.
Create extra SKU Field in QuickBooks
Adds a dedicated SKU field on invoices in QuickBooks.
Create items as subclasses in QuickBooks
This creates a class for each item sold. If a category already exists, it will be used as the parent class, and each item will be created under it as a subclass.
Create Custom Fields in QuickBooks Desktop for Group ID
Automatically creates custom fields in QuickBooks Desktop to store internal ConnectBooks identifiers such as Group ID, transaction types, These fields help with support, audits, and troubleshooting.
Allow editing QuickBooks Docs date before export and mark settlements as exported
Adds a field that lets you adjust transaction dates in QuickBooks docs and mark groups as exported. This is useful when fixing past exports or when an accounting period is locked in QuickBooks.
Combine Chargeback Fees
Groups all chargeback related fees into a single line instead of exporting each one separately. This simplifies fee reporting and keeps journals shorter.
Do Not Import Cogs to QuickBooks
When this is enabled, we will not import the cost of goods sold to QuickBooks.
Import collected and remitted tax amounts
Separates sales tax collected from customers and sales tax remitted by the marketplace, instead of importing only the net amount which is usually zero. This gives clearer visibility into tax activity and makes reconciliation easier.
Split adjustments into positive and negative entries
Imports positive and negative adjustments as separate entries instead of a single net amount, making adjustments easier to review and audit.
Import Listing Prep Cost to QuickBooks
Sends prep costs entered on the listings page into QuickBooks. This should only be enabled if those costs are not already being recorded separately as expenses in QuickBooks, such as labor.
Enable Net Wash
Exports sales as net amounts by item. A separate journal entry is created to offset the difference between gross and net. This is useful if you want sales recorded net in QuickBooks while still matching Amazon 1099 totals.
Allow Multi Select Delete and Re Export to QuickBooks
Allows you to select multiple settlement exports, delete them, and re export in bulk. Helpful when fixing mappings or correcting setup issues.
Require Custom Advanced Mapping
This setting requires you to set a custom chart of accounts mapping for every fee type before exporting. If even one fee is missing a custom mapping, the export will not run. This ensures nothing is sent to QuickBooks using the ConnectBooks default accounts and gives you full control over where each account posts in QuickBooks.
Set Separate Account Mapping per Fulfillment Channel
Allows different QuickBooks accounts for FBA, FBM, WFS, and other fulfillment types. This improves reporting by fulfillment method.
Allow Export with Negative Inventory
Allows exports even if inventory is negative in ConnectStock. This can be useful during setup or cleanup but should be used cautiously to avoid inventory inaccuracies.