Rank: Member
Joined: 10/7/2005(UTC) Posts: 43
|
Hello.
I am finally exporting orders from my website to QB. I have had a few issues with shipping and handling not mapping over to QB but I think I have fixed the problem. The only problem I have thus far is the following...
Order Example....
Order subtotal 370.00 tax 31.45 Shipping 0.00 Handing 1.00 Total: 402.45
This order used a promo code of "Shipfree" to get free shipping. In the past the QB Connector would add a discount line to make up for the shipping discount. So the discount shipping line is mapping over as BVC-Shipping instead of BVC-Discount. How do I set up 3.13 to document BVC-Discount when a discount is taken? I am exporting many orders and going back and finding orders with outstanding balances since the discount was not recognized on the invoice. Thanks for your help!
FYI, I am exporting orders from BV4 cart. My site is using BV5 but I am months away until I start exporting from the newer version. |
|
|
|
|
Rank: Member
Joined: 6/6/2005(UTC) Posts: 483
|
I don't understand your problem. In your example Sales should come across = 370, Tax Payable should = 31.45, Shipping = 0.00 or $1 depending on where you got your handling charges going. Your actual shipping charges for this item should be charged to shipping outside BV on your accounting system (QB). This should leave you with a debit balance in shipping expense at the end of the year instead of 0 or a slight credit balance. Talk to your accountant but I don't think you really need to put your defrayed shipping charges in as a discount. None of that stuff is going to come out exactly even anyway. The main thing is all the numbers should add up to 402.45.
If they don't, I don't know if this will help but.... Try changing the item that BV uses for the charge in question (that it sets up in QB) in QB to go to the proper account.
Bob Noble
|
|
|
|
Rank: Member
Joined: 3/3/2006(UTC) Posts: 1,737
|
I'm with Bob... I think. Shipping is a 'free' item to the customer, but to you it's either an additional 'cost of materials sold' or a marketing/advertizing cost. I'd go to the QB forum and seek advise from someone with stronger accounting skills and QB chops.
Let us know how you go with this. How to credit/charge off 'free' stuff, 'discounted' stuff has always been a grey area for me. There are tax implications, in some states shipping costs are added to the price and is taxed. This should all be set up on your QB quarterlies to show the costs even if you did give it away as a promotion. These costs will be reportable in a different column.
If your state collects sales tax on shipping, they'll have some say as to how you handle this too.
Also, put something relevant in the thread's title so we can find this in the future. |
Optimists invent airplanes, Pessimists buy parachutes. |
|
|
|
Rank: Member
Joined: 10/7/2005(UTC) Posts: 43
|
Thank you for the feedback. I agree with your statements but the issue at hand is the website is waiving shipping due to promo code being used. When I export an entire month worth of orders I see the waived s/h being charged.
So the fix is I have to manually go through every order and delete the shipping.
The way the old QB worked was when $$ showed up in the Admin Discount field it would create BVC-Discount on the invoice.
I do not think there is a fix to the problem. |
|
|
|
|
Rank: Member
Joined: 10/7/2005(UTC) Posts: 43
|
Any thoughts? My only other issue with 3.13 connector is it is charging tax to every order. So you can appreciate the mess I have for the month I just exported. Any advise would be great! |
|
|
|
|
Rank: Member
Joined: 3/3/2006(UTC) Posts: 1,737
|
Is the connector charging tax, or is QB charging tax upon import? Maybe a chat at QB's forum will get you more eyeballs on this. I don't think many here use it. |
Optimists invent airplanes, Pessimists buy parachutes. |
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.