Tax Spreadsheet

[John Brown]

Any chance of re-posting the spreadsheet you did for calculating your income tax, NormanH.

Somehow my down-loaded version does not work now

John

[NormanH]

I will be updating it, but not till the end of the week as I am away from home from Monday for a few days In any case another poster has come up with something more sophisticated, which I hope will lead to improvements in mine [:D]

[John Brown]

Thanks Norman,

Filling in 2047K & 2042 SK but can't find 8TK anymore ?

Glass or 2 of Merlot needed.

Put the form away till next week, better luck then 

[NormanH]

On my paper version it 8TK is the fourth box up from the bottom on the last page of 2042

[John Brown]

Thanks Norman

On my paper version there is no 8TK because its a simpified pre part-completed version that was sent out to me ( by mistake I think )

I'll have to wait till after 1st May when the down-loadable version of a normal full form is available.

I must admit I did trawl the internet trying to find why my form was different.

And then I tried completing the Return on-line and got really spooked when it said twice that my figures don't add up, when I knew they did

Apparently the version I got was for someone still in work ( whatever that this, must be something I once did? )

John

[NormanH]

This is my latest attempt

https://docs.google.com/file/d/0B-TBbphDzPcwYWlXck9xN2hBMUE/edit?usp=sharing

before using in anger I hope some other people will check.

I have tried to include:

the 1156 € reduction for income below a certain sum

and the decote if the tax bill would be under 960€, but I may have made mistakes

[AnOther]

Link doesn't work for me, throws up an 'Erreur dans Google Drive'

[NormanH]

mmm I wonder why not?

Works for me on various browsers, but then it IS my page

[NormanH]

Does this work?

https://www.dropbox.com/s/6q3x5452nekzqhb/frenchtax2013%20%28copy%29.ods

[Gardian]

Nope - IE said "Non".

[NormanH]

Weird both  links work for me, and my smartphone can find the Dropbox one too.

https://www.dropbox.com/s/6q3x5452nekzqhb/frenchtax2013%20%28copy%29.ods

Must be a Windoze problem..

[AnOther]

Got it downloaded from the Dropbox link but the computer doesn't know what to do with an Open Office .ods file, Excel won't have it.

Converted it online to .xls and then it opens.

The perils of using niche non standard software [;-)]

Free instant online conversion here:

http://www.freefileconvert.com

One point, why is it showing Social Charges on the OAP, (B3), they are not applicable if you are on an S1 which presumably most will be ?

[NormanH]

The Social charges are there because I do have to pay them.

Those who don't  can just ignore them of course.

I thought LibreOffice was the standard software nowadays? In any case it can handle both .ods and .xls....[6]

Thanks for doing that.   [B]Does it seem about right?

[John Brown]

Thanks for the Spreadsheet

I lost some of the formula transfering it to Excel and with all the rain I've had time to fiddle with the spreadsheet restoring the lost data

Have a look at my attempt and see if you approve the changes !

I'll email to you ( edit, just tried, can't see how you do that )

John

[NormanH]

You can either upload it to something like Dropbox or Google documents and give a link, as I did, or you can pm me and I'll give you my email.

[John Brown]

Hi Norman

See if this works,

https://docs.google.com/file/d/0B02Cx1IXK4EqRy1yemxlQ2J1UTQ/edit?usp=sharing

John

[suein56]

John, as an interested party ie being a novice re pensions etc, I logged into my account to be able to 'see' your spreadsheet.

At the moment I am trying to understand why your savings interest should benefit from a 10% reduction.

Interest is not a pension, so why the 10% 'abattement' ?

Do you know something I don't ?

Sue

[NormanH]

Yes it works.

I think the first rate f tax is 5.5% rather than your 6%, and as sue implies there shouldn't be 10% off the savings...

[John Brown]

Great,

I've made the changes to the savings interest and the rate. It was using 5.5 but was rounded up in the cell to 2 decimal points to .6

If I include a line for WFA is it treated as a pension payment and does that get 10% off

Hopefully Parsnips can give it a once over and me a few ideas on how to develop this further so it can be better used

John

[NormanH]

I have added a line to allow for the fact that the Decote is only applicable if the French Tax person is less than 960€

I have sent it back hoping the format holds up.

I also sent another pm..

[John Brown]

I'd used last years threshold of 878 Euro so I'll change it to 960. Isn't the Decote applied to your tax figure after you had applied the DTT allowance

I know there's been some debate about this in the past

John

[NormanH]

Ah I didn't see a line which limited the decote to those under 960 or to 878.

The grey area is whether the figure of 960 is the figure after the French credit has been deducted  or before it has.

Obviously if it is before the deduction far fewer people would benefit...

[tinabee]

My tax office informed me that the decote is calculated BEFORE the deduction of the credit for government pensions (and presumably UK rental income).

Here's the text of the message I received:

Bonjour,

Le Royaume-Uni et la France ont signé une nouvelle convention relative à l'imposition des revenus acquis au Royaume –Uni.

A compter du 1er janvier 2010 la nouvelle convention du 19 juin 2008 est applicable.

L’article 24 de la nouvelle convention stipule que la double imposition sera évitée par l'imputation d'un crédit d'impôt et non plus selon la règle du taux effectif.

Le crédit d’impôt est égal au montant de l’impôt français correspondant à ces revenus à condition que le résident soit soumis à l’impôt du Royaume uni à raison de ces revenus.

Vos impositions, avant imputation du crédit d’impôt mentionné ci dessus, étant supérieure à 878 € la décote ne s’applique plus.

Je me tiens à votre disposition pour tout renseignement complémentaire et vous prie d’agréer,Madame Monsieur, l’expression de ma considération distinguée.

xxx xxx 
Contrôleur des Finances Publiques
Service des Impôts des Particuliers

[NormanH]

Yes that is what we were discussing with parsnips last year.

1) The fact that they don't apply the decote after the deduction but before, which he was trying to fight.

This changes the spreadsheet obviously.However I was sure that the amount was now 960, but perhaps they have gone back on the rise..

2) The fact that the system has changed which has yet again this year caused a lot of confusion here, not least because the Confusion  opps I mean the Correction paper has given wrong info bolstered by a meaningless article from Bevins Franks

[John Brown]

Thanks Tinabee,

I'll make the changes to the spreadsheet regarding both person's ages to qualify for low income / age related allowances

The deduction of "Reasonable Transfer Charges"  is from an earlier tax return ( I think 2008 ) where then it asked for gross and nett income from your Government / Local Authority Pension and with the nett figure I was told by the local Tax Office to use the amount that landed in my French bank account and that allowed for transfer charges & fees.

I'll move the Decote to before the DDT reduction until the battle is won by Parsnips & others over that

I'll put the respective social charges under different headings

Then I'll have a cup of tea