Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
ScottBarbery
 
Posts: n/a
Default 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
  #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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Expense report template tired of searching Excel Discussion (Misc queries) 2 May 22nd 05 08:48 PM
How to change $ to £ in pre-formatted "Expense Statement" template Ardnanrigh Excel Discussion (Misc queries) 6 February 4th 05 11:09 PM
What is the best template to keep track of all the utility bills.. rayann03 Excel Discussion (Misc queries) 0 January 31st 05 08:33 PM
where can I get a template for excel to track vending machine tak. templates Excel Discussion (Misc queries) 0 January 9th 05 03:37 AM


All times are GMT +1. The time now is 06:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"