AuditExcel.co.za

sars travel logbook excel

Run an office pool prediction sweepstakes (opens in new tab) during the 2024 European Soccer Championships.  

Excel logbook for SARS

' src=

If you are looking to create an Excel logbook for SARS and you want it to include the dates for working days only, you can easily create it in Excel using the WORKDAY function. Using this function means you that you won’t need to enter every date and it can even take into account public holidays.

Below a video explanation from our YouTube channel (please remember to susbcribe)

The process itself is fairly easy. Open a new workbook and in cell A2 enter the start date e.g. 1 Jan 2014.

In cell C2 to C15 list the public holidays you want to take into account.

Now in Cell A3 type the following formulae

=WORKDAY(A2,1,$C$2:$C$15)

The formula above will start at 1 Jan 2014 and will show you the date of the next workday. This formula assumes that Saturday and Sunday are non work days and also assumes that the public holidays listed in C2 to C15 are non work days. To understand how it works watch the WORKDAY video clip

You can now copy the formula down as far as you want and it will show only the upcoming workdays. Then to make it even more useful, format the date to include the day of the week (click on the date cells, right click and click on FORMAT CELLS, click on CUSTOM and in the dialogue box type dd mmm yyyy dddd)

If you work in an industry where Saturday and/ or Sundays could be work days e.g. a restaurant and you want for example a Monday to be treated as a ‘weekend’ then you need to make use of the WORKDAY.INTL function. All it asks for is an additional option of what is considered a weekend.

So the syntax as shown below is exactly the same except for the Weekend option

WORKDAY.INTL(Start Date, Days, [Weekend] ,[Holidays])

For the Weekend option you can enter a number from 1 to 17 which tells Excel what to consider a weekend i.e.

  • 1 or omitted = Saturday, Sunday
  • 2 = Sunday, Monday
  • 3 = Monday, Tuesday
  • 4 = Tuesday, Wednesday
  • 5 = Wednesday, Thursday
  • 6 = Thursday, Friday
  • 7 = Friday, Saturday
  • 11 = Sunday only
  • 12 = Monday only
  • 13 = Tuesday only
  • 14 = Wednesday only
  • 15 = Thursday only
  • 16 = Friday only
  • 17 = Saturday only

SARS Excel Logbook Download

Want to learn more about Microsoft Excel and creating a logbook yourself? If you prefer attending a course and live in South Africa look at the Johannesburg  MS Excel 3 Day Advanced Course   or the Cape Town  MS Excel 3 Day Advanced training course. If you prefer online learning or live outside South Africa, look at our  online MS Excel training courses .

Download the Free Excel Logbook from SARS here.

South Africa VAT Calculator for the move from 14% to 15%

All content copyright AuditExcel 2024

  • Privacy Policy
  • Terms & Conditions

How to Fill SARS Travel Logbook

If you use your private car for business purposes and receive a travel allowance from your employer, you can claim a deduction on your annual income tax return. To do this, you must have a SARS travel logbook where you record your vehicle’s odometer reading and details of your business travel. This article explains how you fill out your SARS travel logbook. 

How Do I Fill SARS Travel Logbook?

First and foremost, you should download the SARS eLogbook for the tax year, which starts on 1st March and ends on 28th February of the following year. Your 2022 – 23 SARS elogbook assessment must-have business travel details from 1st March to 28th February 2024. The tax filing season starts on 1st July 2024. 

You must first record your motor vehicle odometer reading on 1st March and record the odometer reading on 28 or 29 February, the last day of the tax year. The logbook has fields you should fill in related to your business travel. You can calculate your total kilometres for the tax year by subtracting opening kilometres from opening kilometres. 

When you fill out the SARS travel logbook, only include the kilometres covered when you travel for business. There are fields in the logbook where you enter your destination and kilometres travelled. Remember that you cannot claim the travel between your home and workplace for business purposes. 

You must have a separate logbook for each car if you have more than one vehicle used for business during a particular tax year. You must record the following details for every business trip in your SARS travel logbook.

  • Date of travel 
  • Business travel information (Starting point of the destination, places visited, and reasons for the business trip)  
  • Kilometres travelled 

Make sure you keep your logbook for about five years from the date you submit your return because you may be asked to submit it to SARS to support your claim . 

Do You Have to Use SARS Logbook?

Without a travel logbook, you cannot claim any cost of business travel against the travel allowance allocated to you. In other words, without a logbook, you cannot claim for travel deduction. With a travel logbook, it becomes easier to calculate the amount you can travel. SARS can also use the logbook to verify your claim if the need arises. Therefore, you should retain your logbook with other material for five years from the submission date. 

How Does SARS Calculate Travel Allowance?

SARS uses two methods to calculate your travel allowance. The first method involves using a cost scale table supplied by SARS and found in the introduction section of your travel logbook.

The simplified way utilizes the fixed rate per kilometre, as illustrated in the table below. With this method, there should be no other advance, no allowance, or other compensation paid by the employer. 

SARS can also calculate your claim using actual costs incurred during your business travels. It is essential to keep a record of your expenses during the tax year on top of keeping a logbook. The expenses include repairs and maintenance, oil, fuel, insurance, car license, finance charges, wear-and-tear, and lease costs. 

