Have you synced before?
If so, it looks like you have FILE – RESTORED FROM BACKUP a backup made on a secondary computer. What you describe is exactly what I would expect to see from a secondary data set, it normal.
You should always restore a backup from your primary computer if you have been syncing.
If you need to restore from a backup and for some reason your primary computer backup is not available then it is possible to convert a secondary data set into a primary data set.
If you need to do so just post and I will post the procedure.
I will need to know if you are running 2017 or 2019.
If the position you find yourself in is nothing to do with syncing give more detail.
To convert a secondary data set to a primary data set you need to run the attached script md2017_convert_secondary_to_master.py in Moneydance 2019. Don’t worry it states 2017.
With your data set open click WINDOW - SHOW MONEYBOT CONSOLE use OPEN SCRIPT to select the script and click RUN. Wait for the script to complete its run, it can take a minute. Close and reopen Moneydance. You should now be able to change the syncing method.
The problem was caused by restoring a secondary computer backup instead of your primary computer backup.