FUNCTIONALITY UPDATED FOR PLANGURU 2012.
Supporting schedule details don’t total up to the financial statements for historical and actual results, this is designed functionality in PlanGuru 2011. We developed supporting schedule functionality to allow users to forecast balances at a "sub-ledger" level. As a result we anticipated that customers would import historical balances for these accounts at the ledger level (financial statement total) and only use the supporting schedule details for forecasting future periods.
The supporting schedule category totals (that you see on your financial statements) cannot simultaneously be available for import, and be a function of the supporting schedule detail lines. Thus, when designing this functionality we had to chose what we though our customers would prefer: 1. Allow historical/actual balances to be loaded into supporting schedule category total or 2. Force our customers to manually populate the schedule details for historical and actual periods. As is obvious to you now we chose option 1, and for many of our customers this works.
It has since come to our attention that a number of customers find this functionality sub-optimal for their purposes. In response to this we are developing an enhancement that would allow our customers to choose between the two options listed above.
Until then here are two suggested work arounds for dealing with this issue:
- If you want to forecast these accounts using supporting schedules you should either import the summary balances into the appropriate financial statement categories or enter in the totals for each of your supporting schedules into the financial statements.
- Another option would be to create subtotals in the financial statements instead of using the supporting schedules. Using the Cost of Goods Sold example (see attached image) here is how you could implement this approach
- Deleted the Cost of Goods Sold category and related schedule from the income statement.
- Add three categories to the financial statements titled “COS – Local”, “COS – Import” and “COS – Catalog” and populate your historical data for each of these balances.
- On the financial statement highlight the three newly added categories, right click and select “Add subtotal grouping” from the drop down menu.