UK Vat & Duty Calculator - A simple freeware tool - Page 3 - The Wholesale Forums
 
 
 
Home  |  Register  |  Members  |  Calendar
Welcome to The Wholesale Forums! All times are GMT +1. The time now is 12:43 AM.

Old 22-06-2007, 11:24 AM   #21 (permalink)
Jezz
Community Member
 
Jezz is offline

Join Date: Jun 2007
Location: Australia
Posts: 43
iTrader: (0)
Thanks: 0
Thanked: 0 Times in 0 Posts

Default

Code:
// C = InitialPrice, I = Insurance, F = Shipping
DutyPayable = (InitialPrice + Insurance + Shipping)/100 * DutyRate;

//Add shipping and Insurance to initial price
InitialPrice += Insurance + Shipping;

// Apply Duty
InitialPrice += DutyPayable;

// Calculate VAT 
VatPayable =  InitialPrice/100 * VatRate;

// Apply VAT
TotalPrice = InitialPrice + VatPayable;
Think this is what we need?

This is getting a little embarrassing

Last edited by Jezz; 22-06-2007 at 11:43 AM..
Reply With Quote
Old 22-06-2007, 01:14 PM   #22 (permalink)
DSC
Community Members
 
DSC is offline

Join Date: Dec 2005
Location: England
Posts: 1,078
iTrader: (0)
Thanks: 0
Thanked: 0 Times in 0 Posts

Default

I think you've got it, should be a very useful tool and that you are doing it for free is great.
Reply With Quote
Old 22-06-2007, 01:30 PM   #23 (permalink)
D M
Community Member
 
D M is offline

Join Date: Jun 2007
Location: UK
Posts: 1,321
iTrader: (0)
Thanks: 3
Thanked: 27 Times in 25 Posts

Default

Here's how I would do it:

// Calculate CIF
CIF = Cost + Insurance + Frieght

// Calculate Duty
DutyPayable = CIF / 100 * DutyRate

// Calculate VAT
VatPayable = (CIF + DutyPayable) / 100 * VatRate

// Apply Duty + VAT
TotalPrice = CIF + DutyPayable + VatPayable
Reply With Quote
Old 22-06-2007, 02:07 PM   #24 (permalink)
Jezz
Community Member
 
Jezz is offline

Join Date: Jun 2007
Location: Australia
Posts: 43
iTrader: (0)
Thanks: 0
Thanked: 0 Times in 0 Posts

Default

Yes, I was just thinking that before I logged in DM
This is so simple, I feel like such a tool, LOL
Just that I couldn't find a simple formula for this anywhere.
Thankyou both heaps for this!

I'm going to fix this and upload it now.

Quote:
Originally Posted by DSC View Post
and that you are doing it for free is great.
Thanks DSC
I enjoy programming as a hobby, Still much to learn though
Reply With Quote
Old 22-06-2007, 02:44 PM   #25 (permalink)
Jezz
Community Member
 
Jezz is offline

Join Date: Jun 2007
Location: Australia
Posts: 43
iTrader: (0)
Thanks: 0
Thanked: 0 Times in 0 Posts

Default

Ok.. just uploaded the new version, which I think is actually working now.

Still needs an icon, I'm still searching for a suitable free one.

Edit: Ok bought an icon for a couple of bucks (better than me trying to make one )
I'm thinking that this probably won't stay something that doesn't need installation.
By making it an installed app I can then save settings to the registery etc..

That way the rates don't have to be hard coded, You'll be able to add your own products rates etc. And I've just found a webservice for currency conversion.
This means that I can add a currency convertor that will (optionally) update it's conversion values automatically.

A few more things that I've thought of as well.. but I won't promise too much at once

Last edited by Jezz; 22-06-2007 at 03:59 PM..
Reply With Quote
Old 24-06-2007, 02:18 PM   #26 (permalink)
Jezz
Community Member
 
Jezz is offline

Join Date: Jun 2007
Location: Australia
Posts: 43
iTrader: (0)
Thanks: 0
Thanked: 0 Times in 0 Posts

Default

I've just added a new version,
This has a currency converter, And uses a webservice to download the conversion rates.
And now it even has an icon! lol

I haven't done much in the way of error handling on the webservice bit...
So it will probably crash if you try to download rates without an internet connect.
I'll do something with this soon.

Cheers,

Jeremy

Last edited by Jezz; 28-06-2007 at 12:51 PM..
Reply With Quote
Old 28-06-2007, 12:52 PM   #27 (permalink)
Jezz
Community Member
 
Jezz is offline

