BIR Form No. 2305 data entry and validation module download

As what we have previously discussed, the Bureau of Internal Revenue (BIR) issued Revenue Memorandum Circular (RMC) No. 59-2015 to circularize the availability of:

  • Update of Exemption of Employees (UEE) (BIR Form No. 2305) Data Entry Module
  • 2305 Batch File Validation Module

UEE Data Entry Module is a data entry module where the employer inputs all the registration updates of exemption of its employees one by one with validation before sending electronically to the BIR.  2305 Batch File Validation Module, on the other hand, is a  validation module of BIR Form 2305 for the CSV file generated by the employer using own extract program.

Advertisements

To download these resources click the following links:

Update of Exemption of Employees Data Entry Module

2305 Batch File Validation Module (.exe)

2305 Batch File Validation Module (.zip)

Job Aid – Batch Entry Module (Annex B)

Advertisements

Job Aid – Batch Data Entry Module (Annex A)

The high level guide on how to use the data entry module and the validation module and to submit the related reports, read our article on BIR introduces Form No. 2305 Data Entry and Validation Module.

Be reminded of the following:

  • Employees can no longer visit and submit BIR Form No. 2305 to RDOs and LTDs
  • BIR Form No. 2305 shall be filed electronically by the employer using any of the format provided in RMC No. 59-2015
  • Reports generated should be transmitted via e-mail to BIRFORM_2305@bir.gov.ph
  • Employee shall submit the accomplished BIR Form 2305 together with the required documents to employer
  • Employer validates the completeness of documents
  • Submit the following every 10th of following month to the RDO or LTDs:
    • Accomplished BIR Form 2305 signed by both employer and employee with attachments
    • System-generated email notifcation
    • Printed Monthly Alphalist of Employees and Information Update (Alpha_1) report

For more details please read our article on BIR introduces Form No. 2305 Data Entry and Validation Module.

Let us know what you think! 🙂

