Record time once, against a project and an activity, with separate billing and costing rates. Then every invoice, every unbilled-hours list and every project margin comes from the same entries.
Pick the billing model on purpose
Service businesses usually bill in one of three ways. Time and materials: the customer pays for hours worked at agreed rates, plus expenses. Fixed fee: an agreed price, usually invoiced at milestones. Retainer: a recurring amount for a defined scope or a bank of hours. Many firms use all three, sometimes on the same client.
The billing model should be a decision recorded on the project, not something the finance team reconstructs at month end. In Sundial, a project carries its customer, its expected value and how it will be billed, so the person raising the invoice is not guessing which arrangement applies.
Timesheets are the source of truth
Whatever the billing model, record time. On time-and-materials work it is the invoice. On fixed-fee work it is how you find out whether the fee was right. On a retainer it is the evidence you need when a client asks what they are paying for.
A Sundial timesheet line has an employee, a project, optionally a task, an activity type, hours, and whether those hours are billable. Non-billable hours still matter: internal meetings, rework, pre-sales. They are part of the project's cost even if the customer never sees them.
Make time entry fast or it will not happen. People log time daily when it takes a minute on their phone and weekly when it needs a laptop and a login they forgot. Sundial's workspace runs on the phone with the same screens as the desktop, which removes the most common excuse.
Billing rates and costing rates are different numbers
The rate you charge a customer and the rate an hour costs you are two numbers, and mixing them is the fastest way to lose track of margin. In Sundial, activity costs set both per activity type, and optionally per employee: a senior consultant doing design work bills at one rate and costs another.
Each timesheet line therefore carries a billing amount and a costing amount. The billing amount feeds the invoice. The costing amount feeds project profitability. Neither has to be calculated in a spreadsheet afterwards.
Review the rates when salaries change or a price list is renegotiated. A costing rate that is a year out of date will tell you a project is profitable when it is not.
From timesheet to invoice
For time and materials, create a sales invoice and pull in the project's unbilled timesheets. The invoice lists the hours and amounts, and each timesheet is marked as billed, so the same hours cannot be invoiced twice. Expenses claimed against the project by employees can be recharged on the same invoice.
For fixed-fee work, invoice from the sales order at each milestone, by percentage or amount. Keep logging time anyway; it is the only way to learn whether the next fixed quote should be higher.
For retainers, an auto-repeating invoice handles the recurring amount, while the timesheets show how the hours were used. If the agreement includes a bank of hours with overage billed separately, the unbilled timesheet list tells you exactly what is over.
Before the monthly run, look at unbilled billable hours by project. That list is money you have earned and not yet asked for, and it is usually larger than people expect.
Know the margin while the project is still running
Each Sundial project rolls up its costs (timesheet costing amounts, purchases and expense claims booked to it) and its revenue (billed amounts and invoices). The result is a project margin you can see during the work, not three months after it closes.
Watch fixed-fee projects most closely. When logged cost approaches the fee and the work is not near done, you still have options: renegotiate scope, change the team, or at least stop the same mistake on the next proposal.
We are building Sundial so that a project lead can ask in plain language which projects have unbilled hours older than thirty days, or which fixed-fee projects are over budget, and get the list with the entries behind it. The data model above is what makes that question answerable.





