While it may not work 100% of the time due to dates and other transactions, but @jpfieber has a solution that work well, although I’m not sure how they would work for a credit account as theyre intended for bank statements i believe but it could work
It has a feature to append days to a statement in order to account for these erroneous posting dates
The [account reconciliation] google sheets version (Account Reconciliation - Google Sheets)
Or the excel version