Count your own hours as cost
Internal hours are the biggest cost in most service projects. Book them as team_cost at their cost rate, or the budget looks healthier than it is.
Planned budget per category next to what you actually spent and invoiced. See early when a project eats into its margin, not when the last invoice goes out.
Free, no signup. Opens in Excel, Google Sheets and Numbers.
Example data. Delete it before you add your own.
| Date | Project | Type | Category | Description | Amount | Currency |
|---|---|---|---|---|---|---|
| 2026-09-04 | Website relaunch | Income | milestone_payment | Invoice 1 of 4: kickoff | 21,000 | EUR |
| 2026-09-30 | Website relaunch | Expense | team_cost | Team hours September | 14,400 | EUR |
| 2026-10-02 | Website relaunch | Expense | software | Design tool and CMS licences | 1,250 | EUR |
| 2026-10-26 | Website relaunch | Income | milestone_payment | Invoice 2 of 4: design sign off | 21,000 | EUR |
| 2026-10-31 | Website relaunch | Expense | team_cost | Team hours October | 16,800 | EUR |
| 2026-10-31 | Website relaunch | Expense | team_cost | Contract developer October | 7,200 | EUR |
| 2026-11-06 | Website relaunch | Expense | travel | Workshop at client office | 380 | EUR |
| 2026-11-13 | Website relaunch | Expense | other | Stock photography | 640 | EUR |
On the Budget tab, fill in the planned amount per category. The contract value goes at the top.
Log every invoice and cost on the Transactions tab, with the date, the category and the amount.
The Budget tab adds up actual spend per category and shows what is left.
Compare spend with progress. Half the budget gone at a third of the work is the moment to act.
Internal hours are the biggest cost in most service projects. Book them as team_cost at their cost rate, or the budget looks healthier than it is.
60% of the budget used is fine at 70% done and a problem at 40%. Look at both numbers together, every month.
Put 5 to 10% under other as contingency. When you spend it, write down why, so the next estimate is better.
A budget sheet adds up what you type, a month after it happened. Hours, rates and invoices come from three places and someone copies them in. In Vaizy logged hours turn into cost at each person's rate, invoices sit next to milestones, and you see cash flow for one project or the whole portfolio.
See project finances in VaizyStart a free trial and open the import dialog from the dashboard.
Drop in the file. Vaizy recognises the columns and maps them for you.
Check the preview and import. Nothing is saved until you confirm.
The contract value, a planned amount per cost category, every actual cost and invoice, and what is left per category. This template has all four.
Those are the finance categories Vaizy uses. Keeping them the same means the Transactions tab imports without changes. The Budget tab explains each one in plain words.
Yes, the Transactions tab imports as income and expenses on the project you name. The Budget tab stays in the spreadsheet, because Vaizy calculates those totals itself.
Import this template into Vaizy and see it next to your milestones, team and budget. Free for 14 days, no credit card needed.