Adding Employees and Compensations for 1601-C Forms

In order for you to process your 1601-C form (Monthly Remittance Return of Income Taxes Withheld on Compensation), you would need to have a list of your employees as well as compensations for each staff. 

But what if you have 100+ employees? Maybe the question that you might think of is  “Should I enter those transactions in JuanTax one by one?”

Of course not. Here at JuanTax, we want you to easily file your 1601-C forms, which is why we added bulk import features for both your employee list and compensations.

For Employees

(1) Bulk Import

To import your list of employees, you would need to have a CSV spreadsheet file which will contain all the employee’s necessary information such as TIN, Last Name, First Name, Employment From, Rate, Region, Sub Filling, Wage Type, and Exemption Code.

Then go to Contacts, proceed to Employees and click Import Employee(s) icon.

Click the Browse button and start searching for the file that you need.

Once you had found the destination of your file, click Open.

Your file will be imported to the Import Employee(s) section, which means you can now proceed to the next part of the import setup by clicking Next.

Map the corresponding fields in your CSV file. Please take note that you should also make sure to indicate any of the following exemption codes (Z, S, S1, S2, S3, S4, M, M1, M2, M3, M4) based on the number of the employee’s dependents.

After reviewing your data, finish the import by clicking DONE.

(2) Manually Add Employees

If you had forgotten to include a certain employee, then you can also manually add them just by clicking the Add Employee (plus) icon.

Enter your employee’s basic information, then click Add Employee button to save your changes.


For compensations, you need to go to the Compensation section of your dashboard and create a new report by clicking the Generate Report icon (plus sign).

Next up, you need to go to the Sources tab and start adding your compensation(s). Much like employee(s). You also have two options if you would (1) Import your Compensations or (2) Add Compensation(s) Manually.

(1) Import your Compensations

To import your list of compensations, you would need to have a CSV spreadsheet file which will contain all the necessary information such as Employee TIN, Basic Pay, Payment Date and Tax Withheld. Other optional fields are Holiday Pay, Overtime Pay, Night Shift Differential Pay, Hazard Pay and Other than Non-Taxable Compensation.

Click the Import Compensation(s) icon to start importing your compensations.

Browse for your file and after that, click the Next button to proceed with the setup. Please take note that you first need to add your employees in order to successfully import your compensation data.

Map the corresponding fields that you need. Remember that most of the fields have Multi-select option where you can choose between one or more column header.

Review your imported data then click the Next button to proceed. Finish the import by clicking DONE.

(2) Add Compensation(s) Manually

You can also add your compensations manually just by clicking the Add Compensation (plus) icon.

If ever the employee that you would add in the compensations window is not part of the employee list that you imported earlier, you still need to enter all of the employee’s basic information by clicking the Add as New Employee option button. It will prompt you to a modal where you should manually enter the employee’s data.

Enter information such as Basic Pay, Non-Taxable Compensation, Other than Non-Taxable Compensation as well as Gross Income and Tax Amount. After that, click Save Changes button to update your list.

You can also click the +Add Line button if you need to add another employee.

2307 and 2306 Creditable Certificates

Users can now also create creditable certificates for schedules of  tax returns in JuanTax.

BIR form 2307, or simply referred to as Certificate of Creditable Tax Withheld At Source, which shows income subjected to the expanded withholding tax which is paid by the withholding agent. In JuanTax, these kinds of certificates can be done for VAT and can be seen in Schedule 6 and Percentage tax (as seen in Schedule 1).

While 2306 forms (Certificate of Final Income Tax Withheld) can only be done in VAT reports in JuanTax. This form is issued by the withholding agent (employer) which also reflects income subjected to final tax. It’s located in Schedule 8 of the form.

Another thing is that when it comes to final withholding tax, 2306 are processed annually, while 2307 are being done quarterly.

You need to go to your dashboard and look for Creditable Certificate. There are two tabs present: 2307 and 2306 certificates.

Click the Add Transaction icon (plus icon) to start adding transactions.

You would still need to enter all of the vendor’s basic information by clicking the Add as New Contact option button. It will prompt you to a modal where you should manually enter the vendor’s data.

Enter information such as Contact Type, TIN, First Name, Middle Name, Last Name as well as Address, City and Zip. After that, click Save button.

Enter other details such as Vendor, Period Covered, Income Payment and ATC, then hit Save button. There is also an +Add line button where you can add another line of transaction.

Bonus Feature: Download SAWTs

We also added a bonus feature which would let you obtain a downloadable copy of your SAWT (Summary Alphalist of Withholding Agents/Payors of Income Payments Subjected to Creditable Withholding Tax).

Once you go to your tax report, you will now see a SAWT button in Step 1: Filing Type, which would let you download either a DAT file or Excel file format of your SAWT.

Did this answer your question?