Kolumn

09 / 20 · Time and projects

Freelancer timesheet and billing

Hours per client and project, ready to invoice.

SEK 99

Incl. 25% Swedish VAT. Buyers outside the EU and EU businesses with a valid VAT number pay 20% less.

Also part of the bundle with all 20 templates for SEK 499. All 20 templates

Middle Earth Consulting AB contributes 1% of your purchase to removing carbon dioxide from the atmosphere.

What it does

Log your hours per client and project. The template calculates hours from start and end time, picks the right hourly rate per client and shows what is unbilled per client and month – your billing summary.

What you get

Sheets
Time, Summary, Clients
Each file also has an instructions sheet and a lists sheet.
Formulas
1354
Files
2 × .xlsx: English and Swedish
Works in
Excel (Windows, Mac, web), Google Sheets, LibreOffice
Macros
None
Licence
One licence per business or household, unlimited internal users

Screenshots

English version with example data
English version with example data
Swedish version with example data
Swedish version with example data

How to use it

  1. Add your clients and hourly rates on the Clients sheet.
  2. Log every work session on the Time sheet: date, client, project, start, end and break in minutes.
  3. Set Billable to No for internal hours.
  4. Choose the month on the Summary sheet. Once invoiced, set Invoiced to Yes on those rows.