If the employer provides a fixed allowance to the employee for business travel, the amount will appear under code 3701 on the IRP5. If a petrol card is issued, the money used for fuel will be added to the total amount. 

A valid log book with all the necessary information about business trips covered must be maintained to support your claim. If some of the relevant details are missing, SARS may dismiss the logbook, which may lead to additional assessment.

To succeed in your claim for business travel costs, you should take the following measures: 

  • Ensure your opening kilometres on the odometer matches the previous year’s closing kilometre. Any mismatch can lead to the dismissal of your claim by SARS. If you have a good reason for the mismatch, ensure you write a letter to SARS. 
  • Check the correctness of the kilometres covered during private and business travel. If there is an error, SARS may decline your claim. 
  • The car’s service history must correspond with your logbook, or else your claim is dismissed. 
  • Ensure that you provide reasonable private and business kilometres to get the best result. If your claim is biased toward business travel, your claim can be rejected. There is no way you can use your vehicle for private business. For instance, the distance from your home to your workstation is private, not a business. 

Therefore, keeping an accurate travel logbook is a good idea to make it easier for SARS to calculate your travel allowance.   

What Is the SARS Rate per Kilometre?

The tables published in the government gazette and SARS’s travel logbooks are used to determine the allowable rate per kilometre for business travel deductions. If the employer pays no other compensation to the employee, the rate is 418 cents or R4.18 per kilometre. 

If the reimbursed travel costs exceed the prescribed rate of R4.18 per kilometre, the full amount will be subject to PAYE. With fixed travel insurance, only 80% of the travel allowance will be subject to PAYE. If the employee has not met the full cost of fuel used in the car or maintenance costs, no claim can be made against these two. 

If you use your private vehicle for business purposes, you are eligible to claim a travel allowance. You must keep an accurate travel logbook to make it easier for SARS to calculate and process your claim. Without a travel logbook, your claim will be rejected.  

Keep Reading

How to Add a New Taxpayer Profile to eFiling

How to Add a New Taxpayer Profile to eFiling

New Taxpayer Profile to eFiling. Today we walk you through everything to know about manipulating profiles on eFIling, creating portfolios, and more. 

How to Add a Tax Directive on SARS eFiling

How to Add a Tax Directive on SARS eFiling

How to Add a Tax Directive on SARS eFiling . Here’s everything you should know about this form of enforced payment arrangement.

How to Register a Company On SARS eFiling

How to Register a Company On SARS eFiling

In this article, we will be taking you through the process of how to register a company on SARS eFiling

How to Get a Tax Number from SARS

How to Get a Tax Number from SARS

The most common piece of information that taxpayers may require is their SARS tax number, and you can retrieve it in these ways

Where to Get A Medical Scheme Tax Certificate?

Where to Get A Medical Scheme Tax Certificate?

Here’s everything you need to know about medical scheme tax certificates, which are a critical part of proving your medical aid expenditure

NOA – Notice of Appeal

NOA – Notice of Appeal

NOA – Notice of Appeal. Read on to learn different aspects of the NOA process. How Do I Submit a SARS Notice of Appeal?

How to File a 2024 Tax Return on eFiling

How to File a 2024 Tax Return on eFiling

This post will walk you through the procedures needed to file your tax return for 2024 electronically. Let's dive in!

How to Activate PAYE On eFiling

How to Activate PAYE On eFiling

As you continue to read below, there will be guidelines that will assist you in registering your employees and activating PAYE on eFiling. 

When to Submit my SARS Tax Return

When to Submit my SARS Tax Return

When Can I Submit my SARS Tax Return? Here's what to know about submitting your South African tax return to SARS.

How to Check SASSA R350 Payday

How to Check SASSA R350 Payday

You can check your SASSA R350 payday through the SASSA website or the Moya app. Both methods are simple. Here's how.

How to Reject the SARS Auto-Assessment

How to Reject the SARS Auto-Assessment

Today, we will look at the SARS auto-assessment in more detail, including how to reject it if you don’t agree with it

What Are the Consequences of Not Paying Tax?

What Are the Consequences of Not Paying Tax?

What Are the Consequences of Not Paying Tax? Read on to learn the consequences of not paying taxes to the government.    

How to Complete DTR02 in South Africa

How to Complete DTR02 in South Africa

This article will explain how to complete the DTR02 form using the eFiling system. We will further offer some background info on the DTR01 record

How to Submit Provisional Tax to SARS

How to Submit Provisional Tax to SARS

This article will guide you through submitting your provisional tax return to SARS. 

How to Submit An EMP601

How to Submit An EMP601

This article will explain how to submit an EMP601, what it is, the difference between EMP201 and EMP601

Logbook for a Company Car or Travel Allowance – What You Need To Know

Date: 13 July 2021

Author: Coenraad de Beer

If you receive a travel allowance from your employer, or use a company provided vehicle, you will need a logbook to record your business trips. If you want to submit a claim for business travel on your income tax return, you will need this logbook to substantiate your claim.

Where can I find such a logbook?

If you are looking for a free logbook, you may use the one supplied by SARS . There are also various electronic devices and cell phone apps available to simplify the process of logging your trips, but no matter what method you use, just make sure your logbook meets the minimum requirements set by SARS.

