Timesheet / Attendance (Pontaj)

Monthly timesheet with CSV export.

Create a timesheet

Total:
Day Start End Break (min) Worked Notes

TL;DR

This is a practical monthly timesheet / pontaj:

  • fill start/end and break minutes per day
  • see total worked time (hours + minutes)
  • export CSV for invoicing, internal reporting, or audit trails

Who this is for

  • Contractors billing by hours/days.
  • Employees tracking time for internal reporting.
  • Teams that want a lightweight record of “what was worked, when, and why”.

How to use it

  1. Select the month.
  2. Fill start/end times and breaks per day (or just the days you worked).
  3. Add short notes for context (client, project, meeting, incident, travel).
  4. Export CSV and attach it to your invoice/email if needed.

What makes a timesheet actually useful

The value of a timesheet is not only the total hours. It’s the traceability:

  • What period is being billed or reported?
  • Were breaks included/excluded consistently?
  • Can you explain gaps (vacation, holidays, client delays, sick days)?
  • Can a client/manager approve it without “back and forth”?

If you can answer those questions, timesheets reduce payment delays, disputes, and scope creep.

Worked examples

Example 1: day-rate billing

Fill 8 hours for working days, export CSV, and bill days worked.

Example 2: hourly billing

Track exact times, then sum total hours and invoice hours worked.

Example 3: multiple clients

Use notes to label client/project per day, then split invoicing externally (separate invoices, separate CSV exports, or a single export with clear notes).

Example 4: approvals via agency

If you bill through an agency or vendor portal, the same month often needs:

  • a clean total that matches the invoice
  • enough detail in notes to align with internal approvals Export CSV, then paste totals/notes into their portal if required.

Best practices (contractors)

Align on billing rules up front

Before month 1, clarify:

  • do you bill by hours or by days?
  • are breaks billable or excluded?
  • what counts as billable (meetings, on-call, support, travel)?

Keep notes short and consistent

Good notes are searchable and non-ambiguous:

  • “Client A – sprint planning”
  • “Client A – feature X implementation”
  • “Client B – bugfix + deploy support”

Lock the month when invoicing

When you send the invoice, keep the exported CSV that matches it. If someone asks questions later, you want a stable snapshot.

Use timesheets to protect your rate

If you’re “always available”, tracking interventions helps you quantify ad-hoc work and renegotiate scope/rate without guesswork.

Best practices (employees)

  • Track unplanned work (support, incidents, escalations). It often explains why planned work slipped.
  • If your role includes on-call, record interventions and durations.
  • Even when not required, consistent tracking helps performance reviews and workload planning.

Edge cases & gotchas

  • If you cross midnight (night shifts), a simple day row can miscount; split the shift into two rows/days.
  • Time zones: decide one convention (your local time vs client time) and stick to it for the entire month.
  • Rounding: if you round to 5/10/15 minutes, apply the same rule to every day and document it in your agreement.
  • CSV is not a “legal” document; it’s evidence/supporting material.

FAQ

Can I export to Excel?

Yes. Open the CSV in Excel/Google Sheets.

Can I use this for overtime?

Yes as a tracking base. For overtime rules and compensation logic, use Overtime estimate and your employment agreement/policy.

How do I handle vacations and public holidays?

Leave the day empty (or add notes like “vacation” / “holiday”) so totals remain accurate and gaps are explained.

What next?

Use:

Sources

Next steps (IT Jobs List)

For timeAttendance sheets, consistency beats “granularity”: same rounding rule and the same style of context notes.

Quick recommendation

  • Save your assumptions (rates, breaks, thresholds) so you can reproduce the result.
  • If you use the output in an invoice/offer, include a short explanation (what’s included and what’s not).

Practical checklist (IT Jobs List)

  • Decide: rounding per session or per day (and write the rule down).
  • Track breaks separately if they’re not billable.
  • At month end, export and keep an audit trail.
By Ivo Pereira Last updated: 2025-12-27