IMPORTANT! This is MoneySavingExpert's open forum - anyone can post

Please exercise caution & report any spam, illegal, offensive, racist, libellous post to

  • Be nice to all MoneySavers
  • All the best tips go in the MoneySavingExpert weekly email

    Plus all the new guides, deals & loopholes

  • No spam/referral links
or Login with Facebook
VAT - Excel Document
Closed Thread
Views: 5,844
Thread Tools Search this Thread Display Modes
# 1
Old 27-09-2007, 11:43 AM
Serious MoneySaving Fan
Join Date: Apr 2006
Location: Grantham
Posts: 865
Default VAT - Excel Document

Hi all,

Friend of mine is in charge of running a small rest room tea bar.
He has an excel document which he has been using to administer the accounting for this.

All was fine until he had the bright idea of using bookers as opposed to ASDA to purchase stock

now the problem is that some of the stuff is chargable for VAt and some isnt

What, if any is the best way to update his document to account for VAT?

is it as simple as a autosum formula? if so, how?


mercman1969 is offline
Report Post
# 2
Old 27-09-2007, 11:52 AM
MoneySaving Stalwart
Join Date: Feb 2007
Posts: 322

If I read your post correctly, then a simple way to calculate VAT on excel is to multiply the net figure by 1.175

So if the net figure is in cell A1, the formula is =a1*1.175 which will give you the gross figure (including vat). To strip out the VAT and return to the net figure divide by 1.175 hence =a1/1.175
timnicebutdim is offline
Report Post
# 3
Old 27-09-2007, 11:58 AM
Fantastically Fervent MoneySaving Super Fan
Join Date: Apr 2007
Posts: 5,956

I'd have three columns for the amount:

Net, VAT and Gross

Net - obviously free from VAT.
VAT - show the VAT amount if there is any (you can auto calc this from using net*17.5/100
Gross - have this totalling the Net and VAT columns.

Obviously if there is no VAT on the item, put a zero in the VAT column so the net and gross show the same value.

As this is food related, there may be different VAT rates applicable, so you might want a 4th column to show the VAT rate.
isofa is offline
Report Post
The Following User Says Thank You to isofa For This Useful Post: Show me >>
# 4
Bean Counter
Old 27-09-2007, 12:22 PM
Serious MoneySaving Fan
Join Date: Mar 2007
Location: Scotland
Posts: 1,424

Originally Posted by mercman1969 View Post
All was fine until he had the bright idea of using bookers as opposed to ASDA to purchase stock

now the problem is that some of the stuff is chargable for VAt and some isnt
Is all the information not on the VAT receipt from Bookers? And if he does not have a VAT receipt he should ask for one. The VAT receipt will detail how much as been bought at the different VAT rates i.e. the net and VAT amounts for each category.
Bean Counter is offline
Report Post
Closed Thread


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

 Forum Jump  

Contact Us - - Archive - Privacy Statement - Top

Powered by vBulletin® Copyright ©2000 - 2015, Jelsoft Enterprises Ltd.

All times are GMT. The time now is 12:35 AM.

 Forum Jump  

Free MoneySaving Email

Top deals: Week of 25 March 2015

Get all this & more in MoneySavingExpert's weekly email full of guides, vouchers and Deals

GET THIS FREE WEEKLY EMAIL Full of deals, guides & it's spam free

Latest News & Blogs

Martin's Twitter Feed


Cheap Travel Money

Find the best online rate for holiday cash with MSE's TravelMoneyMax.

Find the best online rate for your holiday cash with MoneySavingExpert's TravelMoneyMax.

MSE's Twitter Feed