?
Solved

Compute VAT; formula, Access/VBA library

Posted on 1997-06-11
9
Medium Priority
?
1,857 Views
Last Modified: 2008-02-26
Does anyone know VAT formula or can tell me where i can find Access/VBA library for  VAT formula. In Europe and Canada, they use VATand can be up to 10 VATs.
Let say, given: qty=1, Price=$100.00, Amount= qty * Price = 1 * 100.00, where:      " * "  means multiplication.
 Compute each tax and Total  VAT if:
 Sales tax=3.00%, Province tax=3.00%, County tax=1.5%, City tax=1.5%, Government tax=2.00%.

Thanks in advance to all..
0
Comment
Question by:pisoft
[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
9 Comments
 

Author Comment

by:pisoft
ID: 1602823
Edited text of question
0
 

Author Comment

by:pisoft
ID: 1602824
Adjusted points to 100
0
 
LVL 3

Expert Comment

by:Bogey
ID: 1602825
The calculation is simply the PRICE times the product of each tax.

In you example:

PRICE * (1.03 x 1.03 x 1.015 x 1.015 x 1.02) = TOTAL

If you prefer just the actual TAX amount, TAX = TOTAL - PRICE




0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

Author Comment

by:pisoft
ID: 1602826
Bogey, Quebec does not compute it that way as well as other European countries. You computed it just like US SAles tax.
0
 
LVL 13

Expert Comment

by:akb
ID: 1602827
VAT = Price * 0.11482501655 or 11.482501655% (I think).
Actually I wouldn't have a clue but this numer seems to make sence!
0
 
LVL 2

Expert Comment

by:Philippe
ID: 1602828

Pisoft,

Unless your question is not well formulated, the answer is easy.

To calculate the total tax add up all taxes and multiply the result by the original price:

Let's suppose you have the tax in percent as in
T1 = 15 (15% state tax), T2 = 12 (12% county tax), T3 = 5 (5% bozo tax)

total = price * (T1+T2+T3+100)/100

Each single tax is

Tax1 = price * (T1+100)/100, Tax2 = price * (T2+100)/100, etc.

Hope this helps,

 Philippe

0
 
LVL 2

Expert Comment

by:Philippe
ID: 1602829

Pisoft,

could you comment on why you rejected the answer. It is not easy for us to help us if you don't give us more detailed information.

 cheers,

  Philippe

0
 

Author Comment

by:pisoft
ID: 1602830
I am looking for a Quebec and German VAT type of formula. The formula that I see are all standard sales tax formula as in the United States taxation. In the US, we have Tax Codes and we just add them. Not in Quebec, Not in Germany.
0
 

Accepted Solution

by:
mdl052397 earned 200 total points
ID: 1602831
Dear Pisoft,

As my main occupation is adminstrative s/w for Belgium and France, I know fairly well the VAT system. In Belgium you have the following VAT rates : 6%, 12%, 18%, 21% (applied for most products) and 33%

VAT is calculated on the net price, so after all other reductions were deducted.

ex:        base price                           1000,-
             sales reduction 10%            -100,-
             net price                               900,-
             VAT 21%                              189,-
             amount to pay                     1089,-

I never heard of libraries specifically treating this stuf, and I don't think they exist, as the calculation is fairly easy. Or I didn't understand your question well.

kind regards,

mdl
0

Featured Post

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

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

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

777 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