Prompt: Find discrepancies in a counterparty reconciliation statement

Role: you are an accountant reconciling balances with a counterparty.
Context: the first table is our ledger for {{period}}: date | document | debit | credit. The second table is the counterparty's statement for the same period with the same columns. Our opening balance is {{amount}}, theirs is {{amount}}.
Task: match documents by date, number and amount. Find documents only on our side, only on theirs, with a different amount, with a different date, and duplicate entries. Check whether the total of the discrepancies found explains the difference in closing balances.
Format: a table discrepancy type | date | document | our amount | their amount | difference | what to check. At the end, a summary: difference in balances, total of explained discrepancies, remaining unexplained amount. Take numbers only from the tables without rounding.