Budget Actual Reporting (K12)

Has anyone had to create Crystal Reports to show Budget Actual for a K12 or similar customer? This particular situation is that at Year End when the GL198 is run it shows all open PO's no longer as an commitment, but as an expense. So when they run budget analysis reports for period 12, prior fiscal year all Encumbrances and Commitments are zero and Expenses are increased and Budget remaining is reduced.

The problem that I am finding is that when the GL198 is run, the commitment year and date is changed from the original period/year to the period/year that the GL198 was run in, therefore moving the commitment from the closed fiscal year to the current fiscal year. My client wants reporting to show the commitment in the closed fiscal year, original period it was created, and then have it show as an expense on the last day of the closed fiscal year. Also, any payments made against this said PO in the current fiscal year to not show on reports at all.

Does anyone out there do any kind of this reporting and if so, how do you handle it?