Godown mirroring with cumulative tracking

The problem

Stock for 200+ fan and electrical SKUs lived in two places — Godown A (head) and Godown B (secondary) — and reconciliation was manual. Every Sale or Purchase had to be logged in both sheets, then someone summed them at month-end to know what was actually on hand. Errors crept in. Closing stock rarely matched the physical count.

The solution

A macro-driven Excel workbook that mirrors stock movements between godowns and aggregates them in real time.

• Six purpose-built sheets — Godown A, Godown B, Stock_Adjustment (the activity log), Master_Stock (live aggregate), Pricing, and "for print" snapshot
• Mirror-to-other-sheets macro — one button, entries in Godown A propagate to the matching ItemID in Godown B and the master aggregate
• Stock_Adjustment ledger captures every movement with date, model, size, colour, godown, quantity, and Action Type (Sale or Purchase) — full audit trail
• Master_Stock auto-computes total qty A + total qty B per ItemID — closing stock visible at any moment
• For-print snapshot renders the current state in the right format for physical stock checks
• Built entirely inside Excel — no new software for the team to learn

Walkthrough

The outcome

• ~6 hours saved every week — reconciliation reduced to one click
• Closing stock visible live, not at month-end
• Discrepancies caught and flagged automatically — fewer surprises during audits

Note for Harsh: confirm exact hours-saved number once measured over a few weeks. Add real screenshots.

Tech stack

Stuck reconciling spreadsheets?

We turn manual reconciliation into one-click ops. Excel, Sheets, or Tally.