Retail Dogma

Year to Date (YTD)

Year to date (YTD) is a term used in reporting, to express the period between the beginning of the year, up to the date of reporting.

Example

If the business follows a normal calendar year that starts on the 1st of January and wants to report financial results up to the end of April, the term Year to Date (YTD) for this report would mean the results from 1st of January till 30th of April

Year to Date in Retail Reporting

Year to date (YTD) is used, together with other terms, such at WTD, MTD and quarter to date (QTD) in retail reporting for various KPIs related to sales and finances.

Some reports that use the YTD term

Year to Date (YTD) Sales

The business can generate a daily snapshot of the sales report that shows the performance of the business for the current week (WTD), the current month (MTD) and the current year (YTD), and compares it to the same periods from last year to see the growth in comp sales, as well as the achievement against budget.

This way of reporting year to date sales at any given time, and comparing it to the budgeted sales, helps in tracking performance throughout the year; rather than waiting till the next financial reporting period.

Year to Date (YTD) Profit & Loss Statement

year to date profit and loss statement

The year to date profit and loss statement will report all the different P&L lines from the beginning of the year up to the date of reporting.

Example from a YTD April P&L for a business following normal calendar year

Sales: Total sales from 1st of Jan to 30th of April

Gross Profit: Total gross profit from 1st of Jan to 30th of April

Staff Cost: All staff cost paid from 1st of Jan until 30th of April

and so on…

These results are usually reported against results for the same period last year (LY) and the budgeted numbers for the same period.

This will help measuring performance and achievement against budget, and addressing any issues within the year.

A D V E R T I S E M E N T

Read Also: P&L Management

Fiscal vs. Calendar Year

It is important to understand that YTD doesn’t always mean from 1st of Jan up until the current date.

If the business follows a normal calendar year, then it is from the 1st of Jan. However; some businesses follow a fiscal year, that can start, say, 1st of July.

Example

For the same report of YTD April for two different businesses, following two different reporting years.

Business A follows normal calendar year

The report will be for the period from 1st of Jan to 30th of April; i.e 4 months

Business B follows a fiscal year that starts on 1st of July

The report will be for the period from 1st of July to 30th of April; i.e 10 months

Other Reporting Terms

  • WTD: From the 1st day of the week, up to the reporting day
  • MTD: From the 1st day of the month, up to the reporting day.
  • QTD: From the 1st day of the quarter, up to the reporting day.

Read More On