What information should be recorded for each trip?

·         Date of travel

·         Kilometres travelled (record opening and closing odometer reading of each trip)

·         Reason for the trip

·         Details for whom the engagement was undertaken (new requirement since 2021)

·         Name of the person you visited (new requirement since 2021)

·         Contact details of the person you visited (new requirement since 2021)

Interestingly enough, at the time of writing this article, the SARS logbook did not have separate columns for the new requirements, so we assume this must be recorded in the “Reasons” column of the logbook.

What information about my vehicle is required?

You need to record the odometer reading as soon as the vehicle is taken into use for the first time. After that you need to record the odometer reading in the last day of February each year. The opening and closing kilometers will be used to calculate the total kilometers travelled with the vehicle during the tax year.

In addition to the logbook and kilometer readings, the following information is also required:

1.       The vehicle registration number

2.       The car make (for example Toyota)

3.       The car model (for example Hilux)

4.       Year of manufacture

5.       Cost price of the vehicle (i ncluding VAT but excluding interest)

6.       Date of purchase

7.       Acquisition method: Purchase Agreement or Lease Agreement

8.       Was the vehicle purchased with a maintenance plan? (in case of a company provided vehicle)

Tips for maintaining your logbook during the tax year:

1.       Instead of using a complicated or expensive device to log your trips, use your smart phone to take a photo of your odometer reading when you depart and again when you arrive at your destination. Most modern smart phones will store metadata along with the photo. For example when you view the photo in your gallery on an Android phone, you can simply swipe up and you will be able to see the time, date and in some cases even the location where the photo was taken (as long as your location services are enabled on your phone). You can correlate this information with your diary at the end of each week and record this into a spreadsheet or the SARS logbook.

2.       If you use multiple vehicles for business travel, keep a separate logbook for each vehicle.

3.       You do not need to record private trips, but it does not hurt if you are using a system that records all your trips. A more comprehensive logbook improves your chances of a successful travel claim.

4.       The distance travelled between your home and normal place of work cannot be claimed for business purposes and is regarded as private travel. According to SARS’s Interpretation Note 14, Section 5.4.2, if you travel to a client en route to your normal place of work, it will be regarded as business kilometers. This is an interesting interpretation from SARS, because according section 8(1)(b)(i) of the Income Tax Act, you will not be permitted to claim the entire trip, because the distance between your home and place of employment or business is regarded as private. Keep in mind that interpretation notes are not binding on the courts or the taxpayer, so you may use an example like this to give you guidance on what constitute business travel, but just make sure you have a solid justification for your business travel in cases where there might be a gray area. When in doubt, consult your tax practitioner.

5.       Be as detailed as possible when describing the reason of your trip. Don’t use vague descriptions like “meeting”, “client” or “business”. Give specific details of why you were travelling, for example, “monthly manager’s meeting”, add the details of the person or entity for whom the engagement was undertaken, for example your client’s name “XYZ Distributors (Pty) Ltd” and include the contact details of the specific person you are visiting, for example “Mr X – Cell number 123 456 789”. If you are visiting a group of people or multiple individuals at the same location, record the details of the most senior person you visited.

This is the basic requirements of a travel claim, based on the deemed cost method. There is a second method where your record the actual expenses of your business travel. This second method is less frequently used because it involves much more admin and seldom yields better results than the deemed cost method.

Disclaimer: The information and material published on this website is provided for general purposes only and does not constitute professional advice. We make every effort to ensure that the content is updated regularly and to offer the most current and accurate information. Please contact us directly for any specific problem or matter. We accept no responsibility for any loss or damage, whether direct or consequential, which may arise from reliance on the information contained in these pages.

sars travel logbook excel

SARS – Travel eLogbook

Sars has detailed the steps to be followed below:, latest from our blog, non-executive directors (vat and paye), tax cases – high court.

sars travel logbook excel

Get in touch

Useful Links

Ethical dilemmas, u pdate your profile.

LearnWorlds logo

Sign in/up with Google

Sign in/up with Facebook

Sign in/up with Linkedin

Sign in/up with Apple

Sign in/up with Twitter

sars travel logbook excel

Anlo Financial Solutions | Johannesburg Accountants

Email: contact@anlofin.com | Phone: (011) 658-1324 | Johannesburg Accountants

Travel Log Template 2023 - Personal Tax

We cannot generate a Travel Log for you as it is illegal, but we will gladly send you a travel log template that you can use to generate this logbook. SARS requires you to submit a logbook and might request this from us.

Click the button to download the template.

Other information we will need to file Personal Tax:

IRP5’s from all employersIT3s (a-c) for all sources of income

Interest certificates other that IT3s

Retirement annuity contribution certificate

Medical aid contribution certificate

Additional medical expenses paid that were not claimed through the medical aid. (This is currently a hot topic for SARS to audit so please ensure that additional expenses claimed were not already claimed through the medical aid and that you have proof of payment for these expenses.)

All medical expenses should be in the name of the taxpayer. If it is in the name of the dependant, SARS will disallow it because they say that the dependant can also claim these expenses (double deduction)

Schedule and supporting documentation of other income earned and expenses deductible relating to this income. As you know this is currently a hot topic for SARS to audit and we require your participation in ensuring all expenses can be supported and are a valid business expense