Join Date: Jun 2007
Location: Australia
Posts: 43
iTrader: (0)
Thanks: 0
Thanked: 0 Times in 0 Posts

Default

I haven't bothered doing any more with this.
It does throw an exception if there is no active connection and you try to download the conversion rates.
It's a fairly easy problem to fix but I've been too slack!
Actually I'm quite bored with it now, lol

Is anybody using this?
(if there is I'll fix it)
Reply With Quote
Old 28-06-2007, 02:29 PM   #28 (permalink)
kkell69
Community Member
 
kkell69 is offline

Join Date: Jun 2007
Location: UK
Posts: 13
iTrader: (0)
Thanks: 0
Thanked: 0 Times in 0 Posts

Default

Hi Jez,

I would love to use it as this is all new to me and it would help alot.

Problem is when i download from rapidshare and i uncompress it wont work!

Any help would be great

cheers
KKell69
Reply With Quote
Old 28-06-2007, 02:50 PM   #29 (permalink)
Jezz
Community Member
 
Jezz is offline

Join Date: Jun 2007
Location: Australia
Posts: 43
iTrader: (0)
Thanks: 0
Thanked: 0 Times in 0 Posts

Default

Hi kkell69,

The problem is most likely that you do not have the .net framework 1.1 installed
It's available here:
http://www.microsoft.com/downloads/d...displaylang=en

It's a fairly large download though (22mb) And will only work on xp or vista.
Bummer hey, I need to learn C++
Then my stuff will run on anything.

Edit:
I was wrong the .net framework 1.1 will run on these systems:

Windows 2000; Windows 98; Windows 98 Second Edition; Windows ME; Windows NT; Windows Server 2003 Service Pack 1 for Itanium-based Systems; Windows Server 2003 x64 editions; Windows Vista Business; Windows Vista Enterprise; Windows Vista Home Basic; Windows Vista Home Premium; Windows Vista Starter; Windows Vista Ultimate; Windows XP; Windows XP Professional x64 Edition

It's a pain to have to download such a large file just to run this simple little program, but many other programs also require this to run.

Cheers,
Jeremy

Last edited by Jezz; 28-06-2007 at 03:12 PM..
Reply With Quote
Old 28-06-2007, 09:04 PM   #30 (permalink)
kkell69
Community Member
 
kkell69 is offline

Join Date: Jun 2007
Location: UK
Posts: 13
iTrader: (0)
Thanks: 0
Thanked: 0 Times in 0 Posts

Default

great piece of software, i will use it all the time.


Many Thanks

Reply With Quote
Reply

Thread Tools
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
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
VAT and Import Duty - Your Questions Answered malcolmk133 Import/Export, VAT/Tax and Legal Discussion 93 25-11-2008 10:29 AM
Individual Selling Goods Online, Legalities jaguar65 Advertising and e-Commerce Discussion 21 25-06-2008 04:36 PM
import duty and vat quick quest 3701 Import/Export, VAT/Tax and Legal Discussion 11 09-01-2008 01:18 AM
VAT help. andy Import/Export, VAT/Tax and Legal Discussion 33 03-08-2007 09:55 AM
VAT and/or duty?? wba88 Import/Export, VAT/Tax and Legal Discussion 2 22-05-2007 12:30 PM


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

Control Panel
Member Login:
Quick Navigation
Register
Forum Rules
Advertising Opportunities
Member of the Month
Top Contributors
Contact Us
Advertisement
Member of the Month
TWF - Member of the Month AwardDecember 2008
Costaconsoles
Popular Discussions
Recession, hard times?
Pound getting weaker
eBay suspensions galore?
Opening online store
Tips for new members
Useful Articles
Tips for Supplier Checking
Dealing with the Chinese
Sourcing Products Abroad
UK VAT and Import Duties
Approaching Wholesalers
Newsletters
TWF Newsletter - July 08
TWF Newsletter - June 08
TWF Newsletter - Nov 07
Archived Newsletters
Forum Guides
Leaving iTrader Feedback
Reporting a Post
Competitions
Business Article Writing 08
Fantasy Football 2008/9
Resources
The Wholesale Directory
Top  |  Profile  |  Calendar  |  Archive  |  Advertise  |  Contact
Our Network: Wholesale Forums  |  Wholesale Products and Suppliers Directory  |  Wholesale Business Blog and Resources  
Skin Designed by: vBulletinSkinz.com
Powered by vBulletin® Version 3.7.4 | Copyright © 2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0
Copyright © The Wholesale Forums 2004-2008, All Rights Reserved.