Maths question

[Nick]

 

[Snoopy]

Hang on, no. It's not working.
I've got a total VAT figure only here, and I need to work out what the cost was before the VAT was added.

You're assuming I've got a figure that's the total INCLUDING VAT. I've only got the VAT total that I've received from my cussies.

Ah! Sorry

 If I may say so your book keeping is a bit of a mess.

Surely you price a job, write an invoice (two copies) showing the price and add VAT so the invoice shows both pre and apres VAT totals.

All this working backwards from only one figure is guaranteed to cock up.

I know that's where you are at but for the future ..........................?

[Miss Demeanour]

NOOOOooooo  

[Nick]

 

[Pirate]

This might help

http://www.youtube.com/watch?v=Bfq5kju627c

[GROWLER]

Hang on, no. It's not working.
I've got a total VAT figure only here, and I need to work out what the cost was before the VAT was added.

You're assuming I've got a figure that's the total INCLUDING VAT. I've only got the VAT total that I've received from my cussies.

Ah! Sorry

 If I may say so your book keeping is a bit of a mess.

Surely you price a job, write an invoice (two copies) showing the price and add VAT so the invoice shows both pre and apres VAT totals.

All this working backwards from only one figure is guaranteed to cock up.

I know that's where you are at but for the future ..........................?

Yea, I know.
I've spent hours working out who's paid me over the last 4 months, and just adding the VAT paid figures up.
I should really have added up the invoices paid before VAT, and then it would have been simpler like wouldn't it...I think?

So, is there no formula for working the VAT backwards to find the cost before VAT then?
Have I got to go back to me books and paying in book to add everything up again before VAT, and then simply mutiply by 15% and 17.5% to double check the VAT received matches the all the paymants received?

Have I made that clear enough do you think?

[Barman]

Hang on, no. It's not working.
I've got a total VAT figure only here, and I need to work out what the cost was before the VAT was added.

You're assuming I've got a figure that's the total INCLUDING VAT. I've only got the VAT total that I've received from my cussies.

Ah! Sorry

 If I may say so your book keeping is a bit of a mess.

Surely you price a job, write an invoice (two copies) showing the price and add VAT so the invoice shows both pre and apres VAT totals.

All this working backwards from only one figure is guaranteed to cock up.

I know that's where you are at but for the future ..........................?

Yea, I know.
I've spent hours working out who's paid me over the last 4 months, and just adding the VAT paid figures up.
I should really have added up the invoices paid before VAT, and then it would have been simpler like wouldn't it...I think?

So, is there no formula for working the VAT backwards to find the cost before VAT then?
Have I got to go back to me books and paying in book to add everything up again before VAT, and then simply mutiply by 15% and 17.5% to double check the VAT received matches the all the paymants received?

Have I made that clear enough do you think?

Why don't you type the numbers into a spreadsheet... you can do what you like with them then... 

[Snoopy]

Hang on, no. It's not working.
I've got a total VAT figure only here, and I need to work out what the cost was before the VAT was added.

You're assuming I've got a figure that's the total INCLUDING VAT. I've only got the VAT total that I've received from my cussies.

Ah! Sorry

 If I may say so your book keeping is a bit of a mess.

Surely you price a job, write an invoice (two copies) showing the price and add VAT so the invoice shows both pre and apres VAT totals.

All this working backwards from only one figure is guaranteed to cock up.

I know that's where you are at but for the future ..........................?

Yea, I know.
I've spent hours working out who's paid me over the last 4 months, and just adding the VAT paid figures up.
I should really have added up the invoices paid before VAT, and then it would have been simpler like wouldn't it...I think?

So, is there no formula for working the VAT backwards to find the cost before VAT then?
Have I got to go back to me books and paying in book to add everything up again before VAT, and then simply mutiply by 15% and 17.5% to double check the VAT received matches the all the paymants received?

Have I made that clear enough do you think?

Yes ~ clear as mud

And yes ~ I rather think you do need to add up the other totals as well.

Anything else is bound to end in disaster. Sorry.

[GROWLER]

This might help

http://www.youtube.com/watch?v=Bfq5kju627c

 

[Snoopy]

Why don't you type the numbers into a spreadsheet... you can do what you like with them then...  

Easy for you to say from that distance. Some of us are within range.

[GROWLER]

Hang on, no. It's not working.
I've got a total VAT figure only here, and I need to work out what the cost was before the VAT was added.

You're assuming I've got a figure that's the total INCLUDING VAT. I've only got the VAT total that I've received from my cussies.

Ah! Sorry

 If I may say so your book keeping is a bit of a mess.

Surely you price a job, write an invoice (two copies) showing the price and add VAT so the invoice shows both pre and apres VAT totals.

All this working backwards from only one figure is guaranteed to cock up.

I know that's where you are at but for the future ..........................?

Yea, I know.
I've spent hours working out who's paid me over the last 4 months, and just adding the VAT paid figures up.
I should really have added up the invoices paid before VAT, and then it would have been simpler like wouldn't it...I think?

So, is there no formula for working the VAT backwards to find the cost before VAT then?
Have I got to go back to me books and paying in book to add everything up again before VAT, and then simply mutiply by 15% and 17.5% to double check the VAT received matches the all the paymants received?

Have I made that clear enough do you think?

Why don't you type the numbers into a spreadsheet... you can do what you like with them then... 

Ey?

Is that some sort of digitalisation scheme for anna log maths then?

It should be dead simple this, really.

?115 inc VAT has ?15 of VAT in it if it the ?100 was charged at 15% VAT, yes?
So, I've now got a sum of ?15 in me hand...cash to make it easier like.
How do I simply work out using a formula what the price was before I charged the VAT, which as we all know was ?100.
It's just the formula i need.

[Snoopy]

In theory ?15 represents the VAT@15% so divide it by 15 and multiply by 100.

?15 divided by 15=?1

?1x100 = ?100.

Total bill should then have been ?115.

Let's try it with ?153.75 being the VAT collected at 15%

?153.75 divided by 15 = ?10.25

?10.25 x 100 = ?1025.00

Total bill should then have been ?1178.75

[GROWLER]

In theory ?15 represents the VAT@15% so divide it by 15 and multiply by 100.

?15 divided by 15=?1

?1x100 = ?100.

Total bill should then have been ?115.

Let's try it with ?153.75 being the VAT collected at 15%

?153.75 divided by 15 = ?10.25

?10.25 x 100 = ?1025.00

Total bill should then have been ?1178.75

Yup. I think that works. Got to go out but will resume this fun tax collecting and workings out later.

Tax needn't be taxing ey?

[Nick]

 

[Barman]

In theory ?15 represents the VAT@15% so divide it by 15 and multiply by 100.

?15 divided by 15=?1

?1x100 = ?100.

Total bill should then have been ?115.

Let's try it with ?153.75 being the VAT collected at 15%

?153.75 divided by 15 = ?10.25

?10.25 x 100 = ?1025.00

Total bill should then have been ?1178.75

Quite so Snoopy...

A spreadsheet with the pre VAt amount, VAT, add totals would allow you to automatically add them all up and cross check...

As Snoopy points out any other way simply won't work and the VAT man will be down on you like several tonnes of stolen hub caps...