Hi
something like:
A Date; B Description of expense; C Total expense; D VAT?
Headings in row 1
Then in D2 enter =C2-(c2/1.<your VAT %), eg =C2-(C2/1.14)
At the end of the day, total columns C and D, and you have your answer
"ScottBarbery" wrote:
Could someone please help me set up a template to track expense and VAT while
I am building my house? I need to track VAT so I can claim it back at the end
of the build. I am currently using Office 2003.
Thank You
|