Solved

Return tax information after creating invoice

Posted on 2014-03-05
6
403 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 94

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 94

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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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 94

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 94

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
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 …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

749 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