View Single Post
  #2   Report Post  
Kassie
 
Posts: n/a
Default

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