Transferring Sales for Multiple Locations, Into One QuickBooks Account

You can update your Commerce Sync settings to differentiate what Commerce Sync transfers for each of your locations.

  1. Set up a Customer for the locations: In your accounting solution, create or identify distinct Customers for each location. For example, one would be called "Square/Clover Customer Uptown" and the other "Square/Clover Customer Downtown". 

  2. Create Accounts and Items to use for the settings specific to each location
    1. If using "single income account" for the sales setting (not sales by category)
      • Create an account per location similar to "Square/Clover Sales XXXXXX" (where X's is location name)
      • Create an item per location similar to "Square/Clover Item XXXXXX" (where X's are location name)
        • Assign previously created "Square/Clover Sales XXXXXX" account in the item information
    2. Create similarly named accounts/items for Discounts, Refunds and Tips (if you need these broken out per location)

  3. If using the sales by category setting, you will most likely want to rename the categories in Clover/Square to be location specific (IE. Square/Clover Food Uptown)

  4. Set up the tax rates:
    • This step only needs to happen if your need your sales tax broken down to be reported using a separate tax rate in QuickBooks.
    • In your point of sale system, specifically create or identify your sales tax rates. For example, one tax rate would be called "Uptown City Tax Rate" and the other would be called "Downtown City Tax Rate".
    • You will then, mimic these rates, with the exact names from your POS into your accounting solution.
    • Refer to this article for questions on multiple tax rates.
  5. Install Commerce Sync in your other locations. For QuickBooks Desktop users, please see this article on adding new locations.
  6. Once you are installed and connected, open up your Commerce Sync Dashboard, access the Settings and update that location to have the Customer your created in Step 1.

Commerce Sync will transfer the sales for that location, into the company file, under the newly created Customer. You can customize your P & L to have the Customer break-down to see the locations broken out there.



Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request
Powered by Zendesk