Sunday, May 6, 2018

Procedures For BIR ALPHALIST DATA ENTRY V6.0

The bureau has issued BIR Alphalist Data Entry v6.0 to update Alphalist Data Entry v5.1. Included in the package is the Procedures for Alphalist Data Entry v6.0. 

PROCEDURES FOR ALPHALIST DATA ENTRY V6.0

A. PROCEDURES TO INSTALL,

IMPORT AND UPDATE DATABASE

I. Install
1. Go to www.bir.gov.ph
2. Go to Downloadables
3. Download the Alphalist v6 Setup
4. Install the downloaded Alphalist v6 Setup
5. Enter the Company Taxpayer Information

II. IF WITH EXISTING DATABASE (Alphalist v5.1 is installed)

a. Import database
1. Click the Alphalist Data Entry v6 shortcut located in your desktop
2. Login and enter the Company Taxpayer Information
3. Go to Utilities
4. Click Import Records
5. Click Browse
6. Go to C:\BIRALPHA51\DATA or locate the BIRALPHA51\DATA folder if the default directory was changed during the installation
7. Select efsbir.dbc
8. Click OK
9. Click Import Now
10. A Warning Message will appear, click Yes

b. Update Database
1. Go to Utilities
2. Click Update Database

III. IF WITHOUT EXISTING DATABASE (Alphalist v5.1 is not installed)

a. Update Database
1. Go to Utilities
2. Click Update Database

B. PROCEDURES TO GENERATE FILES

* For QAP Forms, three (3) files will be generated in the local directory where the system is installed (by default, C:\BIRALPHA6) * Provided that the data entry is already done

a. 1601E FORMS
1. In the Main Menu, Click QAP Forms
2. Click 1601E
3. In the "For the Quarter of" selection, select the Quarter you wish to generate
4. Click Generate File
5. Click Save button (*Save button will appear three (3) times)
6. Click OK

b. 1601F FORMS
1. In the Main Menu, Click QAP Forms
2. Click 1601F
3. In the "For the Quarter of" selection, select the Quarter you wish to generate
4. Click Generate File
5. Click Save button (*Save button will appear three (3) times)
6. Click OK C. PROCEDURES TO PRINT/INQUIRE

* For QAP Forms, all of the encoded monthly remittance returns within the selected quarter will be generated

a. 1601E FORMS
1. In the Main Menu, Click QAP Forms
2. Click 1601E
3. In the "For the Quarter of" selection, select the Quarter you wish to inquire
4. Click Print/Inquire

b. 1601E FORMS
1. In the Main Menu, Click QAP Forms
2. Click 1601F
3. In the "For the Quarter of" selection, select the Quarter you wish to inquire
4. Click Print/Inquire

D. PRODURES TO GENERATE EXCEL REPORTS
a. 1601E FORMS
1. Do Procedures C.a.1 to C.a.4
2. Click Excel Report

b. 1601F FORMS
1. Do Procedures C.b.1 to C.b.4
2. Click Excel Report

Please refer: https://www.bir.gov.ph/images/bir_files/downloadables/patches/PROCEDURES_alphalist_DE.pdf

