Post Detailed Shipped Orders to Quickbooks
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. (Be sure that your QuickBridge settings are configured to your requirements.)
If you only want to post order totals for profit and loss, use the Post P&L to QB in Summary feature. It is recommended to reconcile payments from the SellerCloud interim account to your actual bank account into which payments are entered.
Posting orders to QuickBooks
- Open QuickBooks on the same computer as QuickBridge.
- In QuickBridge, click QuickBooks > Post Detailed Shipped Orders.
- Choose the appropriate dates and other filters. Note: The Channel filter only offers choices when orders from that channel exist in your date range.
- Click Get Shipped Orders. The grid will populate with orders that have not yet exported to QuickBooks.
- Click Post Invoices to QuickBooks and await confirmation. The orders will be marked as "Exported" in SellerCloud to prevent re-export. (If you need to update an order and repost, change the status to "Not Exported." The order will reappear in QuickBridge.)
Note: The Enable QuickBooks WorkFlow setting must be selected in Client Settings.
Exported order data in QuickBooks
- Customers - New accounts are created for each new customer and returning customers have orders placed in their existing accounts. Channel orders can be set to a generic customer (QuickBooks > File > Options > Main tab > Use Generic Customer Name box); otherwise, customer name in QuickBooks is populated with 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 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 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).
Posting orders in foreign currency
By default, orders in foreign currency will post to QuickBooks in USD using the conversion rate saved on the order. As of Version 126.96.36.199, you can post orders in the foreign currency using QuickBooks' multi-currency feature. To enable, go to QuickBooks > File > Options > QuickBooks Features > check Use Multi-Currency Feature in QuickBooks.
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.