Hey everyone,
I built a small Node.js tool to help with day-end stock reconciliation for ERPNext, especially for setups where daily counts are tracked in Excel before being updated in ERP.
The Problem
If you have ever had to manually check your Excel day-end sheet against ERPNext stock levels, you know how error-prone and repetitive it gets:
-
You have to open every item or export data from multiple warehouses.
-
It is hard to catch small quantity mismatches before they affect accounting.
-
Re-entering sold quantities as invoices takes a lot of time.
The Solution
This script:
-
Fetches your ERPNext stock balances through the API
-
Reads your latest Excel sheet
-
Calculates what was sold or missing
-
Creates a draft POS Invoice for review, so you can quickly confirm the day’s sales or losses without manual entry
It is designed for small retailers, warehouses, and ERPNext admins who want a faster way to keep physical stock and ERP data in sync.
GitHub: https://github.com/Stelele/stock-reconciliation
I would love to hear how others handle day-end stock checks or if there is interest in expanding this into a plug-and-play ERPNext app.