-snip- One thing that might be noteworthy is that the Core balance is an amount that is exactly less than the value of one of the consolidation transactions, and the two UTXOs consolidated in that transaction had the same receive address. Could somebody help me understand what's going on here? Thanks in advance!
Since it's the same address and only one transaction appeared,
Bitcoin Core might have missed the other transaction or currently do not have the block where that transaction is included.
If it's currently syncing, wait for it to sync.
If Bitcoin Core has already caught up already to the tip of the blockchain, perform a rescan using
rescanblockchain command in the console. (
this could take a while)
If your blockchain is pruned, you can only rescan specific blocks that aren't pruned yet, query the 'pruneheight' using
getblockchaininfo command.
Additionally, if the missing transaction belongs to the pruned block, Bitcoin Core wont be able to scan it without syncing from scratch.