ShipStation

How do I map the shipping cost from ShipStation to QuickBooks?

Set-up Connex to map the field

Is there a demo?

Here is a demo about income, COGS, and shipping costs:

How do the fields map?

Connex will map the shipping cost field to a QuickBooks line item:

How do I instruct Connex to update existing sales with the shipping cost?

  1. Login to Connex.
  2. Click manage.
  3. Expand orders > sync orders to QuickBooks > sync manually to QuickBooks.
  4. In the order status field, enter awaiting shipment and shipped.
  5. Expand orders > sync orders from QuickBooks.
  6. Select update shipping cost and tracking number: 

Connex will automatically update the sale, after it syncs to QuickBooks. Our tool receives the sale before and after it ships.

How do I map the shipping cost and what the customer paid in QuickBooks?

Connex can send either the shipping the customer paid or your shipping cost to QuickBooks. As a workaround, you can enter your costs in bulk:

  1. Obtain a statement of how much your costs were for a month. In this example, we accumulated $100 for shipping costs in a month.
  2. Log into QuickBooks.
  3. Go to lists > item list.
  4. Find your shipping item.
  5. Assign a shipping income account:
  6. Go to vendors > enter bills.
  7. Enter a bill for the costs. Choose an account for the expense and enter the full amount.
  8. Save the bill.
  9. In QuickBooks, go to reports > company and financial > profit and loss standard.
  10. View your report. Notice the shipping income and the shipping costs accounts.