When creating a report in Silverfin, you can always 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
- 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: 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).