Financial control and tracking: spent, remaining, forecast
Updated on · Capalane
In short. Each assignment can carry a daily rate, and each project and PI a budget. Capalane derives the spend, spend to date, remaining work, forecast at completion and variance against budget, by project, by PI, by role and by person. Every change is recorded in an audit log, and everything can be exported to CSV or XLSX.
A project's financial tracking often lives in a second workbook, fed by hand from the first. In Capalane, it is calculated directly from the time logged and the capacities: there is nothing to copy over.
Explicit formulas
spent = days logged × daily rate
remaining = (max(capacity, logged) − logged) × daily rate
forecast = spent + remaining
variance = budget − forecastThe spend to date applies the same formula to completed weeks only. An assignment with no daily rate is valued at zero and flagged. The default currency is the euro.
Reports by project, PI, role and person
Operational tracking groups the figures by PI, by role and by country: capacity, time logged, rate, rate to date and delay. Financial tracking adds the amounts. The per-person view shows each person's workload across all their projects.
An audit log of every change
Who changed which entry, which rate, which daily rate, and when: the log keeps every change and can be exported. A question about a figure is settled by consulting it, without digging through a file's history.
Export at any time
CSV exports open directly in French-locale Excel: semicolon separator, decimal comma, accents preserved. A project can also be exported as an XLSX workbook. Your data is never locked in, including at the end of a trial: the workspace becomes read-only and nothing is deleted.
To go further: track time spent and budget by PI.
Frequently asked questions
How is the forecast at completion calculated?
Forecast at completion = spent + remaining. Spent values the days logged at each assignment's daily rate; remaining values the capacity left. The variance compares the forecast with the budget.
Which export formats are available?
CSV that opens correctly in French-locale Excel (semicolon, decimal comma) for financial tracking, operational tracking and the log, and an XLSX workbook for a project.
What happens if an assignment has no daily rate?
Its days are valued at zero and the assignment is flagged, so the gap does not go unnoticed in the amounts.
Track your projects and resources in one place
Capalane calculates capacity with public holidays and leave, collects time in a grid that types like Excel and produces reports by project, by PI and by person.
Discover Capalane