Year to Date (YTD)

The period from the beginning of the current year to the current date

Year to Date (YTD)

It is used in finance and accounting to track a company's sales or stock value performance, calculate portfolio performance, or show the net earnings on a worker's paycheck stub (the latter is more of an HR function). 

It is a valuable metric for comparing a company's performance relative to previous periods and its peers. In addition, it allows us to compare historical data for financial reporting purposes and identify and analyze trends in the performance. 

The YTD can refer to either the calendar year or the fiscal year. The calendar and fiscal year can be the same, i.e., starting on 1st January and ending on 31st December, or they can differ. However, according to the IRS, the fiscal year, also called the financial year, can end on any last day of the month except for December. 

The fiscal year (FY) is an accounting term that covers 12 months.

Companies can choose when their fiscal year starts; it is usually when the first business activities have started or when the company is ready to go into business. The fiscal year for the U.S federal government runs from 1st October to 30th September. 

The following example of YTD in terms of calendar and fiscal year will make the concept easier to understand.  

Company A started operating on 6th June 2019, while company B went into business on 9th September 2019. So let's assume that both companies have to report their results on 20th January 2020 and that the Year-to-Date is based on the financial year.

  • Company A will report its financial performance from 6th June 2019 to 20th January 2020.
  • Company B will detail its performance from 9th September to 20th January.

The calendar year for both companies will be: 

  • Company A - from 6th June 2019 to 1st January 2020
  • Company B - from 9th September 2019 to 1st January 2020 

How To Calculate YTD for Investment Returns?

The YTD is a period used by analysts, investors, and managers to calculate and compare financial performance. 

The analyzed performance can provide information about the change in a company's sales figures, costs, or investment returns, such as from equity or debt securities. The result is multiplied by 100 to achieve a percentage return. 

The formula for YTD returns is as follows: 

YTD returns = (Value at specified date / Value at the beginning of the period) - 1

where the value at the beginning of the period can refer to the beginning of the calendar or fiscal year, depending on which one is used. 

or

YTD return = (Value at specified date - Value at the beginning of the period) / Value at the beginning of the period

Both calculations lead to the same result. The following example will help understand this better. 

Let's assume that an investor invested $15,000 in corporate bonds on 3rd February. Their portfolio grew to $20,000 on 25th July. Plugging the same in the formula above, the YTD return will be 33%: 

 ($20,000 / $15,000) - 1 = 33%

or 

($20,000 - $15,000) / $15,000 = 33%

The YTD for investment returns, corporate sales, and costs gives an idea of the entity's financial position, whether it's incurring losses or registering profits.

Free Excel Crash Course

Sign Up for our Free Excel Modeling Crash Course

Begin your journey into Excel modeling with our free Excel Modeling Crash Course.

Learn More

Year to Date: How To Use It? 

The metric is easy to use. However, the year basis needs to be the same to obtain accurate results when comparing. For example, if the YTD is based on the financial year of two businesses, the financial year will have to be used as a reference timeframe. Conversely, if the calendar year is used, both entities' starting date will be 1st January. 

It is not impossible to use YTD with the calendar year and fiscal year if a firm wants to collect more insight and data. In this case, the juxtaposition of findings can help inform decisions regarding trading, workforce resources, and supply chain, among others. In addition, the YTD allows us to compare historical data from similar and different periods.

The following example will bring more clarity. For comparison, company A reported revenue of $37,000 in January and $50,000 in February expenses. The YTD revenue is $87,000 ($50,000 + $37,000).

The YTD can be influenced by the company's fiscal year since the business can choose the start date of its financial year. In addition, companies with seasonality cycles will report increased sales in specific periods of the year. The peak sales period is generally favored to be close to year-end as it sends a positive signal that can influence investors' decisions and beat analysts' forecasts and estimates.

Year to Date: How To Use It?

Accounting Foundations Course

Everything You Need To Build Your Accounting Skills

To Help you Thrive in the Most Flexible Job in the World.

Learn More

What Is Year to Date on a Pay Stub?

The pay stub also called a check stub, is an HR document that provides detailed information about a worker's salary. The total pre-tax wages are broken down into different items that include but are not limited to:

  • Taxes
  • National insurance contributions 
  • Holiday pay
  • Sick pay
  • Relevant bonus or overtime payment 
  • Loan payments
  • Pension contributions 

The pay stub also includes the YTD information. For example, an employee who receives their pay stub for July will see the total of their gross wages up to this moment. Gross income represents the monthly revenue before deductions are made. 

YTD Net Pay

The net pay is shown on a check stub once all the deductions are made from the gross salary. The net pay is the amount of money an employee gets after paying taxes, social security, and pension contributions. The net pay of a worker is similar to a company's net income, which appears at the bottom of the income statement (IS).

The YTD net pay is presented as an item on the check stub. For example, a pay stub for October will show all the net earnings from the beginning of the calendar year up to this point. The net pay is what an employee receives after all deductions have been made. 

Both YTD net and gross earnings are essential for an employer. Having the sum of all workers' gross wages and net pays enables the employer to manage costs since payroll is usually the highest cost to a company and can account for up to 70% of business revenue depending on the industry. The ratio total payroll / total revenue helps to determine:

  • Employee productivity
  • Cost management 
  • Affordability of a pay rise or a bonus   
  • Recruitment decisions, specifically whether to hire part-time or full-time equivalent (FTE) workers

An excellent payroll to revenue ratio is considered to be within 15%-30%. However, labor-intensive sectors can have 50% of total revenue payroll expenses.

YTD Net Pay - Bonus

What Is the Difference Between Month to Date and Year to Date?

Month-to-date (MTD) is a financial metric that refers to the period from the beginning of the current month to the current date. Typically, MTD doesn't include the current date as business dealings are incomplete. 

For example, on 21st November, the month to date runs from 1st November to 20th November. Like YTD, the MTD enables a company to calculate its revenue and costs and investors to determine their portfolio returns. 

The difference between these two terms is how far back they go. Month-to-date looks back at what has happened in this current month. At the same time, year-to-date goes back to the beginning of the period, whether 1st January for a calendar year or 6th April for the fiscal year, the latter being the beginning of the financial year in the UK.

Both YTD and MTD are useful for measuring business and investment performance. Year to Date provides an annualized snapshot of performance, which can subsequently be broken into specific monthly data using the MTD function. In addition, the MTD metric can be more insightful than YTD for measuring payroll costs and revenue for industries with distinct seasonality of operations, such as hospitality and tourism.

Month to date enables comparison, just like YTD, and helps managers to plan resources and inventories, mitigate seasonal recruitment risk and ensure efficiencies.

Accounting Foundations Course

Everything You Need To Build Your Accounting Skills

To Help you Thrive in the Most Flexible Job in the World.

Learn More

Free Resources

To continue learning and advancing your career, check out these additional helpful WSO resources: