Monthly tax and contribution reports

Monthly tax and contribution reports

These reports produce the files you remit to the government each month: the SSS, PhilHealth and Pag-IBIG contribution files and the BIR 1601-C withholding tax return in the Philippines, the CPF file in Singapore, and Form 941 in the United States. KAMI builds each file from your payslips, so what you file matches what you paid. This article explains how to create them, what each one contains, and how to record the payment afterwards.

For Malaysia see Malaysia statutory payroll reports, and for Indonesia see Indonesia statutory payroll reports. Annual returns are in Year-end payroll reports.

Where: Payroll › Dashboard › View Reports › Create Report › Tax Reports or Contribution Reports

You need:

  • Contribution Reports for the contribution files
  • Tax Filing for the tax returns
  • Create/View Payroll Reports to create the final report

Before You Start

Close every batch for the month. These reports count every payslip that is not inactive, including Open and Pending ones. A file made before the batches are final will not match what you pay.

Know which month a batch belongs to. Contribution reports pick batches by their Contribution month, and tax reports by their Payroll Month. Both are set when the batch is created. A batch with the wrong month lands in the wrong file.

Fill in your employer numbers. The SSS file takes the employer number from your company details, or from the subsidiary's when you filter by subsidiary.

How to create a monthly report

  1. Select View Reports, then Create Report, and select the report. It opens in a new tab.
  2. Choose the Year and Month. The table fills once both are set.
  3. Narrow it if you file separately by entity or location: search by name, or select Filters and choose a Branch, Subsidiary, Cost Centre or Group.
  4. Check the table against your payroll totals for the month.
  5. Select Create Report (on some pages Create reports). A window lists each file the report produces.
  6. Select Preview next to each file. It downloads straight away and creates no record. Where a file offers Send in email, tick it to receive a large file by email instead.
  7. When every file is right, select Create Final Report. KAMI creates one record holding all the files.
  8. Download the files from the record and file them with the agency. KAMI does not submit to the government for you.

How to record the remittance

  1. On View Reports, open the record.
  2. Set Status to Approved once checked, or Paid once remitted.
  3. Under Payment Details, enter Amount paid, Date Paid, Payment Method and Payment Reference. Upload the agency's receipt under Files if you want it kept with the filing.
  4. Select Save.

Philippines

ReportWhat it containsFiles
SSS (Social Security System)Each employee's SSS Number, Compensation, Premium (ER), Premium (EE), EC and Total premium, with a Status code: N - Default, 1 - Newly hired (hired that month), 2 - Terminated (left that month) or 3 - No Earnings (zero compensation)Full Details (Excel), SSS Format (CSV), SSS Format (Excel), and SSS Format (TXT) to load on the SSS website
PhilHealthEach employee's PhilHealth Number, Employee Contribution and Employer Contribution. The status is Active, No earning (zero compensation) or Separated (left that month)Employee list (CSV), Employee list (Excel) with the month, headcount and totals, and PHIC File to upload on the PhilHealth website
Pag-IBIG (Home Development Mutual Fund)Each employee's HDMF Number, Employee ID, Employee Contribution, Employer Contribution and TinEmployee list (Excel), the monthly remittance list
BIR-1601-CThe company's monthly return of tax withheld on compensation, as the form's items 14 to 36, from Total Amount of Compensation to Total Amount Still Due. Filter by Subsidiary and Cost Centre, and answer Amended Return, Number of Sheets Attached, Any Taxes Withheld? and the tax-relief questionEmployee list (Excel), Company File (PDF), Company File (Excel)

On the 1601-C, the items for previous remittances, surcharge, interest and compromise are left blank for you to complete on the BIR form. Mark each month's 1601-C record Paid: the yearly 1604-C Annual summary is built only from 1601-C records marked Paid.

Singapore

CPF lists each employee's CPF Number, Ordinary wage, Additional wage and CPF to be paid for the month. It produces Employee list (Excel), a full detailed CPF report you use to complete your CPF submission. Filter by Subsidiary, Branch, Cost centre or Group.

United States

Form 941, the Quarterly Federal Tax Return, reports income tax, social security tax and Medicare for the quarter. Choose the Year and Quarter (One to Four), then create the PDF.

Tips

  • Reconcile three ways before filing. The report total against the month's payroll totals, a few employees against the agency's own table, and the headcount against the number of people you expect to remit for.
  • File every entity you run. If you run several batch cycles or subsidiaries, make sure each is in a file. Leaving one out is an under-remittance.
  • Watch the month a rate changes. It is the month most likely to be wrong, and the one an auditor will check.
  • Check leavers and new joiners. On the SSS file their status codes come from the hire and termination dates on their profile, so a wrong date gives a wrong code.
  • Never edit the file to match an expectation. If the figures look wrong, fix the payslip and create the report again.

Troubleshooting / FAQ

Q: An employee is missing from the SSS file. Their batch may have a different Contribution month, or they have no payslip that month. Check the batch, then the filters.

Q: The file includes a payslip we haven't approved. Contribution and tax reports include Open and Pending payslips. Close the batch, then create the report again.

Q: The report total doesn't match our payroll. Check the Branch, Subsidiary, Cost Centre and Group filters, and that every batch for the month has the same Contribution month.

Q: Contributions don't match the agency's table. Check the rate, cap and rounding on the contribution type. See Contribution types.

Q: We filed and then corrected a payslip. The report no longer matches your filing. Keep the original files and use the agency's amendment process.

Related articles