Capital gains or losses made on the sale or disposal of fixed assets and Dividend Tax paid certificate

Donation certificate with valid PBO number

Any other document that might be relevant to your personal income situation i.e. out of country confirmation letter from employer, letter from school indicating disability

Ready to get started with Anlo? Get in touch for a free consultation to see how we can help you!

Xero+Gold+Partner+Badge

ANLO FINANCIAL SOLUTIONS JOHANNESBURG

Email: [email protected] phone: (011) 658-1324.

Find Us: Building 37 Waterford Office Park Cnr Waterford and Witkoppen Road. Fourways

Stay upated with Anlo!

Never miss a newsletter - subscribe to be on the list!

You have successfully joined our subscriber list.

Can’t find what you’re looking for? Search, or contact us for more information

Testimonials

Who We Help

New Startup Businesses

Self Employed

Small and Medium Businesses

South Africans in the UK

Accounting & Bookkeeping

Xero Custom Training

Anlo Academy

Personal Tax Return

Tax & SARS

©2024 ANLO FINANCIAL SOLUTIONS

sars travel logbook excel

You are using an outdated browser. Please upgrade your browser to improve your experience.

Instagram

Travel eLogbook 2022-2023

Login to my account, quick registration.

  • (1) Negotiating Tax Debt and Payment Arrangements with SARS
  • (19) Accounting
  • (2) Accounting for Income Tax
  • (7) Administration of Estates
  • (1) Application of tax rates, s6(2) rebates
  • (1) Assessed losses
  • (4) Audit, Reviews & Other Services
  • (8) Capital Gains Tax
  • (1) Capital Gains Tax - Individuals Tax
  • (1) Capital Gains Tax Implications of Trusts
  • (2) Case study: Home office expense
  • (1) Case study: Travel allowances
  • (1) Company Formations
  • (117) Corporate Tax
  • (9) Customs and Excise
  • (2) Deceased Estate
  • (1) Deductions Pre-trade and prepaid expenses
  • (1) Deferred tax assets and deferred tax on equity
  • (1) Deregistration
  • (2) Employer and Employee (PAYE and UIF Specific)
  • (1) Estate Duty
  • (1) Events / Webinars
  • (8) Faculty News
  • (2) Farming
  • (142) Individuals Tax
  • (1) Input - Customs Duty
  • (3) Interest
  • (13) International Tax
  • (17) Legislation
  • (1) Low interest rate loans and loan subsidies
  • (1) Nature of the rights of beneficiaries
  • (1) Notional input tax
  • (8) Payroll
  • (2) Practical Payroll
  • (2) Provisional tax (Link with other Taxes)
  • (1) SARS Dispute Resolution
  • (4) SARS Issues
  • (1) Salaried Employees
  • (127) Tax Administration
  • (2) Tax Administration Part 2B: Resolving Problems with SARS using the Tax Ombud
  • (1) Tax Administration Part 3B Dispute Resolution - Objection and appeal
  • (3) Tax Update
  • (2) Tax implications of loans to trusts
  • (1) Tax residence
  • (1) Tax returns and payments
  • (1) Transfer-Pricing
  • (1) Trust Income / Gain Allocations
  • (1) Trust types and income allocations
  • (3) VAT periods
  • (1) Wear and tear allowances
  • (1) Zero Rated
  • Recent Comments

sars travel logbook excel

  • 06 April 2022
  • Individuals Tax

Click here to view the 2022-2023 eLogbook for the 1 March 2022 – 28 February 2023 assessment year and filing season starting 1 Jul 2023.

LEAVE A COMMENT

Need help .

We couldn't found any email record. Please create new account Create an account

Ask a Technical Question is available to subscribers. Click here to find out more

STAY IN TOUCH

Subscribe to our mailing list and you will receive our best posts every week on our live CPD webinars , upcoming courses and webinars-on-demand

By subscribing to our mailing list you accept our Terms of Service and Privacy Policy

Verify Cell Number

Explore smarty.

  • New 2 COLUMNS

CTF Services, 21 Kroton Street Roodepoort 1709

sars travel logbook excel

SARS has now made it compulsory to have a detailed Car Log Book. CTF now provides you with a workable sample here Car Log book,

  • Travel Log Book 2024 download here
  • Travel Log Book 2023 download here
  • Travel Log Book 2022 download here
  • Travel Log Book 2021 download here
  • Travel Log Book 2020 download here
  • Travel Log Book 2019 download here
  • Travel Log Book 2018  download here
  • Travel Log Book 2017  download here
  • Travel Log Book 2016 download here
  • Travel Log Book 2015  download here
  • Travel Log Book 2014 download here
  • Travel Log Book 2013 download here
  • Travel Log Book 2012 download here

CTF is an established company that is geared to provide individuals and businesses of all sizes with a comprehensive and professional financial management service at an affordable rate

  • GET IN TOUCH
  • OUR PARTNERS

OUR SERVICES

  • TAX COMPLIANCE
  • TAX CALCULATORS
  • TAX SUBMISSIONS

Get IN Touch

Phone: +27 11 781 2588 E-mail: [email protected]

