1. Create a new Record Query
2. On the Criteria tab, select the appropriate filters for the records to be included
3. On the Output tab, expand Activity, expand Summary
4. Select Record Balance
5. Enter the Appropriate As of Date as needed, select Ok
6. Select additional Output and Sort options
7. Run the Query