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. 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)
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
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!
ReplyDeleteGud 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!
ReplyDeletePlease 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!
ReplyDeleteHi.i have the same problem also regarding Alphav6. ano po ginawa nio para po ma.ifile?.
DeleteHi,
ReplyDeleteNakapag 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.
viewing the generated report thru excel is not working. BIR, please review and update your database! need that excel for attachment to documents purposes.
ReplyDeleteHi bakit po kapag nag inquire/print wala lumalabas na report sa QAP?
ReplyDeleteThanks
Hello.. I cannot Print/Inquire or generate excel file in Alphalist version 6.0..Pls help..Thank you!
ReplyDeletena 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
ReplyDeleteGo to utilities found on the main page of the Alphalist V6 then click update database the you can print
Deletedone it works.. TY LA
DeleteHi!
ReplyDeleteI'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!
cannot log-in on alphalist data ntry using my BIR userID and password
ReplyDeletesame problem, cant print/inquire. ano alternative BIR?
ReplyDeleteI 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.
ReplyDeleteHello 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.
ReplyDeletehello po, newby here.. just want to inquire the steps in adding employees in the alphalist.. thanks po...
ReplyDeleteI always see "Please Always Quit the MS Excel Application to Avoid This Error...!" when I click GENERATE FILE or PRINT ...1604CF. Any help?
ReplyDeleteTried 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.
same problem, nakuha mo na po ba kung papano ang gagawin?
Deletehello po, na-solve nyo na po rpobe na eto? i am encountering this too need help badly
DeleteAny update? Are you still encountering the error?
DeleteMonths after, SAME problem. Tried putting the app on Windows 7 Compatibility mode. Same problem.
DeleteNow trying older versions of Windows AND installing EXCEL (Dapat ba may excel sa PC, sa akin wala eh)
Same here how to solve this
Deleteyes, keep on logging in every time I will generate an excel file I need to close the alphalist system.
DeleteAny update? Did you solve this problem?
DeleteAny update? Did you solve this problem?
DeleteAll excel files should be close before you can print/inquire.
DeleteMake 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.
Deletewould just like to report that adding the template directory to MS Excels trusted documents works, can finally export to excel
Deletesame problem also....please po share nman kung na solve na po nyo
DeleteSana nagbigay k instructions how to do that
Deletegood pm po sir,panu nyo po nagawa? pwede po paturo step by step,salamat po.
DeleteSolution: Upgrade your Excel 2010 to 2013 and up.
DeleteSolution: Upgrade your Excel 2010 to 2013 and up.
DeleteHi we're able to resolve this error by following the steps below:
DeleteAdd 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.
BIR ALPHALIST 7.0 ERROR " please Always quit the MS excell application to avoid this error" solution
Deletehttps://www.youtube.com/watch?v=aVQ_ZimnvWc&t=73s
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"alphalist V6 setup.exe is not a valid win32 application"
ReplyDeletePaano po ito, hindi ako maka install. Salamat po
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.
ReplyDeletePlease advice
Thanks,
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?
ReplyDeletesalamat po sa magiging kasagutan
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
ReplyDeletepaano kapag version 3.4 pa yung gamit ko ?? tas ililipat ko ung database nya sa version 6.0 ?? any suggestion please
ReplyDeleteBakit po autocomputed ang taxable basic salary as difference agad ng gross compensation and total non-taxable? hindi po nacoconsider ang taxable benefits.
ReplyDeleteGood pm, concern ko po ay sa BIR Form 1604CF sa Gross Compensation Income.
ReplyDeletesa version 6.0, hindi po siya total ng taxable+non taxable income kundi,, non-taxable + taxable salaries lang.
About sa 1604CF the BIR will release update alphalist kasi may mga changes due to train law.
ReplyDeleteSame 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..
ReplyDeleteHow to bulk entry to 1604CF per schedule.? thru excel.
ReplyDeleteAng hassle iencode as manually.
helow po pano po mag multiple Alphalist in one computer 3 companies po kami salamat
ReplyDeleteAnung witholding tax code po ginagamit nio kapag 10% legal fees,
ReplyDeletekasi yung sa alphalist v6, P720k below lng po available e.
thanks
GOOD AFTERNOO,
ReplyDeleteKapag 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
SAME PROBLEM PLZ HELP
DeleteSAME PROBLEM PLZ HELP
DeleteHello po,same problem po,naayos na po s inyo?
DeleteHI when is the deadline for this year Alphalist?
ReplyDeleteThank you
BIR 1604CF 2019 is on Jan 31, 2020 and BIR 1604E 2019 is on March 1, 2020. Thanks.
DeleteBIR 1604CF 2019 and BIR 1604F is extended from Jan 31, 2020 to February 28, 2020 under RMC No. 124-2019. Thanks
Deletehi. 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