the basics will probably be a sum of the transaction account line's amount columns where the posting column is T grouped by the account