Calc Book Keeping Balance Issue

Hello,
First post here.

I wanted to create a simple Calac spreadsheet. I have all the headlines sorted.
The main categories are listed as in this screen shot…

Unit cost * QTY is easy, and I allocate the formula to both Debt and Credit, and in Ballance I put Credt-Debt (=H3-G3).

But that’s the end of it all. As I add to credit and debt the balance does not work, and I get double ups in the debt and credit fields.

It was a simple idea that became complicated.

Any ideas on what’s happening?

Book keeping.xlsx (9.7 KB)

Thanks for your helps