sars travel logbook excel

  • Privacy Overview
  • Strictly Necessary Cookies

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful. See our Disclaimer

Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.

If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.

Elogger

“The devil is in the details”

Email Address

What is a compliant logbook?

sars travel logbook excel

The SARS minimum requirements are:      >    Date of Travel      >    Kilometeres Travelled      >    Business travel details (where to and  reason for the trip)      >    Opening and Closing Odometer  

The above minimum requirement from SARS are really basic logbook data but they have issued an Interpretation Note 14 (Issue 5) dated 30 March 2021 that outline more details required in terms of the Reason for each trip.

SARS Interpretation Note 14 (Issue 5) – 30 March 2021

SARS now require much more detail for Reasons – extract from Interpretation Note 14, page 15

The “reason for trip” is a crucial element of a logbook. SARS will not be in a position to fulfil its obligation under the law to test the validity of a travel claim where the “reason for trip” is recorded in a logbook as simply “meeting”, “client”, “business” or similar vague particulars. 

The information that taxpayers provide under “reason for trip” must therefore be sufficient to allow SARS to verify that the travel undertaken was for business purposes and qualifies for a deduction. At the very least, this should include the following information:

Specific details of why the travel was undertaken, for example “presentation to board”, “meeting with supplier” or “delivery to client”.

Details of the person with or for whom the engagement was undertaken, for example, “head office of ABC Ltd”, “Mr A at LMN Supplies (Pty) Ltd” or “delivery to client Mr Z”.If contact details are available these should also be provided.

As much detail should be provided as possible. In many cases, this will permit SARS to verify travel claims without having to request additional information from a taxpayer or to disallow travel claims because of insufficient information that was provided to verify such claims. 

The information required to be provided under “reason for trip” is not confidential information. In the same way that taxpayers claiming a deduction for expenditure incurred under, for example, section 11( a ) could be required to provide relevant information such as client invoices, client contracts, etc., so too should taxpayers provide full details of business travel to SARS should they wish to claim a travel deduction. It bears pointing out that SARS is bound by the confidentiality provisions of Chapter 6 of the TA Act.

Elogger Logbook Format in Excel

Elogger provides accurate logbook data including Date, Distance (Business or Private). The mode is changed using the Mode Button.

We also added Actual Street Addresses. The Start Destination is the End destination of the previous trip.

sars travel logbook excel

Our Logbook Converter

Our free management tool for elogger clients to help you to allocate names and reasons for each trip.

sars travel logbook excel

Your downloaded logbook data is shown including the vehicle details as specified under Your Details. As helper columns we include the Trip count at the specific 1km radius, indicator if it is the first occurence and the day of the week.

Do you want to keep all the trips or some of them in the original mode. Simply type Yes in column P and copy, paste in the applicable rows. Your Final mode will then be the same as what you downloaded.

Allocate Home, Office, Client details or Private in column Q. This will alter the Suggested mode accordingly. Very important that no space before or after the name and the first letter as capital.

Your Private Trip Conditions as selected in Your Details will suggest the mode for :

 > Public Holidays  > Weekends  > Travel From Home to Office etc

Watch the short video on the Logbook Conversion process

Convert your logbook data using trip conditions

Send us an email to download the Logbook Converter Excel file

Icon

Logbook Converter V1.03

New to Tax? Start Here

  • Do I need to submit a tax return?
  • Salaried tax payers
  • Provisional tax
  • Independent contractors
  • Small business (sole proprietors)

Living or Working Overseas

  • Foreign employment income
  • Foreign trade income
  • Other foreign income

Earning Extra Income

  • Rental income
  • Capital gains tax
  • Tax on Investments - What you need to know

Claiming & Deductions

  • What can I claim
  • Wear & tear / depreciation
  • Travel expenses
  • Medical expenses
  • Donations tax

SARS & eFiling

  • How to register
  • How to get my tax number
  • How to make a payment via eFiling
  • How to register for provisional tax

After You File

  • Amending details
  • Tracking your refund

Company (Pty) Tax

  • Company tax guide
  • Turnover tax explained
  • Register a company for eFiling

Quicks Links

  • Tax definitions
  • Guides & tutorials
  • Tax questions & answers
  • Main tax help page
  • Ask a tax question
  • Tax & Retirement- What you need to know

sars travel logbook excel

Logbook requirements for SARS for claiming travel allowance?

Blog categories.

  • Salary / IRP5 (4,703 posts)
  • Independent Contractor (995 posts)
  • Provisional Tax (672 posts)
  • Medical (968 posts)
  • Capital Gains (409 posts)
  • Donations (246 posts)
  • Deductions (3,820 posts)
  • Commission (1,053 posts)
  • Rental Income (971 posts)
  • Retirement (1,044 posts)
  • Dividends (1,047 posts)
  • Depreciation / Wear and Tear (350 posts)
  • Penalties (783 posts)
  • Travel Allowance (771 posts)
  • Audit / Verification (2,671 posts)
  • Tax Threshold (497 posts)
  • Foreign employment income (203 posts)
  • SARS & eFiling (2,107 posts)
  • Company Tax (2 posts)
  • Foreign Investment (1 posts)
  • PAYE & UIF (47 posts)
  • Source Code (2 posts)
  • Foreign Income (1 posts)
  • TaxTim in the Media (1 posts)
  • Tax Tables (3 posts)
  • Financial Literacy Series (3 posts)
  • Cryptocurrency (3 posts)
  • Auto-Assessments (1 posts)

