Line Item Tax - Send Tax Table info

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Thank you for the screenshot.  You know the saying... a picture is worth a thousand words. :)

The Order Level feature will map things the way you want.  My only concern is that you would have to map so many, and update them each year.  It would take a week to add them all and map them.  Also, the tax by location interface may not handle 1000+ items.  It was not optimized for that many entries. That is what the tax file does.  

Your best bet is doing it all directly through SQL Manager or writing a script.  We do not have an import script pre-made for that sort of task.  If I remember correctly you have some developers on staff that could build one.  You would need to import your spread sheet to create the tax locations and automatically create a mapping record.

I will create a wish list item for adding rate to the line item description, but I am not sure when the next update will be released.  We just put out v1.07 last week.  

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Matt Members Profile Send Private Message Find Members Posts Add to Buddy List Moderator Group Joined: 20-July-2006 Location: United States Status: Offline Points: 73	Post Options Post Reply Quote Matt Report Post Thanks(0) Quote Reply Topic: Line Item Tax - Send Tax Table info Posted: 06-August-2010 at 11:48pm
	Thank you for the screenshot. You know the saying... a picture is worth a thousand words. :) The Order Level feature will map things the way you want. My only concern is that you would have to map so many, and update them each year. It would take a week to add them all and map them. Also, the tax by location interface may not handle 1000+ items. It was not optimized for that many entries. That is what the tax file does. Your best bet is doing it all directly through SQL Manager or writing a script. We do not have an import script pre-made for that sort of task. If I remember correctly you have some developers on staff that could build one. You would need to import your spread sheet to create the tax locations and automatically create a mapping record. I will create a wish list item for adding rate to the line item description, but I am not sure when the next update will be released. We just put out v1.07 last week.

odathp Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 19-April-2010 Status: Offline Points: 0	Post Options Post Reply Quote odathp Report Post Thanks(0) Quote Reply Posted: 06-August-2010 at 10:34pm
	There is a line item tax, but not showing tax rate. Also, the tax rate does not display in the PC invoice. To be honest, I really like the idea of taxing by location and mapping each tax code to an item in QuickBooks. That would completely resolve the real issue here. When using a tax file, QB Add-on requires using a line item tax which can not be mapped to items in QB.

Matt Members Profile Send Private Message Find Members Posts Add to Buddy List Moderator Group Joined: 20-July-2006 Location: United States Status: Offline Points: 73	Post Options Post Reply Quote Matt Report Post Thanks(0) Quote Reply Posted: 06-August-2010 at 9:30pm
	Hi John, Tax by Location does require mapping. Everything I said is correct, except that I said "zone" instead of "location". You would need to create one "location" for each of the tax codes and map them to items in QuickBooks. Regarding the line item tax. I am not clear at all. You are saying that invoice does not show the tax rate, but you are deleting the line item tax from QuickBooks. It sounds like it is there if you are deleting it. Are you saying their is a line item, but it has no rate (e.g. 0%). If that is what you are saying you should open a ticket so we can review your control panel settings. No one has ever reported that issue before. In any event, if you are removing the line item tax from QuickBooks and replacing it with Order Level, then why not just use the Order Level setting? If you need further assistance please open a ticket so we have the information we need to properly investigate.

odathp Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 19-April-2010 Status: Offline Points: 0	Post Options Post Reply Quote odathp Report Post Thanks(0) Quote Reply Posted: 06-August-2010 at 8:50pm
	Just so we are on the same page, the invoice does not show the tax rate when using a tax file. That is our problem. Also, I wasn't talking about using tax zones. I was thinking about using tax by location using zip codes, which does not require mapping them to items in Quickbooks. It seems like the tax by location using zip codes is the same as using a tax file with the benefit of a user defined description along with going back to an order level tax vs the line item tax. Here is what our customer is currently doing. 1. Going PC and editing the order 2. Clicks on "Check Tax Rate" and gets the tax info (Orange County 7%) 3. Going back to QB invoice and deleting the line item tax 4. Changing the invoice to order level 5. Selecting a tax account for the appropriate tax rate If we could show the tax rate on the invoice, they wouldn't have to go back to PC and find the tax rate for each invoice. They would still be deleting the line item tax because QB Add-on does not support order level tax when using a tax file. Thanks again, John

Matt Members Profile Send Private Message Find Members Posts Add to Buddy List Moderator Group Joined: 20-July-2006 Location: United States Status: Offline Points: 73	Post Options Post Reply Quote Matt Report Post Thanks(0) Quote Reply Posted: 06-August-2010 at 8:19pm
	Thanks John, that is correct. Really the tax file is a great option for you. Entering 1471 zones into ProductCart and mapping them to items in QuickBooks would work, but that is really not efficient. What exactly do you need in your report? The invoice already has the zip code and tax rate. Do you need the county name? Maybe you can customize the report. Just a thought.

odathp Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 19-April-2010 Status: Offline Points: 0	Post Options Post Reply Quote odathp Report Post Thanks(0) Quote Reply Posted: 06-August-2010 at 8:00pm
	The "Display taxes separately" option is not available when using a tax file. We are using a tax file. We did noticed when "not using a tax file" there is an option for taxing by location. It appears in theory we could add each Florida zip code and the corresponding tax rate with a description. The customers tax file has 1471 zip codes. Wonder if there is a way to import that data into PC database? Seems to be a better option then a tax file. Giving us the ability to put a description of each tax rate that we are assuming would show up on the invoice. Thanks, John

Matt Members Profile Send Private Message Find Members Posts Add to Buddy List Moderator Group Joined: 20-July-2006 Location: United States Status: Offline Points: 73	Post Options Post Reply Quote Matt Report Post Thanks(0) Quote Reply Posted: 06-August-2010 at 12:55pm
	So you basically just need the description of the tax in QuickBooks to have more detail. What value do you have for "Display taxes separately?" in ProductCart tax settings?

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 06-August-2010 at 10:34am
	Some time ago we built a custom sales report that tracks sales tax by rate at the line item level. If that would be useful, we could provide such a mod for you.

odathp Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 19-April-2010 Status: Offline Points: 0	Post Options Post Reply Quote odathp Report Post Thanks(0) Quote Reply Posted: 06-August-2010 at 10:21am
	I guess my last post was a little long winded. To summarize, the customer is currently using line item tax and a tax file. Everything works. They would like to include the [tax file] tax rate on the invoice. The invoice currently says "Florida Sales Tax" on the line item tax description. They would like to change it to "Florida Sales Tax (Orange County 7%). "Orlando County 7%" comes from the tax file. Could you point me to the code? I could have my staff modified it to meet the customer needs. Or, if Early Impact feels this is a valuable enhancement, they could include it in the next version of PC. Now that I think of it, this is possibly not a QB Add-on issue. I put it here because the customer needs to identify the tax rate for each invoice that is sent to QB (for IRS auditing purposes). Thanks, John

Matt Members Profile Send Private Message Find Members Posts Add to Buddy List Moderator Group Joined: 20-July-2006 Location: United States Status: Offline Points: 73	Post Options Post Reply Quote Matt Report Post Thanks(0) Quote Reply Posted: 06-August-2010 at 2:14am
	Hi John, are you asking if the Add-On supports order level tax, or are you saying it is not working? Have you read the section in the guide about configuring your tax preferences? From what you have posted I think line item tax and a tax file would be the best solution for you. However, you can use order level tax and have the same results. You basically just map the accounts in ProductCart to the ones in QuickBooks. If you feel you have found a bug please open a support ticket so we can investigate.