Skip to main content

How to export settlements to QuickBooks Desktop

Get a settlement ready in ConnectBooks and bring it into QuickBooks Desktop with the Web Connector.

A settlement is a payout from the marketplace. ConnectBooks gets each one ready, and the QuickBooks Web Connector brings it into QuickBooks Desktop.

Haven't connected QuickBooks Desktop yet? See How to connect your QuickBooks Desktop file to ConnectBooks.

Before you start: close all open windows in QuickBooks and switch to single user mode. This helps the import go smoothly.

Step 1: Get the settlement ready in ConnectBooks

  1. Go to Accounting Export and pick a store.

  1. Click the green Export button in the Settlement column. The status changes to "Syncing...".

Some stores also have a COGS column (product costs). It exports on its own. See How the settlement and COGS exports work.

Step 2: Bring it into QuickBooks Desktop

  1. Open your QuickBooks Desktop company.

  2. Click File, then Update Web Services.

  1. The Web Connector opens. Tick the box next to your company.

  2. Click Update Selected.

After a few minutes, the status in ConnectBooks changes to "Exported".

Frequently asked questions

It says "Syncing..." and doesn't change.

Run the Web Connector again (Step 2). The settlement goes in only when the Web Connector runs.

I see a warning instead of the Export button.

Click it, then click Fix next to each issue. See How to export settlements to QuickBooks Online for the list of warnings. They're the same.

Can this happen on its own?

Turn on Auto Sync to get settlements ready by themselves. You still need the Web Connector to run. See Auto Sync for QuickBooks Online.

I ran the Web Connector, but the settlement didn't come into QuickBooks.

Make sure only 1 QuickBooks company file is open, and that it's the file connected to ConnectBooks. Then run the Web Connector again.

Did this answer your question?