Using Timekeep

Export payroll reports for your accountant in Timekeep

Apr 4, 2026 · 3 min read

Every month, you run payroll and your accountant or bookkeeper needs the numbers. What each person earned, what was deducted, what the net pay was. They need it in a format they can work with, not a screenshot of your dashboard.

Timekeep generates a payroll CSV that has everything in one file. One row per employee, with every earning and deduction broken down by type. Your bookkeeper can open it in Excel or Google Sheets and work from there.

What the payroll CSV contains

The monthly payroll CSV includes the following for each employee in the export period:

  • Basic pay
  • Overtime pay (regular, rest day, holiday)
  • Holiday pay
  • Night differential
  • Leave pay
  • Late and undertime deductions
  • SSS contribution (employee share)
  • PhilHealth contribution (employee share)
  • Pag-IBIG contribution (employee share)
  • Withholding tax
  • Loan deductions
  • Net pay

Each column is labeled. Your accountant can see exactly what went into each person's net pay without having to ask.

How to download the payroll CSV

Go to the Payroll page and switch to the By Month tab. Each month shows the total gross pay, net pay, and deductions. Click the download icon on the right side of the row to export the CSV for that month.

Timekeep bookkeeper payroll view with By Month tab and download icon
Timekeep bookkeeper payroll view with By Month tab and download icon

The By Month view groups both cutoffs under a single month. The download icon on the month row exports a combined CSV so your accountant gets one number per employee for the full month, not two separate cutoff rows.

What your accountant does with it

Your bookkeeper can import the CSV into their accounting software, use it to prepare the payroll journal entry, or verify the numbers against the bank transfer. The file has all the detail they need.

The government contributions columns are useful for preparing the monthly remittance reports for SSS, PhilHealth, and Pag-IBIG. Your accountant has the employer share and employee share for each deduction, per employee.

Attendance export for auditing

If your accountant or HR needs a detailed attendance report, you can also export attendance records. The attendance CSV includes every clock-in and clock-out for the selected date range, with timestamps, late minutes, overtime hours, and break durations.

This is useful for verifying that payroll numbers match the attendance data, or for providing documentation if there's a question about a specific day.

Employee roster export

You can also export a list of all employees as a CSV. This includes names, government ID numbers (SSS, PhilHealth, Pag-IBIG, BIR numbers), daily rates, and employment details. Useful for your accountant when filing remittance forms that require employee information.

Payroll records in Timekeep

Every finalized payroll is stored in Timekeep. You can go back to any month and download the report. If your accountant asks about a payslip from three months ago, you can download the CSV for that period or pull up the individual payslip in a few seconds.

For small businesses that previously kept payroll records in spreadsheets on a shared desktop, having payroll history stored and searchable in one place is a meaningful improvement.

What your bookkeeper actually needs

Every bookkeeper has a different workflow. Some want one file per month. Some want individual payslips. Some want the payroll broken down by cost center or position.

The Timekeep CSV gives your bookkeeper a clean, complete starting point. Everything is labeled, all the math has been done, and the numbers tie back to the payslips your team sees in the portal. There's no reconciliation step because everything comes from the same source.

Try it free for 30 days at timekeep.ph.

Quick answers

Frequently asked questions

What does the payroll CSV export contain?

The monthly CSV export includes each employee's gross pay, all earnings broken down by type (basic, overtime, holiday, night differential), and all deductions (SSS, PhilHealth, Pag-IBIG, withholding tax, loans, late, undertime). One row per employee.

Can I export attendance records separately?

Yes. The attendance export gives you a detailed record of every clock-in and clock-out, including late minutes, overtime hours, and break times for any date range.

Does the CSV work with Excel and Google Sheets?

Yes. The CSV file opens in Excel, Google Sheets, or any accounting software that imports CSV. Your bookkeeper can work with it the same way they would any spreadsheet.

Can I export payroll for multiple months at once?

You can select multiple payroll periods and download them as a combined monthly CSV. The export groups all cutoffs within the month into a single summarized row per employee.

Is there an employee data export as well?

Yes. You can export your staff roster as a CSV with employee names, government ID numbers, daily rates, and other details. Useful when your accountant needs employee records for filing.