What is the Year to Date Period option?
The YTD option in Period Close is for setting which periods belong to the current and last year to date Period.
When to use it?
Generally this should only be used when you are required to generate a report on Year to Date rather than To Date figures, which is the default in Eclipse. For example needing to provide special reports for your auditors and year end.
How to use it?
All reports in Eclipse use the To Date amounts, but if you need to report on YTD amounts then please contact support so they can configure special YTD reports for your production database.
Once your reports have been setup navigate to your Control Table → System Defaults → General Ledger tab and untick Hide YTD Option to enable the YTD Option.
Navigate to General Ledger → Period Close → YTD to access the YTD Option. By default this will be set as blank to 999999 to run over every single period.
Add the starting and ending period for the current year and the previous year and then press Cancel or X to close the window. These periods will be used to run your YTD reports.
For example, our current year periods are from 100317 to 100322, and our previous year is from periods 100310 to 100316.
If you are unsure of your period numbers, you can navigate to the Periods tab and select the Previous Periods dropdown box to see all past periods.After you have set your periods, you must then run a Chart Rebuild in the Budget Worksheet by following this guide: How to run a Chart Rebuild.
You should run a Chart Rebuild each time you change your YTD periods to recalculate the periods and fix any out of balance errors.