Why Analytics figures can differ from Budget and Expenses
Analytics follows fixed rules for what it counts. Most differences to the Budget or Expenses page come from one of the points below.
- Only complete entries count
- Entries are split by period
- Other settings that change the figure
- Data is cached for an hour
Only complete entries count
- A budget item or expense needs an activity, a participant and a cost category. Without one of these it is left out.
- Drafts, whether budget items or expenses, are left out.
- You only see what your access rights allow, so another user may see different totals.
Entries are split by period
When you filter by dates or by a reporting period, or look at a Time report, an entry that stretches across the edge of the period is counted only for the part inside it.
- Budget items are planned in project months (month 1 starts at the project start date). An item runs from the start of its first project month to the end of its last one. The part inside the period is counted by days.
- Expenses entered with a period (Start Date and End Date) are split by days too. An expense with a single date counts in full in the period that contains the date.
- An expense belongs to a reporting period by its dates, not by a field on the expense. A reporting period you create later takes in all expenses whose dates fall inside it.
Example: an expense from 1 December to 31 January, 1,000 EUR. Analytics shows about 500 EUR in December (31 of 62 days) and about 500 EUR in January (31 of 62 days). A list of the Expenses page grouped by year may show the whole amount in one year.
Other settings that change the figure
- Include Indirect Costs is on by default and adds indirect costs to the cost figures.
- Currency shows only expenses entered in the chosen currency; budget items are not shown in another currency than the workspace currency.
- Accumulate subtotals adds sub-items to their parent.
- Tag (Budget) and Tag (Expenses) filter Plan and Actual separately.
All of these are described in "Analytics view settings" and "Filter Analytics reports".
Data is cached for an hour
Analytics keeps loaded data in your browser for up to one hour. After you change a budget item or an expense, click Refresh Data at the top of the report.
To find the entries behind a number, use the magnifier button described in "Read the figures in an Analytics table".