FIX(trial balance): group by respects period ids

[jniles]

This is a critical fix to the trial balance, ensuring that period totals are correctly calculated and stored in the appropriate periods.