Connect with and learn from others in the QuickBooks Community.
Join nowHello
We live in WI and we have difficult sales and use tax rules. As an electrical contractor some things are taxable and some I have to pay use tax on. We have well over 1,000 items in our inventory. When working a project that is non taxable, we currently have to look up the cost of each item individually, record this amount on a spread sheet, calculate sales tax and add to the item, then add markup to that. Obviously this is taking WAY too much time to create invoices. I am wondering two things:
1. Is it possible to put item cost on the invoice to only be seen by us. (This would reduce the need to look up each individual item)?
2. If not.... Can I make the item prices the item cost and create different price levels for regular markup versus sales tax plus markup?
Thanks
Solved! Go to Solution.
2. If not.... Can I make the item prices the item cost and create different price levels for regular markup versus sales tax plus markup?
Yes and that is the easiest way to do it, especially if you have premier or enterprise since you can do custom pricing by item rather than all of them.
1. Is it possible to put item cost on the invoice to only be seen by us. (This would reduce the need to look up each individual item)?
yes but it is a pain to do, you create a custom field for cost, then enter the item average cost in that field per item. On the invoice, customize data layout, column tab, enable the field for screen but not for print.
with 1K items this utility might help take some of the pain away
http://www.q2q.us/ucfOverview.htm
2. If not.... Can I make the item prices the item cost and create different price levels for regular markup versus sales tax plus markup?
Yes and that is the easiest way to do it, especially if you have premier or enterprise since you can do custom pricing by item rather than all of them.
1. Is it possible to put item cost on the invoice to only be seen by us. (This would reduce the need to look up each individual item)?
yes but it is a pain to do, you create a custom field for cost, then enter the item average cost in that field per item. On the invoice, customize data layout, column tab, enable the field for screen but not for print.
with 1K items this utility might help take some of the pain away
http://www.q2q.us/ucfOverview.htm
Thank you so much! I have been going round and round with how to handle this!
You're Welcome
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.