Skip to main content
Financial Planning Tools

Timesheet Calculator

Calculate daily and weekly billable hours, deduct lunch breaks, and handle overnight shifts past midnight automatically.

Day Start Time End Time Break (Mins) Daily Net Hours
Monday 8.0 hrs
Tuesday 8.0 hrs
Wednesday 8.0 hrs
Thursday 8.0 hrs
Friday 8.0 hrs

Total Weekly Hours

40.00 hrs

Calculation Formula & Logic

Daily Net Hours = (End Time - Start Time) - Unpaid Break Duration

Correctly calculates shifts that cross midnight (e.g. 22:00 to 06:00 is 8 hours).

Worked Step-by-Step Example

  1. Step1: Start: 09:00 | End: 17:30 | Break: 45 minutes.
  2. Step2: Gross duration: 8h 30m. Deduct break: 7h 45m (7.75 decimal hours).
  3. Result: Weekly Total (5 days): 38.75 billable hours.

100% Client-Side Privacy Guarantee: Your financial calculations, invoices, and figures are processed purely in your local browser sandbox. No sensitive financial data is ever transmitted, logged, or stored on remote web servers.

Belastingdienst 2024-2025 Aligned 100% Client-Side Privacy Guaranteed

Mathematical Formula & Calculation Logic

Daily Net Hours = (End Time - Start Time) - Unpaid Break Duration
Practical Worked Example:

Array

Complete Guide & Practical Application

Managing financial administration and invoicing as a freelancer, sole proprietor (eenmanszaak), or small business owner in Europe requires precision. The Timesheet Calculator is designed to eliminate guesswork and administrative red tape ("rompslomp") by providing deterministic calculations backed by Dutch Tax Administration (Belastingdienst) and EU standards.

Key Legal & Tax Guidelines to Remember

  • Belastingdienst Precision: Always use commercial half-up rounding to two decimal places on every line item and VAT subtotal to ensure reconciliation with tax audits.
  • Audit Trail Consistency: Invoices and calculation summaries should never be deleted once issued. If changes occur, issue a corresponding Credit Note cross-referencing the original invoice identifier.
  • Statutory Retention Period (Bewaartermijn): Under Dutch tax law (Article 52 AWR), all business invoices, timesheets, and expense logs must be retained for at least 7 years (10 years for immovable property).

Common Mistakes & Pitfalls to Avoid

  • Subtracting 21% from a gross price: Never calculate reverse VAT by multiplying gross amounts by 0.21. You must divide by 1.21 to find the true net base.
  • Confusing Profit Margin with Markup: Margin is profit relative to selling price; markup is profit relative to cost. Misinterpreting these leads to pricing deficits.
  • Missing Mandatory Factuureisen: Ensure your KvK number, BTW-id, and client address are clearly visible before dispatching an invoice.

Applicable Dutch Accounting Terms Explained

Dutch Term English Equivalent Practical Definition
Omzetbelasting (BTW) Value Added Tax (VAT) Consumption tax levied on sales of goods and services (standard 21%, reduced 9%).
Voorbelasting Input VAT The VAT paid on business expenses that you can deduct on your quarterly return.
Factuureisen Invoice Requirements Statutory mandatory data elements required on commercial tax invoices.
Zelfstandigenaftrek Self-employed deduction Income tax deduction for entrepreneurs meeting the 1,225 annual hour criterion.
KOR (Kleineondernemersregeling) Small business scheme VAT exemption for entrepreneurs with annual turnover below €20,000.

Frequently Asked Questions

Divide the minutes by 60. For example, 15 minutes is 0.25h, 30 minutes is 0.50h, and 45 minutes is 0.75h.