Oracle SQL tutorial
Compare the calculated analytical Repo P&L with general ledger accounting entries and identify differences in a single SQL query.
About this tutorial
Continue from the previous Repo P&L calculation tutorial. We aggregate the analytical results and the corresponding general ledger entries at the same level: GL account, instrument, ISIN and currency.
Using Common Table Expressions (CTEs), UNION ALL and conditional aggregation, we bring both sides together and calculate the difference between analytical and booked P&L.
Reuse the previous calculation and aggregate by GL, instrument, ISIN and currency.
Apply debit and credit signs and aggregate the accounting entries at the same level.
Combine both datasets with UNION ALL and calculate analytical, booked and difference columns.
Repo P&L workflow
This tutorial is the second step in the complete Repo P&L reconciliation workflow.