keeping vat as o .. can anyone help

[nawara]

hey
i have recently figured out how to make access calculate my vat automaticaly for me
this is the procedure i carried out:
forms>suppliers forms(the name of my form)>design view>Vat(one of my feild name)>properties>All tab>control source
in control source i wrote this formula :
=[sub total]*0.175
0.175 being the VAT England uses

now my question is that some off my suppliers do not charge us vat
what is the best way for me to do this
can anyone help? if anyone can help it would be appreciated if you guided me through
ragards Noor

 

[neileg]

I suggest that you don't hard code the VAT calculation for lots of reasons.
- the VAT rate can vary for different goods or services from the same supplier
- some suppliers not being VAT registered
- if suppliers offer a settlement discount, then the VAT may be based on the discounted value
- there can be rounding differences

So, I would apply the VAT calculation on a line by line basis. If you want to speed things up, then you could make the default value of the VAT on the line 17.5% of the net, but you should allow the ability to alter this.

 

[nawara]

I suggest that you don't hard code the VAT calculation for lots of reasons.
- the VAT rate can vary for different goods or services from the same supplier
- some suppliers not being VAT registered
- if suppliers offer a settlement discount, then the VAT may be based on the discounted value
- there can be rounding differences

So, I would apply the VAT calculation on a line by line basis. If you want to speed things up, then you could make the default value of the VAT on the line 17.5% of the net, but you should allow the ability to alter this.

thnks neileg your very kind
but could you tell me how to make it a default .. i am fairly new to access so it would be gratefull if you could step by step direct me
thank you
regards Noor

 

[DCrake]

Simple Software Solutions

Following on from Neil's thread Vat rates and Vat codes are common through all accounting systems. They tend to appear as

T1 = x
T2 = y
T3 = z

Can't remember the exact codes and rates of the top of my head. However, consider having fields in you table that hold the actual vat rate a transaction level.

Lets suppose you you have your table and T1 = 17.5% and you have a query that calculates the vat content based on the value of T1. This is fine until the government decides to change the vat rate when you run a historical report it will calculate the vat content for the whole period at the new rate. You can either store the net and vat content as seprate values in your table and add them both together to to give you the gross in your queries or the net amount and the percentage rate at the point the transaction was made, again calculating the vat in your query.

This is one occasion when storing a calculated value in a field is perfectly acceptable.

Another tip is if you want to calulate the vat content of a given value if you use the formula 7/47ths this will calculate the amount of vat charged on a gross amount.

So (117.5 / 47)*7 = 17.5

CodeMaster:

 

[neileg]

If you open the Properties Sheet for the control where you show the VAT, look on the Data tab and there is a property called Default Value. Put your formula in there. When you create a new record, the VAT calculation will appear in that control, but you can overtype it it it isn't what you want.

I would use Round() as well to round the calculation to 2 decimal places.

 

[nawara]

If you open the Properties Sheet for the control where you show the VAT, look on the Data tab and there is a property called Default Value. Put your formula in there. When you create a new record, the VAT calculation will appear in that control, but you can overtype it it it isn't what you want.

I would use Round() as well to round the calculation to 2 decimal places.

hmmm i tried tht but it doesnt calculate it automatically.... maybe i am doing something wrong:s

 

[nawara]

Following on from Neil's thread Vat rates and Vat codes are common through all accounting systems. They tend to appear as

T1 = x
T2 = y
T3 = z

Can't remember the exact codes and rates of the top of my head. However, consider having fields in you table that hold the actual vat rate a transaction level.

Lets suppose you you have your table and T1 = 17.5% and you have a query that calculates the vat content based on the value of T1. This is fine until the government decides to change the vat rate when you run a historical report it will calculate the vat content for the whole period at the new rate. You can either store the net and vat content as seprate values in your table and add them both together to to give you the gross in your queries or the net amount and the percentage rate at the point the transaction was made, again calculating the vat in your query.

This is one occasion when storing a calculated value in a field is perfectly acceptable.

Another tip is if you want to calulate the vat content of a given value if you use the formula 7/47ths this will calculate the amount of vat charged on a gross amount.



CodeMaster:

hmm is queries the only way we can carry this out?
thanks soo much btw.. much appreciated

 

[Rabbie]

hmm is queries the only way we can carry this out?
thanks soo much btw.. much appreciated

You can do it on forms but you may need a little VBA to do the actual calculations after you input the net price. I use a VAT Rate table indexed by a VAT code so I know which rate to use.

 

[nawara]

You can do it on forms but you may need a little VBA to do the actual calculations after you input the net price. I use a VAT Rate table indexed by a VAT code so I know which rate to use.

how would i do this?

 

[neileg]

You need to have a field in your transaction table for the VAT and bind the control in your form to that field (in other words the control source for the control is the field in the table). You would then put some VBA behind the text box where you enter the net price to trigger the calculation.

To pick up on some of the points raised by other posters about VAT rates. Firstly, you can only reclaim the input tax on a VAT invoice that is specified in the invoice. That is true even if the calculation is wrong. So if your invoice says £5.78, that's what you have to reclaim. If your own calculation works this out at £5.79 or even £57.80, you still need to record £5.78. The use of rates tables for input tax is less appropriate than it is for output tax calculation. Secondly, the 7/47 calculation is only valid where the 17.5% rate is used. If the VAT is at 5% then the fraction becomes 1/21. If the supplier has a settlement discount, then the fraction could be anything!

 

[Pauldohert]

Hi guys - I have a releated - but differnat question -

some may be interested or be able to help?

Do I work out VAT line by line or on the total of lines for each VAT rate - ie Invoice Total if all is at .175?

http://www.access-programmers.co.uk/forums/showthread.php?p=731546#post731546

Cheers.

 

[Rabbie]

Hi guys - I have a releated - but differnat question -

some may be interested or be able to help?

Do I work out VAT line by line or on the total of lines for each VAT rate - ie Invoice Total if all is at .175?

http://www.access-programmers.co.uk/forums/showthread.php?p=731546#post731546

Cheers.

HM Revenue and Customs allow you to use either method. The difference caused by rounding error is rarely more than a few pence.