In Data preparation two facilities are available.
1. Calculate Values
If in your ERP output, total invoice value is not provided then by using this feature of “Calculate Sum” you will be able to make total of invoice values for all your document no. It will minimize your manual work of calculations.
2. Data Consolidation
To consolidate multiple CSV files into one Excel workbook, you can use this feature.
To know in detail click on above-mentioned links.