Which accounting software ?

[colinicky]

Originally Posted by Mark Chase

So i went back to a spread sheet. My one does vat and would be simple to set up for multiple vat percentages.

I put in the amount and put a 1 in the next box if its vat able. If not i put a 0 This could easily be adjusted for a 2 or 3 for different rates.

ATB

Mark

this is what I'm after ATM my mother would enter the total, then the basic amount & then the vat element all by hand & working out each bit with a calculator !

Because most of our things are fixed price the ideal for me would be a formula that gave this :-

If Column A = "ground rent " then column B = £2000 ,then Column C= (column B /117.5*100),then Column D = (column B/117.5*17.5 )

If you see what I mean ? but how the hell do you write a formula for that !

[Mark Chase]

Originally Posted by colinicky

this is what I'm after ATM my mother would enter the total, then the basic amount & then the vat element all by hand & working out each bit with a calculator !

Because most of our things are fixed price the ideal for me would be a formula that gave this :-

If Column A = "ground rent " then column B = £2000 ,then Column C= (column B /117.5*100),then Column D = (column B/117.5*17.5 )

If you see what I mean ? but how the hell do you write a formula for that !

H5 is the triger which is a 1 or a 0 for three diferent VAT settings id need

H, I and J and to put a 1 in the relevent column

Then you will need three VAT columns each with a letter asociated H I or J

If H = 0 coloumn 1 =0.00

If I = 0 coloumn 2 = 0.00

If J =1 then coloumn 3 = VAT at what ever rate you set it.


My coloums are set to things like car, office wages, tools, phone etc etc. They start at L and go up to coloumn U

So my system takes what vere numbers apear on that row and do the math bassed on a 1 being in box H

=SUM(L5:U5)*17.5%*H5

Ill send you a months accounts to play with

ATB

Mark