Solved

Compute VAT; formula, Access/VBA library

Posted on 1997-06-11
9
1,844 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
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
 

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
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.

 
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 100 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

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

Have you ever had the experience that you had to follow 10 steps over and over again every time when you need to nicely forward an important email to your manager? Fear no more! With the help of the Quick Steps feature in Outlook 2010, your old chor…
Introduction It seems that at least a couple of times per month, I answer a question that requires automating Outlook from another Microsoft Office application, usually (although not always) to send one or more email messages.  For example: …
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

863 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

28 Experts available now in Live!

Get 1:1 Help Now