153 Responses to "BIR Form No. 2305 data entry and validation module download"

  1. what should I do in this case?I really don’t know how to fix this.. please help

    TIN : 446305051
    BRANCH CODE : 00000
    DATE : 11132017
    FORM TYPE CODE : 2305
    ———————————————————
    ROW # ERROR DESCRIPTION
    ———————————————————
    0000000003 Email Address cannot be empty.
    0000000003 Relationship Start Date Length is invalid. “09175701462”
    0000000003 Relationship Start Date is invalid. Row value: “09175701462”

    SUMMARY REPORT
    ———————————————————
    ROW ERROR DESCRIPTION
    ———————————————————
    1 Email Address cannot be empty
    1 Relationship Start Date is invalid
    1 Relationship Start Date length is invalid

    COUNT DESCRIPTION
    —– ————————————————–
    3 TOTAL NUMBER OF RECORDS READ
    2 VALID RECORDS
    1 INVALID RECORDS

    Reply
  2. Hello po, paano po kapag invalid TIN in Data Entry? New employees po kasi tapos ang TIN issued by the BIR halimbawa ay 704-513-892. Ano pong dapat gawin, salamat po.

    Reply
  3. Hi, can someone please help me? When I choose CSV file when generating report, wala pong laman yung excel file tapos may napapansin akong sumusulpot na export.ini file. May naka-experience ba ng ganto? PLEASE HELP ME. kasi di ko napapansin yung file na sine-send ko sa BIRFORM_2305@bir.gov.ph, blangko pala 🙁

    Reply
  4. Hello everyone! I need some help, I’ve been using this program for almost a year now and so far, I haven’t encountered any problems not until I change my pc with the same Microsoft Office version 2007. Every time I tried to open the BIRF2305 database access the message “Unrecognized database format” always pops-out. Can someone help me with this? Thank you.
    https://uploads.disquscdn.com/images/e46509bf3413cacf2d16a4f2992093dbccd0f2631ba69407dc835b92470a1ccb.jpg

    Reply
  5. hi mga sir, tanong ko lang po kung required po i fill up yung email add. ng employee?. What if wala po talaga silang email add. ano pong pwedeng ilagay kasi hindi po siya nag ssave.
    Thanks

    Reply
  6. Hi, ask ko lng po meron pong lumalabas na error pg ino-open ko ung BIR2305.accdb na “Your microsoft access database or project contains a missing or broken reference file ‘2’ version 1.0” ano po b solution dito?? na-try ko na po ang iba’t-ibang version ng MS Office from 2010 – 2016. I also upgraded from Win8 to Win10, but still same problem exists. Pls help me nmn po. Thanks a lot in advance po sa makakatulong..

    Reply
    1. JennyRose Misalang · Edit

      In reply, effectivity date of exemption and effective date always has the same date as follows:

      a) birthdate of the youngest qualified dependent-update of additional exemption
      b) date of marriage – for update of marital status
      c) date hired(relationship start date); single w/ no qualified dependent – update of employer information

      Reply
  7. Hi. Tanong lang po regarding sa pag entry ng widow/er status. May empleyado kase kame na widow/er na babae. Everytime I changed her claims from husband to wife. Di sya nababago, nabalik into husband. Panu kaya yon? maraming salamat sa sasagot 🙂

    Reply
  8. good afternoon. Relationship start date is invalid. row value “contact no. namin”. email address cannot be empty, ganyan umh lumalabas nung vinalidate ko though filled up naman. what will i do? hoping for your prompt response. thanks

    Reply
    1. “effective date and relationship start” should be the same po, you can use the date kung kailan nyo po na update yong status ng employee, while sa “effective date of exemption” naman po is yong birthdate ng bunsong anak.

      Reply
  9. Jonard Ortega Deniega · Edit

    Sa mga nakakatanggap ng ganito:

    SUMMARY REPORT
    ———————————————————
    COUNT DESCRIPTION
    ———————————————————

    0 TOTAL NUMBER OF RECORDS READ
    0 VALID RECORDS
    0 INVALID RECORDS

    No data found.

    ETO SOLUSYON JAN:

    Pag nag-gegenerate kayo ng kahit na anong report lagi nyo tandaan ang ilalagay dun sa START DATE ay yung RELATIONSHIP START DATE tapos sa END DATE naman kahit yung TODAY na date nalang.. Thank you…

    Reply
  10. PRINGLE KAYE ANGGONG · Edit

    SUMMARY REPORT
    ———————————————————
    COUNT DESCRIPTION
    ———————————————————

    0 TOTAL NUMBER OF RECORDS READ
    0 VALID RECORDS
    0 INVALID RECORDS

    No data found.

    BAKIT PO GANITO YUNG LUMALABAS AFTER AKO NG VALIDATE NAG CSV FILE

    Reply
      1. Jul Pearl Clavecilla Navarro · Edit

        Hi, I hope this helps. Tumawag kc ako sa BIR. Ito mga pinagawa nila sa akin para makagenerate ng CSV file na may laman.

        1. Save UEE Data Entry module sa desktop.

        2. Change calendar setting
        short date: M/d/yyyy
        Long date: dddd, MMMM dd, yyyy

        3. Ilagay sa start at end date kung anong araw ang igegenerate ( in my case 12/09/2016-12/09/2016. I tried 12/01/2016-12/31/2016 pero walang laman ang nagenerate ko.)

        (For every step na gagawin, update employees records then generate. Open lang per employee record then save)

    1. if you’re inputing individual just input the first 9 digit of your TIN (i.e: 123-456-789); you havve to put 00000 on the branch code since its individual, but if Non-Individual, supply the 9 digit to the TIN portion and the remaining digit should be supplied at branch code since, possible that it would be 0000, or (i.e: 00200).
      my problem is that “invalid input for effectivity date.” and “invalid input effectivity date of exemption”. i did try all the possible thing. gawing pareho iyong relatioship start dat and effective date and “effectivity date of exemption” as -today-, but still the the above mention (the 2 error) pop ups.

      Reply
      1. “effective date and relationship start” should be the same po, you can use the date kung kailan nyo po na update yong status ng employee, while sa “effective date of exemption” naman po is yong birthdate ng bunsong anak .. para naman po sa TIN problem, u should input the first 9 digit of the employees TIN same as sa employer pero u should put 0000 on the branch code of the employer since automatic nman po yong sa employee (depende na lang po kung ano ang branch code # nyo, but it should be 4 digits #)

      1. if you’re inputing individual just input the first 9 digit of your TIN (i.e: 123-456-789); you havve to put 00000 on the branch code since its individual, but if Non-Individual, supply the 9 digit to the TIN portion and the remaining digit should be supplied at branch code since, possible that it would be 0000, or (i.e: 00200).

  11. Hi,
    May I ask if pwede po ba n mag generate kami ng CSV file kahit hndi pa nemen nai aupdate lahat ng employees namen? nganun palang kasi kami mag uupdate. pwede po bang kahit partial namen iuupdate for ex. kahit 20 employees muna.? thanks everyone, hope you can help me.

    Reply
  12. Hi Everyone, just wanted to share iyong itinuro ng contact center ng BIR for those hindi makapaggenerate ng CSV file. Make sure that the calendar settings of your computer are as follows:
    short date: M/d/yyyy
    Long date: dddd, MMMM dd, yyyy
    Click apply and ok
    Repeat the process of generating CSV where in start date and end date is the current date
    🙂

    Reply
  13. Kindly help naman po, lagi pong zero (0) bytes or blank CSV file ang nagegenerate ko. Pag chinechek ko nman po nag list of employee at BIR 2305 na form may data. Hindi po tuloy ako makapagvalidate at makapag e-sub. Thanks po in advance 🙂

    Reply
  14. Kindly help naman po, been generating CSV file pero lagi pong blank file or zero (0) bytes. Pag chinecheck ko ang list of employees and BIR 2305 may data naman po. what do I need to do para po hindi blank ang CSV file. Thanks po

    Reply
    1. hi po…try nyo po kung gagana…diba po pag naglog in tayo sa MS Access may mga UPDATE RECORDS po na nakalagay…try nyo po iclick un tapos open nyo ung isang record nyo then i save nyo po ulit..tapos try nyo po ulit mag generate ng csv file kung may lalabas na na data.

      Reply
  15. Good day! Ano po ba ang dapat na ilagay sa Effectivity Date and Effectivity Date of Excemption? Kasi, nilagay ko yung date ngayon or date of creation pero laging nag e-error ng “INVALID INPUT EFFECTIVITY DATE”. Please help. Thank you!

    Reply
  16. Hello po! Paano po ieenter ang TIN at telephone number invalid daw po kasi. Same lang nman po pag enter ko ng TIN number as the sample format pero TIN cannot be empty daw. Thank you po.

    Reply
  17. I have microsoft access 2013.. i have downloaded already the BIRF2305.aacb .. when i open it and enter na user my nagpa'pop up.. "the text you entered isn't an item in the list." tapos can't type na.. help me po.. please. Thank you very much!

    Reply
  18. good morning po, ask ko lang bakit po magkaiba yung # ng employees kapag nagvalidate ako ng files compared dun sa na generate ko na files. magkapareho nmn sya ng date. thanks po.

    Reply
  19. Orlando O. Calundan, CPA sir thanks po for rply ok na po sa TIN, sa date nalang po kc pag wlang dependent at may dependent lagi po ako nalilito ung effective date po sa taas at ung relationship of date po at effectivity date dun po ako nagkakaroon ng error…ty

    Reply
  20. Mari Con pag wala pong anak or dependent, anu po dapat ilagay?? saka po sa effectivity date of exemption??? please paisagot po, need po makapagsubmit na …

    and sa relationship start date po ba ay yung kung klan nagstart ang contrata? like sa teachers, kung klan napa-in?

    Reply
  21. ano pa ba linalagay dun sa effective date? ung date na kung kelan ipapasa? tsaka nung nagpunta daw ako sa BIR main pra ipasa ung mga hardcopy nmin eh hinihingan ako ng alphalist at transmittal. sabi nila may kasamang sinend ung BIR sa email na alphalist eh wala nmn. san ba makakakuha nun? gagawa ba kami ng sarili format nun? salamat sa makakasagot

    Reply
  22. Is in direful need of your help, please. Why is it na sinasabi na "TIN CANNOT BE EMPTY" eventhough nakafilled-in naman po siya? Please please help po, I've been trying to do it for three days but i just get the same result. Your answer is very much appreciated po. Thank you so much.

    Reply
  23. Hi po, example po yung bagong employer ko pinapapasa aq ng 2305,e d pa po aq employed ngayon sa june pa..cla nb maglalakad nung 2305 ko…change status lng naman..ano po ba ggawin ko?
    sav po kc sa BIR n pinunthan ko,dunq dw isubmit ung marriage contract q at cla na ang magbbgay s knila kc online na nga,..pano po ba..

    Reply
  24. Sir/Ma’am, nag create po ako ng new user ng company namin..the problem is, hindi po ako maka log-in..sabi dun “enter text that matches one of the listed items”..i created another one pero ganun pa din po..
    please help 🙂

    Reply
  25. Been trying this for 3 days already but still unsuccessful. Nakakawindang lang un mga details na dapat i-fill up. Maybe its the reason for the error and why I cannot generate the report, it is always invalid. 🙁

    Reply
  26. Good afternoon po! Sir, inquire lang po bakit po kaya di ako maka-add ng user lagi pong sinasabi na "TIN cannot be empty" e nakafill-in n rin po ung TIN? ano po kayang problema? Thanks po!

    Reply
  27. Question mga sir, CSV file po ba is talagang excel file sya? nakapag generate ako ng CSV but excel file sya and if yes po naman, yun na talaga sya? yun na yung sesend ko sa email ng BIR?
    and my mga naencounter din akong problem sa pag create ng employees namin, bagong download lang kasi itong module namin so ginagawan ko pa lahat ng employees namin ng file sa module, ang problem is yung "effective date", "relationship start date" and "effectivity date of exemption", laging error nalabas, ano ba yang date na yan? anong format etc? di ko kasi maregister mga employee e lalo na yung mga married with dependent, thanks sa mga sasagot

    Reply
  28. sir mam bakit pag nag vavalidate po ng module na csv eh ang luma labas ay ROW ERROR DESCRIPTION
    ———————————————————
    0000000001 No detail record found in file.

    SUMMARY REPORT
    ———————————————————
    ROW ERROR DESCRIPTION
    ———————————————————

    COUNT DESCRIPTION
    —– ————————————————–
    1 TOTAL NUMBER OF RECORDS READ
    1 VALID RECORDS
    0 INVALID RECORDS

    Reply
  29. Mark Anthony Tonic I knew how to resolve this.. but you will restore database and then start to input or add new record (yung mga ininput mu na hindi na read, i input mu ulit (i'm talking to the BIRF2305 microsoft access) then after you re-input it generate the CSV file and then go to BIRF2305 validation module to validate your report.

    Reply
  30. Orlando O. Calundan Hi Sir, same po kami ng problem ni Ms. Joy Lim Osmillo. Pag nag generate po ng CSV file wala po laman so pag nag validate po wala din laman pero ung ibang report po like "List of Employees" and "Bir Form No. 2305" may laman po. Ask ko lang po sana Sir kung nakakapag generate po kayo ng CSV file na may laman. Thank You.

    Reply
  31. Philippine Accounting Updates Bakit po ganun, hindi pa rin po ako makapag create ng user account..i already opened the module, then put everything on it (First name, Middle name, last name etc etc until sa last which is the telephone # pero hanggang dun lang, walang nag pop out whats next or what or walang nag appear like sa job aid na mag ask to save..why?

    Reply
  32. We already downloaded the updated version of your system but we still cannot save the new user data. Is there any possible option for us to resolve this problem?

    Reply
    1. We already downloaded the updated version of your system but we still cannot save the new user data. Is there any possible option for us to resolve this problem?

      Reply

Leave your Comment!