Connex Desktop: Summary Transaction

If you have several orders a day, Connex can summarize the last 24-hours of sales and aggregate them into a single sales receipt or invoice as well as create summaries for each store.


Summary Transaction feature requires the Super subscription plan or higher.

What are the benefits of creating a summary?

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 are 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 invoices. Connex for QuickBooks Online 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 Connex Dashboard , Choose the connection and click Manage.
  2.  Next, expand the Orders Tab, then click Orders>Sync Orders to QuickBooks>Transaction Tab
  3. At the Transaction Type Drop Down, Select Summary Transaction from the list.
  4. Next, expand the Sync Manually to QuickBooks tab.
  5. Choose a date to summarize.  
  6. By default, Connex syncs orders by their creation date. You can sync orders with a certain status, though you might have issues reconciling.  In the Order Statuses to Export field, enter some statuses.  Otherwise, leave the field blank to sync all statuses. 
  7. Click Save Settings.

How do I set-up the sync to run daily?

Here are the steps:

    1. If you are a Connex for QuickBooks Online user, Connex will sync automatically.

    2. If you are a Connex for QuickBooks Desktop User, run your Web Connector in QuickBooks.

    3. Connex will automatically reset the timers to tomorrow at the same time.

    Does the Summary support multiple currencies in the same selling channel?

    Connex 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:


    You must create deposit account:

    1. In QuickBooks, go to the gear box and click chart of accounts.
    2. Click new.
    3. Select other current asset for the type and subtype. Add the currency: 


    Step 1: Create a rule to map the deposit account based on currency: 

    1. From the Connex Dashboard, on the left,  click Rules Engine.
    2. Add a rule to map deposit accounts for each currency by following the sample below:


    Step 2:  Choose the Customer Type on the Customer Tab in Connex:

    On the Connex Dashboard, choose the connection and click Manage.

    Next expand the Customers Tab>Matching.  From the drop down, choose Store Name and Currency as the customer mode. Connex will append the currency code to the selling channel name in QuickBooks:

    1. Expand the Orders > Sync Manually to QuickBooks tab to change the sync dates under export settings to a one-day range, such as August 13th 12:00 AM to August 13th 11:59 PM.
    2. Open the Orders>New Order and Product Accounts tab and choose a default deposit account for your home currency. In this case, we will use undeposited funds.
    3. Click Sync Now.

    How does Connex calculate sales tax on the Summary?

    Connex adds a line item called Sales Tax that credits sales tax payable. Connex adds tax as a line item for several reasons:

    • A summary order can contain orders with different tax rates from different states. A QuickBooks tax code only applies a single tax rate.
    • When Connex adds a QuickBooks tax code, Connex 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 Connex creates:

    Example Summary Transaction

    Here is an example transaction.