Onestop Accounting

Travel Allowance Queries?

For prompt, efficient service…

SARS eLogbook 2023-2024

SARS eLogbook 2023-2024 Fixed Cost Table is provided for your convenience. Search the table for the allowed travel allowance claim costs. Filter by the “Value of Vehicle” column by entering the first, first two or first three digits of the relevant vehicle value. Last updated,  9 February 2024.  Read more about claiming Travel Allowances here . View the SARS 2023-24 eLogbook here .  The use of this tax table is subject to our  disclaimer . Rates per kilometre, which may be used in determining the allowable deduction for business travel against an allowance or advance where actual costs are not claimed, are determined by using the following table:

SARS Fixed Cost Table: March 2023-February 2024

Simplified method.

Where: a. The provisions of section 8(1)(b)(iii) are applicable in respect of the recipient of an allowance or advance; and b. No other compensation in the form of an additional allowance or reimbursement (other than for parking or toll fees) is payable by the employer to that recipient; that rate per kilometre is, at the recipient’s option, equal to 464 cents per kilometre.

  • No fuel cost may be claimed if the employee has not borne the total cost of fuel used in the vehicle, and no maintenance cost may be claimed if the employee has not borne the total cost of maintaining the vehicle (e.g. if the vehicle is covered by a maintenance plan).
  • 80% of the travelling allowance must be included in the employee’s remuneration to calculate PAYE. The percentage is reduced to 20% if the employer is satisfied that at least 80% of the motor vehicle usage for the tax year will be for business purposes.
  • The fixed cost must be reduced pro-rata if the vehicle is used for business purposes for less than a year.
  • The distance travelled during a tax year and the distance travelled for business purposes substantiated by a log book are used to determine the costs that may be claimed against a travelling allowance.

Alternative Method

Where an allowance or advance is based on the actual distance travelled by the employee for business purposes, no tax is payable on an allowance paid by an employer to an employee up to the rate published on the SARS website www.sars.gov.za under Legal Counsel / Secondary Legislation / Income Tax Notices / Fixing of rate per kilometre in respect of motor vehicles, regardless of the vehicle’s value.

However, this alternative is not available if another compensation in the form of an allowance or reimbursement (other than for parking or toll fees) is received from the employer in respect of the vehicle.

Company Cars

Employees may also be entitled to claim a reduction on the fringe benefit for business mileage travelled in motor vehicles provided by an employer. An accurate record of mileage travelled is required to claim such a deduction. This logbook may also be used for this purpose. The exact minimum information as set out above is also required for company cars. For the rates for other tax years, please visit www.sars.gov.za or call the SARS Contact Centre on 0800 00 7277.

The rates in the Fixed Cost Table are adjusted periodically. The rates in the table on this page relate only to the 2023/24 tax year, i.e. from 1 March 2023 – 28 February 2024.

Dynamic title for modals

Are you sure.

Cartrack putting you in control logo

Business or pleasure? Our SARS-compliant logbook does it all from one app.

Get a tracking device for fleet or personal today.

It is all good and well keeping a logbook but it needs to be accurate to ensure your travel claim is valid. Don’t worry, there’s an app out there that is about to make your trip-logging life a whole lot easier.   

In this article, you will:

Learn about the time-saving app you need for sars tax claims, learn exactly how the logbook and claim process works, find out about some great features you can enjoy when using cartrack's logbook, the time-saving app you need for sars tax claims.

Tax season is already in full swing again. If you need assistance accurately managing your trips for your business travel claim, we've got an app that does it all for you.

It is all good and well keeping a manual logbook but it needs to be accurate to ensure your travel claim is valid. To guarantee a smooth process, it's important to have a clear understanding of the necessary information for travel claims such as:

  • Receipts and so on...

Sounds pretty detailed right?

Don’t stress, this app is about to make your trip-logging life a whole lot easier. ‍

‍ So , how exactly does the whole logbook and claim process work:

  • Step 1: Record your vehicle’s odometer reading every year on the opening day of the tax year (which is always 1 March) and again on the closing day (which is always the last day of February) ‍
  • Step 2: Determine your total kilometres of the year by calculating the difference between the closing and opening readings (without these readings, you cannot claim a tax deduction) ‍
  • Step 3:  Define which portion of your total kilometres travelled were actually for business use

Can any taxpayer receive a travel allowance to claim a deduction for the use of their private vehicle for business purposes?

Simply put, yes. But it is important to note that travelling between your home and work doesn’t count, it is seen as private travel.

If you don’t keep a logbook you can’t claim a travel deduction, simple as that. 

However, you’ll be happy to know that Cartrack’s logbook app is designed to help you effortlessly deal with every single step mentioned above.

how_exactly_does_the_whole_logbook_and_claim_process_work

So, what’s next?

Now that we’re all clear on that, what do you do with all your trip information and how does our logbook make your life easier?

To claim your allowance for business travel you are required to record  trip details like:

  • Your distances travelled ‍
  • The location you visited ‍
  • The reason for your trip

