How do you handle large datasets in Excel when performing weekly reconciliations at Adobe, and which functions do you rely on most?
For this SQL exercise, compare posted Adobe transactions with weekly reconciliation control totals. Include matched records, amount or count mismatches, and records present on only one side.
account_code, week_start, transaction_count, reconciled_count, transaction_total, reconciled_total, and reconciliation_status.account_code and week_start.| Column | Type | Description |
|---|---|---|
| transaction_idPK | INT | Unique transaction identifier |
| account_code | VARCHAR(20) | Adobe account or ledger code |
| transaction_date | DATE | Transaction posting date |
| amount | DECIMAL(12,2) | Posted transaction amount |
| transaction_status | VARCHAR(20) | Posting status |
| Column | Type | Description |
|---|---|---|
| reconciliation_idPK | INT | Unique reconciliation control row |
| account_code | VARCHAR(20) | Adobe account or ledger code |
| week_start | DATE | Monday starting the reconciliation week |
| reconciled_amount | DECIMAL(12,2) | Expected weekly amount |
| reconciled_count | INT | Expected weekly transaction count |