The aura effect will show up when you press the attack button while carrying the chest/treasure, as long as you’re near your coffer, allowing you to place it down and claim it. Simply dropping it will leave it unclaimed, and it will eventually despawn.

I don’t use a controller, so I don’t know the default buttons, but a previous PS5 user that was having the same issue did say that using the “attack” button worked for them.