cancel
Showing results for 
Search instead for 
Did you mean: 
rastysaeed
Level 2

adding shipping cost as expenses/items in a bill

Hello Dears 
I have a bill, containing 2 different items 
also, it has shipping cost/ items 

for example  
Item#1 buying cost= 10$ . shipping cost= 2$
Items#2 buying cost= 15$ . shipping cost= 1$
So, Item#1 total cost for me= 12$. and Item#2 total cost= 16$

Now, the bill for the vendor should tell me the amount due= 10+15=25$
and it should show in the inventory list, cost of items #1 as 12, and Item#2 as 16

How can I do it in QuickBooks Desktop, 

regards

 

Solved
Best answer April 03, 2021

Best Answers
Adrian_A
Moderator

adding shipping cost as expenses/items in a bill

You have me to help you record this bill, rastysaeed.

 

First, we'll have to add the inventory items and then enter $12 as the Cost for the first item and $16 for the second one. As for the shipping fee, we'll have to add it as a service item and enter it as a negative amount. Let me guide you how:

 

  1. From the Lists menu, select Item List.
  2. Select New on the Item drop-down.
  3. Select its TYPE.
  4. In the Cost field, enter $12.
  5. Select an Income Account.
  6. Click OK.

 

 

Second, repeat steps number 1 and 2 for the second item. For the third step, enter $16 as the Cost amount. Select an Income Account and click OK.

 

 

Then, you're good to add the shipping fee items.  Here's how:

 

  1. Select Item List from the Lists menu.
  2. Select New on the Item drop-down.
  3. On the TYPE field, select Service.
  4. You can enter Shipping Fee as the Item Name/Number.
  5. Enter -1 as the Rate.
  6. Select an Account.
  7. Click OK.

 

Repeat steps number 1 to 4. For the step 5, enter -2 as the Rate of the second shipping fee item. Then, select an Account.

 

 

Afterward, you're good to create a Bill. Here's how:

 

  1. From the Vendors menu, select Enter Bills.
  2. Select a VENDOR.
  3. Go to the Items field.
  4. Select the item 1.
  5. Select the shipping fee with the $-2 amount.
  6. Select item 2.
  7. Enter the shipping fee item with $-1 amount.
  8. Click Save & Close.

 

 

Also, I'd recommend reaching out to your accountant so you'll be guided on the correct account to use.

 

I've also added this reference on how we can pay bills: Pay bills in QuickBooks Desktop.

 

There you have it. I'm just around if there's anything that I can help. Keep safe!

View solution in original post

Rajanikanth
Level 6

adding shipping cost as expenses/items in a bill

Hi,  rastysaeed

If you are using QuickBooks Desktop Premier or Enterprise versions follow the below steps

01.Create bills for items at cost price e.g. Item A - 10$ 500 units and B - 15$ 250 units

02.Create bills for shipping costs e.g 2$ + 1$ = 3$ ( Create items with proper Unit of Measure e.g                      Km/Kg  etc )

03.Create the items for the final cost assemblies e.g. Items AA and BB 

04.Move to Build assemblies  select Item AA as Assembly Item and Assemble the cost to AA

     for e.g. select Item A and shipping costs > Quantity to Build enter 500 units > Hit Build and Close.

05. Now you can check the Inventory valuation summary Item A - 0 units and B - 0 units, Items AA - 500 units with cost per unit 12$ and BB 250 units with cost per unit 16$.

 

Feel free to contact me for any clarifications.

 

 

View solution in original post

JenoP
Moderator

adding shipping cost as expenses/items in a bill

Hi there, SriniHN.

 

For now, there's no option to automatically calculate the shipping charges if each line or item has it's own cost. You can either follow the workarounds given in the previous reply or use a thrid-party app that offers this type of  service.

 

You can go to this link where you can see all accredited third-party apps: https://desktop.apps.com/home. 

 

The Community is always here if you need anything else. 

View solution in original post

4 Comments 4
Adrian_A
Moderator

adding shipping cost as expenses/items in a bill

You have me to help you record this bill, rastysaeed.

 

First, we'll have to add the inventory items and then enter $12 as the Cost for the first item and $16 for the second one. As for the shipping fee, we'll have to add it as a service item and enter it as a negative amount. Let me guide you how:

 

  1. From the Lists menu, select Item List.
  2. Select New on the Item drop-down.
  3. Select its TYPE.
  4. In the Cost field, enter $12.
  5. Select an Income Account.
  6. Click OK.

 

 

Second, repeat steps number 1 and 2 for the second item. For the third step, enter $16 as the Cost amount. Select an Income Account and click OK.

 

 

Then, you're good to add the shipping fee items.  Here's how:

 

  1. Select Item List from the Lists menu.
  2. Select New on the Item drop-down.
  3. On the TYPE field, select Service.
  4. You can enter Shipping Fee as the Item Name/Number.
  5. Enter -1 as the Rate.
  6. Select an Account.
  7. Click OK.

 

Repeat steps number 1 to 4. For the step 5, enter -2 as the Rate of the second shipping fee item. Then, select an Account.

 

 

Afterward, you're good to create a Bill. Here's how:

 

  1. From the Vendors menu, select Enter Bills.
  2. Select a VENDOR.
  3. Go to the Items field.
  4. Select the item 1.
  5. Select the shipping fee with the $-2 amount.
  6. Select item 2.
  7. Enter the shipping fee item with $-1 amount.
  8. Click Save & Close.

 

 

Also, I'd recommend reaching out to your accountant so you'll be guided on the correct account to use.

 

I've also added this reference on how we can pay bills: Pay bills in QuickBooks Desktop.

 

There you have it. I'm just around if there's anything that I can help. Keep safe!

Rajanikanth
Level 6

adding shipping cost as expenses/items in a bill

Hi,  rastysaeed

If you are using QuickBooks Desktop Premier or Enterprise versions follow the below steps

01.Create bills for items at cost price e.g. Item A - 10$ 500 units and B - 15$ 250 units

02.Create bills for shipping costs e.g 2$ + 1$ = 3$ ( Create items with proper Unit of Measure e.g                      Km/Kg  etc )

03.Create the items for the final cost assemblies e.g. Items AA and BB 

04.Move to Build assemblies  select Item AA as Assembly Item and Assemble the cost to AA

     for e.g. select Item A and shipping costs > Quantity to Build enter 500 units > Hit Build and Close.

05. Now you can check the Inventory valuation summary Item A - 0 units and B - 0 units, Items AA - 500 units with cost per unit 12$ and BB 250 units with cost per unit 16$.

 

Feel free to contact me for any clarifications.

 

 

SriniHN
Level 2

adding shipping cost as expenses/items in a bill

I am also in similar situation what rastysaeed has mentioned.

 

We got multiple shipments(vendor a, vendor b, vendor c) in one truck. Trucker gives one invoice for his charges and we get vendor invoices all three(a, b, c).

 

Each invoice has atleast 50 different line items.

 

By following your method it will take quite a lot of time to calculate each and individual final cost(cost+trucking charge). Don't we have a functionality in QB it can auto calculate by assigning a trucking charges to all those invoices so that QB can calculate final cost price?

 

Otherwise what is the best way to enter with less manual work?

JenoP
Moderator

adding shipping cost as expenses/items in a bill

Hi there, SriniHN.

 

For now, there's no option to automatically calculate the shipping charges if each line or item has it's own cost. You can either follow the workarounds given in the previous reply or use a thrid-party app that offers this type of  service.

 

You can go to this link where you can see all accredited third-party apps: https://desktop.apps.com/home. 

 

The Community is always here if you need anything else. 

Need to get in touch?

Contact us