I am currently rolling out bank by bank validation of the extractions. This provides visual confirmation that all of the transaction data is present.
I have been getting a lot of sets of statements uploads for HSBC in the UK recently.
To do this I am extracting the opening and closing balances to verify all of the transactions against for the statement period. The account number for the statement is extracted and used to group the statements together. This creates a view that makes it easy to see if it is a continuous set of statements and has the option to export the merged extraction.
https://www.statement2excel.com/banks/uk/convert-hsbc-bank-statements-to-excel