2012-13 Taxi package Monday to Sunday

[antonycc]

Hello,

The taxi package shipped with a working week that wasn't the standard Monday to Sunday we normally use for the Taxi package. This doesn't affect the financials which are monthly in the P&L but some users may prefer to have it back using the standard week starting on a Monday.

Anyone with the 2012-13 Taxi package can download a new version (you original download links will work for a while).

For the more Excel savy, the changes can be made in your copy by doing the following:

1. Change SalesApr12 > Cell A10 to: =A7
2. Delete SalesApr12 > Row 8 and Row 9
3. In sheet SalesMar13, insert a row before row 64
4. Change SalesMar13 > Cell A64 to: =A63+1
5. Change SalesMar13 > Cell B64 to: =A64
6. Change SalesMar13 > Cell A65 to: =A64
7. Change SalesMar13 > Cell A66 to: =A64

(Take a backup before starting if you are unsure about this kind of thing).

Thanks,

Antony.

[antonycc]

A customer (thanks Bill) has pointed out another couple of corrections:

In the Draft Tax Calculation cell E14 references the Admin sheets cell L19 where it should reference L20. To correct this change the formula in E14 from:

=IF(E5>Admin!N20,IF(E5<Admin!N$23,(E5-Admin!N20)*Admin!L$19,(Admin!N$23-Admin!N20)*D14),0)

To

=IF(E5>Admin!N20,IF(E5<Admin!N$23,(E5-Admin!N20)*Admin!L$20,(Admin!N$23-Admin!N20)*D14),0)

The wages forecast deducts capital allowances twice. To correct this delete the values in Wages Forecast from cells B33 and C33.

The wages forecast also doesn't predict expenditure well. The update requires a more advanced amendment you may wish us to apply for your.
Change the value in Wages Forecast > D24 from:

=IF($C5>0,IF(D5>0,D9,$C9/$C19),0)

to

=IF($C5>0,IF(D5>0,D9,($C9-'Profit & Loss Acc'!$B10)/$C19+'Profit & Loss Acc'!$B10/12),0)

Then drag this formula over through cells E24 through O24.

Thanks,

Antony.

[antonycc]

A bug appear to have crept into the draft tax calculation for the Taxi package. This effects anyone using the draft calculation for planning how much to take as drawings and how much to set aside for tax.

Quite a significant bug but something quick to change. You can apply the change yourself using the details below or alternatively email your financial accounts file to: support@diyaccounting.co.uk and we'll apply the change for you.

Open Financialaccountsyearto050413 > Draft Tax calculation and change the formula in cell E8 to reference C9 instead of C8. Specifically
Change Draft Tax calculation > E8 from:

=IF((E7>0),(IF((E7<C8),E7*D8,C8*D8)),0)

to:

=IF((E7>0),(IF((E7<C9),E7*D8,C9*D8)),0)

And

Change Draft Tax calculation > E9 from:

=IF((E7>C9),((E7-C8)*D9),0)

to:

=IF((E7>C9),((E7-C9)*D9),0)

Sorry for any inconvenience caused.

Antony.

[Bill Hilton]

Thanks Antony. I have applied the suggested fixes. Its good to see you taking action on my feedback as well. I'm sure DIY will go from strength to strength. If you are interested I have applied another few modifications to help me monitor profits throughout the year. This helps to ensure that I don't get into a situation where I suddenly owe the Tax man money. I enter my receipts & expenses daily and also have other earnings from my pension & investments but can see at a glance my year to date profits & total taxable earnings.
Sincerely Bill

[antonycc]

Thanks Bill,

I'd be glad to hear of your enhancements. We do try to fit in updates each year. You could post the change here (if practical) or email us direct.

Thanks,

Antony.