Solved

Return tax information after creating invoice

Posted on 2014-03-05
6
401 Views
Last Modified: 2014-03-07
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...
0
Comment
Question by:Zharphyn
  • 4
  • 2
6 Comments
 
LVL 91

Expert Comment

by:John Hurst
ID: 39908923
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
 

Author Comment

by:Zharphyn
ID: 39910178
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
 
LVL 91

Expert Comment

by:John Hurst
ID: 39910282
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:Zharphyn
ID: 39910761
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
 
LVL 91

Accepted Solution

by:
John Hurst earned 500 total points
ID: 39910788
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
 
LVL 91

Expert Comment

by:John Hurst
ID: 39913342
@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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I think the Typed DataTable and Typed DataSet are very good options when working with data, but I don't like auto-generated code. First, I create an Abstract Class for my DataTables Common Code.  This class Inherits from DataTable. Also, it can …
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

947 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now