What you need to use here to the ‘events in progress’ pattern or technique.
This will give you the amount which is considered in transit on a specific date.
Check out the tutorial here which covers this technique in a bit of detail
You need to solve this in the model with slightly different relationships (inactive ones) then a specific formula technique that works with these unique relationships.
This should get you what you need I believe. See how you go
Sam