How to Invoice from FreshBooks, Wave or QuickBooks Without a Spreadsheet.

If you've been freelancing for more than a few months, you know the pipeline. It's Friday afternoon. You have a week of tracked time in some app. You have an invoicing tool — FreshBooks, Wave, QuickBooks, Xero, Bonsai, HoneyBook, take your pick. And between the two of them sits a spreadsheet you maintain by hand because your tracker doesn't talk to your invoice tool.

It usually goes like this:

1. Open the tracker. Filter to "this week."
2. Copy each session into a spreadsheet.
3. Group by project. Sum the hours. Multiply by your rate.
4. Re-check the math because you don't quite trust it.
5. Open FreshBooks (or Wave, or QuickBooks). Click "New invoice."
6. Type each line item by hand. Watch the totals.
7. Send. Realize you forgot a session. Edit and re-send. Apologize.

An hour, gone. And the work was already done — you were just translating it from one shape to another.

The shorter pipeline

There's a faster version that works for any invoice tool that accepts pasted line items — which is to say, all of them. The trick is to stop maintaining the intermediate spreadsheet and start treating your tracker's clipboard output as the invoice line itself:

1. Open the tracker. Tick the sessions you want to bill.
2. Click "Generate." Copy.
3. Open the invoice in FreshBooks / Wave / QuickBooks. Paste into the line-item description field.
4. Send.

Roughly ninety seconds. The trick is that the tracker has to emit text that's already shaped like an invoice — not a CSV, not a JSON blob, not a PDF report. Plain-text lines like:

Acme — homepage redesign            1.5h × $95.00 = $142.50
Northwind — brand refresh           2.5h × $95.00 = $237.50
Marlowe Studio — pitch deck         3.0h × $95.00 = $285.00
─────────────────────────────────────────────────────────
TOTAL                               7.0h          = $665.00

That's what ClockSplit's clipboard output looks like by default. It's deliberately the format that drops cleanly into any invoice tool — including a plain Google Doc, if you're sending invoices that way.

Step-by-step: FreshBooks

FreshBooks is the best-supported case because it has the most flexible line-item editor of the three. To paste in pre-formatted lines:

1. Open FreshBooks → Invoices → New Invoice.
2. Pick the client. Set the invoice date.
3. Click into the first line-item row's Description field.
4. Paste your tracker's clipboard output. FreshBooks will paste multi-line text into a single description cell — which is what you want; it preserves the alignment.
5. In the Quantity field, put the total hours from the bottom line of your clipboard output. In the Rate field, put your hourly rate. FreshBooks calculates the subtotal automatically.
6. If you'd rather have one line per project, repeat steps 3–5 for each session block instead. This is a taste call — some clients prefer the one-line summary, others want to see every session.
7. Add tax / VAT if applicable. Send.

Pro tip: for Pro and Lifetime ClockSplit users, you can skip FreshBooks entirely for smaller engagements — the one-click branded PDF output is good enough to send as the invoice itself. FreshBooks still wins for accounts you need formal tracking on (recurring clients, taxed contracts, payment portal integration).

Step-by-step: Wave

Wave's invoice editor is leaner and treats line items more like spreadsheet rows. The flow:

1. Open Wave → Sales → Invoices → Create an invoice.
2. Pick the client (or create one).
3. In the first line-item row, click the Item field and select (or create) a "Design services" item with your hourly rate set.
4. Paste your tracker's clipboard output into the Description field. Wave preserves whitespace if you wrap the paste in monospace (Cmd+K → Code, on a Mac); otherwise the alignment will collapse, but the numbers still read fine.
5. Set the Quantity to your total hours.
6. If you've configured taxes in Wave, tick the tax checkbox. Save and send.

Wave is the right tool when you want zero monthly fee for the invoicing itself — it makes its money on payments. The downside is that Wave doesn't do time tracking, which is exactly why you need a tracker like ClockSplit feeding it cleanly.

Step-by-step: QuickBooks Online

QuickBooks Online is the most opinionated of the three. It expects you to either track time inside QuickBooks itself or to import time via CSV. Neither is what you want for a single weekly invoice. The faster path:

1. Open QuickBooks → + New → Invoice.
2. Pick the customer.
3. In the line-item table, set the Product/Service to your "Design hours" item. Make sure that item has the right rate set in its settings.
4. In the Description column, paste your tracker's clipboard output. QuickBooks accepts multi-line text in descriptions; the alignment will degrade slightly because QuickBooks doesn't render monospace, but the totals still read fine.
5. Set Quantity to your total hours.
6. If you have multiple projects on one invoice, the cleanest pattern is one line per project (not one line per session). Paste the per-project summary block; let the per-session detail live in your tracker.
7. Save and send.

Reserve the CSV import path for when you're catching up multiple invoices at once — e.g. you just got back from vacation and have three weeks of un-invoiced work. For a normal Friday-afternoon invoice, paste is faster.

Common pitfalls

Three things to watch for, in any of the three tools:

Misaligned monospace. If your tracker emits a beautifully aligned block with hours and amounts in columns, that alignment depends on the receiving tool rendering the text in a monospace font. FreshBooks and Wave can preserve it; QuickBooks usually can't. If alignment matters to your client, attach a PDF instead of pasting raw text. (ClockSplit Pro generates this PDF in one click.)

Currency mismatch. If you bill in EUR but your tracker shows USD, the line items will look right and the totals will be wrong. Set your tracker's currency to match the invoice tool before generating output. ClockSplit supports 17 currencies.

Tax handling. Tracker line items shouldn't include tax — let the invoice tool add it. Otherwise you'll double-tax and have to apologize to the client.

The bigger picture

The reason this pipeline keeps eating an hour of your Friday isn't that your invoice tool is bad. It's that your tracker is generating data in a shape that doesn't match what the invoice tool wants. Fix that, and the spreadsheet you've been maintaining in the middle quietly stops being necessary. That hour goes back on your calendar — and at $95/h, that's $4,940 a year of unbilled time you've been spending on translation.