Summary Transaction

Follow

Introduction

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

What are the benefits of creating a single transaction?

There are many 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. Easier reconciliation: You will get one invoice per day per sales channel. If you use ShipStation and you have three channels, then you would sync three invoice. Cloud Cart Connector will group invoices by the deposit account, so you can track sales by payment method.
  5. Automatic: Our software creates this invoice automatically for you, once a day, every day.  

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, Cloud Cart 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. Click submit.
  6. In Cloud Cart, hover over the gear and click transaction log in a few minutes.

How do I set-up the sync?

Here are the steps:

  1. On the configure page, select summary invoice from the transaction drop down.
  2. Scroll down to export settings.
  3. Adjust the export after to 12:00 am yesterday.
  4. Adjust the export before to 11:59 pm yesterday.
  5. Click save and sync.
  6. Cloud Cart will automatically reset the timers to tomorrow at the same time.

Do you support multiple currencies in the same selling channel?

Cloud Cart can group orders by their currency code and deposit account. 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 the gear box and click chart of accounts.
  2. Click new.
  3. Select other current asset for the type and sub type. Add the currency: 

Cloud Cart Connector

  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:
     dep_acct.png
  3. On the Cloud Cart configure page, choose store name currency as the customer mode. Cloud Cart 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.

How does Cloud Cart calculate sales tax?

Cloud Cart adds a line item called SalesTax that credits sales tax payable. Cloud Cart adds tax as a line item for several reasons:

  • A summary order can contain orders with different tax rates from different states. A QB tax code only applies a single tax rate.
  • When Cloud Cart adds a QB tax code, Cloud Cart must remove tax and recalculate it. Since you want the total tax from for the day, you want a line item.

Here is the sales tax item that Cloud Cart creates.

What if I only charge tax in one state?

Cloud Cart can add a default sales tax code, if the order contains tax and the shipping address state matches no existing mapping. Here are the steps:

  1. On the Cloud Cart configure page, click sales tax.
  2. Click add new tax code.
  3. Choose a tax code and enter US. Leave the state field blank.

Here is an example transaction with Massachusetts sales tax that ships to New York.

Sample

Here is an example transaction.

Have more questions? Submit a request
Powered by Zendesk