User RolesAdminStaff contributorExternal ContributorPulse user

When creating a report in Silverfin, you have the option to use PTD (Period to Date), YTD (Year to Date), and RYTD (Relative Year to Date). This article explains the differences between these terms and how to use them effectively in your reports.


TABLE OF CONTENTS

YTD (Year to Date)

YTD represents the cumulative, absolute figures for a given period. For example, if 50 is booked in Q1, 100 in Q2, and 30 in Q3, the YTD for Q3 is 180.

PTD (Period to Date)

PTD indicates the movements within a specific period. It is calculated by subtracting the total figures of the previous period from the total figures of the current period. 

  • A previous period must exist for PTD calculation.
  • The first period of a financial year excludes the opening balance.
  • The sum of PTDs will never equal the YTD but will match the RYTD.
  • For instance, if the YTD for Q3 is 180 and for Q2 is 150, the PTD for Q3 is 30 (180 - 150).

RYTD (Relative Year to Date)

RYTD measures the movements up to a specific period without including the opening balance. It is calculated by subtracting the YTD figures of the previous financial year from the YTD figures of the current period.

  • The YTD figures from the previous year are needed for this calculation.
  • The RYTD is the sum of all PTDs.
  • Clicking on the RYTD figure in a report reveals the entire history, equivalent to the YTD.

By understanding these terms and their calculations, you can accurately analyze and interpret financial data in Silverfin reports.