- Create a gift query of the appropriate gifts and sort it by Batch Number
- Create a gift export and export the Amount and Batch Number fields plus any other needed field. Export in Excel format.
- Open the file in Excel and ensure it is sorted by batch number
- At the end of each batch number, enter a formula to total the amount fields for that batch