Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowHello 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! Go to Solution.
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:
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:
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:
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!
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.
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.
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:
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:
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:
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!
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.
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?
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.