What is wtd in retail?
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
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 or YoY, 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.
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
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.
Read Also: P&L Management
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.
For the same report of YTD April for two different businesses, following two different reporting years.
Business A follows normal calendar year
Business B follows a fiscal year that starts on 1st of July
If you want some single values, why did you use functions "*TD"? Usually, the "*TD" functions need a date context. For example, MTD accumulates the values of a month and starts again from the next month.
2018-01-01 100
2018-01-02 200
... ...
2018-01-31 1200
2018-02-01 100
2018-02-02 200
Maybe you just need something like this:
BTW, Is WTD the week to day?
WTD = Week to Date (Sales) - Cumulative sales totals for the current week. MTD = Month to Date (Sales) - Cumulative sales totals for the current month.
