Help centre Time and billing

Timesheet exports for client billing

Export itemised or summary timesheets to Excel or CSV, with hourly rates and amounts, ready for client invoices.

Included in Team and Business. Anyone can export their own time. Admins and chosen people can export the whole team's.

Open the export

  • Your own time: Timesheet → My week → Export.
  • Everyone's time: Timesheet → Team → Export for billing.

Choose what to include

  • From and To: any date range, for example a calendar month or a client's billing period.
  • Person (team export): everyone or one person.
  • Board / client: all boards or one client.
  • Billable time only: leave on for invoices; turn off for internal reports and payroll.

The window shows how many entries and hours match before you download.

Choose the report

ReportWhat it containsBest for
ItemisedOne row per entry: date, person, board, task, what was worked on, time as hours:minutes, decimal hours and billable. Grouped by board with a subtotal for each, and a grand total.Sending to the client with the invoice, or checking every entry
SummaryTotals per board with rate and amount, totals per person, and totals per task.Working out the invoice and reviewing workload
BothExcel: Summary, By task and Itemised sheets in one file. CSV: the totals first, then every entry.Keeping a complete record for the month

TaskTram remembers your choice for next time.

Add hourly rates (optional)

Under Hourly rates, choose the currency and enter a rate for each board. The export then shows the amount per entry, per board and in total, using billable hours only. Rates are remembered on your device and are never saved in TaskTram, so they stay private to you.

Excel or CSV

  • Excel (.xlsx): formatted sheets with headings and totals. Time is a real Excel duration, so you can add up the hours:minutes column with a normal SUM.
  • CSV: plain text that opens in Excel, Google Sheets or accounting software. Times are written as h:mm and decimal hours.

Example: itemised

DatePersonBoardTaskWhat was worked onTimeHours
2026-11-03PriyaNorthwindLanding pageHero copy, two drafts2:302.50
2026-11-04ArjunNorthwindAds setupSearch campaign build1:451.75
Northwind total4:154.25

A monthly invoicing routine

  1. On the last working day, remind the team to finish logging time.
  2. Open Timesheet → Team → Export for billing and set the month.
  3. Choose Both and Excel. Check the Summary sheet for anything unusual.
  4. For each client, export again with that board selected and Itemised, and attach it to the invoice.

Questions

Why is an entry missing?

Check the date range, the person and board filters, and Billable time only. A timer that is still running is left out until it is stopped.

Why does a task show "No task"?

The time was logged on the Timesheet page without a task. The board and the note still appear.

Can I change the decimal places or rounding?

Times are exact to the minute. Decimal hours are rounded to two places. Round further in Excel if your contract requires it.

Still stuck? Email us and a person will reply within one working day.

← Timesheets  ·  Check-ins →

Last updated 2026-11-13