Inventory a wallet's outputs within a confirmation window
For a reconciliation job, the useful unit is an outpoint. Several unspent outputs can share one address and still need separate records.
Request a bounded inventory
The example reads the loaded shop wallet and asks for outputs with six through 144 confirmations, inclusive. It excludes unsafe outputs and retains the transaction ID and output index as a pair.
bitcoin-cli -rpcwallet=shop listunspent 6 144 '[]' false | jq '.[] | {txid, vout, amount, confirmations}'
Keep the snapshot reproducible
Two rows with the same txid may have different vout values. Keying rows by transaction alone loses legitimate outputs. The window moves each time the tip changes and a spend can remove a row immediately. Record the tip alongside the scan if two runs must be compared.