Solved

Return tax information after creating invoice

Posted on 2014-03-05
6
405 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 95

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 95

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
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 

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 95

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 95

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

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

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

A while ago, I was working on a Windows Forms application and I needed a special label control with reflection (glass) effect to show some titles in a stylish way. I've always enjoyed working with graphics, but it's never too clever to re-invent …
Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

691 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