How to Calculate MTD and YTD Values for General Ledger Data?

When data is loaded, Planful automatically calculates either Month-to-Date (MTD) or Year-to-Date (YTD) values based on the data load rule setting.

When used in the DLR, this is how the calculation happens:

• YTD setting: YTD=MTD current period + YTD prior period
• MTD setting: MTD=YTD current period - YTD prior period
• Account Based: If account type is Flow then YTD=MTD current period + YTD prior period. If account type is Balance then MTD=YTD current period - YTD prior period.
  

Here’s the complete explanation for calculating MTD and YTD values for GL data in Planful, including how to handle Flow and Balance accounts separately:

How the System Calculates MTD and YTD Values for GL Data?

When loading data, Planful automatically calculates either MTD (Month-to-Date) or YTD (Year-to-Date) values based on the data load rule setting and the Account Type (Flow or Balance).

1. For Flow Accounts (Revenue, Expenses):
   Flow accounts track cumulative activity over time (e.g., revenue, expenses, etc.).
   • YTD Setting (Flow Accounts):
     • MTD = YTD (current period) - YTD (prior period)
     • This calculates MTD as the difference between the current period's YTD value and the prior period's YTD value.
   • MTD Setting (Flow Accounts):
     • YTD = MTD (current period) + YTD (prior period)
     • This calculates YTD as the sum of the current period's MTD and the prior period's YTD values.
       
       Example : Revenue (Flow Account)  
     • Prior Period YTD = 100,000 USD
     • Current Period YTD = 150,000 USD
     • MTD for the current period = 150,000 USD - 100,000 USD = 50,000 USD
2. For Balance Accounts (Assets, Liabilities):
   Balance accounts represent a snapshot at a point in time (e.g., assets, liabilities).
   • YTD Setting (Balance Accounts):
     • YTD = Current Period Balance
     • The YTD value is always equal to the balance in the current period, as balance accounts show a point-in-time value.
   • MTD Setting (Balance Accounts):
     • MTD = Current Period Balance - Prior Period Balance
     • MTD is calculated as the difference between the current period's balance and the prior period's balance.
       
       Example : Assets (Balance Account) 
     • Prior Period Balance = 200,000 USD
     • Current Period Balance = 250,000 USD
     • MTD for the current period = 250,000 USD- 200,000 USD= 50,000 USD