Annual Church Summary

I am working on putting together our annual church bookkeeping summary report, where I summarize categories and total debits and credits. I can do that easily with Summary & Analyze pulldown menu. However, I also want to have the final balance for the year listed in the “running balance” column, which would be the data for the last entry of the year. Is there a way to post that along with the other summaries? I would then get total credits, total debit and balance (credits-debits). In the menu there are options, such as Total, Count, Maximum and Minimum, but no ability to show the credit-debit for the year.


I figured out how I can do it by copying the balance of the last record and then posting the copied cell into the summary field for balance . Seems to do what I want.