Great, was thinking I had something along those lines left..
Maybe a google sheets upload could work? Could even code in the minus 1 per day to automate that part so you only have to update any incoming transfers..
Or just update what you have and offline now and add the date so it's clear. I'm guessing it should be easy and efficient for you in that regard