Showing posts with label how to install alphalist data entry v6.0; how to import database alpalist v5.1; generate files; generate excel reports; QAP; Quarterly Alphalist Data. Show all posts
Showing posts with label how to install alphalist data entry v6.0; how to import database alpalist v5.1; generate files; generate excel reports; QAP; Quarterly Alphalist Data. Show all posts

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