Doing this means I lose all of the detail needed to properly do a P&L which is critical for a business by the way. It only keeps the "Square Transactions" as a ...

Unfortunately all of your suggestions mean that I have lost all of my detailed information on the sales products that were sold, and it is all lumped as "Square...