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

OR

  1. Create a gift query of the appropriate gifts. Output gift amount and batch number.
  2. Create a pivot report. Drop the batch number and gift amount in the rows column and total amount on the data section.