What do PTD, YTD and RYTD in a report mean?
When creating a report in Silverfin, you can choose between PTD, YTD and RYTD.
This terminology is explained below:
YTD = Year to Date:
Cumulative, absolute figures for a given period.
Example: 50 is booked in Q1, 100 in Q2 and 30 in Q3 => the YTD for Q3 is 180
Note: the YTD columns are always calculated using bookyear, never calendar year, when the report “year” option is set to calendar year. We do plan on updating this in the future.
PTD = Period to Date:
Movements in a given period. These are always calculated as the total figures in this period minus the total figures for the previous period.
A few notes on this figure:
- A previous period must always be present if this figure is to be calculated
- In the very first period of a financial year, this figure excludes the opening balance
- The sum of the PTDs is therefore never equal to the YTD, but it is equal to the RYTD (see below)
Example above: The PTD for Q3 is 30 (calculation: 180 – 150)
RYTD = Relative Year to Date:
RYTD represents the movements up to a given period, without including the opening balance. The calculation for this is the YTD figures for the current period minus the YTD figures for the previous financial year.
- Therefore the YTD figures for the previous year are required for this calculation
- The RYTD is the sum of all the PTD
It is important to note here that if you click on the figure in a report that shows the RYTD, you will see the entire history (i.e. the YTD).