Thanks Sahanu. I tried your advice and it works great to link a single file. Unfortunately the file name changes daily as they always append the backup date and time stamp. (Your_User.2023-11-13_05-43-28.tar
I managed to get it done by adding a link as such. Hopefully that will keep linking the latest backup.
ln /backup/Your_User* /home/Your_User/web/Your_Domain/private/
Now using my admin user to log on with FTP. I can download all my backups from the /private folder.
Thanks!