accounting problem not working, keep making conflicts

[Side.Order]

hello again, it's been a long time posting... if anyone is willing to help me here that would be great. if you need to change things up for the better, or if someone is an accounting expert and can make this even better that would be fantastic

[FDibbins]

For a start, remove all those merged cells, they cause all sorts of problems with formulas and macros.

Next, you have a circ ref error (which Im sure you already knew) where S7 references AF7. But AF7 references AF11...which uses S7 in a calc. You need to resolve that, otherwise you could get all sorts of unexpected answers.

In AA7 you have this...
=IF(Z7=0,"$0.00",SUM(Z7,AB4)-AB7)
By putting "" around $0.00 you are converting the number to text, and excel often has a hard time running calcs on text numbers. Rather, just use...
=IF(Z7=0,0,SUM(Z7,AB4)-AB7)
It is already formatted as currency
You also dont need to use the SUM function there - not wrong, just redundant...
=IF(Z7=0,0,Z7+AB4-AB7)
maybe a bit easier to follow the logic

Same thing with AF7 with "0%"

You have a few other text number formulas there, but you get my drift.