Skip to main content

How to Export Bills & Adjustments to QuickBooks

How ConnectStock sends your bills and adjustments to QuickBooks, and which accounts it uses.

Once your inventory file is linked to QuickBooks (see How to Connect Your Inventory File to QuickBooks), ConnectBooks can send your bills and adjustments there.

Which accounts are used

Every bill and adjustment goes into accounts in QuickBooks. If you set an account on a bill, an adjustment or an item, ConnectBooks uses it. If you didn't, it uses the default account for the whole file.

Set the file's default accounts: Go to Stores & Files, open Inventory Files, click the file, then click Accounting on the left. Click Edit, pick the account, then click Save.

Change the account on 1 bill or adjustment: Open it, click Edit, pick the account, then click Save. On an adjustment, the account is "Inventory Adjustment Account". On a bill, the account picker (Accounts Payable) is only there for QuickBooks Desktop files.

Set accounts for 1 item: Open the item, click Edit, pick its own inventory asset or COGS account, then click Save. ConnectBooks uses these whenever that item is bought, sold or adjusted.

Send 1 store's COGS to 1 account: You can send all ConnectStock COGS for a store to 1 account instead. In the store's Advanced Mapping tab, pick the account in Default COGS Account and turn on "Use the store's COGS account for ConnectStock". For that store, this takes the place of the item's COGS account and the file's default COGS account. See How to Send ConnectStock COGS to the Store's COGS Account.

What shows up in QuickBooks

Each line goes to an account, usually your inventory asset account. The item name and quantity are in the description. QuickBooks doesn't get a product to track.

For example, you buy $2,000 of books. When the bill goes to QuickBooks, your inventory account and the amount you owe both go up by $2,000. QuickBooks doesn't get a "Book" product. When the books sell, ConnectBooks lowers your inventory and raises your cost of goods sold by the right amount.

Bills keep their vendor, bill number and date, just like in ConnectBooks.

Attach the bill PDF

ConnectBooks can attach the bill's PDF to the bill in QuickBooks Online or Xero, so the original is right there.

It's turned on for you when you link the file. To check it, go to Stores & Files, Inventory Files, click the file, then Accounting. Look for "Export Bill PDF to QuickBooks" (or "to Xero").

This isn't available for QuickBooks Desktop. For Xero, you may be asked to reconnect so we can add attachments.

Before you export settlements

To avoid errors, make sure:

  • Every product is mapped to a ConnectBooks item.

  • Nothing is below zero. If a product shows negative stock, add the missing bill or an adjustment. Settlements can't go out until every cost is covered.

Frequently asked questions

Why don't I see my products in QuickBooks?

Each line goes to an account, usually your inventory asset account. The item name and quantity are in the description. QuickBooks doesn't get a product to track. Your product detail stays in ConnectBooks.

Why didn't my bill PDF show up in Xero?

Xero needs permission for attachments. Turn the setting on again and reconnect when asked.

My settlement won't export because of negative inventory.

Add the missing bill or an adjustment for that product, then try again. See "How to Troubleshoot Negative Inventory in ConnectStock".

Can 1 store send its COGS to a different account than my other stores?

Yes. Turn on "Use the store's COGS account for ConnectStock" in that store's Advanced Mapping tab and pick its Default COGS Account. See How to Send ConnectStock COGS to the Store's COGS Account.

Did this answer your question?