Import it into Excel and create a Pivot Table?
That depends upon..
The format that the information is in..
The format you want the information to come out in..
And the format of the final product..
Pivot tables are fine for a preliminary raw report based upon raw data..
If it’s in excel format..
“Import it into Excel and create a Pivot Table?”
Probably using Audit Command Language, (ACL) software, much more useful to the auditor’s tasks at hand, given the volume of data.
Import it into Excel and create a Pivot Table?
*************
Oh no, you can’t do anything efficient like that. That would speed up the process. Can’t have that. Let’s keep counting... /sarc