Daily account balance variance analysis

I have a list of several thousand names, relationship ID number (formatted as text), and account balance. The relationship ID is unique but names are not.

I need to identify day over day which account balances change (either increase or decrease) by $1,000. This is reviewed every day, and the list changes each day as new accounts are added and/or closed.

Editing to add that I am using excel 365

Can this be done without power query?