Matching your supplier ledger with the company or distributor statement before month-end
⬇ Free supplier reconciliation sheet (Excel / Google Sheets)Mahine ke end par distributor ya company ka statement aata hai aur aap ke register ka total uss se nahi milta. Fark kabhi 500 rupay ka hota hai, kabhi 50,000 ka. Yeh post aap ko ek aisa tareeqa degi jo kisi bhi fark ko aadhe ghante mein dhoondh leta hai.
Fark kyun aata hai
- Maal aap tak pahunchne mein der hui: statement mein tareekh pehle ki, aap ne baad mein likha.
- Rate ka fark: company ne naya rate lagaya, aap ne purana likha.
- Return ya claim ka credit note jo statement mein nahi aaya ya aap ne nahi likha.
- Adaigi aap ne ki lekin company ne us din ki tareekh mein nahi likhi.
- Ek hi bill do dafa ya ek bill chhoot gaya.
Qadam 1: Dono taraf ek hi tareekh tak ka hisaab
Statement ki aakhri tareekh dekhein, aur apne register ki bhi usi tareekh tak ka total nikaalein. Is ke baad ke bill aur adaigiyan alag likhein, wohi aam taur par fark ki wajah hoti hain.
Qadam 2: Do columns ki seedhi milaan
Ek sheet par baayein taraf apne bill aur adaigiyan, aur daayein taraf statement ki entries likhein. Har entry ko tareekh aur bill number se milayein. Jo entry dono mein hai, us par tick lagayein; jo sirf ek taraf hai, wohi aap ka fark hai.
| Tareekh | Bill no. | Aap ka record | Statement | Fark |
|---|---|---|---|---|
| 03 Oct | INV-4417 | Rs 184,000 | Rs 184,000 | 0 |
| 12 Oct | INV-4452 | Rs 96,500 | Rs 98,000 | Rs 1,500 (rate) |
| 19 Oct | PMT-882 | Rs 150,000 | Nazar nahi aaya | Rs 150,000 (adaigi) |
Yeh numbers demo ke liye hain; apne asli bill, rate aur adaigi isi tarah likhein.
Qadam 3: Har fark ki wajah likhein
- Agar rate ka fark hai to purani rate list ya company ki chitthi dekhein.
- Agar adaigi nazar nahi aayi to bank slip ya rasid ki photo bhejein.
- Agar credit note ya return hai to company ko usi tareekh ka reference bhejein.
- Agar bill dobara aaya hai to ek ko cancel karwayein.
Qadam 4: Distributor ko ek saaf message
Assalam o Alaikum. 31 October tak ke statement mein hamare record se 151,500 ka fark hai: INV-4452 par 1,500 rate ka, aur 19 October ki 150,000 ki adaigi (slip lagi hai). Meherbani kar ke dekh lein.
Qadam 5: Mahine ka aakhri total sath likh kar band karein
Jab sab fark hal ho jayein to dono taraf ka aakhri total likhein aur usay "closing balance" ki tarah band karein. Agle mahine ka hisaab yehi se shuru hoga. Isse purane farq kabhi aage nahi chalte.
Software ke saath yeh kitna aasan hota hai
Jab har khareed aur adaigi usi din software mein jaati hai to supplier ka khata khud aap ke saamne hota hai, aur statement milate waqt aap ko sirf farq dekhna padta hai. KhadMunshi mein supplier ki khareed aur adaigi alag darj hoti hain, aur har supplier ka lena dena saaf rehta hai.
