Saturday, February 4, 2017

File Formats and Submission of Semestral List of Regular Suppliers by Top 20,0000 Private Corporations

Revenue Memorandum Circular (RMC) No. 5-2009 has issued by the bureau to inform the public about the File Formats and  Submission of Semestral List of Regular Suppliers by Top 20,000 Private Corporations per RR 17-2003, as amended by RR 14-2008.

Currently, the Semestral List of Regular Suppliers is submitted through CD at the Bureau of Internal Revenue (BIR) of the Private Corporation's jurisdiction on or before July 31 and January 31 for the first and second semesters of each calendar year, respectively. The company is also required to submit hard copy of the Semestral List of Regular Suppliers.

Taxpayers shall use either excel format or their own extract program which shall pass through the validation module to be issued by the BIR.

Technical Annex "B" - Technical Specification for Top 20,0000 Private Corporations required to submit Semestral List of Regular Suppliers:


























Annex "C" - Transmittal Form for CDs. The Transmittal Form is use for the Submission of CD's of the Semestral List of Regular Suppliers.

88 comments:

  1. Ask ko lang po dun sa STEP III ndi naman po available un srs na tab doon? ano po gagawin?

    ReplyDelete
  2. Could I ask for a sample of final format, I've tried those steps but still the validation gone wrong. Thanks

    ReplyDelete
    Replies
    1. Hi Sir. From my experience, the could be because of software versions. Here's my case, I followed steps A-G using excel 2010. When I used the same version (2010) to create CSV file, the validation always showed an error. But when I used excel 2003 to create the CSV file (out of the excel file the I have created using 2010), it was validated successfully. Hope this helps.

      Delete
    2. Hi Sir Joseph, I think you have to submit manually in the BIR of your RDO. (In my article, I referring to BIR RDO No. 050. Thank you.

      Delete
    3. hi po i used 2003 kaso invalid din file name

      Delete
  3. This comment has been removed by the author.

    ReplyDelete
  4. How to disable filename validation po? di po sya kasi nkikita sa module. Version 1 & 1.1 na po ung gamit ku.

    ReplyDelete
  5. Naging okay naman po yung validation ko using those steps mentioned, kaso lang po pag e-submission ko invalid attachment daw. I attached the validated srs na may CSV na filename extension. Hindi ko po magets kung bakit invalid attachment yung reply ng BIR sa akin. please help...thanks

    ReplyDelete
    Replies
    1. Same here. I even tried zipping before sending just like for MAP. It seems manual submission pa din ang SRS

      Delete
    2. Same here. I even tried zipping my file before sending just like for MAP. It seems manual submission pa din ang SRS. Use Annex C for this

      Delete
    3. I think it is still manual submission to respective RDO.

      Delete
    4. its beacause you sent a csv file, not a dat file, so esubmission find it invalid. this format are only for manual submission to bir - hard copies are to be submitted. when using esubmission, file extension that are readable for the system are dat file and zip file. this maybe the reason of "invalid file submitted" though it was validated by SRS module.

      Delete
    5. I also tried submitting the .dat file just last week. Still I got an "invalid file submitted" email from BIR.

      Delete
    6. san nyo po nakita ung DAT File ng vinalidate nyo?

      Delete
  6. Ako din, sinunod ko lahat ng steps pero pagdating sa esubmission invalid sya.
    I called our rdo, i-submit daw sa kanila ang hard copy.

    ReplyDelete
  7. can you help me , how about if more 20 than suppliers how can i validate it ? or it has separate format?

    ReplyDelete
  8. need pa po ba magsubmit ng sworn declaration?

    ReplyDelete
  9. Need pa rin po ba magsubmit kahit na wala po sya winithholdan for the sem? if yes po, same procedure po ba?

    ReplyDelete
    Replies
    1. kung wala naman po kayong winitholdan, wala din naman kayong ilalagay sa form. so no need na

      Delete
  10. Replies
    1. mam pwede po ba makahingi ng sample na sinend nyo po sa bir? ty po. pasend po dito sa email kung ok lang po. maraming salamat.
      oroscoforms@yahoo.com

      Delete
  11. Anybody can help me? i just encoded the Semestral List or Regular Suppliers to Excel and save as csv(comma delimited) then validate using application of SRS validation module. but it will appear as error. how can i do to this?

    ReplyDelete
    Replies
    1. the details should be followed as posted above. any single misformat can make it invalid. it is the computer who can't read the details correctly, so try to check every detail's format as presented above. but in my case, we have some difference regarding on the branch code. here, it should be three digit, but mine was four digit and it was validated.

      Delete
  12. Hi Ask ko lang po kung exclusive lang po sa Top 20000 kapag po ba puro 2% lang WHT di na po kailangan?

    ReplyDelete
    Replies
    1. Hi AC. WC/WI 160-2% (Services) & WC/WI 120-1% (Goods). Please refer Semestral List of Regular Suppliers by Top 20,000 Private Corporations per RR 17-2003, as amended by RR 14-2008.

      Delete
  13. Can you please send me a sample for the file to be submitted?

    ReplyDelete
  14. Please send a sample for the file to be submitted (Semestral List of Regular Suppliers)

    ReplyDelete
  15. Hi, just for clarification, I need to submit CD of srs with its copy printed on paper? Thanks.

    ReplyDelete
  16. I already encoded the Semestral List of Regular Suppliers to Excel 2003 and save as csv(comma delimited). When validated using SRS validation module, laginf error. I followed na format naman. Huhu can someone help me? Kindly send me a sample format. Huhuhu Thank you.

    ReplyDelete
    Replies
    1. https://technobound.com/index.php/2018/11/26/srs-validation-module-step-by-step/

      Delete
  17. Please help us,when validate using SRS validation module may error sya. invalid header.data found in excess column.

    ReplyDelete
  18. Hi. Pwede po makahingi ng sample ng Semestral list of regular supplier on excel?

    ReplyDelete
  19. Can you help us? please we badly need it.
    can you send us the format of SRS.

    ReplyDelete
  20. Can you please send me a sample format for the text file for esubmission please...dgm_41@yahoo.com Thanks and GOd bless.

    ReplyDelete
  21. Hello po, pwede po ba magpasend ng final format nyo? yung as in gawa nyo po? dko po kse magets. Sorry po. Regards po

    ReplyDelete
    Replies
    1. What is your email add?

      Delete
    2. Hi po please send din po sa akin sample yung gawa nyo po. salamat

      Delete
    3. pasend din po sakin jeccapatulotvalencia@gmail.com laging error nalabas sakin e. salamat

      Delete
    4. pakisend din naman po sakin nung format. Thanks po

      Delete
    5. hi pwede din po ba humingi po ng excel format po for SRS po.

      joycedguevarra@gmail.com po
      Thank You so much po

      Delete
    6. ask po ako favor hingi din po sana ako ng excel format nyo po ng SRS
      joycedguevarra@gmail.com

      thank you so much po

      Delete
  22. Hi good day, I followed the format given but still error in validation, always nag pop up " TIN in the filename has special characters: /" . Nakailang ulit na ako. Still same error. Can someone help me? Thank you very much

    ReplyDelete
  23. can you please help me, yan ung error sakin eh
    0000000001 Invalid FTYPE CODE. Row Value : SRS

    ReplyDelete
    Replies
    1. same problem din po sakin. naayos nyo po ung error? baka po pede pa help po. thanks po

      Delete
  24. Pahelp nga po..Pahingi nga po ako ng semestral list of of regular supplier na excel.Total for the 6 months transaction or per transaction po ng supplier and ang iencode. thanks po

    ReplyDelete
  25. Ilang cd po ang dapat i submit?

    ReplyDelete
  26. Ano po dapat gawin pag ang error ay " TIN in the filename has special characters"? Ok naman yung format ko walang special characters. Thanks

    ReplyDelete
  27. Hi. Pwede po makahingi ng sample ng Semestral list of regular supplier on excel?

    Can you help us? please we badly need it.
    can you send us the format of SRS. (acctg@polyline.com.ph)

    ReplyDelete
  28. How much is the penalty for the late submission of SRS to BIR? Thanks in advance!

    ReplyDelete
  29. Hi po pwede magpasend sample copy sa excel. eto po email mansev.acctg@gmail.com thanks in advance po.

    ReplyDelete
  30. 1000 penalty then use 0605 form for late payment

    ReplyDelete
  31. 1000 penalty for late submission

    ReplyDelete
  32. pasend naman po sakin nung format nyo po yung final na nasubmit na walang error. lagi kasing error yung samin e. paemail naman po sakin dito:jeccapatulotvalencia@gmail.com. maraming salamat po

    ReplyDelete
  33. Hi! Ask lang po if need pa e-submission for SRS? Nag-validate naman po ako ng file na naka-CSV type, nag-validate naman po na walang error, pero nung email ko sa E-submission, invalid daw po yung file:

    This is to confirm receipt of the file(s) as stated below:
    Total attachment/file(s) received : 1
    No. of valid file(s) : 0
    No. of invalid file(s) : 1

    We have validated your submission in compliance with existing BIR regulations.
    Find below the details of your submission:
    Date of Submission: 4/23/2019 9:02:42 AM
    Filename(s):
    1. Invalid Attachment : 009277494000012312018SRS.CSV
    A. 009277494000012312018SRS.CSV - INVALID

    ReplyDelete
    Replies
    1. Hi po. Pwede po ba makahingi ng excel or csv template as sample lang po. Ang dami ko ng attempt to validate pero unsuccessful talaga. Please send po sa email kung pwede, iamcora0602@gmail.com. Thank you very much!

      Delete
    2. same problem here. na-solve nyo po ba ito? manual filing po ba or may dapat ayusin sa csv file, considering na NO ERRORS ENCOUNTERED naman po sa validation?

      Delete
    3. pahingi naman po ng sample csv template nyo palaging error yung akin e hindi ko na malaman how to resolve

      Delete
  34. This comment has been removed by the author.

    ReplyDelete
  35. Good day po. I have the same problem po.. invalid po ung files ko.. pwedi po bang makahingi ng excel sample na gawa nyo po..please send to my email po vergie_bookkeeping@zeezen.net.. Thank you very much po..

    ReplyDelete
  36. Hi, Good morning. Pwede rin po ba ako makahingi ng excel sample na gawa nyo. Laging may error kapag magvavalidate na po ako. Kindly sent to my email po.
    jsc.pse2018@gmail.com

    Thank you.

    ReplyDelete
  37. Hello po, ask ko lang how to resolve below errors.

    Row 53 is blank since until 52 lang ang suppliers ko.

    Thanks.


    ---------------------------------------------------------
    ROW ERROR DESCRIPTION
    ---------------------------------------------------------
    0000000053 FTYPE CODE cannot be empty.
    0000000053 WA TIN cannot be empty.
    0000000053 WA branch code cannot be empty.
    0000000053 Return period cannot be empty.
    0000000053 Sequence number cannot be empty.
    0000000053 Supplier's TIN cannot be empty.
    0000000053 Supplier's branch code cannot be empty.
    0000000053 Supplier's Registered Name or Last Name and First Name cannot be empty.
    0000000053 ATC CODE cannot be empty.
    0000000053 Income Payment cannot be empty.
    0000000053 Tax Rate cannot be empty.
    0000000053 Amount of Tax Withheld can not be empty.


    ReplyDelete
  38. Hi. Good aftermoon. May I ask what's wrong with this one and how to fix.

    Thank you.


    ROW ERROR DESCRIPTION
    ---------------------------------------------------------
    0000000001 Invalid Header. Data found in excess column.

    SUMMARY REPORT
    ---------------------------------------------------------
    ROW ERROR DESCRIPTION
    ---------------------------------------------------------
    1 Invalid Header. Data found in excess column.


    ReplyDelete
    Replies
    1. same problem encountered we are using MS 2010.

      Delete
    2. Hi, have you fixed your error? How po? I encounter the same error as yours. First timer here!

      Delete
    3. Yung row 1 ay dapat ang may encode lang ay apat na column lang. yung srs, tin, branch code, at yung return period.

      Delete
  39. Hi ask ko lang po, after validation san ko po makikita ung DAT File? kase TXT lang na nasa notepad ung kaya kong isave.

    Thank you po sa sasagot.

    ReplyDelete
  40. Good day po.. Tumawag po ako sa Esubmission hotline 981-7020. Sabi po nong nakausap ko, talagang ma e envalid c srs dahil hindi namn po daw ito esinasubmit tru esubmission..Manual submission lng po daw sa RDO e save sa CD ang validated csv file at magprint nang hard copy tapos dalhin kay RDO.

    Medjo nakakagulo talaga ito, kasi in my case, we are under EFPS at according po sa letter na nareceive ko from BIR na kapag EFPS ka dapat e esubmission c SRS..Hindi ko na po alam gagawin ko.. Sino po dito naka EFPS din??? Sana may makatulong..

    ReplyDelete
    Replies
    1. kami EFPS din pero 1st tym lang magsasubmit.Marami error ung excel. Panu ba yung template nun?

      Delete
  41. Hi! Pwede pong makahingi ng excel template ng SRS as sample lang po please. Many thanks in advance.

    ReplyDelete
    Replies
    1. Hi po, pa email lng din po ako kng meron ka ng sample excel form ng SRS. Thanks po. smagnanao@hms.com.ph po

      Delete
  42. Hello po, first time ko pong mg submit ng SRS, pwede po bang humingi ng sample excel form pano po gumawa. smagnanao@hms.com.ph yan po email add ko po. Thanks

    ReplyDelete
  43. Hi. Just want to help po.

    To save CSV file sa DAT file, follow these steps po/

    1. Magbukas po kayo ng Windows Explorer.
    2. Hanapin po yung file ng CSV.
    3. Right click yung file.
    4. Click niyo po yung Open with Notepad.
    5. Then, click sa file... save as...
    6. Then sa file name lagyan niyo lang po ng .dat

    Then it will save as a DAT file.

    Hope these help po.

    God bless.

    ReplyDelete
  44. Hi po.

    Baka makatulong po ito sa pagconvert ng CSV sa DAT file.

    Step 1
    Launch Windows Explorer. Browse to the CSV file you want to convert.

    Step 2
    Right-click on the CSV file and select "Open With," then "Notepad." This opens your CSV file in Notepad.

    Step 3
    Click "File," then "Save As." Type the DAT file name. For example, if the name of the CSV file is "market.csv," you can type "market.dat."

    Step 4
    Click "Save" and your CSV file is converted to a DAT file.

    Hope these help.

    God bless.

    ReplyDelete
  45. Good Morning pwede po ba makahingi ng excel format para sa SRS ( joy.pagtalunan@specmaster.com.ph ) salamat

    ReplyDelete
  46. pa email din po ako pls sample excel po floriecinense08@gmail.com

    ReplyDelete
  47. Hi po, favor naman po, pwede po ba pa send din ng sample excel format sa email & SRS transmittal din po. Salamat po.

    ReplyDelete

  48. Hi! Pwede pong makahingi ng excel template ng SRS as sample lang po please. email ephelrose@gmail.com

    ReplyDelete
  49. can i also have a sample format. ung excel kindly email me too at rriz95@yahoo.com salamat in advance.

    ReplyDelete
  50. same here po.. pasend po din sana ng excel format.please po.salamat. meddyboy27@gmail.com po email ko.

    ReplyDelete
  51. ROW ERROR DESCRIPTION
    ---------------------------------------------------------
    0000000001 Invalid Header. Data found in excess column.

    SUMMARY REPORT
    ---------------------------------------------------------
    ROW ERROR DESCRIPTION
    ---------------------------------------------------------
    1 Invalid Header. Data found in excess column.


    GUYS PA HELP PO PANU PAG GANITO ERROR

    ReplyDelete
  52. ROW ERROR DESCRIPTION
    ---------------------------------------------------------
    0000000001 Invalid Header. Data found in excess column.

    SUMMARY REPORT
    ---------------------------------------------------------
    ROW ERROR DESCRIPTION
    ---------------------------------------------------------
    1 Invalid Header. Data found in excess column.


    GUYS PA HELP PO PANU PAG GANITO ERROR

    ReplyDelete