Looks like this is an ongoing thing.
Does anyone think that having a column for current month and one for previous month might help matters? At the end on the month move the just finished month into the previous (overwriting the data from the month before) and then setting all of the current column to 0 for a fresh beginning. This could take place at the end of the month server time during maintenance.
So a few moves between midnight your-time and maintenance server-time get into the previous month. It's always going to be midnight somewhere on the planet, that's unavoidable, but days/months begin when the server guys say, which is generally after the maintenance cycle.