Hello Benjamin Vruwink,
I actually think this is a great way to do this, or at least: this is how I would have done it, except the IN and OUT part.
Here I would have created a new column with Totals and Colors formatting.
Would you be able to share your workbook with us please so we can better try ourselves on the topic?
I'm sure the community could help us as well