I need a template to track expense + VAT when building a house

[Guest]

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

 

[Guest]

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