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

Please exercise caution & report any spam, illegal, offensive, racist, libellous post to forumteam@moneysavingexpert.com

  • 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,710
Thread Tools Search this Thread Display Modes
# 1
mercman1969
Old 27-09-2007, 11:43 AM
Serious MoneySaving Fan
 
Join Date: Apr 2006
Location: Grantham
Posts: 862
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?

Regards

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

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
isofa
Old 27-09-2007, 11:58 AM
Fantastically Fervent MoneySaving Super Fan
 
Join Date: Apr 2007
Posts: 5,953
Default

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,411
Default

Quote:
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

Bookmarks
 
 




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 - MoneySavingExpert.com - Archive - Privacy Statement - Top

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

All times are GMT +1. The time now is 6:17 AM.

 Forum Jump  

Free MoneySaving Email

Top deals: Week of 22 October 2014

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

profile

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.

TuneChecker Top Albums

  • ED SHEERANX (DELUXE EDITION)
  • STATUS QUOAQUOSTIC (STRIPPED BARE)
  • SAM SMITHIN THE LONELY HOUR (DELUXE EDITION)

MSE's Twitter Feed

profile
Always remember anyone can post on the MSE forums, so it can be very different from our opinion.
We use Skimlinks and other affiliated links in some of our boards, for some of our users.