BIR Form No. 2316 UserFriendly

Click the link below to download the form.
BIR Form 2316 - Certificate of Compensation Payment/Taxes Withheld


BIR Form No. 2316 - Certificate of Compensation Payment / Tax Withheld For Compensation Payment With or Without Tax Withheld

Description

A Certificate to be accomplished and issued to each employee receiving salaries, wages and other forms or remuneration by each employer indicating therein the total amount paid and the taxes withheld therefrom during the calendar year. 

This Certificate in turn should be attached to the Annual Income Tax Return (BIR Form 1700 - for individuals receiving purely compensation income, or BIR Form 1701 for individuals with mixed income). 

Filing Date

To be issued to payee on or before January 31 of the succeeding year in which the compensation was paid, or in cases where there is termination of employment, it is issued on the same day the last payment of wages is made. 

You can download the BIR version at http://www.bir.gov.ph/birforms/form_cer.htm#2316.

After opening the file, click >>Options,.. Enable this content, then OK .  The worksheets where the forms reside are protected but without password.  You cannot select cells that are locked for protection like those with calculations and other unused cells. The purpose is to prevent accidental deletion of cells especially those with hard-to-edit calculations.  At the right side of the forms are unprotected cells with outside border. The purpose of which is to serve as a calculator.  Included of course in unprotected cells are cells or items that require user’s input.  To unprotect the worksheet/s, on the Review tab, in the Changes group, click Unprotect Sheet. 

Likewise the column and row headers are not shown.  To show/hide the column and row headers go to Office Button > Excel Options > Advanced, under the Display options for this worksheet, check or uncheck the Show row and column headers checkbox.

At the right side of the upper right corner of the form is a big number in red.  That number is the “LOOK UP VALUE” in VLookUp function I used in this form.  That “LOOK UP VALUE” is also the value in the field/column “SEQ. NO” of your annual alphalist.  This number can be changed or click the “UP ARROW” to increment the value by one (1) except for the last record.

The format of the alphalists, especially the fields/colums’ arrangement must be strictly unchanged.  Avoid moving or deleting columns and rows except if you are capable of editing the calculations involved or creating your own formula.  Inserting column is also prohibited.  Just copy/paste your existing data in the provided alphalist worksheets.  The maximum row number in VLOOKUP function is 200.  If your record is beyond the scope of “ROW200”, a simple trick is to insert row/s on or before row200 and the referred row in the formula will be adjusted accordingly.

Kindly review every details of this form and If you notice any error please let me know, contact me at eacruzjr@gmail.com.  Thank you very much for your time and I hope I missed nothing.  Just click the link below to download the form.

BIR Form 2316 - Certificate of Compensation Payment/Taxes Withheld 


A dialog box will pop-up with the following warning:
The workbook cannot be opened because it contains the following features that cannot be displayed in the browser:
Just click cancel, at skydrive window, right click the file and download.