Just to clarify your situation: you have 2 PS4's, and both have the same account? So if you have the same account, and your save is being uploaded to the cloud, technically it should work fine. (I have 2 PS4's too, so I understand your question)
The automatic save doesn't always save the last state, so you need to upload it manually when exiting the game, go to Settings and upload it to your cloud.
When you log in to your other PS4, it should work.