Ratecard InvoicesGuide

How to turn Jira worklogs into client invoices with the right rates

Updated 2026-10-10 · by Hieu Tran, written with AI agents and checked against the sources below

Jira records hours, not money. Turning worklogs into an invoice means mapping projects to clients, applying the rate that was in effect on each day for each person, dropping non-billable work, and getting it into your accounting tool without retyping.

1. Get the worklogs out

• Tempo users: export the logged-time report as CSV (issue key, worker, date, hours).
• Jira only: a CSV export with all fields includes Log Work columns, each holding comment, date, author and seconds separated by semicolons.
• Filter to the month you're billing.

2. Rates that change over time

Keep a small rate table: person, client, rate, effective-from date. For each worklog, use the most specific rule (person + client, then person, then client, then a default) whose start date is on or before the work date. That way a rate change in March doesn't reprice February.

3. Clients and non-billable work

Map each Jira project key to a client. Projects without a client (internal, meetings) are non-billable and stay off the invoice, but keep them in the report so the hours add up.

4. Into accounting

• Group lines per client by person and rate, or by issue, depending on what your clients expect.
• Xero imports sales invoices from a CSV in its template layout, as drafts you approve.
• QuickBooks Online imports invoices from CSV and lets you map columns during import; keep custom transaction numbers on to keep your invoice numbers.