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?

Improve company productivity with a Business Account.Sign Up

x
 
JohnConnect With a Mentor Business 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
 
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
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
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
 
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:
@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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.