A useful billable-hours spreadsheet records the work once, identifies which hours are eligible for charging and shows whether they have already been invoiced. Those are separate facts, and they deserve separate columns.
For a freelancer with a few clients, that can be enough to manage a straightforward hourly workflow. The sheet becomes unreliable when one “billable” checkbox is expected to mean approved, invoice-ready, invoiced and paid at the same time.
Start with one row per work entry
Use columns for entry ID, date, client, project, description, decimal hours, billable status, approval status, hourly rate, potential amount and invoice reference. Add currency when you work in more than one.
Keep the rate applicable to the work visible in the record. A formula that always looks up today’s rate can silently change historical calculations after a rate increase. Preserve a rate history or a stable approved rate for each entry.
This illustrative layout assumes hourly work, one currency and no taxes or expenses:
| Entry | Hours | Billable? | Approved? | Rate | Potential amount | Invoice |
|---|---|---|---|---|---|---|
| E-01 | 2.00 | Yes | Yes | $110 | $220.00 | INV-101 |
| E-02 | 1.50 | Yes | Yes | $110 | $165.00 | — |
| E-03 | 0.75 | No | Yes | $110 | $0.00 | — |
| E-04 | 1.25 | Yes | No | $110 | $137.50 | — |
The sheet contains 5.5 hours of work and $522.50 in potential billable value. Only $165 is approved and uninvoiced under these assumptions. The $220 entry is already invoiced, and the $137.50 entry still needs approval.
Keep the arithmetic visible
For a simple row, potential amount equals decimal hours multiplied by rate when the work is billable; otherwise it is zero. Invoice readiness requires additional checks: approval complete, billing conditions satisfied and no previous invoice reference.
Use explicit status values rather than relying on cell colors. “Pending,” “approved” and “disputed” can be filtered and reviewed. A yellow cell needs someone to remember what yellow means.
If the agreement includes a cap, minimum charge or other adjustment, represent it separately and explain it. A basic hours-times-rate calculation does not capture every commercial rule.
Reconcile before creating the invoice
Filter to the client and exact billing period. Review descriptions, eligibility and rates. Sum the selected rows, then compare that amount with the draft invoice.
After issuing the invoice, assign its reference to the included entries. Preserve a record of the selection so another person can reproduce it later. If an invoice is revised or credited, document the relationship rather than simply clearing old references and hoping the next run is correct.
Keep payment tracking on the invoice record. A partial payment does not mean that a particular time entry is half worked or automatically available for billing again.
Protect the source of truth
Choose one authoritative file and an owner for its structure. Separate editable input columns from calculated columns, and make changes traceable through your normal version-history or backup process.
Avoid sending the editable master workbook to each client. A client-specific export is easier to review and less likely to expose other accounts or internal information.
Once a week, check for duplicate IDs, missing projects, unusual durations and eligible entries without a next billing action. Those checks can catch operational mistakes that perfectly valid formulas will not detect.
Know when the spreadsheet is becoming the work
Consider a dedicated system when several people edit the record, rates vary by project or person, approvals are difficult to trace, or maintaining invoice status takes too much effort. The question is whether the workflow remains reliable and manageable, not whether spreadsheets are inherently unsuitable.
Time Trakkr connects time records with approvals and invoicing. Compare that workflow with the tasks your sheet currently performs through the feature overview. For duration-format issues, start with the decimal-hours guide.
Common questions
Can the same sheet handle fixed-fee work?
It can record effort, but an hourly amount formula should not determine a fixed-fee invoice. Keep the agreed fee and billing schedule separate.
Should non-billable work be deleted?
No. It still consumes time and affects capacity and project economics. Classify it accurately instead.
