How to set frequencies and periods for daily/weekly/monthly reconciliations?
Summary:
We have several entities which are sharing the same calendar. Mostly Balance Comparison is used, with a few possible Transaction Matching cases. The requirement is to have following reconciliations:
-Daily: balances integrated and reviewed every day.
-Weekly: balances integrated daily and reviewed weekly.
-Monthly: balances integrated monthly and reviewed monthly.
If we use Base calendar and define each day as a period, e.g. Jan 1 with a start date 1st of January and end date 1st of January and so on, in this case the full year will be utilized by daily periods and there is no space for weekly and monthly periods. We would like to define weeks as Week 1, Week 2 etc. and regular months as January, February etc. All the data will come from Data Integration.