Summary: Year-To-Date (YTD) is a payroll term covering the total amount of an employee's earnings starting from the beginning of the calendar year going until the current date.
The acronym YTD stands for year-to-date. That’s the easy part. Figuring out how to use this measure for financial calculations, however, is another story. YTD is used on financial statements, employee payslips, and even for tax documents, so it’s important to understand precisely what this means in different contexts and how to calculate it. That’s why we’re going to explain this concept carefully here with lots of examples of how to use YTD.
Definition of YTD
While we’ve said that YTD means year-to-date, this isn’t quite enough to really get this idea across. The “to-date” part of it is easy. This means up until today or the date you put on a document. However, a year can start in two different ways, and this normally has to be clarified for YTD to be meaningful.
Calendar Year: In most of the world, the calendar year starts on January 1st, New Year’s Day in the Gregorian calendar. However, some cultures use traditional calendars based on solar or lunar cycles (ex., Chinese calendar, Islamic calendar, etc.) which start on different dates. When in doubt, January 1st is a safe bet as it’s used by a large majority of people in the world for business, education, and other schedules.
Fiscal Year: A fiscal year is a 12-month period defined by the opening and closing of financial records. Governments, schools, and companies can choose their own fiscal years which are usually based on their busiest periods. The US government’s fiscal year, for example, starts on October 1st.
YTD can therefore mean either:
“from January 1st until today” or “from the beginning of the fiscal year for this institution until today”. If it’s not stated, you can generally assume that the calendar year is being referred to.
What is YTD Used for?
There are a lot of different reasons to use YTD figures, and while they’re usually related to finance, they can be used to measure any value that changes over time. You can use YTD to talk about consumption of materials, spending, numbers of sales, contracts, new employees, or anything else that can be measured and compared annually. Here are some of the most common applications of YTD figures found in the business world:
Employee finances: One of the most common places to find the term YTD is on an employee’s paystub, the paper or digital information document that accompanies each of their paychecks. Each paystub normally gives a breakdown of their gross pay (earnings) and deductions for the pay period, whether it’s monthly, semi-weekly, bi-weekly, or weekly. It also shows their net pay for the period, which is what the employee actually gets on their paycheck.
However, it’s also useful to know how much the employee has been paid so far for the year (YTD net pay) and how much they’ve had withheld for taxes. For employers, these numbers help with budgeting and also tracking tax remittance obligations. They can also help employees set their personal budgets and calculate their tax payments to see if they’ll owe more or be entitled to refunds at the end of the year.
Investment projections: Fund managers and other investment professionals can sell their management skills or investment products more easily when they can show great performance. For a new type of investment or to illustrate a change in the market, they may not be able to point to last year’s performance, however. Instead, they can show how an investment has been doing year-to-date and use this figure to project how well the investment is expected to perform by the end of the year.
Managing budgets: If a project manager has an annual budget of $500,000 to manage and has already used $400,000 in the first two months of their fiscal year, they may be in trouble. YTD spending figures can be very useful in helping organizations control their costs and make projections on their financial positions in the future.
Anyone with a budget can make good use of YTD figures, however. HR professionals can determine labor costs YTD, and if they fall well below their budgets, they can recommend hiring more workers. Individuals can assess their spending on utilities YTD to figure out if they’ll need to put more savings away to cover their future costs.
Team performance: Successful talent management requires an ability to get the most out of a team of employees. To judge quality, however, you need to be able to qualify performance, and YTD figures can be useful for such calculations. A manager might want to look at how much their team has sold YTD to make projections and to help set end-of-year goals.
YTD commissions can indicate how well a sales team has been performing and help project total spending for the year. HR professionals may also look at their number of hires YTD to evaluate their own performance in recruiting valuable team members.
How to Calculate YTD
There are different ways to figure out year-to-date figures depending on how accurate you want your projections to be. It’s also important to realize that figures close to the start of the year are calculated with fewer data points than those later in the year (eg, four weeks of data in the first month vs 52 by the year’s end).
Here are two different ways to calculate year-to-date figures along with examples. For simplicity’s sake, we’ll base these on the calendar year starting January 1st.
Basic YTD Calculation
If you’re part-way through the year and want to determine a YTD figure to the previous year’s total, you can use a simple calculation to compare them. The basic calculation involves dividing the YTD by the previous year’s total and multiplying by 100. This will give you the percentage of the previous year’s figure that the YTD figure represents.
For example, think of a sales team that posted $875,000 in sales the previous year. At the end of June this year, they had already made $505,000 in sales YTD. The percentage of last year’s sales represented by their YTD sales would be calculated as follows:
% of previous year’s total = (YTD total / previous year’s total) x 100
% of previous year’s total = ($505,000 / $875,000) x 100
% of previous year’s total = 57.71%
The team’s sales figures halfway through the year are 57.71% of those of the previous year. If they continue selling at the same rate, they may be able to expect another 57.71% increase from July to December, which would bring their total sales for the year to $1,010,000. That’s good news!
Annualized YTD Calculation
If you have data for part of a year, you can use annualization to help project this data for the entire year. This is commonly used when determining rates of return on investment. To calculate an annualized rate of return, you need to add 1 to your YTD rate.
You then raise this by the power of the number of periods in one year that your YTD timespan represents. Next, you subtract one from this number and multiply by 100 to give your rate of return in terms of percentage. This is best illustrated in a concrete example.
Investor X invested in a compounding investment last year and received an 8.8% (0.088) rate of return. They invested in the same investment this year and by the end of September (9 months YTD), their rate of return was 10.25% (0.1025). This is how to calculate their annualized rate of return:
Annualized rate of return = [(1 + rate of return per period) # of periods in the year -1] x 100
= [(1 + 0.1025) 12/9 -1] x 100
= [(1 + 0.1025) 1.33 -1] x 100
= [0.1386 x 100]
= 13.86%
If the investment continues to grow in the same way, Investor X can expect to gain 13.86% on this investment this year, which is far better than the 8.8% received last year.
YTD Summarized
YTD or year-to-date figures are very useful for measuring how values have changed from the start of the year until today. They’re used in everything from investment to business planning and personal finance management. With some simple calculations, YTD figures can tell you a lot about where you are now and what to expect by the end of the year.
FAQ
No, these two terms mean different things. If you receive a monthly paycheck in July, for example, your YTD net pay may show up on your paystub. This would be the total of all the pay you received from January through to July. Your annual income is all the money you take in throughout a whole year.
Year-to-date will give you a total that adds up the figures from the start of the year until today. YOY stands for year-on-year and compares a figure from today to the figure for the same thing one year ago. For example, if your net worth today is $2.1 million and it was $1.9 million on the same date last year, you’re worth roughly 10% more year-on-year than you were last year.