nsForum logo

Welcome Guest ( Log In )

 
Reply to this topicStart new topic
> Orders With Sales Tax Importing With Items As Non-taxable, This will cause QB reports to be inaccurate.
Rhonda
post Jul 3 2008, 05:54 AM
Post #1





Group: Verified NS Member
Posts: 468
Joined: 1-March 08
From: Dallas, TX
Member No.: 734



When a taxable order is imported, the sales tax is listed on a line item for sales tax but the product line items are marked as non-taxable. This will be a problem when we go to run our sales tax reports to get total taxable sales and sales taxes paid. The total taxable sales will not be correct.

I know this was done to keep the QB sales tax from double-calculating sales tax but here is how eBay's import program handles that issue: They import the sales tax as a line item as webconnect does AND they set the products as taxable. THEN they update the QB sales receipt sales tax field to "see above" or some "non-taxable" item value so that sales tax is not double.

Webconnect needs to do something like this because if not, our QB sales tax reports will show that we are collecting more sales tax than total taxable sales generated.

Please review and update us on this issue.
Go to the top of the page
 
+Quote Post
batteryhouse
post Jul 11 2008, 09:22 AM
Post #2





Group: Verified NS Member
Posts: 1
Joined: 20-January 08
Member No.: 538



QUOTE (Rhonda @ Jul 3 2008, 10:32 AM) *
When a taxable order is imported, the sales tax is listed on a line item for sales tax but the product line items are marked as non-taxable. This will be a problem when we go to run our sales tax reports to get total taxable sales and sales taxes paid. The total taxable sales will not be correct.

I know this was done to keep the QB sales tax from double-calculating sales tax but here is how eBay's import program handles that issue: They import the sales tax as a line item as webconnect does AND they set the products as taxable. THEN they update the QB sales receipt sales tax field to "see above" or some "non-taxable" item value so that sales tax is not double.

Webconnect needs to do something like this because if not, our QB sales tax reports will show that we are collecting more sales tax than total taxable sales generated.

Please review and update us on this issue.



I am also haveing issues with this. This is very confusing for credit card transation since network solutions charges the sales tax to the customer but in quickbooks it doesnt so the two totals dont match.
Go to the top of the page
 
+Quote Post
Rhonda
post Jul 14 2008, 03:16 PM
Post #3





Group: Verified NS Member
Posts: 468
Joined: 1-March 08
From: Dallas, TX
Member No.: 734



Now that I'm finally able to import my orders for which I collect sales taxes, I am following up on this isue with orders with sales taxes not setting the individual line items to taxable. I though it might just be happening for non-registered customers but i see that it also happens for registered customers as well.

The order shows that the customer is taxable and there is a sale tax item and amount on the sales receipt BUT the individual lines items are not set to taxable and that is the problem. This makes all the tax sales revenue reports incorrect. They undervalue the amount of taxable sales which is a must to know when reporting and paying sales taxes to the state.

Does anyone else see what I'm talking about? To whom should I contact to get this on a fast track to be fixed? We pay sales taxes monthly and I have to manually update this to get my data accurate. MonsterBooks handled this correctly in the past.
Go to the top of the page
 
+Quote Post
Rhonda
post Jul 17 2008, 09:56 AM
Post #4





Group: Verified NS Member
Posts: 468
Joined: 1-March 08
From: Dallas, TX
Member No.: 734



bump.....

Any response from NS on this issue?

Anyone else having this issue?
Go to the top of the page
 
+Quote Post
vitality2
post May 8 2009, 06:10 PM
Post #5





Group: Verified NS Member
Posts: 7
Joined: 6-February 08
Member No.: 614



QUOTE (Rhonda @ Jul 14 2008, 02:34 PM) *
Now that I'm finally able to import my orders for which I collect sales taxes, I am following up on this issue with orders with sales taxes not setting the individual line items to taxable. I though it might just be happening for non-registered customers but i see that it also happens for registered customers as well.

The order shows that the customer is taxable and there is a sale tax item and amount on the sales receipt BUT the individual lines items are not set to taxable and that is the problem. This makes all the tax sales revenue reports incorrect. They undervalue the amount of taxable sales which is a must to know when reporting and paying sales taxes to the state.

Does anyone else see what I'm talking about? To whom should I contact to get this on a fast track to be fixed? We pay sales taxes monthly and I have to manually update this to get my data accurate. MonsterBooks handled this correctly in the past.



I have the same problem. NS claims that QuickBooks approved of them exporting taxable items as non taxable.

Have you found a solution?

I am going to try and get NS and QuickBooks together to solve this problem.

Thanks,
Dick
Go to the top of the page
 
+Quote Post
Tigger
post May 9 2009, 02:28 PM
Post #6





Group: Verified NS Member
Posts: 266
Joined: 9-August 08
From: Philadelphia, Pa
Member No.: 1,843



QUOTE (vitality2 @ May 8 2009, 07:28 PM) *
I have the same problem. NS claims that QuickBooks approved of them exporting taxable items as non taxable.

Have you found a solution?

I am going to try and get NS and QuickBooks together to solve this problem.

Thanks,
Dick


I am also having this problem. Running QB09 if that helps. Anyone else having this issue, if so please speak up so Netsol can see if it is an isolated or system wide problem.
Go to the top of the page
 
+Quote Post
Rhonda
post May 11 2009, 11:59 AM
Post #7





Group: Verified NS Member
Posts: 468
Joined: 1-March 08
From: Dallas, TX
Member No.: 734



QUOTE (Tigger @ May 9 2009, 02:46 PM) *
I am also having this problem. Running QB09 if that helps. Anyone else having this issue, if so please speak up so Netsol can see if it is an isolated or system wide problem.


I'm still having the problem and for what it's worth, these are my current issues that drive me nuts with the WebConnect:

1) When a brand new customer account is created for a customer OUT of my taxable state, the line items are properly imported as non-taxable but the customer account is incorrectly imported at "taxable."

2) When a brand new customer account is created for a customer IN my taxable state, the line items are incorrectly imported as non-taxable but the customer account is properly imported as taxable.

3) When a customer (who didn't register an account) who lives in my taxable state places an order, the line items are incorrectly imported as non-taxable.

4) For orders places inside my taxable state, the sales tax line item always imports properly but the sales tax code is never set to the value I created and thought I had properly mapped with NS. It is always set to No Sales Tax but I want it to map to "See Above" (a special sale tax item to alert the customer that the sales tax is listed as a line item above).

If these tax issues could be resolved, I wouldn't have to touch my orders so much once they are imported! I am willing to offer any assistance with testing, etc if NS could get someone to work on these issues.

I am also waiting on the following:

1) Country to be removed from the shipping address field when it's US so that we can easily ship from QB (as Monsterbooks used to do).
2) Order number to be populated in the Sales # field (as Monsterbooks used to do) instead of in the memo field.
3) The customer order notes to populate in a line item field (as Monsterbooks used to do) so we can easily see them instead of in the memo field.

Thanks!
Go to the top of the page
 
+Quote Post
vitality2
post May 15 2009, 11:11 AM
Post #8





Group: Verified NS Member
Posts: 7
Joined: 6-February 08
Member No.: 614



Hi Ronda,

Frustrating is it!

I just sent my second email to NS on this problem. I hope to hear from them.

Dick
Go to the top of the page
 
+Quote Post
Tigger
post May 28 2009, 09:05 PM
Post #9





Group: Verified NS Member
Posts: 266
Joined: 9-August 08
From: Philadelphia, Pa
Member No.: 1,843



For the record. As of this date, the problem still exists. Having to go into each order to change items from non tax to taxable, having to edit "WebStore Guest Customer" for existing customers, having to remove parentasis from customer and item names is all so very time consuming. An answer from Netsol on these issues is long overdue.

Thanks,
Angel
Go to the top of the page
 
+Quote Post
dlevens
post Sep 30 2009, 02:10 AM
Post #10





Group: Verified NS Member
Posts: 48
Joined: 5-August 09
Member No.: 4,918



QUOTE (Rhonda @ May 11 2009, 12:07 PM) *
I'm still having the problem and for what it's worth, these are my current issues that drive me nuts with the WebConnect:

1) When a brand new customer account is created for a customer OUT of my taxable state, the line items are properly imported as non-taxable but the customer account is incorrectly imported at "taxable."

2) When a brand new customer account is created for a customer IN my taxable state, the line items are incorrectly imported as non-taxable but the customer account is properly imported as taxable.

3) When a customer (who didn't register an account) who lives in my taxable state places an order, the line items are incorrectly imported as non-taxable.

4) For orders places inside my taxable state, the sales tax line item always imports properly but the sales tax code is never set to the value I created and thought I had properly mapped with NS. It is always set to No Sales Tax but I want it to map to "See Above" (a special sale tax item to alert the customer that the sales tax is listed as a line item above).

If these tax issues could be resolved, I wouldn't have to touch my orders so much once they are imported! I am willing to offer any assistance with testing, etc if NS could get someone to work on these issues.

I am also waiting on the following:

1) Country to be removed from the shipping address field when it's US so that we can easily ship from QB (as Monsterbooks used to do).
2) Order number to be populated in the Sales # field (as Monsterbooks used to do) instead of in the memo field.
3) The customer order notes to populate in a line item field (as Monsterbooks used to do) so we can easily see them instead of in the memo field.

Thanks!


This post was placed in May, and it is now a few days away from October and I still see these same issues. Were any of these fixed? Does NS even care to fix them? 5 months have gone by and what do we have to show for it?

Dennis
Go to the top of the page
 
+Quote Post
Tigger
post Sep 30 2009, 08:44 PM
Post #11





Group: Verified NS Member
Posts: 266
Joined: 9-August 08
From: Philadelphia, Pa
Member No.: 1,843



I wonder how many merchants actually use this feature. I do and would like to see this fixed. If you use this feature and would like to see it fixed, you should post your feelings. NS oils the squeaky wheel and if your not squeaking about this, don't expect for it to be fixed any time soon.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
Tags
No Tag inserted yet

1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

RSS Lo-Fi Version    Network Solutions © 2010 Time is now: 21st March 2010 - 12:44 AM
Domain Names | Web Hosting | Web Design | Shopping Cart Software | Online Marketing | SSL Certificates