Different opening and closing balances between Budget workbooks and Advisor Reports

Why is the opening and closing balance in Budget Workbook not the same as Advisor Reports?
Data shown in the Advisor Reports are extracted from the Advisor Database. The Advisor Report will show complete and correct Opening Balance and Closing Balance where the Budget Workbook is missing out.

Data in the Budget Workbook will not necessarily show the complete picture if there were some Activity PGs being closed in PeopleSoft after the 1st January of previous year. As such the opening balance will not be consistent with that in the Advisor Database or PeopleSoft.

Closed PGs are filtered out from the Budget Workbook to eliminate the requirement of posting into closed PGs in PeopleSoft during the interface transfer from Advisor to PeopleSoft. When there are a large number of closed PGs the interface process becomes extremely time consuming, therefore closed PGs are eliminated.

It is strongly recommended that those BUs that budget at PG level rather that Budget Activity level leave their PG open until they are no longer required to show the previous year’s numbers.
Was this answer helpful?
Your rating has been submitted; please tell us how we can make this answer more useful.