The_time-saving_app_you_need_for_SARS_tax_claims

Once this is done, you must enter all this information into your logbook and submit it to SARS. This sounds like a lot of paperwork and hassle, right? Thanks to Cartrack’s digital logbook it’s not.

  • It automatically logs all of your vehicle trips ‍
  • You can easily mark them as personal or business trips on the app ‍
  • It automatically creates and emails your SARS-ready tax-compliant logbook ‍
  • You can effortlessly download your SARS-ready reports and submit them via the SARS eFiling online platform or straight to your tax consultant.

These_are_some_great_features_you_can_enjoy_when_using_Cartrack’s_easy_logbook

This saves you loads of notes, paper trails, lost paperwork and time trying to remember all your trip details, making it super simple to monitor and record both business and personal travel trips, all from one easy-to-use app.

Additionally, the GPS logbook allows you to access your trip data, anytime, anywhere which means you can complete your logbook whenever you have a few minutes to spare, from wherever you are. No more paperwork, no more pens, no more rejected travel tax claims .

These are some great features you can enjoy when using Cartrack’s easy logbook:

  • View all your trips made within a selected timeframe ‍
  • Keep a record and notes of all trip history ‍
  • Select if your trips were for business or pleasure ‍
  • View the total distance travelled for your selected timeframe ‍
  • Export your trip data in your preferred SARS-ready format

Ready for a hassle-free tax season?

Visit Cartrack or call us on 011 250 3000 to download the Cartrack app today.

If you are already one of our 1.7 million customers and want to unlock this feature, chat with us today on 011 250 3000 so we can make your tax season hassle-free!

Business or pleasure? Our SARS-compliant logbook does it all from one app.

It is all good and well keeping a logbook but it needs to be accurate to ensure your travel claim is valid.

Learn other critical tips

sars travel logbook excel

How to Eliminate the Biggest Risks Associated With Your Fleet Operations

sars travel logbook excel

Which Petrol Is the Best in South Africa and Why It Matters

sars travel logbook excel

Powerful Fleet Management Reporting: 7 Ways to Simplify Your Fleet Company

sars travel logbook excel

  • Forms category
  • South Africa
  • Business and Economy

ZA SARS Travel Logbook 2022-2024 free printable template

Get, create, make and sign.

Edit

Editing online

sars travel logbook excel

ZA SARS Travel Logbook Form Versions

Fill form : try risk free, people also ask about, our user reviews speak for themselves, for pdffiller’s faqs.

Below is a list of the most common customer questions. If you can’t find an answer to your question, please don’t hesitate to reach out to us.

Fill out your online with pdfFiller!

pdfFiller is an end-to-end solution for managing, creating, and editing documents and forms in the cloud. Save time and hassle by preparing your tax forms online.

Not the form you were looking for?

Related features - 1962, related forms.

Form preview

IMAGES

  1. Log Book Example 2013-2024 Form

    sars travel logbook excel

  2. Elogger

    sars travel logbook excel

  3. SARS Logbook Requirements and the Trip Logbook App

    sars travel logbook excel

  4. How to create a sars logbook

    sars travel logbook excel

  5. 66631 2011e logbookv2

    sars travel logbook excel

  6. Free Excel Logbook Template

    sars travel logbook excel

VIDEO

  1. Beautiful Lakes Bellagio

  2. How to Book Free Flights

  3. GPS Logbook

  4. What do Gorillas like to eat??

  5. I am Hungry #zoo #gorilla

  6. Lake Como

