Return tax information after creating invoice

I am working on creating a program in VB.NET that connects to QuickBooks.  The program will track client's annual maintenance fees (AMF).  Currently, we create an estimate in QuickBooks for the AMF to send to clients, but the boss does not want QuickBooks to be cluttered with unpaid estimates, so moving forward, my program will store the estimates in a SQL Server DB and then push the estimate to QuickBooks as an invoice when the estimate gets paid.  All of this I can do, however where I am having a challenge, is in calculating taxes.  My boss want QuickBooks to calculate the taxes and then I am to store that information with the stored estimate.  His argument is that he does not want the invoice ultimately created in QuickBooks to be out by a penny or two from the estimate that we sent the client.
What I am supposed to do, is create the invoice information in my program, push the data to QuickBooks, and read back the tax information, and then delete the invoice from QuickBooks.  This all works, except where I have more than one tax applied to the invoice.  I am in Canada, and in my province (British Columiba) we have two sales taxes.  One from the Federal government (GST), and one from the Provincial government (PST).  I can read back from QuickBooks the total tax percentage, and total tax invoiced, but I am having difficulty figuring out how to read back the individual taxes.  I need to know the 5% GST and the 7% PST separately, but all I can find is 12% overall tax.
Does anyone know how to read the list of taxes applied, rather than the overall total of taxes applied?

Thanks
Brad

PS - I hope I made sense...
ZharphynAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnBusiness Consultant (Owner)Commented:
If you want the taxes separately, you need to go into the tax item list and set up tax codes for both PST and GST and how you want them calculated.

The reason you are getting one tax amount is that you have used one tax code in the invoice (say H tax code). That will never separate out.

So you need the G and P codes defined in the item list. They may already be there. Be aware that both taxes will show up on the invoice and that may be a customer service issue.

In terms of rounding, you need to round the tax the same way as QuickBooks. It keeps the tax separately in dollars and cents, so you need to do the same in your routine.

This is an overview, but once you have determined how to create your invoice with two tax codes, I can fill in the details.
0
ZharphynAuthor Commented:
Hi John
The QuickBooks invoice is being created with two separate taxes listed.  I am try to pull the data back through the sdk, but I can find no reference to a tax list, just the tax total.

Thanks
Brad
0
JohnBusiness Consultant (Owner)Commented:
A couple of things:

PST is not a flow through VAT, and so it gets accounted for and buried as a cost. In this case you would have to estimate it in your other program.

VAT taxes (GST) might get combined in one sales tax amount. If you have this (I don't think so) you would have to record the separate amounts in two sub accounts using the sales tax item list.
0
PMI ACP® Project Management

Prepare for the PMI Agile Certified Practitioner (PMI-ACP)® exam, which formally recognizes your knowledge of agile principles and your skill with agile techniques.

ZharphynAuthor Commented:
Is there no way that I can pull this information back from QuickBooks rather than estimate it?  The entire exercise was to try and avoid rounding discrepancies between the two programs.

Thanks
Brad
0
JohnBusiness Consultant (Owner)Commented:
If the amount is either combined in a tax line (not totally clear from above) or buried as part of cost (PST non-flow through), then no, there are no records in QuickBooks to get this information. Tax is set up to pay and be dispensed with.

You would need to see how QuickBooks rounds (items in dollars and cents rounded to the penny and added up) and round your program the same way.

Some institutions (my stupid telephone company) calculates in 13 decimals and rounds at the end. Then QuickBooks (even without your program) will come up with a different bill total than the phone company. I have to adjust tax manually.

The world is not perfect unfortunately.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JohnBusiness Consultant (Owner)Commented:
@Zharphyn - Thank you, I know getting two programs to match is not perfect. However, I was still happy to help to the extent that I could.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
QuickBooks

From novice to tech pro — start learning today.