If you have a PPF Budget (DC Only) error, it means that there is a disagreement between the values on the iBudget tab versus whats on the PPF tab in the range R11:T76


You diagnose the problem in PPF!S88:U94 (Note:I did some columns to align the accounts and figures)

If the sum of all of the DIFFs is > 500, then there is an error flag. So, we need to get the reconcilliation close, but it doesn't have to be exact. In the above, we can see that the main problem is under LEP/NEP revenue.


For each account, here's the rows to review

4000 · Per-pupil alloc | Core Annual Revenue (T34) + Residential Revenue (T62)

4010 · Per-pupil SpEd alloc | Sped Levels Annual Revenue (T41) + SpEd Compliance Annual Revenue (T45) + 

                                                 Sped Residential Annual Revenue (T56)

4020 · Per-pupil LEP/NEP alloc | LEP/NEP Annual Revenue(T49) + LEP/NEP Annual Revenue(T59)

4040 · Per-pupil at risk | At Risk Annual Revenue (T67)

4100 · Per-pupil facility alloc | Facilities Annual Revenue (T71)


----

> Problem 1:The number of students or PPF rates don't agree (MOST COMMON) 


We need to evaluate what the difference is between the FRT!PPF tab and the budget model

FRT: PPF tab (gray x blue cells)

Budget: Pop tab

 - The number of students totall agrees


Budget: PPF Inputs

 - Both PPF input amounts are different


Now let's see if the math adds up

6209.5 - 6209.2755 = 0.2245 x 172 students = 38.614

9314.25 - 9313.91 = 0.33675 x 117 students = 39.399

Total difference = 78.01


So, this explains some of the differences, but not the whole story

Solution: If you do see a difference, update your PPF!ColS and PPF!ColT


----

> Problem 2: The FRT!iBudget and Budget!Report doesn't match  (UNCOMMON) 

Make sure that you're looking at the right budget 



----

> Problem 3: There are unusual edits in the budget file (MOST UNCOMMON)


Among those that I've seen

  • The #students in the budget is a fractional number. In the above example, 172 students were actually "171.75. Solution: Enter 171.75 in the PPF!ColT
  • Someone manually added "+40,000" to the account forecast on Rev-Loc. Solution: Manually create the PerStudent Revenue by dividing total revenue (including 40k) by #Student and inputting that into PPF!ColT