Consultants · problem and fix
Fixed fee project going over budget: how consultants track hours on Mac in 2026
A fixed fee project goes over budget when hours slip past the plan, and nobody sees it until the invoice is late. To track hours against a fixed fee budget, split the fee into hours per task, log time the same day, and compare hours used with hours budgeted every week. This page shows how to do that on a Mac, with tools you may already have.
The short answer
- Split the fixed fee into hours per task, so each task has a limit you can check.
- Log time the same day, with a timer. Memory is not a timesheet.
- Compare hours used with hours budgeted every week, and act on the trend, not only the total.
- Write down every out-of-scope request and its hours before you start the work.
What tracking hours against fixed fee budgets costs you
Margin you priced but never earned
A fixed fee is a promise about the price, not the hours. When the work takes longer, the extra hours come out of your margin. The fee does not change, so each extra hour lowers what the project really paid per hour. You may not notice until the project is nearly done.
Hours you cannot invoice later
On a fixed fee, you usually cannot bill the extra time as it happens. If you did not log it, those hours are gone. Unlogged time also hides the problem from you, so your next bid repeats it.
Evenings and weekends
Overruns often come out of your own time. Gallup reports that about one in four U.S. employees feel burnout very often or always. Its survey did not study fixed fee work, so treat that figure as background, not proof of this problem.
A hard conversation late in the project
A budget problem raised in week one is a scoping talk. The same problem raised in the final week feels like a dispute. Late news costs trust, and trust is easy to lose and slow to rebuild.
A worse estimate on the next bid
If you do not record actual hours, your next estimate starts from the same wrong guess. The next fee then carries the same risk, and the same surprise arrives on the next project.
Why it happens
The planning fallacy
People predict their own task times too optimistically. Buehler, Griffin and Ross tested this in 1994, and the bias held even after a strong manipulation, according to The Decision Lab. The same source notes that only about 30% of students finished on their predicted date.
Anchoring on the original proposal
The hours in the proposal become the number everyone remembers. Each later estimate starts from that number, even when new facts arrive. The Decision Lab lists anchoring on an unrealistic original plan as one way the planning fallacy works.
Estimating the whole project, not the tasks
A single total hides the hard parts. Estimating subtasks shows where the time really goes. The Decision Lab recommends estimating subtasks rather than whole projects, because the total alone feels finished and is easy to accept.
Scope creep by email and phone
Requests arrive in small pieces. Each one looks like a favor, so nobody writes it down. Without a written change, nobody adds the hours to the budget. Your team then spends time it never priced into the fee.
Time logged late or not at all
Timesheets written on Friday are partly guesses. Missed entries make the budget look healthier than the work. This is the most fixable cause on the list, and it is the one most teams skip.
Waiting for the bad news to be undeniable
Teams often wait until the budget is gone before they talk about it. People dislike delivering bad news. Without a weekly number, there is nothing concrete to deliver. That makes it a habit problem, not a personality problem.
How to fix it
These work with or without any app.
Estimate task by task, then add up
Write each task from the statement of work, then give it an hours budget. Add the budgets to get the project total. Compare that total with the hours behind your fee. If they do not match, fix the gap before you sign.
Use past projects as a reference class
Pull the actual hours from projects with a similar scope. Use those actuals as the starting point for the new budget. Adjust only with a clear reason, such as a new tool or a larger client team.
Log time the same day with a timer
Start a timer when you begin each task, and stop it when you stop. Harvest's Mac app supports keyboard shortcuts for timers, and it can remove idle time from a running timer. Without a timer, log each block before you leave your desk.
Run a short weekly check
Pick a fixed day and time. Compare hours used with hours budgeted for each task. Flag any task that is ahead of its share of the work. Write one line about what you will do, then do it.
Write change orders before the work starts
Before you begin any out-of-scope request, write the task, the estimated hours, and the client's approval. Keep the note in the Budget tab. If the client will not approve it, your team has a clear answer.
Test a free setup first
Harvest's pricing page lists a Free plan with one seat and says it supports fixed fee budgets. Try it on one small project before you pay for anything. Excel can also handle the budget tab alone, using SUMIFS.
Tell the client early, with a number
Lead with the number, not the apology. Say the hours used, the hours left, and the two options you see. Then ask the client to choose the path, and write down the choice the same day.
Ask a colleague to challenge the budget
Before kickoff, ask a colleague to review the task budgets. Ask them to challenge the lowest numbers first. A second view catches the optimism that shows up in every first estimate.
Why a fixed fee budget is really an hours budget
A fixed fee is a price. Your budget is still hours. The fee tells the client what they pay. The hours tell you what the work will cost you. Most overruns start when a team prices a project in dollars and never turns the fee back into time.
Run a quick check before the kickoff call. Divide the fee by the hours you planned to work. That gives you an effective hourly rate. If the rate looks low, the project is at risk before the first meeting even starts.
Hours matter for another reason. SPI Research reports billable utilization of 68.9% in its 2025 benchmark. It warns that low-margin work may boost utilization but erode financial health. A busy team on a thin fee can still earn less than it planned.
Build a task budget you can check every week
Break the project into the tasks listed in your statement of work. Give each task its own hours budget. Keep the list short enough to read on one screen. A long list feels thorough, but nobody updates it.
Here is a worked example in words. Say the proposal covers discovery, analysis, a workshop, and a final report. Give each one an hours budget. Add all of the budgets together. That total should match the hours behind your fee, not a number you wish you had.
- Task: the name from the statement of work, written the same way every time.
- Budget hours: what you planned for that task, based on past work where you can find it.
- Logged hours: the sum of time entries for that task, pulled from your log.
- Remaining hours: budget minus logged. A negative number means the task is over.
Set up the tracker in Excel on Mac
Open Microsoft Excel and create a Budget tab and a Log tab. On the Log tab, put one row for each time entry. Include the date, the task name, and the hours. On the Budget tab, put one row for each task, with its budget hours beside it.
Next, total the logged hours by task. In the Logged hours column of the Budget tab, use a SUMIFS formula. If the task name sits in A2, and the Log tab stores task names in column B and hours in column C, enter =SUMIFS(Log!C:C,Log!B:B,A2). Copy it down the column.
Then add a Remaining column with =B2-C2, and a Percent used column with =C2/B2 formatted as a percentage. Select the data and choose Insert > Table so the sheet stays readable. Use the right-click menu to open Format Cells if you want a different number style.
Read the Percent used column as your early warning. A row at full means the task is done with its budget. A row above full means the task is over. Do not wait for a row to turn red before you act.
Track hours on a Mac without buying a new tool
Harvest is a good place to start. Its pricing page says fixed fee budgets are supported on the Free, Teams and Enterprise plans. The Free plan has one seat. Its Mac app lets you start and stop timers with keyboard shortcuts, and it can find and remove idle time from a running timer.
Check the price before you commit. Harvest lists Teams at $11 per seat per month, or $9 per seat per month billed annually. Profit tracking by client, project, task or team appears only on Enterprise. Toggl Track places fixed-fee projects and profitability reports on its Premium plan, listed at $16 per user per month billed annually.
Neither tool is part of Lazur. Lazur is not a plugin for any app, and it does not log time for you. Pick the tool that fits your team, then use Lazur to explain its settings or walk you through them.
A short weekly check that catches overruns early
| Check | Question to ask | If the answer is no |
|---|---|---|
| Hours used | Is each task's used share at or below its share of the work done? | Find the tasks running ahead and re-scope them this week. |
| Scope | Did any client request add work this week? | Write a change note and get approval before you start. |
| Logs | Does every logged hour have a task name? | Fix blank or misspelled entries before you read the totals. |
| Forecast | Will the remaining hours cover the rest of the work? | Tell the client now and offer options with dates. |
Run the check on the same day each week. Friday works well, because the week's logs are complete. Pick a time and keep it. A check that moves around each week tends not to happen.
About 30%
Students who finished on their predicted date, in a 1994 planning study
Planning fallacy (The Decision Lab)68.9%
SPI's 2025 billable utilization. Its older research put 70% to 80% as the range that maximized profit.
The Truth About Billable Utilization (SPI Research)1 in 4
U.S. employees who feel burnout very often or always, according to Gallup
Employee Burnout: The Causes and Cures (Gallup)Handle scope creep before it reaches the budget
Scope creep usually arrives in an email or on a call. A client asks for one more slide, one more round of edits, or one more interview. Each request sounds small. Together, they use up the margin you priced.
Use one rule. Before you start any request outside the statement of work, write a short note with the task, the estimated hours, and the client's approval. In Outlook on Mac, press ⌘ N to start a new message, and send the note to the client and your project lead.
Keep the note in the same workbook as the budget. A change order buried in your inbox is hard to add up later. A row on the Budget tab is easy to read on Friday.
Tell the client early, and show the numbers
Clients rarely mind a budget at risk. They mind learning about it at invoice time. Raise the issue when the trend appears, not after the limit is gone. An early conversation leaves you more options.
Build a short deck for the conversation. In PowerPoint on Mac, choose Insert > Chart to draw a bar chart of hours budgeted and hours used for each task. Keep it to one slide. Put the options on the next slide, such as cutting scope, moving the date, or adding budget.
Open with one plain sentence about what you found. Follow it with what you propose. Then let the client choose. A choice feels like partnership. A surprise feels like a dispute.
Edge cases that break a simple tracker
Some work does not belong to one client. Proposal writing, internal reviews, and training often sit outside the fee. Give that work its own internal task code. Then you can see how much unbilled time the project really carries.
Retainers and fixed fees often share a client. Keep a separate Budget tab for each contract. If both live in one sheet, the totals mix, and a strong month can hide a weak project.
Team members who log time differently can break the totals too. A typo like Analisys will not match Analysis, so those hours go missing. Agree on task names before the work starts.
If client data is involved, follow your firm's rules on where notes and time entries live. Lazur's voice and screen features only run while you hold the shortcut, but your employer's rules still come first.
Mistakes people make with fixed fee budgets
- Setting the budget from the proposal alone, without checking it against past work.
- Logging only billable tasks, so the budget looks healthier than the work really is.
- Waiting for month end to compare hours used with hours budgeted.
- Treating a change request as a favor and doing it without a written note.
- Reading one good week as a trend.
Use past projects to price the next fixed fee bid
The Decision Lab says people predict task times from the plan in front of them and ignore how similar projects went. Its fix is reference class forecasting, which bases the estimate on what comparable projects actually took. The same source says awareness alone does not stop the bias.
Pull actual hours from the projects most like the new one. Compare each to its original budget. Use the gap as a starting point for the next bid. Keep the subtasks, because they show where the time really went.
A 2022 paper on IT project cost overruns, published in the Journal of Management Information Systems, found overruns follow a power-law pattern. Those projects are IT builds, not consulting engagements. Treat the paper as a warning about big misses, not as a rule for your next bid.
What to do this week
- Open your current fixed fee project and list every task in the statement of work.
- Write a budget hours number next to each task, using your best past data.
- Start logging today, with a timer or a same-day entry.
- Put a Friday check in your calendar and name it after the project.
- Write the next out-of-scope request as a change note before you start the work.
Where Lazur fits, and where it stops
Lazur helps with the parts you already do. It explains a formula, points at a column, guides you through a settings screen one click at a time, and drafts a change note at your cursor. It does not click for you, and it does not run a timer in the background.
Hold the shortcut and Lazur listens and looks at the screen. Audio and the screenshot go to AI providers to answer, and are not stored. Content is never used to train AI models. Check your firm's rules before you use it on client work.
For the Excel side of this, see the consultant Excel page. For inbox triage, see email overload for consultants. Download the app from the download page, and check plans on the pricing page.
Faster with Lazur
Where Lazur helps with tracking hours against fixed fee budgets
Hold ⌥ ⌘ and say what you want. Lazur sees your Excel window. Lazur draws a circle and a label around the button or menu you need.
- 1
Hold ⌥⌘ and talk
- 2
Lazur draws a circle and a label around the button or menu you need.
- 3
You stay in Excel. Nothing to copy into a chat window.
More things to say in Excel
- “Explain how this SUMIFS formula totals my hours.”
- “Where is the Remaining hours column?”
- “Walk me through setting a fixed fee budget in Harvest.”
- “Hold fn and dictate a change note in Outlook.”
- “Draft a short email telling the client the change adds hours.”
- “Remind me on Friday afternoon to check the budget hours.”
Free for 3 days, then $18/month. Download for Mac
You say“Where is the Remaining hours column?”
Lazur · points at itLazur draws a circle and a label around the Remaining column on your screen.
What consultants say to Lazur for this
Each one is a single hold of ⌥ ⌘.
“Explain how this SUMIFS formula totals my hours.”
Lazur reads the formula on screen and explains each part out loud, so you can change it yourself.
Explains what's on screen
“Where is the Remaining hours column?”
Lazur draws a circle and a label around the column on your screen.
Points at it
“Walk me through setting a fixed fee budget in Harvest.”
Lazur guides you one click at a time and waits for each click. It does not click for you.
Walks you through it
“Hold fn and dictate a change note in Outlook.”
Hold fn, speak, and clean, formatted text appears at the cursor in any app.
Types what you say
“Draft a short email telling the client the change adds hours.”
Lazur drafts the text and types it at your cursor. You read it and send it yourself.
Drafts it
“Remind me on Friday afternoon to check the budget hours.”
Lazur adds a reminder you can see in Apple Reminders.
Handles the small stuff
A plan you can start this week
- Day 1
Split the fee into task hours
Copy the task list from the statement of work into one column. Next to each task, write the hours you think it needs. Compare the total with the hours behind your fee. If they do not match, fix the gap now.
- Day 2
Build the sheet
Open Excel and make a Budget tab and a Log tab. Put one row per task on Budget, and one row per time entry on Log. Add the SUMIFS formula to total logged hours by task, then check one task by hand.
- Day 3
Start logging the same day
Log every block when it ends. Use a timer in Harvest, or a same-day entry in whatever tool you pick. Keep task names identical to the Budget tab, or the totals will miss those hours.
- Day 4
Write the first change note
Look back at this week's requests. Any task outside the statement of work gets a short note with its estimated hours and the client's approval. Add it as a row on the Budget tab.
- Day 5
Run the Friday check
Open the Budget tab and read the Percent used column. Flag any task above its share of the work, and write one line about what you will do next week. Repeat it on your calendar.
Questions people ask
Does Harvest support fixed fee budgets on its free plan?
Harvest's pricing page says fixed fee budgets are supported on the Free, Teams and Enterprise plans. The Free plan has one seat, which suits a solo consultant. Check the pricing page before you commit, because plans can change.
Can I track a fixed fee project with Excel alone?
Yes, for a small project. Keep a Log tab for time entries and a Budget tab for task limits, then use SUMIFS to total the hours. Excel will not start timers for you, so you still need a habit of logging the same day.
How do I see quickly if a fixed fee project is over budget?
Compare hours used with hours budgeted for each task, and read the Percent used column. Any task above its budget is over. Then check whether the remaining tasks still fit inside the rest of the fee.
Does Lazur track my hours automatically?
No. Lazur does not run a background timer or log hours for you. You can ask it to set a timer or a reminder, explain a formula, or draft a note, and it answers out loud.
Does Lazur work on Windows?
Not yet. Lazur is a Mac app for Apple silicon and Intel Macs. Windows is planned, but it is not available today.
Can I use Lazur with client information?
Check your firm's rules first. Lazur listens and looks at the screen only while you hold the shortcut. Audio and the screenshot go to AI providers to answer and are not stored. Content is never used to train AI models.
Sources
- Employee Burnout: The Causes and Cures · Gallup · checked 2026-11-09
- Harvest Pricing · Harvest · checked 2026-11-09
- Harvest for Mac · Harvest · checked 2026-11-09
- Toggl Track Pricing · Toggl · checked 2026-11-09
- The Truth About Billable Utilization · SPI Research · checked 2026-11-09
- Planning fallacy · The Decision Lab · checked 2026-11-09
- The Empirical Reality of IT Project Cost Overruns (Oxford ORA record) · University of Oxford ORA · checked 2026-11-09
Fix tracking hours against fixed fee budgets with Lazur, free for 3 days
Hold a key and ask. Lazur sees your screen, points at the button and talks you through it, in any Mac app. No credit card.