Can anyone help me please?
I am in the situation where my Vehicle expenditure is shown as lower than my Mileage Allowance so the spread sheet has switched to Mileage allowance as the best tax option. However this shows me making more net profit than before the switch occurred. This seems strange to me.
The calculation in cell B10 of the Profit & Loss Acc page is as follows:-
If ((C1=Mileage Allowance), 0, (Fixed Assets I1+Fixed Assets J1+Fixed Assets P1+Fixed Assets Q1))
When I look at the workings for Fixed Assets I1 & J1; Cells I26 to I30, and Cells J36 to J43 all have a zero & no calculation in the cells. Can this be correct?
I understand that vehicle costs such as servicing, tyres & diesel all should disappear but Capital Allowance disappears as well. The effect is that no Capital allowance is added to my costs when the spread sheet has switched to the most efficient tax option of Mileage Allowance. This in turn means I will have to declare more net profit & pay more tax at the year end. It seems counterintuitive.