cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
marumir05
Level 3

Shopify shipping

How to categorize Shopify shipping separately? The order invoice that comes through Shopify includes the product price and shipping cost.

 

Line#1 Product A --------- $50

Line#2 Shipping cost ------ $50

Total ---------------------------$100

 

We want to "Receive Payment" the invoice, then be able to categorize the shipping cost. Hope it makes sense.

Solved
Best answer March 02, 2023

Best Answers
Rubielyn_J
QuickBooks Team

Shopify shipping

I can help you categorize Shopify shipping separately in QuickBooks, @marumir05.

 

First, we need to create an expense account to track the shipping cost (if necessary). Here's how:

 

  1. Proceed to Settings ⚙.
  2. Choose the Chart of accounts.
  3. Click New. Depending on your account view, you’ll either see a panel labeled New account or New category

 

For detailed steps, you can utilize this resource for your reference: Add an account to your chart of accounts in QuickBooks Online.

 

Once done, assign the account to the service item (shipping cost).

 

  1. Proceed to Get paid & pay or Sales, then select Products & services (Take me there).
  2. Select New.
  3. Select Non-inventory or Service.
  4. Enter a Name for the product or service and a SKU, if you track them.
  5. From the Category ▼ dropdown, select the category that best describes your product or service. 
  6. If you sell the item, confirm the checkbox is selected for I sell this product/service to my customers. 
  7. In the Description on sales forms field, enter a description. 
  8. Enter an amount in the Sales price/rate field. 
  9. Select the Income account ▼ dropdown and the account you want to use to track the sale. 
  10. In the Sales tax section, sales tax is applied by default based on location. 
  11. Lastly, click Save and Close.

 

Then, use the item on your invoice and receive the payment

 

If you make a bank deposit with several checks in a single deposit, use the Undeposited Funds account to record the payments in QuickBooks. This lets you group multiple payments into one deposit transaction in QuickBooks.

 

Keep me posted if you have further concerns with categorizing Shopify shipping in QuickBooks. I'm always around to help. 

View solution in original post

1 Comment 1
Rubielyn_J
QuickBooks Team

Shopify shipping

I can help you categorize Shopify shipping separately in QuickBooks, @marumir05.

 

First, we need to create an expense account to track the shipping cost (if necessary). Here's how:

 

  1. Proceed to Settings ⚙.
  2. Choose the Chart of accounts.
  3. Click New. Depending on your account view, you’ll either see a panel labeled New account or New category

 

For detailed steps, you can utilize this resource for your reference: Add an account to your chart of accounts in QuickBooks Online.

 

Once done, assign the account to the service item (shipping cost).

 

  1. Proceed to Get paid & pay or Sales, then select Products & services (Take me there).
  2. Select New.
  3. Select Non-inventory or Service.
  4. Enter a Name for the product or service and a SKU, if you track them.
  5. From the Category ▼ dropdown, select the category that best describes your product or service. 
  6. If you sell the item, confirm the checkbox is selected for I sell this product/service to my customers. 
  7. In the Description on sales forms field, enter a description. 
  8. Enter an amount in the Sales price/rate field. 
  9. Select the Income account ▼ dropdown and the account you want to use to track the sale. 
  10. In the Sales tax section, sales tax is applied by default based on location. 
  11. Lastly, click Save and Close.

 

Then, use the item on your invoice and receive the payment

 

If you make a bank deposit with several checks in a single deposit, use the Undeposited Funds account to record the payments in QuickBooks. This lets you group multiple payments into one deposit transaction in QuickBooks.

 

Keep me posted if you have further concerns with categorizing Shopify shipping in QuickBooks. I'm always around to help. 

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us