Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: Easyfile CSV format document and example spreadsheet

  1. #1
    Email problem
    Join Date
    Nov 2010
    Location
    Paarl
    Posts
    20
    Thanks
    0
    Thanked 8 Times in 4 Posts

    Easyfile CSV format document and example spreadsheet

    I have been looking for this for ages, so I thought I would post a link here for others. I run a small business with my own wage spreadsheet and wanted to generate the Easyfile Import Payroll CSV file, but could not find the relevant information or an example. All the documentation refers to "download the csv file generated by your payroll software", but what if you don't use commercial payroll software?!

    The document describing the format and codes can be found if you Google "Business Requirements Specification PAYE Reconcilliation 2010" on the SARS website. (link)

    A useful example spreradsheet can be found via this post (link)

    I will add the documents, A spreadsheet and a generated CSV file if required.

  2. #2
    Site Caretaker Dave A's Avatar
    Join Date
    May 2006
    Location
    Durban, South Africa
    Posts
    22,648
    Thanks
    3,304
    Thanked 2,676 Times in 2,257 Posts
    Blog Entries
    12
    Quote Originally Posted by Laurence Lombard View Post
    I will add the documents, A spreadsheet and a generated CSV file if required.
    That sounds like a great idea.

  3. #3
    Email problem
    Join Date
    Nov 2010
    Location
    Paarl
    Posts
    20
    Thanks
    0
    Thanked 8 Times in 4 Posts

    Adding files

    Hopefully (if I have managed to work the file upload system properly) I have attached an Excel spreadsheet and the corresponding csv format output file ready to be imported into easyfile. I worked on this a while ago, and have not tested this version, so let me know if there are any hitches.
    Laurence
    Attached Files Attached Files

  4. #4
    Email problem
    Join Date
    Nov 2013
    Location
    Gauteng
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Easyfile spreasheet

    Hi,

    please help me with the error for field 4150 (reason for IT3a) I need the code I must use for lines where there is IRP5

    [QUOTE=Laurence Lombard;68694]Hopefully (if I have managed to work the file upload system properly) I have attached an Excel spreadsheet and the corresponding csv format output file ready to be imported into easyfile. I worked on this a while ago, and have not tested this version, so let me know if there are any hitches.
    Laurence[/QUOTE

  5. #5
    New Member
    Join Date
    Mar 2014
    Location
    Pretoria
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I tried to import the csv file into easyfile but I keep getting this error "End of Record is last code of the Employer's record and may not be followed by any other character Extra text after Employer EOL Marker - code 9999" any ideas why?

  6. #6
    Silver Member Christel's Avatar
    Join Date
    Feb 2012
    Location
    Port Elizabeth
    Posts
    360
    Thanks
    57
    Thanked 96 Times in 68 Posts
    Hi there,
    Every end of a record must have 9999 as the very last characters.
    Take your CSV import file, open it with notepad and make sure the last characters is 9999
    save

    try again.

    if you don't get it right you are welcome to email me via pm and I'll help you out.
    always fear when Christel is near....

  7. #7
    New Member
    Join Date
    Nov 2013
    Location
    Johannesburg
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thumbs up Thanks!

    Thanks Christel - this helped me!!!

  8. #8
    New Member
    Join Date
    May 2016
    Location
    Boksburg
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    IRP5.csvHi Christel,
    I have the same problem uploading to easyfile. I have confirmed that the records all end with 9999.
    I will attach the file.

  9. #9
    New Member
    Join Date
    May 2016
    Location
    Krugersdorp
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    NEW Esayfile File layout

    I wrote my own payroll program in excel. I used to upload the CSV file with no problems. When trying to do 2016 yesterday the easyfile program would not recognise the file format or layout. Can someone help?

  10. #10
    New Member
    Join Date
    Oct 2016
    Location
    Benoni
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    HI

    I have the same problem - ive checked my file and it definitely says 9999 at the end - please help

Page 1 of 2 12 LastLast

Similar Threads

  1. Excel spreadsheet for VAT reconciliation
    By JaunetteK in forum Accounting Forum
    Replies: 17
    Last Post: 07-Jun-17, 07:03 AM
  2. Affidavit format you can use
    By Citizen X in forum General Business Forum
    Replies: 14
    Last Post: 30-Sep-15, 03:14 PM
  3. JOINT WILL FORMAT
    By Citizen X in forum General Chat Forum
    Replies: 1
    Last Post: 11-Feb-12, 02:29 PM
  4. e-Book format and protection
    By daveob in forum Marketing Forum
    Replies: 4
    Last Post: 05-Dec-08, 08:38 AM
  5. How to format a manual for printing.
    By IanF in forum General Chat Forum
    Replies: 5
    Last Post: 04-Apr-08, 08:08 AM

Tags for this Thread

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •