Summary Transaction

Introduction

If you have several orders a day, Connex can summarize them into a single order. Connex can create summaries for each store.

What are the benefits?

Here are the benefits:

  1. Save space: Instead of several hundred, you have a handful of orders.
  2. Track inventory: Inventory will decrease. The COGS account for each item is debited and the inventory asset account is debited.
  3. Track Income: The sales account is credited and the undeposited funds is debited.
  4. You will get one sales receipt per day per sales channel. If you use ShipStation and you have three channels, then you would sync three sales receipts.

How do I download a day to summarize?

Here are the steps:

  1. On the configure page, select summary transaction from the transaction drop down.
  2. Scroll down to export settings.
  3. Choose a date range to summarize. We recommend a twenty-four hour period like 6/11/2016 to 6/11/2016 11:59 PM.
  4. By default, Connex syncs orders by their creation date. You can sync orders with a certain status, though you might have issues reconciling. Go to the order export to QB tab. In the order status field, enter some statuses.
  5. To run the sync automatically each morning, check the insert orders in bulk on the advanced tab. To run the sync manually, leave this field unchecked. We recommend checking the box, if you are a Bigcommerce customer. 
  6. Click submit.
  7. If you checked insert orders in bulk, wait about 15 - 20 minutes.
  8. On the web connector, check the box to the left of Connex.
  9. Click update selected.

Does the process run automatically?

Here is how it works:

  1. Connex has a scheduled task, separate from your QB, that runs at 5 am EST.
  2. The task pulls down all orders by creation date from yesterday using MM/DD/YYYY 12:00 AM to MM/DD/YYYY 11:59 PM.
  3. Your web connector runs and pulls down these orders.
  4. Even if the web connector runs hourly, the queue is empty until 5 am EST the next day.

How do I clear the queue and start again?

If you accidentally downloaded more than one day, you can clear the queue and start again. In this example, we will download June 16, 2016 again:

  1. Login to Connex.
  2. Choose your connection at the my connections page, if you have more than one. Otherwise, click submit.
  3. Hover over the gear and click reports.
  4. Click pending transactions.
  5. Click clear pending transactions.
  6. Repeat step two.
  7. On the configure page, scroll down to export settings.
  8. Change the export after date to 6/16/2016 12:00 AM and the before date to 6/16/2016 11:59 PM.
  9. Click submit.
  10. On the complete page, click view transactions on the pop up.
  11. Refresh the page every five minutes, until you see orders.
  12. In QB, run your web connector.

Do you support multiple currencies in the same selling channel?

Cloud Cart can group orders by their deposit account, which can change based on the order currency. Each currency needs its own deposit account. In this example, we will summarize four orders. Two of them belong to Amazon FBA, but they use Euros instead of Canadian Dollars. Here is the set-up:

QuickBooks

You must create deposit account:

  1. In QB, go to lists and click chart of accounts.
  2. Click new.
  3. Select other account types.
  4. Select other current asset and choose the currency code. Name the account EUR Deposits.

Connex

  1. Hover over the gear and click rules engine.
  2. Add a rule to map deposit accounts for each currency. If you are creating a summary invoice, choose map deposit account to invoice. Here is an example rule.
  3. On the Connex configure page, choose store name currency as the customer mode. Connex will append the currency code to the selling channel name in QB.
  4. Change the sync dates under export settings to a one day range, like August 13th to August 13th 11:59 PM.
  5. Scroll to the bottom and choose a default deposit account for your home currency. In this case, we will use undeposited funds.
  6. Click submit.

Sample

Here is an example transaction using multi-currency and here is another sample transaction without using it.

Have more questions? Submit a request
Powered by Zendesk