Click here to check out our new Webgility Unify Video Library

SkuVault Sync Settings - Revenue Configuration In Unify

The first step in the SkuVault Sync Settings area is to how you want your revenue/orders to be downloaded from store and recorded into your Accounting system.

The source area sets up when (date) Unify will begin downloading sales from SkuVault.

Here you can select which orders based on order statuses you would like to download and from which date from SkuVault.

The destination display how and what accounting system the sales will sync to. Here we are taking an example of QuickBooks Online.

There are 2 ways you can create transactions in Accounting systems:

  • Create Single transaction type for all orders. Either Sales Receipt or Invoice
  • Create different transactions for Orders based on Purchasing channel, Payment Method or Order status.

An Invoice is a document in QuickBooks, which will record the fact that an item was sold, but is not marked as a "paid" inside QuickBooks Online, but will not record the payments in the relevant accounts. The same has to be done manually.

If your customers are paying for their orders at the same time as they place them, and you do not have any credit systems or pay by cheque systems, then you can use sales receipts. A sales receipt is a document in QuickBooks online that reduces inventory and records payments at the same time.

What account should the order deposit to?

The deposit account is your account in QuickBooks online which would be used to record the payment for the order posted to QuickBooks online from Unify. Most people would use un-deposited funds and then record the payment manually in a separate account of choice, but you may create and use a deposit account of your choice.

 Payment method

This is what is recorded as the payment method in your invoice or sales receipt. Your payment method can be As on the store, Cash, Check or Credit Card depending on your business requirements.
The As on store option would record the payment method in the invoice or sales receipt exactly the way the payment method is recorded in the online store (PayPal/visa/credit card/ Auth.Net etc.). However, if you receive cheque or cash from your customers, you can choose one of the other options too.

Who assigns transaction numbers?

A transaction number is the number of the document, in QuickBooks Online, that you chose to record in step 3 above. A transaction number provided by the Shipstation would be the same number as the order number and is frequently used because it makes it easy to look up the transaction document (Invoice / Sales receipt) in QuickBooks online.

At the same time if you use QuickBooks online on a regular basis for orders that do not originate on your Web store, then you would be better off using QuickBooks assigned numbers. In this case, if you manually recorded a transaction number 499 in QuickBooks online and then posted an order from Unify, QuickBooks online would assign the number 500.

Transaction date

Use this option to determine, if you want to set the transaction date, (date on which the invoice or sales receipt is created), as the order date or date of order posting to QuickBooks Online depending on the business setup.

Order shipped date

Use this option to determine what you want to set as the shipped date for the order. This is the date of order shipment that would be recorded in the QuickBooks online transaction. You can choose the actual shipping date of the order, or the actual order date (the date the order was received in the online store).
Aside from the two above, you can also choose the order date + 15 days or order date + 30 days options. These options basically mean that the shipment date would be recorded in QuickBooks online as the date that the order was received in the online store with the addition of 15 or 30 days; and are usually used by wholesalers who give credits, importers who need to import the product before shipping, Dropshippers, etc.

Save memo as

Memo is a field in the sales receipt or invoice that you have created, in which the additional information related to Order notes, Customer Comments and Online Order# can be added. You can also select "None," if you don't want to save anything in this field.

Save print message to customer as

These are notes that are given by a customer on their order. For example: "please pack and deliver my order one day earlier." These notes can be added to the invoice or sales receipt.

Set product description as

Product description is a description of the product that is visible to the buyer on the website. You can choose to have the standard product description or one of the below options: 

Online Product Name : name of the product as on the online store.
Online Product Name + [Options] : name of the product as on the online store with the options available for the product e.g. Shirt Men’s RED SMALL
Online Product Description : Description of the product as on the online store.
Online Product Description + [Options] : Description of the product as on the online store with options of the product on the online store.
QuickBooks Product Description : Description of the product as in QuickBooks Online.

Set reference No as

Reference No is a field in the sales receipt or invoice to reference the transaction. In which the additional information related to Order# and Transaction ID from Quickbooks can be added.

Calculate taxable subtotal before discount?

Taxable subtotal is, as the term says, the total amount that a customer has to pay before any applicable discounts are given. If you want to record the taxable subtotal before discounts in your invoice / sales receipt, you can select this option.

Track location in QuickBooks

Select this, if you want to track the location of your orders and show the same in your invoice or sales receipt. Track location is essentially useful if you have shops and / or online stores in multiple locations and have orders coming in from a variety of locations. Click here to learn about location tracking in QuickBooks Online. 

Use classes in QuickBooks

Select this, if you want to track the classes in Quickbooks invoice or sales receipt. With classes, you can categorize each detail line on a transaction. Click here to learn about Class tracking in QuickBooks Online. 

Record taxes from online store in QuickBooks

This is the last step of Order Sync Settings. It is here that you decide how would like the taxes charged in the online store to be recorded into QuickBooks online. 

To begin recording taxes charged in the online store into QuickBooks online, select the Record taxes from online store in QuickBooks option. Under this option, Unify will ask you to Select a Sales tax item which you can select from the drop-down. If nothing appears in the Sales tax item field, of if your choice of sales tax item is not there in the list, tax items may need to be created in QuickBooks Online. Click here to learn how. 


Next Steps : 

SkuVault Sync Settings - Customer Configuration In Unify

SkuVault Sync Settings - Product Configuration In Unify





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


Based on our last 100 reviews, online sellers Webgility

Powered by Zendesk