Bank reconciliation technique

• Download transactions from accounting system for month
• Download transactions from bank for month

The format is usually excel or csv.

Put the output(money going out of you account) transactions in two adjacent columns and sort each column independently. Use a formula IF(A1 = B1, "OK", "NOT OK") and then use the fill handle in excel / google sheets / libre office etc. to check for all transactions. The “NOT OK” rows either miss a transaction or has a transaction extra.

Do the same for input transactions.