Skip to content
  • There are no suggestions because the search field is empty.

Configuring Additional Settings for Posting Order Data in QuickBooks

This article helps Webgility Desktop users configure Additional Settings in Webgility Desktop to map specific order and payment fields from their sales channels into QuickBooks Desktop. It explains where to find these settings, which QuickBooks fields can be populated, such as Check Number, Other, Payment Reference, PO Number, Payment Memo, Payment Date, and Customer Message, and provides recommended mappings to ensure transactions post correctly.

Accessing Additional Settings:

The Additional Settings section in Webgility Desktop allows you to control how order data — such as check numbers, payment references, PO numbers, and payment dates — is mapped to QuickBooks transaction fields during sync.

In Webgility Desktop, navigate to Connections, then go to Accounting/POS/ERP and click Sync Settings. Under the Orders section, open the Transaction Settings tab and expand the Additional Settings section by clicking the chevron icon. You can then map order-related data by selecting the appropriate value for each field to post to the corresponding QuickBooks transaction field. Once configured, click Save to apply your changes.


Fields to configure:

  • Check Number Field: This is where you put the number of the check you're using to pay for something. It helps you and others keep track of which check was used for what. The options available to post are-

    • Online PO #

    • Order # without prefix

    • Phone # without prefix

    • Transaction ID

    • Transaction ID without prefix

 

  • Other Field: Use this field to store supplementary transaction data not covered by other fields — for example, a tracking reference or card type. The options available to post are -

    • Tracking ID

    • Store Other Field

    • Billing Email

    • Shipping Email

    • Online PO#

    • Payment Method

    • Order #

    • Order # without Prefix

    • Card Type/Name

 

  • Payment Reference Field: Use this field to record a reference that links the payment to a specific invoice, bill, or order in QuickBooks. The options available to post are -

    • Online PO#

    • Store Name : Order #

    • Order #

    • Order # without prefix

    • Last 4 digit of credit card #

    • Email

    • Customer Name

    • Customer Name : Order #

    • Customer Comments

    • Transaction ID

    • Transaction ID without Prefix

 

  • PO Numbering: This is where you put the number of the purchase order (PO) related to the transaction. It's useful for keeping things organized and making sure the right orders are matched with the right payments. The options available to post are -

    • Online PO#

    • Store Name : Order #

    • Order #

    • Order # without prefix

    • Last 4 digit of credit card #

    • Email

    • Customer Name

    • Customer Comments

    • Transaction ID

    • Transaction ID without Prefix

 

  • Payment Memo: Use this field to add a brief memo describing the purpose or context of the payment as it will appear on the QuickBooks transaction. The options available to post are -

    • Online PO#

    • Store Name : Order #

    • Order #

    • Order # without prefix

    • Last 4 digit of credit card #

    • Email

    • Customer Name

    • Customer Name : Order #

    • Customer Comments

    • Transaction ID

    • Transaction ID without Prefix

    • Transaction #

    • Transaction # without Prefix

    • Payment Method : Transaction ID without prefix

 

  • Payment Date: This is simply the date when you made the payment. It's important for keeping track of when money moves in and out of your accounts. The options available to post are -

    • Order Date

    • Order date + 3 Business Days

    • Ship Date

    • Date of posting to Quickbooks Desktop system

 

  • Customer Message: Select a pre-defined message to display to the customer on their QuickBooks transaction document (such as an invoice or sales receipt). The options available to post are -

    • Please remit to above address.

    • Thank you for your business.

    • All work is complete!

    • It’s been a pleasure working with you!

    • We appreciate your prompt payment.

    • None(blank)