<aside> 💡

After connecting QuickBooks, there are three things to map: your locations, one product used on bills, and your accounts. You'll also choose whether we send your vendor bills to QuickBooks. Mapping tells the integration exactly where in QuickBooks each dollar should land, so it's worth doing carefully (ideally with your bookkeeper). For what happens after mapping, see the QuickBooks Integration Overview.

</aside>

Locations Mapping

<aside> 💡

Every journal entry and bill the integration creates is tagged with a store location, so QuickBooks can report per location. First, enable "Track Locations" in your QuickBooks settings (see How to Connect QuickBooks). Then, in the "Locations Mapping" section of the QuickBooks Integration page in the Web app, match each of your store locations to the corresponding location in QuickBooks.

</aside>

Products

When the integration creates a bill or vendor credit in QuickBooks, it doesn't itemize every SKU on the shipment. Instead, each bill has a summary line for the merchandise total, which uses a Generic Product you set up in QuickBooks. If the shipment has a shipping cost, the bill also gets a line called Freight. Shipping is part of what your inventory cost you, so we post it to your inventory asset account (the account you mapped for Purchases). There's nothing extra to set up for it. (See How purchase orders become bills for the full picture.)

Note: the QuickBooks "Simple Start" plan doesn't allow creating products, so bills and vendor credits can't sync on that plan.

Step 1

You’ll need to first create one product in your Quickbooks account, a “Generic Product”, which we’ll then map in the POS settings page. This product is used to sync inventory asset values (purchases, COGS, etc) between POS and Quickbooks.

In Quickbooks, go to Sales→Products & Services

Screenshot 2024-09-11 at 12.38.22 PM.png

Then click “New Product”.

Screenshot 2024-09-11 at 12.38.43 PM.png

Create the Generic Product as a “non-inventory” type product.

Screenshot 2024-09-11 at 12.38.52 PM.png

Screenshot 2024-09-11 at 12.39.59 PM.png

Once the product is created, go into POS and reload the Account Mapping page. You should now see it as an option in the Generic Product dropdown.