sars travel allowance calculation

Upload: grant-douglas

Post on 30-Oct-2015

133 views

Category:

Documents


0 download

DESCRIPTION

This spreadsheet allows you to calculate your maximum travel allowance allowed by SARS.

TRANSCRIPT

Travel AllowanceDiagram to Estimate a Travel Allowance for an EmployeeItemCalculationAnswerThis column if you receive a fuel card1Original cost of car (including VAT, excluding finance costs)Supplied by employee129000=Automatically Calculated2Fixed cost of car as per table supplied by SARSUse table (convert to Rands)R 52,033.00=Enter the Amounts3Estimated number of kilometres travelled for year (Business and Private)Supplied by employee/300004Fixed Cost per kilometreCalculate (2/3)=R 1.735Fuel cost as per table supplied by SARSUse table (convert to Rands)+R 0.916Maintanance cost as per table supplied by SARSUse table (convert to Rands)+R 0.337Total cost per kilometreCalculate (4+5+6)=R 2.97R 2.06No Records kept:8Estimated number of kilometres per annum

Unless accurate records of kilometres travelled for both private and business purposes have been kept, the first 18000 kilometres will be deemed to be private.

Business kilometres will be deemed to be the differance between the total kilometres travelled and 18000 kilometres, limited to 14000 kilometresDeemed Business kilometresx156009Business portion of the annual travel allowance:Business kilometres x total cost per kilometreCalculate (7 x 8)=R 46,338.76R 32,173.9610Estimated TOTAL annual travel allowanceCalculate (9 / 40 x 100)=R 115,846.90R 80,434.9011Estimated travel allowance per payroll processing periodLine 10 / 12 months, 52 weeks or 26 bi-weeks=R 9,653.91R 6,702.91Useable Allowance at Percentage80.00%=R 7,723.13R 5,362.33

Travel Ratio (Bus/Tot)52.00%

2013 Travel AllowanceValue of the vehicle Fixed cost Fuel cost Maintenance (including VAT) (R)(R p.a.)(c/km)cost (c/km)00 - 60 00019,31081.426.26000060 001 - 120 000 38,33386.129.5120000120 001 - 180 00052,03390.832.8180000180 001 - 240 00065,66798.739.4240000240 001 - 300 00078,192113.646.3300000300 001 - 360 00090,668130.354.4360000360 001 - 420 000104,374134.767.7420000420 001 - 480 000118,078147.770.5480000exceeding 480 000118,078147.770.5