ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I need a template to track expense + VAT when building a house (https://www.excelbanter.com/excel-discussion-misc-queries/32068-i-need-template-track-expense-vat-when-building-house.html)

ScottBarbery

I need a template to track expense + VAT when building a house
 
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

Kassie

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



All times are GMT +1. The time now is 12:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com