On the Record screen, tap Import time log (below the list of days).
Open your timesheet, select the rows for the days you want, and copy them. Include the header row if there is one; it helps.
Paste them into the box, or tap Or choose a CSV file.
Tap Review. Kompyut shows every day it found, what it sees (on time, late, overtime, rest day work) and how much it changes your pay.
Untick anything you don't want, decide what happened on days not in your log, then tap Save.
Good to know. Nothing is saved until you tap Save, and then everything is saved at once. If something looks wrong, tap Back, fix the rows, and review again.
You don't need a special format. Kompyut looks for a date and clock times on each row and ignores the rest, like names, employee numbers and remarks. The next article shows the layouts it understands.
Timesheet layouts that work
These are the common shapes of timesheets. All of them can be pasted as they are.
1. One row per day, with a time in and a time out
The most common layout: your own spreadsheet, most HR portals, the Kompyut template.
Date
Time in
Time out
Total hours
09/01/2026
8:55 PM
5:02 AM
8:07
09/02/2026
9:00 PM
7:30 AM
10:30
Extra columns are fine. Columns named like Total, Hours, Duration, Late, Undertime, Overtime or Remarks are ignored when you include the header row, so a total like 8:07 isn't mistaken for a clock time.
2. Date and time together
Many time tracking apps export a full date and time in each column, sometimes with separate start and end dates.
Start
End
09/01/2026 20:55
09/02/2026 05:02
Start date
Start time
End date
End time
09/01/2026
8:55 PM
09/02/2026
5:02 AM
The shift is saved on its start date.
3. One punch per row (biometric machines)
Biometric and fingerprint machines, and many HR portals, list every tap on its own row, often with a type like C/In and C/Out.
ID
Date
Time
Type
1023
09/01/2026
8:55 PM
C/In
1023
09/02/2026
5:02 AM
C/Out
1023
09/02/2026
8:58 PM
C/In
1023
09/02/2026
8:59 PM
C/In
1023
09/03/2026
7:10 AM
C/Out
Kompyut pairs each time in with the next time out, in time order:
A time out dated the next morning closes the night shift before it. Both shifts above are saved on the day they started.
Words like In, Out, Check in, Clock out, Log in or C/In are used when they're there. Without them, punches are paired in order: in, out, in, out.
A second tap within 10 minutes, like the 8:59 PM above, is treated as a double tap and ignored.
A time in with no time out after it (you forgot to clock out) is listed under lines that couldn't be read, so you can add that day by hand.
4. Breaks on the same row
Four times in a row are read as time in, break out, break in and time out.
Date
In
Break out
Break in
Out
09/01/2026
9:00 AM
12:30 PM
1:30 PM
8:00 PM
That's 10 hours worked with a 1-hour break. Without break times, your scheduled break is used.
5. Two shifts in one day
Two separate blocks on the same date, either on one row or on two rows with the same date, are saved as your shift plus extra hours.
Dates like 09/01/2026 are read month first (September 1), the way most payslips and systems in the Philippines write them. When the first number is over 12, like 13/09/2026, it's read as the day.
If your system writes day first (01/09/2026 for September 1), check the dates on the review screen. If they're wrong, change the date column in your spreadsheet to a format with the month name, like 1 Sep 2026, and paste again.
Dates without a year
"Sep 1" is read as this year, unless that would be more than a month in the future. Then it's read as last year, so December rows pasted in January land in the right year.
If your timesheet looks different
Some timesheets need a quick change first. Here's what to do for the common cases.
Days across the top (a weekly grid)
Mon 9/1
Tue 9/2
Wed 9/3
In
9:00 PM
8:55 PM
9:02 PM
Out
5:00 AM
7:30 AM
5:01 AM
Turn it sideways so each day is a row:
Google Sheets: select the grid, copy, click an empty cell, then Edit, Paste special, Transposed.
Excel: select the grid, copy, right-click an empty cell, Paste Special, and tick Transpose.
Then copy the new rows and paste them into Kompyut. If the day headers don't include a year, like "Mon 9/1", that's fine.
Only total hours, no clock times
A timesheet that shows only "8.00" or "10.50" hours a day can't be imported, because Kompyut needs clock times to know which hours were overtime or at night. Either:
Columns like "Late 0:15" or "Break 1:00" look like times. Include the header row when you copy, so those columns are ignored by name, or delete them before copying.
Several people in one export
Filter the sheet to your own name or ID first, then copy only your rows.
An Excel file (.xlsx), a PDF or a web page
Excel or Google Sheets: open it, select the rows, copy, paste. You don't need to save it as CSV.
A table on a web page or HR portal: select the table with your mouse and copy it. Tables copied from web pages usually paste fine.
PDF: try selecting the table text and copying it. If the text comes out jumbled or it's a scanned image, type the times into the template instead.
Starting from scratch
Download the template. It opens in Excel or Google Sheets with three columns: Date, Time in, Time out. Keep it updated as you go, and import it at the end of each cutoff.
Small differences from your schedule
Real clock times are rarely exact. Clocking in at 8:51 PM for a 9 PM shift isn't overtime, and most payrolls don't pay it. So by default, times within 30 minutes of your scheduled start or end count as on time.
Example: 9 PM to 5 AM schedule, 30-minute margin
Log
Kompyut sees
8:51 PM to 5:00 AM
As scheduled
8:46 PM to 6:38 AM
1h 38m overtime (the 14 early minutes are ignored)
9:20 PM to 5:05 AM
As scheduled
9:45 PM to 5:00 AM
45m late
7:30 PM to 5:00 AM
1h 30m overtime (came in early)
Change the margin on the review screen, from exact minutes only up to 60 minutes. The amounts update right away, so you can pick the one that matches how your company pays.
Tip. If your payslip never pays early log-ins, a 60-minute margin usually matches it better. If your company pays every minute, choose exact minutes only.
Rest days and holidays you worked don't have a schedule to compare with, so their times are always used exactly.
Days not in your log, and days you already logged
Days not in your log
If a scheduled work day between the first and last date of your log has no times, Kompyut doesn't guess. It lists it under Not in your log, and you choose what happened:
Worked as scheduled (for example, you forgot to clock in but worked)
Absent
Any of your leave types
Rows with a date but no times, like "09/05/2026 ABSENT" or "LEAVE", are listed there too.
Days you already logged
If you had already logged a day, the review shows what the import would replace, for example "Replaces what you logged: leave". Untick the day to keep what you had. Notes and labels you added are kept either way.
Lines that couldn't be read
Rows Kompyut couldn't use are listed at the bottom of the review, with the line number and the reason.
Reason
What to do
No date found
The row has times but no date Kompyut recognizes. Check the date formats, or add the date.
Needs both a time in and a time out
The row has an odd number of times, like 3. Check for a missing time or an extra time column.
Time in without a time out after it
A clock-in with no clock-out (a missed punch). Add the time out in your sheet, or log that day by hand.
Time out without a time in before it
A clock-out whose clock-in isn't in what you pasted. Often the first row of a night shift that started before your first date. Include one more day at the start.
Other things to check on the review screen
Wrong dates (September 1 shown as January 9): your system writes the day first. See month first or day first.
Overtime you weren't paid for, from coming in early: raise the margin.
Every day shows as late or early: your schedule in Settings may not match your real shift. Fix it in Settings › Work schedule, then import again.
Still stuck? Email a few rows of your timesheet (with names and ID numbers removed) to help@kompyut.com, and we'll look at adding your format.
