alternatively, you could trigger on someone entering a transaction into the previously closed period. Not sure if that would meet your goals or not.