cancel
Showing results for 
Search instead for 
Did you mean: 
ChrisSinFL
Level 1

How to account for 3 different Freight & Shipping in QuickBooks 2014 desktop?

Freight & Shipping charges occur 3 different times for a manufacturer.  Freight paid for incoming materials.  Freight cost for shipping finished goods to customers.  Freight charges invoiced to customers for their purchases.  How do I account properly for all these in QuickBooks 2014 for desktop?  Is any included in COGS?  The company does not have inventory; materials are ordered as needed for each sales order.

Solved
Best answer May 24, 2018

Best Answers
Rustler
Level 15

How to account for 3 different Freight & Shipping in QuickBooks 2014 desktop?

@ChrisSinFL

 

Let's do this the easy way

 

You charge customers for shipping, that is income, create a service item called pre-paid shipping and select an income account for it to post to, I create an income account called pre-paid shipping and use that item on your invoice.

 

You pay for shipping to ship to the customer, that is an expense, it is not COGS, just pay the cost and post the expense to an expense account called something like outbound shipping expense.

 

On the P&L it is easy to look at pre-paid shipping income and compare that to outbound shipping expense to see how you are doing in that regard

 

Inbound shipping for inventory items, is part of the item cost.  On the item tab in desktop list the inventory item, the qty, and click in the total cost block and enter the total cost of the item plus a portion of the inbound shipping, when you click or tab out of the block QB will do the per item rate for you.

 

IRS Pub 538 Page 18 which says
For Merchandise purchased during the year, cost means the invoice price minus appropriate discount plus transportation or other charges incurred in acquiring the goods. You must reduce the cost of inventory by a trade (or quantity) discount.

View solution in original post

6 Comments 6
ClayJ
QuickBooks Team

How to account for 3 different Freight & Shipping in QuickBooks 2014 desktop?

Good afternoon, ChrisSinFL.

 

Thank you for reaching out to the Community for help on this. I'd like to give some insight to your questions about recording freight charges in QuickBooks. Freight charges can be added when receiving a bill, and when invoicing a customer. These charges will post to the account you chose when setting up a "shipping/freight" line item. I'll show you how to create this:

  • In QuickBooks, go to Lists and then click Item List.
  • At the bottom left, click Item, and then select New (Ctrl+N).
  • In the Type box, choose Other Charge.
  • Add a name for the item (i.e. "Shipping" or "Freight").
  • In the Account field, select an account to use. This will be the account used to record these transactions.
    Note: Customers most commonly use a separate COGS account for shipping/freight. These line items will not impact the COGS accounts for the inventory items. Be sure to verify this information with your accountant, so you both are on the same page.
  • Add in any additional information you'd like, and click OK.

Now you will be able to add this to bills and invoices. You will add it to an invoice like any other line item, and you'll do the same on bills. If you have any questions about these steps, leave me a comment below.

Rustler
Level 15

How to account for 3 different Freight & Shipping in QuickBooks 2014 desktop?

@ChrisSinFL

 

Let's do this the easy way

 

You charge customers for shipping, that is income, create a service item called pre-paid shipping and select an income account for it to post to, I create an income account called pre-paid shipping and use that item on your invoice.

 

You pay for shipping to ship to the customer, that is an expense, it is not COGS, just pay the cost and post the expense to an expense account called something like outbound shipping expense.

 

On the P&L it is easy to look at pre-paid shipping income and compare that to outbound shipping expense to see how you are doing in that regard

 

Inbound shipping for inventory items, is part of the item cost.  On the item tab in desktop list the inventory item, the qty, and click in the total cost block and enter the total cost of the item plus a portion of the inbound shipping, when you click or tab out of the block QB will do the per item rate for you.

 

IRS Pub 538 Page 18 which says
For Merchandise purchased during the year, cost means the invoice price minus appropriate discount plus transportation or other charges incurred in acquiring the goods. You must reduce the cost of inventory by a trade (or quantity) discount.

sainicharlie
Level 3

How to account for 3 different Freight & Shipping in QuickBooks 2014 desktop?

when i enter a sales receipt for a customer and i have charged shipping, it subtracts from my cogs Freight account, reducing my cogs.  is this correct??

JenoP
Moderator

How to account for 3 different Freight & Shipping in QuickBooks 2014 desktop?

Hi there, sainicharlie.

 

Let's try the account that's assigned to the shipping service item to make sure it's not deducting to your freight account. Here's how:

 

  1. Go to the Lists menu and select Item List
  2. Look for the shipping item and double-click on it.
  3. Proceed to the Expense and Income account fields and make sure the assigned accounts are correct. You may need to change them if the accounts are incorrect. I'd also recommend reaching out to your account just in case you're not sure which accounts to use.
  4. Click OK.

 

Once done, open your freight account report again to check if the shipping charges are no longer deducting from your COGS. 

 

Let me know if you have follow-up questions. We're always here to help. 

Entrepreneurdude
Level 1

How to account for 3 different Freight & Shipping in QuickBooks 2014 desktop?

In simply terms please and thank you: Is  buyer paid shipping not deductible? Or how about free shipping? The IRS considers shipping things out as income right, or as part of the item gross sale. This means they will tax you on the item price + the shipping total amount. So how do you deduct or prevent this because I am not making a profit on the shipping?

Giovann_G
Moderator

How to account for 3 different Freight & Shipping in QuickBooks 2014 desktop?

Thanks for joining the thread, Entrepreneurdude.

 

Let me provide some clarification on your concern about shipping.

 

If you receive free shipping from the supplier that's the time you have income. As suggested by Rustler above, you can create an income account. Make a billable expense to offset the cost if the customer pays for the shipment. I'll show you how.

 

  1. Create an expense account for the shipping.
  2. Go to the Vendors menu, then Enter Bills.
  3. Choose a vendor from the Vendor dropdown list.
  4. Enter the necessary information.
  5. Select the Expense tab, in the Account column, locate the expense account you created.
  6. Enter the amount and memo if applicable.
  7. In the Customer Job column, choose the customer who paid the shipping and checkmark the Billable column.
  8. Once done, hit Save & Close.

 

After that, you can create an invoice and then add the billable expense you created.

 

  1. Go to the Customers menu, then Create Invoices.
  2. Select the name of the customer, a billable expense window will popup. Select OK.
  3. Click the Expenses tab, then checkmark the billable expense.
  4. Hit OK to add it to the invoice.
  5. You can add all the items your customer purchase.
  6. Once done, select Save & Close.

 

Also. I've added this article to learn how to personalize your invoices and get the information you need: Use and Customize form templates.

 

I'll be around to help if you have more QuickBooks questions. Have a good one.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us