Stock & Sales Payment Module -- 2

I manage stock and sales daily but still have no reliable way to capture local payments inside the flow. What I need most right now is a lightweight module (web-based or desktop, I’m open to suggestions) that plugs into, or works alongside, my existing stock record so every sale is instantly matched with the payment received. Core goal • Accept and record each “local payment” in real time, then automatically update the sale status and the running stock count. • Support the usual cash counter scenario first; if you can leave hooks for bank transfer or mobile-wallet additions later, even better. Preferred flow 1. Select or scan the product being sold. 2. Confirm quantity in stock and final price. 3. Pick “Local Payment” and hit save. 4. System writes one line to a payments ledger and one to a sales ledger, and adjusts on-hand stock. Tech notes – I’m comfortable with PHP + MySQL tables or a small Python/Flask app, but any stable stack is fine as long as setup is simple. – A clear SQL schema or an exported SQLite file must be included so I can back the data up myself. Deliverables • Working module (source code) with a short, step-by-step install guide. • One demo database with sample stock items and at least two recorded local payments so I can see the logic in action. • Brief user manual (PDF or markdown) that shows how to enter a sale, process a local payment, and pull a daily sales-versus-payment report. I’ll test by installing on a single Windows laptop and running through a full sale-to-payment cycle. When that passes and the ledgers line up, the job is complete.