What follows is a comprehensive list of Enhancement & Improvements that have been rolled out for PlanGuru 2013. There are many additional minor changes & fixes that weren't significant enough to list here, but this list details all noteworthy changes:
Indirect Cash Flow Statement : PlanGuru now gives users the option of presenting their Cash Flow Statement using the Indirect method. When setting up an analysis for the first time, or by going to the 'Edit>Analysis Setup' menu option, users can choose their preferred cash flow presentation method.
Line of Credit Tool - Variable LOC Limit : The line of Credit tool now allows users to define their LOC limit with more flexibility. Users can make their limit a % of A/R & Inventory up to a fixed limit. In the past users were forced to choose a fixed limit OR a % of A/R & Inventory, but could not make it a combination of the two.
Link to Non-Financial % Rate : This is enhancement is a true game changer for users of the "Percent of Other Categories" and "Adjust Prior Period Amount" methods. Both of these forecasting methods rely on a populated growth rate to forecast the future. In the past these growth rates & relationship % needed to be manually populated or applied by the calc assumptions feature, but in all cases these % were static values that needed to be manually updated within each category. Users of PlanGuru 2013 can now link these rates to a Non-Financial data category. This has two significant advantages. First, this means that forecast percentages can be dynamically calculated in the Non-Financial data tab (using the formula method). Also, this means that multiple categories utilizing these methods can be linked to a single growth rate maintained in the Non-Financial data tab. For example if I was forecasting 20 categories using the same "cost growth rate" I can now update my assumptions by changing the value of one non-financial data category, rather than manually updating the growth rate in 20 categories. This makes changing assumptions and scenario analysis so much easier and more efficient.
Enhanced Calc Assumptions Features - Historical Interim Periods : The "Calc Assumptions" feature is great for users of the "Percent of Other Categories" and "Adjust Prior Period Amount" forecasting methods. This feature calculates historically observed percentages and allows users to forecast the future by applying these calculated percentages. In the past percentages were only calculated on full year historical data. In PlanGuru 2013 historical relationships and growth rates can be calculated and applied by month. This is a key enhancement for users of these methods because forecasted amounts are now intelligently calculated based on the seasonal variations observed within your historical data.
Enhanced Calc Assumptions Features - Add Actual Results : The "Apply Trend" option within the Calc Assumptions feature now factors in relationships & growth %'s observed in "Actual" periods. In the past these numbers were displayed in the Calc Assumptions feature, but didn't factor into the calculated trend. This update means that your trended growth rates will be more accurately calculated based on the most up to date information.
Memory in "Browse" Functionality : Users of the Import Utilities and "Link to Excel" method will be pleased to know that PlanGuru now retains their most recently browsed folder in the application's memory. This is helpful for users because they no longer need to browse to the appropriate directory from their desktop every time they want to link to an Excel worksheet or import data. This will save users time when interfacing with Excel.
Formula Forecast Method - Increased formula length : PlanGuru 2013 has an increased Max formula length. Previously users formulas couldn't exceed 40 elements, this number has been update to 80 in PG 2013. This feature will allow users to create formulas that are twice as long and will prevent the need to create additional "intermediary" calculations.
Adjust Prior Period Amount - Manual & Growth Rate, "split" Forecasting : The Adjust Prior Period Amount Method now allows users to manually forecast the category for a number of periods, and then forecast the same category using a growth rate in some projected period further into the future. This enhancement significantly improves the usability of this key forecasting method.
Non-Financial Categories - Display Non-Financial categories as a % : Users will now be given the option to display Non-Financial data categories as a %. This allows users to present their non-financial data in a more aesthetically pleasing and logical way, and will make a non-financial data category a "linkable %" (see "Link to Non-Financial % Rate" enhancement listed above for more details).
Supporting Schedules - Change Sort order : Customers will now be given the option to sort supporting schedules in the order of their choosing. In the past supporting scheduled were sorted in the order in which they were added to the analysis. The result is that reports would be printed out with supporting schedules sorted in a meaningless order.
VAT/GST - Automated VAT/GST Solution : Users who have value added taxes will be pleased to know that PlanGuru now has a feature that will allow them to automatically calculate their VAT/GST forecasting. This option is configured during the analysis setup process.
QuickBooks Import - Inactive Accounts: Users of the QuickBooks import utility will now be given the option to include inactive QuickBooks accounts during the import process. This is helpful because very often accounts are deactivated in QuickBooks, but are still relevant because they contain balances for historical reporting purposes.
Import Utility - Assign Accounts dialog improvements : A number of changes made to "Assign Accounts" dialog that make mapping accounts easier and more user friendly
Import Utility - Grouping accounts when account numbers are used: In previous versions users couldn't group and accounts when their company used account numbers. This created some challenges for users who had multiple cash and retained earnings accounts. PlanGuru 2013 allows users to group cash and retained earnings accounts even when account numbers are used.
Report Options - Company name override : Users will now be given the option of changing the Company name that displays on printed reports. This is helpful when users have multiple legal entities residing within a common company folder used for consolidation.
Comment Reports : Comment reports can now be exported to Excel
Reporting - Supporting Schedule Categories : Supporting schedule categories can now be reported off of using the Advanced Reporting Add-In. The ARA v-3 will be launched when PlanGuru 2013 goes live. This new version of the ARA gives user the option to include or exclude supporting schedule details in their Income Statement reports.
Consolidation - Cash Accounts For Analyses w/o a Balance Sheet : In the past customers who were forecasting their balance sheet within their consolidation analysis ran into a minor issue for actual/historical cash balances when their forecast was re-consolidated. Cash balances were getting zero'd out for some periods because their departments/divisions (detailed analyses making up the consolidation) contained 0 balance cash categories, even though these analyses didn't include a balance sheet. Thus when the consolidation was re-run the correct total company cash balance (imported into the consolidation analysis) was overwritten by the 0 balances coming from the detailed analysis files. In PlanGuru 2013 this has been fixed.
Consolidation - Depreciation Expense for Analyses w/o a Balance Sheet : Users who forecast the balance sheet on the consolidated level weren't able to link their consolidated Accumulated depreciation account to depreciation expense categories that came from their individual budgeted divisions/departments/locations. In PlanGuru 2013 this has been corrected by allowing users to assign categories with the "Depreciation, Amortization & Depletion" subclass within their detailed (non consolidation) analyses that don't contain a balance sheet. These depreciation expense categories can then be accumulated into the Accumulated Depreciation account added to the consolidated balance sheet.