Skip to main content
All CollectionsWebgility OnlineSetupOrder Setup
Recommended Transactional Settings for Webgility Online
Recommended Transactional Settings for Webgility Online

The recommended settings to post orders individually as a sales receipt to QuickBooks.

Webgility avatar
Written by Webgility
Updated over a month ago

Overview:

In Webgility Online we call it a Transactional Accounting Method. To post every order individually as a sales receipt to QuickBooks, follow these recommended steps below.

Important Note: Make sure the preferred Accounting Method is Selected as Transactional.

  • Go to Sync Settings> Orders

In the Orders tab, you will set up how the individual transactions will manifest in your accounting solution. The recommended settings below are ideal for most customers.

  • Use the same settings to post all orders: Single Transaction Types

  • Post all orders as this type of transaction: Sales Receipt

  • Use this Deposit Account: Undeposited Funds or a Checking Account

  • Set the Payment Method: As on the sales channel

  • Which system should assign the Sales Receipt Number?: QuickBooks

  • Set the Sales Receipt date as: Order Date

  • Set the Ship Date as: Order Date

  • The memo should be Online Order number

  • No Default Message appears

  • Set Product Description as Item Name

  • Set the Reference Number as Transaction id

Advanced Settings:

Advanced Settings expands into several optional settings. These can be left unselected for now. Make sure you Save the settings before moving on with the configuration.

Products

Product Settings are where you determine your matching criteria between your sales channel and QuickBooks. Most commonly this is done by linking the Product SKU from the sales channel to the QuickBooks Online Product Name. This is highlighted with red lines in the image below.

This screen also dictates how Webgility will behave when a product does not match automatically with an item in QuickBooks Online. This is highlighted in Red in the image below. The recommended selection is to Map the product to what it should be in QBO. This will prompt you to map it when the order is posted.

Customers:

Customer Settings allow you to choose how to match the existing customers in QuickBooks. The default settings are, FirstName LastName to Customer Name, and Email to Email these settings work best for most situations.

The other settings on this page are how Webgility will create a new customer when there is no match to an existing one in QuickBooks Online.

After finishing the setup, Save the settings.

Discount:

Discount Settings allows you to select a discount line item to use when posting a discount to QuickBooks. Select Save to save the settings.

Sales Tax:

In the Sales Tax Settings, you will need to select the Sales Tax Item used to record your sales tax, then click Save.

Select how to record Sales Taxes:

  • Here you can choose whether to post the sales tax Based On Location using the option Standard Sales Tax Rate Field

  • Alternatively, you can choose the option to Record The Exact Amount Collected As A Line Item. Select the line item you want to record the sales tax in the transaction.

Refunds:

Refunds Settings allow you to specify how your refund transactions will manifest in QuickBooks Online. The recommended settings shown below will create a refund receipt and pay it out of the clearing account. The other selections on this screen are optional and are not usually adjusted in most cases. Save the settings when you are done.

Note: This area will not appear if your Sales Channel is not supported for refunds with Webgility Online.


If you have any questions or need more help, Feel free to contact our support team.

Did this answer your question?