COMMENTS

  1. Travel e-log book

    2014-2015 SARS Logbook for the 1 March 2014 - 28 February 2015 assessment year and tax season starting 1 Jul 2015; Top Tip: Without a logbook you won't be able to claim the cost of business travel against your travel allowance.

  2. Excel logbook for SARS • AuditExcel.co.za

    September 29, 2014. Free Excel logbook for SARS download at the bottom of the page. If you are looking to create an Excel logbook for SARS and you want it to include the dates for working days only, you can easily create it in Excel using the WORKDAY function. Using this function means you that you won't need to enter every date and it can ...

  3. PDF Introduction

    Always keep your SARS Travel Logbook safe and secure. Use it as a source of information when compiling your Income Tax Return (ITR12). Should you go to a SARS branch, a SARS agent will assist you to submit your ITR12 electronically. Take your completed Travel Logbook together with all other supporting documents with.

  4. Travel eLogbook

    Travel eLogbook. 15 March 2022 - Travel eLogbook 2022-23. Forgot Username. Forgot Password. Manage Tax Type Transfer.

  5. PDF TRAVEL LOGBOOK

    supplied by SARS each year. You will find the cost tables which apply to the tax year from 1 March 2011 to 29 February 2012 on the next page of this logbook. You need not have kept an accurate record of all your expenses - simply use the costs linked to the value of your vehicle. 2. Alternatively, you can calculate your claim based on

  6. PDF INTRODUCTION

    Always keep your SARS Travel Logbook safe and secure. Use it as a source of information when compiling your Income Tax Return (ITR12). Should you go to a SARS branch, a SARS agent will assist you to submit your ITR12 electronically. Take your completed Travel Logbook together with all other supporting documents with.

  7. PDF Travel E-log Book

    TRAVEL E-LOG BOOK When can you claim for travel? If you receive a travel allowance from an employer or principal, you can claim a deduction ... • 2022-23 SARS eLogbook for the 1 March 2022 - 28 February 2023 assessment year and filing season starting 1 Jul 2023

  8. How to Fill SARS Travel Logbook

    SARS uses two methods to calculate your travel allowance. The first method involves using a cost scale table supplied by SARS and found in the introduction section of your travel logbook. The simplified way utilizes the fixed rate per kilometre, as illustrated in the table below. With this method, there should be no other advance, no allowance ...

  9. Logbook for a Company Car or Travel Allowance

    2. If you use multiple vehicles for business travel, keep a separate logbook for each vehicle. 3. You do not need to record private trips, but it does not hurt if you are using a system that records all your trips. A more comprehensive logbook improves your chances of a successful travel claim. 4.

  10. Online Travel Logbook

    Download an excel version of our travel logbooks: 2024/2025 travel logbook. 2023/2024 travel logbook. 2022/2023 travel logbook. Our SARS compliant online travel logbook allows you to keep track of your travel claims throughout the year and view a summary at the end of the tax year.

  11. SARS

    SARS - Travel eLogbook. SARS has released its 2022 template of the electronic travel logbook. The logbook is available for use by taxpayers who wish to claim a deduction for the use of a private motor vehicle for business purposes. If you receive a travel allowance from an employer or principal, you can claim a deduction on assessment of your ...

  12. PDF Introduction

    Always keep your SARS Travel Logbook safe and secure. Use it as a source of information when compiling your Income Tax Return (ITR12). Should you go to a SARS branch, a SARS agent will assist you to submit your ITR12 electronically. Take your completed Travel Logbook together with all other supporting documents with.

  13. Travel Log Template 2023

    Get in touch for a free consultation to see how we can help you! BOOK YOUR Free Consultation. ANLO FINANCIAL SOLUTIONS JOHANNESBURG. Email: [email protected]. Phone: (011) 658-1324. Find Us: Building 37 Waterford Office Park. Cnr Waterford and Witkoppen Road. Fourways.

  14. How to cruise through a travel audit efficiently

    Note, you can only claim a travel deduction if one of the below applies to you: 1 . Travel logbook (having the following content): -Dates for travel, including your Business and Private kilometres applicable to the tax year that's being audited. Kindly note that your logbook must be in a SARS approved format, you can use the SARS-Travel-e-log ...

  15. Travel eLogbook, SARS

    Travel eLogbook 2022-2023. 06 April 2022. Individuals Tax. SARS. Click here to view the 2022-2023 eLogbook for the 1 March 2022 - 28 February 2023 assessment year and filing season starting 1 Jul 2023.

  16. Log Book

    Book. SARS has now made it compulsory to have a detailed Car Log Book. CTF now provides you with a workable sample here Car Log book, Travel Log Book 2024. download here. Travel Log Book 2023. download here. Travel Log Book 2022. download here.

  17. How to create a sars logbook

    Many taxpayers have trouble doing their business travel logbooks, and most tax practitioners either request that you submit a completed logbook to them or c...

  18. Logbooks

    The "reason for trip" is a crucial element of a logbook. SARS will not be in a position to fulfil its obligation under the law to test the validity of a travel claim where the "reason for trip" is recorded in a logbook as simply "meeting", "client", "business" or similar vague particulars.

  19. Logbook requirements for SARS for claiming travel allowance?

    11 August 2015 at 22:14. If you can convert this to an official SARS logbook that would be better, otherwise ensure that your excel sheet is understandable by a SARS official. This entry was posted in Tax Q&A and tagged Salary / IRP5, Independent Contractor, Deductions, Commission, Travel Allowance . Bookmark the permalink.

  20. SARS ELogbook 2023-2024

    For the rates for other tax years, please visit www.sars.gov.za or call the SARS Contact Centre on 0800 00 7277. Note: The rates in the Fixed Cost Table are adjusted periodically. The rates in the table on this page relate only to the 2023/24 tax year, i.e. from 1 March 2023 - 28 February 2024. SARS eLogbook 2023-2024 - Onestop Accounting.

  21. Business or pleasure? Our SARS-compliant logbook does it all ...

    The time-saving app you need for SARS tax claims ‍ Tax season is already in full swing again. If you need assistance accurately managing your trips for your business travel claim, we've got an app that does it all for you. It is all good and well keeping a manual logbook but it needs to be accurate to ensure your travel claim is valid.

  22. ZA SARS Travel Logbook 2022-2024 free printable template

    1. Create an account. Begin by choosing Start Free Trial and, if you are a new user, establish a profile. 2. Simply add a document. Select Add New from your Dashboard and import a file into the system by uploading it from your device or importing it via the cloud, online, or internal mail. Then click Begin editing. 3.

  23. PDF Introduction

    Always keep your SARS Travel Logbook safe and secure. Use it as a source of information when compiling your Income Tax Return (ITR12). Should you go to a SARS branch office, a SARS agent will assist you to submit your ITR12 electronically. Take your completed Travel logbook together with all other relevant material (supporting documents) with. For