Year-to-date

Year-to-date, abbreviated YTD, is the period from the start of a reporting year through a stated cutoff date. A year-to-date count adds eligible activity over that span. The label should identify whether the year is a calendar year or a fiscal year and how the cutoff is applied.

Read the dates behind the label

Calendar-year totals usually start January 1. A fiscal reporting year can start in another month. The relevant starting date should appear in the report, particularly when organizations use different financial years.

Washington, DC's Metropolitan Police Department publishes a year-to-date comparison with an explicit “as of” date and explains that the numbers reflect records entered by a stated time. It also describes them as preliminary. This is a local example of why the time cutoff and revision status belong beside a YTD figure. MPD Crime Data at a Glance.

Example

Hypothetical example: A calendar-year dashboard reports 600 eligible incidents from January 1 through April 30. Last year's count for the same dates was 550. The YTD increase is 50 incidents, approximately 9.1%.

The figure does not predict the full year's total. Multiplying four months of activity by three would impose an assumption that the rest of the year will have the same average pace. Seasonal variation or changes in reporting could make that assumption unsuitable.

Common confusion

Year-to-date is not the last twelve months. On April 30, a calendar-year YTD span contains four months; a rolling twelve-month span reaches back into the previous year.

It is also not necessarily complete through the day a page is viewed. An agency may have released data only through an earlier date, and some eligible records may still await reporting or approval. A webpage refresh time does not resolve that difference.

Make the comparison consistent

Use the same beginning and ending dates in each year, with any leap-day treatment explained. Keep the event category, coverage, and date field consistent. A count by occurrence date can differ from a count by report date even when both use the same displayed span.

State whether the cutoff includes the entire final day and which time zone applies when that detail affects inclusion. Preserve the extraction date for downloaded figures. Later records and corrections can change the same YTD period, so a comparison should identify the versions used.

Related terms

• Year-over-year comparison
• Occurrence date
• Data freshness
• Provisional data

Sources

• District of Columbia Metropolitan Police Department: District Crime Data at a Glance — Local YTD presentation with explicit as-of time, preliminary status, and revision cautions; example values are hypothetical.