Some Editions of Sage 50 have a multiperiod trial balance under Reports | Financials | Multi-period Reports | Trial Balance.

The basic amounts are in tAccount as of the beginning and latest YTD entry for the last two years.

But to get anything but the latest entry balance is pretty special, since monthly periods are not used. To make it extra fun, there is is a separate set of G/L account transaction and detail tables for each fiscal year. eg. current year Jourent -> JentAct; JentLY->JentLYA; tJehxx... etc.

And for years prior to the amounts in the tAccount table, there is an additional yearly ending balance table.

Getting the trial balance numbers between the set periods is a matter of summing all the journal entries between the year end and the month end dates for each month.

I hope that helps, I don't want to discourage.