Post Detailed Shipped Orders to QuickBooks

Overview

Posting detailed shipped orders to Quickbooks will create an individual invoice for each order.

However, there are settings to create a generic customer for each channel. Ensure that your Quickbridge settings are configured to your requirements.

If you only want to post order totals for profit and loss, use the Post General Journal Entries feature. It is recommended to reconcile payments from the Sellercloud interim account to your actual bank account into which payments are entered.


Post Orders to Quickbooks

  1. Open Quickbooks on the same computer as Quickbridge.
  2. In Quickbridge, click Quickbooks > Post Detailed Shipped Orders.
  3. Choose the appropriate dates and other filters.
    Note: Channel filter options appear only when orders from that channel exist in the specified date range.
  4. Click Get Shipped Orders. The grid will populate with orders that have not yet been exported to Quickbooks.
  5. Click Post Invoices to Quickbooks and await the pop-up confirmation.
    1. In Quickbridge – Orders will be removed from the grid.
    2. In Sellercloud – Order Status will show as Quickbooks Exported.
  6. If you need to update an exported order, change the status to Mark as Not Exported to Quickbook from Sellercloud > OrdersManage Orders > Select the order(s) > Action menu > Exported to Quickbook Status. The invoice will reappear in Quickbridge.

The image shows the Post Detailed Shipped Orders window.


Exported Order Data in Quickbooks

Credit terms that are set in Sellercloud orders are automatically retained in Quickbooks invoices. No separate setting is needed for this Quickbridge feature.
  • Customers – Customers that don’t exist in Quickbooks get automatically created. Channel orders can be set to a generic customer from Quickbridge > File > Options > Main tab > Use Generic Customer Name box. Otherwise, the customer name in Quickbooks is populated with the Sellercloud Customer ID.
  • Payments – Based on the Mark Orders Paid setting, found in the File > Options > Main tab. When the relevant setting to post payments is enabled, a payment is posted to the corresponding Bank Account in Quickbooks. For channel orders, Payments are by default placed into interim accounts created by Quickbridge (Amazon Interim Account, eBay Interim Account, etc.) and the invoices in Quickbooks  will be marked as paid, thereby moving the invoice balance from the A/R account to the Bank Account. Payments can also mapped to existing bank accounts, instead of using the default accounts created by Quickbridge for each channel, by enabling the setting Use Custom Bank Account Mappings to apply Invoice payments found in the File > Options > Sales Orders Tab in the Post Detailed Shipped Orders section.
  • Products – All new products are entered into Items and Services and can be viewed in the Item List in Quickbooks
  • Shipping costs and commission fees – These costs are exported to Accounts Payable as bills to a vendor, like the various carriers and channels. Note that vendor accounts are created as orders are imported, e.g., PayPal Fees, Commission Fee. You can prevent certain fees from posting by enabling their corresponding settings in the File > Options > Sales Orders Tab in the Post Fees to Quickbooks section. For the full list of options, see the Configure Quickbridge wiki page.

Post Orders in Foreign Currency

By default, orders in a foreign currency will post to Quickbooks in USD using the conversion rate saved on the order. As of Version 1.0.9.8, you can post orders in the foreign currency using Quickbooks’ multi-currency feature.

To enable this feature, go to Quickbridge > File > Options > Quickbooks Features tab > Enable Use Multi-Currency Feature in Quickbooks > Click Save.

Before using this feature, please read these key points (also shown below):

  • Only use this option if the Multi-Currency feature is enabled in Quickbooks.
  • You can only assign one currency per customer profile in Quickbooks. Therefore, you would need to create separate customer profiles in Sellercloud for customers with multiple currency orders
  • All orders for existing Quickbooks customers will use the existing currency code. For orders where the customer doesn’t exist in Quickbooks, Quickbridge will create the customer with the orders currency. code. All future orders for that customer will use that currency code.
  • If a customer already exists in Quickbooks using an unwanted currency code, alter the existing customer name slightly and Quickbridge will re-create the customer with the subsequent orders currency code.

Edit an Exported Order

Using this feature requires selecting the Enable Quickbooks Workflow setting in the Client Settings.

You can easily edit any order that was already exported by first changing its status to Unexported, and then updating it. Here’s how:

  1. In Sellercloud, go to Orders > Manage Orders.
  2. In Default filters > Order # filter, enter the order and click Search.
  3. Select the order > click Action menu > Mark Quickbooks Unexported.
  4. Edit the order as needed.
  5. When done, you have two choices:
    1. Export the order to Quickbooks again, but first ensure the original order has been deleted to avoid duplicates.
    2. Edit the order manually in Quickbooks, and then mark the Sellercloud order as exported by selecting it as described above > Click Action menu > Mark Quickbooks Exported.

Was this article helpful?

Related Articles