Post Detailed Shipped Orders to Quickbooks

Posting detailed shipped orders to Quick Books will create an invoice for each order individually. However, there are settings to create a generic customer for each channel. (Be sure that your QuickBridge Settings have been configured to your requirements.) 
If you just want to post order totals for Profit and Loss, use the Post P&L to QB in Summary feature. 

It's a good idea to reconcile payments from the SellerCloud interim account to your actual bank account that payments are being entered into.

Note: An income account entitled "Sales" must exist in QuickBooks prior to posting. If it does not exist QuickBridge will return an error message.
Note: An asset account entitled "Inventory" must exist in QuickBooks prior to posting. If it does not exist QuickBridge will return an error message.

Posting Orders to QuickBooks
  1. Make sure that QuickBooks is open and running on the same computer as QuickBridge.
  2. Select QuickBooks from the menu bar.
  3. Select Post Detailed Shipped Orders to QuickBooks
  4. Select the appropriate dates and click the Get Shipped Orders button.
  5. The grid will populate with orders that have not yet been exported to QuickBooks. Note: the Channel filter will only offer channel selections when there are orders from that channel in the specified date range.
  6. Click on Post Invoices to QuickBooks and wait for confirmation. You're Done!
  7. The orders will be marked as "Exported" in SellerCloud to prevent them from exporting again. If you need to update an order and repost, change the status to "Not Exported". The order will reappear in QuickBridge.
Where Exported Order Data is Placed in QuickBooks
  • Customers - New customer accounts are created for every new customer. Returning customers will have their orders placed in their existing accounts. Channel orders can be set to generic customer (File > Options > Main tab). Otherwise, the customer name in QuickBooks will be populated by the order number.
  • Payments - All orders are considered paid so they are not entered into Account Receivable. Instead, channel orders are placed into interim accounts created by QuickBridge (Amazon Interim Account, eBay Interim Account etc..) with a paid status. The balance in these accounts can then be transferred manually into a bank account.  
  • Products - All new products are entered into Items and Services with the adjusted value on hand. If a new item is being created, the inventory on hand will show negative quantity. 
  • Shipping costs and Commission Fees - These costs are exported to Accounts Payable as bills to a vendor, like the various carriers and channels (vendor accounts are created as orders are imported. e.g. PayPal Fees, Commission Fee). 

How did we do?