Thanks both for your replies.
I guess I’m of the same opinion as you @StuartH that’d I’d really like Phocas to add a simpler PERIOD_DAYS and PERIOD_COUNT function.
@ShaneAngel
I’ll speak to my Phocas support advisor, to see if they can run the same script for us as I load out budget by month also.