57 comments:

  1. Gud pm sir, Alphalist version 5.0 to version 6 n po ako agad, how can I transfer ung Alphalist ko from version 5.o, pls help. Tnx!

    ReplyDelete
  2. Gud pm sir, I recently installed Alphalist version 6.0, wla po ako version 5.1. Version 5.0 po ang dating gamut ko. How can I transfer data entries from 5.0 to version 6. Pls help. Tnx!

    ReplyDelete
  3. Please help me poh hindi po talaga ma print preview and 1601E sa QAP bisan Inquiry hindi rin po, pano po ito wala talaga mglabas na files kahit na generate ko na.. thanks hoping for immediate response .. GOd Bless!

    ReplyDelete
    Replies
    1. Hi.i have the same problem also regarding Alphav6. ano po ginawa nio para po ma.ifile?.

      Delete
  4. Hi,

    Nakapag encode na po ako ng data for Jan, Feb & March (1st QTR) kaso pag nagPRINT/INQUIRE ako wala lumalabas na data. Pano po kaya madaling machecheck if tama yung total amount ng EWT na nainput ko per month? Thank you.

    ReplyDelete
  5. viewing the generated report thru excel is not working. BIR, please review and update your database! need that excel for attachment to documents purposes.

    ReplyDelete
  6. Hi bakit po kapag nag inquire/print wala lumalabas na report sa QAP?
    Thanks

    ReplyDelete
  7. Hello.. I cannot Print/Inquire or generate excel file in Alphalist version 6.0..Pls help..Thank you!

    ReplyDelete
  8. na istall ko npo yung v6 pero kahit na copy ko na po yung data sa 5.1 at na update ko nadin bkit po wla padin lumalabas sa screen nya

    ReplyDelete
    Replies
    1. Go to utilities found on the main page of the Alphalist V6 then click update database the you can print

      Delete
    2. done it works.. TY LA

      Delete
  9. Hi!

    I'm using version 6.0 and I cannot generate excel reports because whenever I click Print/Inquire for a certain quarter, the app turns in to blank (white). I tried waiting, thinking that the report is only buffering but still have no progress.

    Hope you can help me with my concern.

    Thanks!

    ReplyDelete
  10. cannot log-in on alphalist data ntry using my BIR userID and password

    ReplyDelete
  11. same problem, cant print/inquire. ano alternative BIR?

    ReplyDelete
  12. I think there is a glitch in the new Alphalist Data Entry. I tried to input the alphalist on a monthly basis however, when I review the files in the data entry after I generate it, the figures were already different from what I entered.

    ReplyDelete
  13. Hello po, cannot log in to version 6.0 ng alpha lsit data entry, d po ba same din xia sa user name and password ng v5.1? bkit po hindi mkpag log in? Thank you.

    ReplyDelete
  14. hello po, newby here.. just want to inquire the steps in adding employees in the alphalist.. thanks po...

    ReplyDelete
  15. I always see "Please Always Quit the MS Excel Application to Avoid This Error...!" when I click GENERATE FILE or PRINT ...1604CF. Any help?

    Tried Reinstalling.
    Tried using a fresh windows user.
    I don't even have MS Excel Installed.
    Tried running it under SAFE MODE.
    Tried UPDATE
    Tried Reindex.
    Still no dice.

    ReplyDelete
    Replies
    1. same problem, nakuha mo na po ba kung papano ang gagawin?

      Delete
    2. hello po, na-solve nyo na po rpobe na eto? i am encountering this too need help badly

      Delete
    3. Any update? Are you still encountering the error?

      Delete
    4. Months after, SAME problem. Tried putting the app on Windows 7 Compatibility mode. Same problem.

      Now trying older versions of Windows AND installing EXCEL (Dapat ba may excel sa PC, sa akin wala eh)

      Delete
    5. yes, keep on logging in every time I will generate an excel file I need to close the alphalist system.

      Delete
    6. Any update? Did you solve this problem?

      Delete
    7. Any update? Did you solve this problem?

      Delete
    8. All excel files should be close before you can print/inquire.

      Delete
    9. Make sure to exclude the template directory in MS Excel protected view or trust the whole template directory. I recently found out that some forms are in protected view and I made it work by trusting the alphalist folder and its subfolders.

      Delete
    10. would just like to report that adding the template directory to MS Excels trusted documents works, can finally export to excel

      Delete
    11. same problem also....please po share nman kung na solve na po nyo

      Delete
    12. Sana nagbigay k instructions how to do that

      Delete
    13. good pm po sir,panu nyo po nagawa? pwede po paturo step by step,salamat po.

      Delete
    14. Solution: Upgrade your Excel 2010 to 2013 and up.

      Delete
    15. Solution: Upgrade your Excel 2010 to 2013 and up.

      Delete
    16. Hi we're able to resolve this error by following the steps below:
      Add a trusted location

      Click File > Options.
      Click Trust Center > Trust Center Settings > Trusted Locations.
      Click Add new location.
      Click Browse to find the folder, select a folder, and then click OK.

      Delete
    17. BIR ALPHALIST 7.0 ERROR " please Always quit the MS excell application to avoid this error" solution
      https://www.youtube.com/watch?v=aVQ_ZimnvWc&t=73s

      Delete
  16. Our basic pay here in Iloilo is 350+15 cola magkano po ang ilagay ko na basic statury minimum wage 350 ba or 365? Ang cola ba sa 13th month pay and other benefit sia na belong or salaries and other form of compensation.Please advise

    ReplyDelete
  17. "alphalist V6 setup.exe is not a valid win32 application"

    Paano po ito, hindi ako maka install. Salamat po

    ReplyDelete
  18. Hi Guys i would like to ask help regarding the 1601E abd 1601F. During print/inquire all the ground total of income tax and Tax withheld are different from the View Portion and i also notice that. Income and Withheld are the total from from the start we using Alpha.

    Please advice

    Thanks,

    ReplyDelete
  19. Hello po, ayaw na po kc gumana ung 5.1 na alphalist, ng install po kmi nang 6.0, tanong ko lang po kung paano po makuha ung mga data dun sa 5.1 papuntang 6.0? kaya po ba iaccess nang 6.0 ung data sa 5.1?
    salamat po sa magiging kasagutan

    ReplyDelete
  20. For this new version (BIR ALPHALIST DATA ENTRY V6.0), is this mean that there is no more monthly submission of alphalist but instead, in quarterly basis already. Please clarify. thanks

    ReplyDelete
  21. paano kapag version 3.4 pa yung gamit ko ?? tas ililipat ko ung database nya sa version 6.0 ?? any suggestion please

    ReplyDelete
  22. Bakit po autocomputed ang taxable basic salary as difference agad ng gross compensation and total non-taxable? hindi po nacoconsider ang taxable benefits.

    ReplyDelete
  23. Good pm, concern ko po ay sa BIR Form 1604CF sa Gross Compensation Income.
    sa version 6.0, hindi po siya total ng taxable+non taxable income kundi,, non-taxable + taxable salaries lang.

    ReplyDelete
  24. About sa 1604CF the BIR will release update alphalist kasi may mga changes due to train law.

    ReplyDelete
  25. Same here din po bakit iba ang lumabas sa grosss compensation. paano po ba gagawin dito help please. my email is lensey0707@gmail.com thank you po..

    ReplyDelete
  26. How to bulk entry to 1604CF per schedule.? thru excel.
    Ang hassle iencode as manually.

    ReplyDelete
  27. helow po pano po mag multiple Alphalist in one computer 3 companies po kami salamat

    ReplyDelete
  28. Anung witholding tax code po ginagamit nio kapag 10% legal fees,
    kasi yung sa alphalist v6, P720k below lng po available e.
    thanks

    ReplyDelete
  29. GOOD AFTERNOO,
    Kapag naclick na yung form 2037 ito po ang lumalabas sa screen "PLease always quit the MS Excel Application to avoid this error....!
    Ano po kaya solution d2.
    Thank you and GOD bless

    ReplyDelete
  30. HI when is the deadline for this year Alphalist?

    Thank you

    ReplyDelete
    Replies
    1. BIR 1604CF 2019 is on Jan 31, 2020 and BIR 1604E 2019 is on March 1, 2020. Thanks.

      Delete
    2. BIR 1604CF 2019 and BIR 1604F is extended from Jan 31, 2020 to February 28, 2020 under RMC No. 124-2019. Thanks

      Delete
  31. hi. need po ng help. i downloaded version 7 of the alphalist data entry system, i was able to open it. however on my second attempt it could no longer open.. password incorrect. how can i change the password. thanks so much.

    ReplyDelete