Payroll reports
Payroll Reports is where you create any payroll report: a payroll export for finance, a batch summary, an other-payments list, a leavers' report, a government contribution or tax file, or the accounting journal. It is also the register of every final report and filing your company has created, with its amount, status and payment details, so you can see what was filed, when, and whether it has been paid.
Where: Payroll › Dashboard › View Reports
You need:
- General Reports to open the payroll, batch and journal reports
- Contribution Reports for the contribution files, and Tax Filing for the tax forms
- Create/View Payroll Reports to see the Create Report button and to edit or delete records in the register
These rights are set in Payroll › Settings › User Rights. See Payroll user rights.
Which report, when
| You want | Use |
|---|---|
| Every payslip line for one or more batches, for finance or an audit | Payroll Report |
| One line per batch with its totals, for the year | Batch Report |
| Every allowance, bonus and deduction paid, by type | Other Payment |
| Leavers with their termination reason, severance and leave pay (Philippines and Indonesia) | Termination |
| Attendance corrections paid in a later batch | Retroactive Events |
| Your own columns and formulas, reused every period | Custom Payroll Report — see Custom payroll report templates |
| A government contribution or tax file | Tax Reports or Contribution Reports — see Monthly tax and contribution reports |
| Journal lines for your accounting system | Accounting Journal — see The accounting journal |
How to create a report
- On the Payroll Dashboard, select View Reports.
- Select Create Report. The Payroll Reports window groups reports under Payment Reports, Tax Reports, Contribution Reports and Others. Only the tax and contribution reports for your company's country are shown.
- Select a report. It opens in a new browser tab.
- Choose the batch or period, apply any filters, and export or create the report as described below.
How to run the Payroll Report
- Open Payroll Report and select Select Batch. The Payroll Batch Selector lists your batches. Search, or use Filters (Year, Month, Batch Cycle, Batch Type, Status), tick one or more batches, and select Run Report.
- The Overview tab shows Total Payable and Total Employees, and a bar chart you can switch between By Department, By Position, By Branch and By Cost Centre, limited to Top 5, Top 10, Top 15, Top 20 or All. With several batches you can pick one under Batch. Its Export button downloads the figures as Excel.
- The Detailed tab lists each payslip with Payroll Month, Cost Center, Status and Total Payable. Use Search and Filters (Batch, Subsidiary, Department, Branch, Cost Centre, Status) to narrow it.
- Select Export. Choose CSV or Excel under Export as, tick the fields you want (or Select all fields), and choose a Group by if you want subtotals: Cost Center, any grouping custom field your company has, or Employee when you selected more than one batch, which puts each employee's batches together on one line.
- Select Submit. KAMI remembers the fields you picked for next time.
The Payroll Report includes every payslip in the batches you choose, whatever its status. Use the Status filter on the Detailed tab when you only want Closed or Paid payslips.
How to run the other payment reports
Batch Report: filter by Payroll Cycles and Status, and choose This year, Last 12 months or Last Year. The chart and table show each batch's Start Date, End Date, Employees, Total Payable and Status. Under Export, Detailed Preview downloads an Excel file straight away, and Detailed Final Report creates a record in the register. Both exports cover the whole time range you chose and ignore the cycle and status filters.
Other Payment: select Select Batch, then filter by Batch, Department, Branch, Position, Subsidiary, Cost Center or Other Payment Type. Each row shows Name, Payroll Month, Other Payment Type, Description and Amount. Export gives Microsoft Excel (.xlsx). Import lets you upload that file back after editing, but only the Other Payment Type and Description change, and the payslips are not recalculated. For amount changes, use a payroll bulk upload instead — see Payroll bulk imports.
Termination: lists terminated employees with Employee ID, Termination Reason, Termination Date, Severance Pay and Leave Compensation, taken from the other payments of those names on their final payslip. Export XLSX downloads it. It is available for Philippine and Indonesian companies, and needs the right to deactivate employees.
Retroactive Events: lists attendance corrections that were paid in a later batch, between a Start Date and End Date (the last month by default), with Payroll Batch, Wage Event Date, Wage Event, Amount, Length and Added By. It needs the Payroll Processor right. See Retroactive payments.
Payment Request Form (under Others) appears only for companies where KAMI has set it up. It summarises one batch's salary, overtime and contributions as a PDF for internal payment approval, with first and second approvers.
The Payroll Reports register
Every Create Final Report adds one record to the list on View Reports. The list shows Report, Type, Period, Date, Amount, Last updated and Status. Search by name, or use Filters: Subsidiary, Type, Period, Year, Month, Status and Last updated.
Select a record to open it. You can change its Name, Subsidiary, Type, Period, Month and Year (or Start Date and End Date), Amount and Status, open its Files, Upload another file (.xlsx, .csv, .pdf or .txt), record Payment Details (Amount paid, Date Paid, Payment Method, Bank Name for electronic payments, Payment Reference) and add a Note. The record shows who last updated it and when. Delete removes the record.
| Status | Means |
|---|---|
| Pending | Created, not yet approved. Every new record starts here |
| Approved | Checked and ready to pay or file |
| Paid | Remitted. Philippine 1604-C Annual reads its monthly figures only from BIR-1601-C records marked Paid |
Tips
- Close the batch before you create a final report. Most reports count every payslip that is not inactive, so a report made while payslips are still Open or Pending will change.
- Preview first, create once. A final report adds a record and, for some tax forms, puts documents in employees' profiles.
- Record the payment on the register. It turns the list into your remittance log, and the next person can see what is outstanding.
- Keep the downloaded file with your filing. Regenerating later from corrected payslips will not reproduce what you sent.
- Use the Payroll Report's Group by Employee when finance wants one line per person across several batches.
Troubleshooting / FAQ
Q: I can't see the Create Report button. You need the Create/View Payroll Reports right.
Q: A report I need isn't in the Create Report window. Tax and contribution reports are country-specific, and you only see your company's country.
Q: My export ignored the batch cycle I filtered by. On the Batch Report, exports use the time range only. Narrow the range instead.
Q: Two people's Payroll Reports for the same month disagree. Check the batches selected and the Status filter. Open and Pending payslips are included unless you filter them out.
Q: Can I get this report emailed every month? The Payroll and Payroll details reports can be scheduled. See Scheduling payroll reports.