COD payment ka hisaab milana courier rate se zyada zaroori kyun hai
COD payment reconciliation, yaani COD payment ka hisaab milana, ka matlab hai ke aap ne jo bhi parcel bheja, use ek ek line kar ke us raqam se milayein jo courier ne waqai aap ko di. Zyada tar Pakistani sellers yeh kaam nahi karte. Bank mein payment aati hai, raqam theek lagti hai, aur baat khatam. Masla yeh hai ke COD parcel aap ka paisa banne se pehle rider, branch, settlement team aur bank transfer se guzarta hai, aur har qadam par koi parcel reh sakta hai, us ki kam payment ho sakti hai ya us par do baar charge lag sakta hai.
Is post mein aap ko teen tab wali Google Sheet milegi jo aaj hi copy kar sakte hain: ek tab aap ke orders ke liye, ek mein courier ki payment report paste hoti hai, aur ek har us parcel par nishaan lagata hai jis ke liye phone karna hai. Saath mein Rs mein ek misaal aur hafta war tareeqa bhi hai, taake ek baar set hone ke baad hafte mein taqreeban 20 minute lagein.
Courier aap ke COD ke paise kitne din rakhta hai?
Itne din ke ghaltiyan gum ho jayein. April 2026 ke Pakistani courier rates ke ek muqablay mein COD settlement ka andazan waqt yeh likha hai:
| Courier | COD settlement ka andazan waqt (April 2026 muqabla) |
|---|---|
| TCS | Retail accounts ke liye 7 se 14 working din |
| Leopards | 7 se 10 working din |
| M&P | 7 se 14 working din (aam) |
| PostEx | Advance ya usi din |
Yeh ek public muqablay ki range hai, waada nahi, aur aap ke contract mein kuch aur likha ho sakta hai. TechCrunch ne 2024 mein report kiya ke Pakistan mein zyada tar couriers COD ki raqam settle karne mein 10 se 15 din lete hain. Returns is se bhi slow hote hain: June 2026 ki OrderNation ki ek bari Pakistani retailer par study ke mutabiq nakaam COD delivery ko seller ke hisaab mein nazar aane mein median waqt 21.7 din laga.
Yaani kisi bhi waqt aap ki do se teen hafton ki sale rider aur aap ke bank ke darmiyan kahin hoti hai. Agar aap roz 50 parcel bhejte hain to 700 se 1,000 parcel raaste mein hain. Itne parcel koi yaad se check nahi kar sakta. Sheet kar sakti hai.
Delivery aur payment ke darmiyan kya ghalat ho sakta hai
Yeh woh paanch masle hain jo yeh sheet pakarne ke liye bani hai. In mein se kisi ke liye badniyati zaroori nahi; zyada tar branch par entry ki ghalti ya aisa status hota hai jo kabhi update nahi hua.
- Deliver hua magar payment nahi aayi: tracking mein delivered likha hai, magar ab tak kisi payment report mein yeh parcel nahi hai.
- Kam payment: parcel report mein hai, magar wusool shuda raqam aap ki COD raqam se kam hai, maslan darwaze par customer ko discount de diya gaya ya ghalat raqam likh di gayi.
- Zyada charge: report mein shipping, COD fee ya return charge aap ke rate card se zyada hai, ya ek parcel par do baar charge laga hai.
- Return hua magar mila nahi: tracking kehti hai shipper ko wapas kar diya, magar parcel aap ke godown tak kabhi nahi pohncha.
- Tax katoti match nahi karti: couriers wusool shuda cash se tax kaat te hain, aur yeh raqam aap ke account par lagu rate ke mutabiq honi chahiye.
Tax ke baare mein: Taxation PK ke ek khulasay ke mutabiq digital tareeqe se order kiye gaye samaan par COD wusool karne wale couriers Income Tax Ordinance 2001 ke Section 6A ke tehat 2% income tax aur supply ki kul maaliyat par 2% sales tax lete hain. Aap par kaun sa rate lagu hai yeh aap ke tax status par depend karta hai, is liye apne accountant se poochein aur apna rate sheet mein likhein. Yahan maqsad sirf yeh dekhna hai ke jo kata woh us rate ke mutabiq hai, aur apne tax return ke liye record rakhna hai.
Template: yeh COD hisaab wali sheet Google Sheets mein copy karein
Ek Google Sheet banayein jis mein chaar tab hon aur un ke naam bilkul yehi hon: Rates, Orders, Settlement aur Summary, taake neeche diye formulas baghair tabdeeli ke chalein. Har courier ke liye alag sheet rakhein.
Tab 1, Rates. Column A mein label aur column B mein apne numbers likhein.
| Cell | Label (column A) | Column B mein kya likhein |
|---|---|---|
| B1 | Fi parcel forward charge | Apne rate card se, Rs mein |
| B2 | Fi delivered parcel COD fee | Apne rate card se, Rs mein |
| B3 | Fi return parcel return charge | Apne rate card se, Rs mein |
| B4 | Wusool shuda cash par tax rate | Aap par lagu kul rate, maslan 4% |
| B5 | Kitne din baad bina payment parcel ka peecha karein | Contract ka settlement waqt calendar dinon mein, aur chand din upar |
| B6 | Zyada charge ki gunjaish | Itne Rs ka farq jise ignore karein, maslan 10 |
Tab 2, Settlement. Jab bhi courier payment report bheje, us ki lines yahan paste karein, har tracking number ki ek line, is tarteeb mein: A tracking number, B payment ki date, C wusool shuda raqam, D shipping charge, E COD fee, F return charge, G kata hua tax, H net payment. Agar aap ke courier ki report mein columns alag hain to ek baar unhein is tarteeb mein kar lein aur yehi tarteeb rakhein.
Tab 3, Orders. Har bheje gaye parcel ki ek line. Column A se H khud ya order export se bharein: A order number, B tracking number, C booking ki date, D COD raqam, E status (Delivered, Returned, In transit ya Lost, English mein hi likhein taake formulas chalein), F status ki date, G product ki cost, H wapas mila (sirf return ke liye Y ya N). Phir line 2 mein yeh formulas likhein aur neeche tak drag kar dein:
| Column | Naam | Formula (line 2) |
|---|---|---|
| I | Payment report mein hai? | =COUNTIF(Settlement!A:A,B2)>0 |
| J | Courier ke mutabiq wusooli | =SUMIF(Settlement!A:A,B2,Settlement!C:C) |
| K | Kam payment | =IF(AND(E2="Delivered",I2),D2-J2,0) |
| L | Laga hua charge | =SUMIF(Settlement!A:A,B2,Settlement!D:D)+SUMIF(Settlement!A:A,B2,Settlement!E:E)+SUMIF(Settlement!A:A,B2,Settlement!F:F) |
| M | Asal mein kitna lagna chahiye | =IF(E2="Delivered",Rates!B1+Rates!B2,IF(E2="Returned",Rates!B1+Rates!B3,0)) |
| N | Zyada charge | =IF(I2,L2-M2,0) |
| O | Status ko kitne din hue | =IF(F2="","",TODAY()-F2) |
| P | Kya karna hai | =IF(AND(E2="Delivered",NOT(I2),O2>Rates!B5),"CHASE: not paid",IF(K2>0,"CHASE: short paid",IF(N2>Rates!B6,"CHECK: overcharged",IF(AND(E2="Returned",H2<>"Y",O2>7),"CHASE: return not received","")))) |
Agar aap ka courier COD fee sirf delivered parcel par nahi balke har shipment par leta hai to column M ke formula mein dono suraton mein Rates!B2 jama karein. Agar return forward rate par charge hota hai to B1 aur B3 mein ek hi number likhein.
Tab 4, Summary. Column A mein yeh label aur column B mein formulas likhein:
| Label | Formula |
|---|---|
| Delivered COD ki kul maaliyat | =SUMIF(Orders!E:E,"Delivered",Orders!D:D) |
| Wusool shuda net cash | =SUM(Settlement!H:H) |
| Delivered magar abhi payment nahi | =SUMIFS(Orders!D:D,Orders!E:E,"Delivered",Orders!I:I,FALSE) |
| In mein se late (peecha karna hai) | =SUMIFS(Orders!D:D,Orders!P:P,"CHASE: not paid") |
| Kul kam payment | =SUM(Orders!K:K) |
| Kul zyada charges | =SUMIF(Orders!N:N,">"&Rates!B6) |
| Na milne wale returns (cost par) | =SUMIFS(Orders!G:G,Orders!P:P,"CHASE: return not received") |
| Kata hua tax | =SUM(Settlement!G:G) |
| Aap ke rate par expected tax | =SUM(Settlement!C:C)*Rates!B4 |
Aakhir mein Orders ke column P par filter lagayein. CHASE se shuru hone wali har cheez filter karein to aap ke paas tracking numbers ki poori list hogi jo apne account manager ko bhejni hai.
Misaal: ek mahine ka hisaab milane se kya nikalta hai
Misaal (farzi numbers, asal courier rates ya kisi store ka data nahi). Ek seller ek courier se mahine mein 200 parcel bhejta hai. Har COD raqam Rs 3,000, product ki cost Rs 1,100, rate card ke mutabiq forward Rs 200, COD fee Rs 100 aur return Rs 200, aur tax rate 4% likha gaya hai. Mahina khatam hone ke teen hafte baad soorat-e-haal yeh hai: 160 delivered, 36 returned, 4 abhi raaste mein.
| Sheet ne kya pakra | Parcel | Rs |
|---|---|---|
| Delivered, kisi payment report mein nahi, peecha karne ki had se purane | 3 | 9,000 |
| Delivered, abhi report mein nahi, magar had ke andar | 5 | 15,000 (intezar) |
| Kam payment: Rs 3,000 ke parcel par Rs 2,500 wusool | 1 | 500 |
| Return par Rs 200 ki jagah Rs 250 charge | 36 | 1,800 |
| Tracking mein returned, 7 din baad bhi nahi mila (cost par) | 2 | 2,200 |
| Is mahine kul peecha karne wali raqam | 42 | 13,500 |
Rs 13,500 is misaal mein Rs 4,80,000 ki delivered COD maaliyat ka taqreeban 2.8% hai, aur yeh sirf is liye nazar aaya ke har parcel ko report se milaya gaya. Sirf bank transfer dekhne se is mein se kuch bhi nazar na aata.
Is misaal mein tax ki jaanch: payment wale 152 parcels par Rs 4,55,500 wusool hue (151 parcel Rs 3,000 ke aur ek Rs 2,500 ka). Rates mein likhe 4% par expected katoti Rs 18,220 banti hai. Agar reports mein kul raqam mukhtalif ho to courier se poochein ke aap ke account par kaun sa rate lag raha hai aur apne accountant se tasdeeq karein.
Hafta war tareeqa: har Monday 20 minute
- Pichle hafte courier ne jo bhi payment reports bhejin, download karein aur un ki lines Settlement tab ke neeche paste karein. Purani lines kabhi na mitayein; duplicate lines zyada charge ki soorat mein nazar aayengi, aur yeh bhi aap ko pata hona chahiye.
- Orders tab par status aur status ki date courier portal ya tracking export se update karein. Agar aap Leopards, PostEx, DEX, Daewoo ya Avix se bhejte hain to RabbitROI courier tracking khud ba khud update karta hai, jis se yeh column baghair copy kiye taaza rehta hai.
- Har return parcel jo waqai aap tak pohncha, use khol kar product check karne ke baad wapas mila column mein Y likhein.
- Column P mein CHASE aur CHECK filter karein. Tracking numbers ki list ek hi message mein apne account manager ko bhejein, har ek ke saath woh raqam jo aap ko milni chahiye.
- Har case uthane ki date notes column mein likhein. Agar do hafte mein case hal na ho to likh kar aage barhayein, aur gum hone wale parcels ka claim courier ki last date se pehle karein.
- Mahine mein ek baar Summary tab par kata hua tax aur expected tax milayein, aur us mahine ki payment reports apne accountant ke liye ek folder mein rakhein.
Woh ghaltiyan jo hisaab milane ko bekaar kar deti hain
- Tracking number ki jagah order number se milana. Couriers tracking number se report dete hain, aur ek order ke do parcel ho sakte hain.
- Cash ke liye tracking status par bharosa karna. Tracking mein delivered ka matlab hai rider ne nishaan lagaya; payment sirf payment report se saabit hoti hai.
- Sirf bank ka total dekhna. Total theek lag sakta hai jabke ek parcel ghaib ho aur doosra do baar gina gaya ho.
- Returns ko chhor dena. Jo return aap ko mila hi nahi woh gum shuda stock hai, aur agar chand din mein peecha na kiya to baad mein saabit karna bohat mushkil hota hai.
- Do couriers ko ek sheet mein mila dena. Rate card aur report ka andaaz mukhtalif hota hai, is liye har courier ki alag copy rakhein aur Summary ke totals jama kar lein.
- Mahine ke aakhir ka intezar karna. Hafta war jaanch se har case uthate waqt taaza hota hai, aur rider ya branch use abhi dhoond sakte hain.
Aam sawalat
COD payment ka hisaab milana kya hai?
Yeh har bheje gaye parcel ko courier ki payment reports se milana hai, taake pata chale kaun se delivered parcels ki payment aayi, kis ki kam aayi, kis par zyada charge laga ya payment aayi hi nahi, aur kaun se returns kabhi wapas nahi aaye.
Pakistan mein courier COD ke paise kitne din mein dete hain?
April 2026 ke ek rate muqablay mein andazan settlement Leopards ke liye 7 se 10 working din, TCS aur M&P ke retail accounts ke liye 7 se 14 working din, aur PostEx ke liye advance ya usi din likhi hai. Apna contract aur bank statement check karein.
Agar delivered parcel kisi payment report mein na ho to kya karun?
Contract ka settlement waqt guzarne ka intezar karein, phir tracking number, delivery ki date aur COD raqam likh kar apne courier account manager ko bhejein, aur case uthane ki date ka record rakhein.
Courier COD payment se kitna tax kaat ta hai?
Taxation PK ke khulasay ke mutabiq digital orders par wusool shuda cash par couriers Section 6A ke tehat 2% income tax aur 2% sales tax lete hain. Aap ka rate aap ke tax status par depend karta hai, is liye apne accountant se poochein.
Courier payment ka hisaab kitni baar milana chahiye?
Har hafte. Hafta war jaanch se cases itne taaza rehte hain ke courier unhein dhoond sake, jabke mahine baad jaanch mein teen chaar hafton ke parcels baghair dekhe reh jaate hain.
Comments
Abhi koi comment nahi. Pehla comment aap karein.