Flipkart Settlement Report को Tally में कैसे Reconcile करें – Complete Guide
Is complete guide mein hum simple Hindi + English mein step-by-step samjhenge ki Flipkart Settlement Report ko Tally mein kaise reconcile karein. Yeh article Indian sellers, accountants aur Tally users ke liye practical banaya gaya hai.
Flipkart Settlement Report Kya Hota Hai?
Flipkart Settlement Report woh detailed statement hai jo Flipkart Seller Hub se download hota hai. Isme dikhta hai:
- Gross Sales (customer se kitna payment aaya)
- Flipkart Commission
- Shipping Fees / Collection Fees
- Returns aur Refunds
- TCS (Tax Collected at Source)
- Other deductions / recovery
- Net Amount jo aapke bank account mein settle hua
Yeh report aapke bank mein aaye amount se match honi chahiye. Is process ko Flipkart Settlement Reconciliation kehte hain.
Flipkart Settlement Ka Flow Samjhein
Customer Payment → Flipkart → Commission + Fees + TCS + Returns → Net Settlement → Aapka Bank Account
 |
Flipkart Settlement Ka Flow Samjhein |
Jab customer Flipkart par order karta hai aur payment karta hai, to poora paisa Flipkart ke paas jata hai. Phir Flipkart apni commission, shipping charges, returns adjust karta hai aur baaki net amount aapke registered bank account mein bhej deta hai.
Tally mein Kaunse Ledgers Banane Chahiye
Reconciliation start karne se pehle TallyPrime mein yeh ledgers banayein:
- Flipkart Clearing A/c – Current Assets ke under (temporary control account)
- Flipkart Commission A/c – Indirect Expenses ke under
- Shipping / Collection Charges A/c – Indirect Expenses
- TCS Receivable / TCS on Sales A/c – Duties & Taxes ya Current Assets
- Sales Return A/c – Sales Accounts ke under
- Bank A/c – Bank Accounts
- Sales A/c – Sales Accounts
Agar aap GST registered hain to Input CGST, Input SGST ya Input IGST ledgers bhi ready rakhein (agar Flipkart kisi service par GST charge karta hai).
Flipkart Settlement Report Download Kaise Karein
- Flipkart Seller Hub mein login karein
- Payments section mein jayein
- Settlements par click karein
- Desired period select karein
- Settlement Report (Excel/CSV) download karein
Is report mein Order ID, Payment Date, Gross Amount, Commission, Fees, TCS, Net Payable sab clearly dikhta hai.
Accounting Entries – Practical Example
Samajhne ke liye ek illustrative example lete hain (yeh sirf samjhane ke liye hai, asli figures aapke report se alag honge):
- Gross Sales = ₹50,000
- Flipkart Commission = ₹7,500
- Shipping / Other Fees = ₹1,200
- TCS (1% approx) = ₹500
- Returns / Adjustments = ₹2,000
- Net Settlement Bank mein aaya = ₹38,800
1. Jab Sales Recognise Karein (Gross Sales)
| Particulars | Debit (₹) | Credit (₹) |
|---|---|---|
| Flipkart Clearing A/c | 50,000 | |
| To Sales A/c | 50,000 |
Is entry se aapki full sales books mein aa jati hai.
2. Jab Settlement Bank Mein Aaye
| Particulars | Debit (₹) | Credit (₹) |
|---|---|---|
| Bank A/c | 38,800 | |
| Flipkart Commission A/c | 7,500 | |
| Shipping / Collection Charges A/c | 1,200 | |
| TCS Receivable A/c | 500 | |
| Sales Return A/c | 2,000 | |
| To Flipkart Clearing A/c | 50,000 |
 |
Sample Journal Entries for Flipkart Settlement |
Is entry se Flipkart Clearing account clear ho jata hai aur saari deductions alag-alag ledgers mein chali jati hain.
Step-by-Step Reconciliation Process in Tally
- Flipkart Settlement Report download karein
- Bank Statement download karein (jis period ka settlement aaya hai)
- Tally mein Flipkart Clearing ledger ka balance check karein
- Settlement report ke Gross Amount ko Sales se match karein
- Commission, Fees, TCS aur Returns ko alag-alag ledger mein post karein
- Net Amount ko Bank A/c mein debit karein
- Flipkart Clearing A/c ka balance zero hona chahiye (ya pending settlements explain hone chahiye)
- Agar koi difference aaye to report mein Order ID se check karein
TCS ka Treatment
Flipkart kai cases mein TCS (Tax Collected at Source) kaat’ta hai. Yeh amount aapke PAN par reflect hota hai. TCS ko TCS Receivable ledger mein debit karein. Baad mein Income Tax return file karte waqt iska credit le sakte hain. TCS ko expense mat banaein.
Returns aur Refunds Kaise Handle Karein
Jab customer return karta hai, to Flipkart us amount ko future settlements se adjust kar deta hai. Sales Return A/c mein debit karein aur Flipkart Clearing A/c mein credit karein. Original sale already record ho chuki ho to return entry alag se pass karein.
Common Mistakes Jo Sellers Karte Hain
- Sirf bank mein aaye net amount ko Sales maan lena
- Commission aur Fees ko Sales se directly adjust kar dena
- TCS ko ignore karna
- Flipkart Clearing account na banana
- Har settlement ko bank statement se match na karna
- Returns ko properly record na karna
- Mahine ke end mein reconciliation na karna
Monthly Flipkart Settlement Reconciliation Checklist
- Seller Hub se Settlement Report download kiya?
- Bank Statement se net credit match kiya?
- Gross Sales books mein record hua?
- Commission alag expense mein gaya?
- Shipping / Collection fees record hui?
- TCS Receivable mein dikha?
- Returns properly adjust hue?
- Flipkart Clearing ledger balance clear hai?
- Koi unexplained difference to nahi bacha?
 |
Simple checklist graphic titled Monthly Flipkart Settlement Reconciliation Checklist |
Key Takeaways
- Hamesha Gross Sales record karein, net settlement ko sales mat samjhein.
- Flipkart Clearing account use karein – control easy rehta hai.
- Commission, Fees, TCS aur Returns ko alag-alag ledgers mein rakhein.
- Har settlement ko bank statement se zaroor match karein.
- Mahine ke end mein complete reconciliation karein taaki books clean rahein.
Frequently Asked Questions
1. Flipkart Settlement Report kahan se download karein?
Flipkart Seller Hub → Payments → Settlements section se Excel/CSV report download kar sakte hain.
2. Kya net bank amount ko Sales maan sakte hain?
Nahi. Net amount mein commission, fees, TCS aur returns already adjust ho chuke hote hain. Gross Sales alag se record karein.
3. Tally mein Flipkart Clearing account kyun banate hain?
Yeh temporary control account hai. Isse aap dekh sakte hain ki kitna paisa abhi settle hona baaki hai aur reconciliation easy ho jati hai.
4. TCS ko expense mein daal sakte hain kya?
Nahi. TCS ko TCS Receivable mein rakhein. Yeh aapka tax credit hai, expense nahi.
5. Agar Settlement Report aur Bank Amount match na ho to kya karein?
Order ID wise check karein. Kabhi-kabhi delayed settlement, partial settlement ya recovery amount difference create karta hai.
6. Returns ka entry kaise karein?
Sales Return A/c Debit aur Flipkart Clearing A/c Credit. Agar commission bhi reverse hua ho to uska bhi adjustment karein.
7. Kitni baar reconciliation karni chahiye?
Ideal yeh hai ki har settlement aane par karein. Kam se kam mahine mein ek baar full reconciliation zaroor karein.
8. Multiple settlements ek saath aaye to kaise handle karein?
Har settlement report ko alag-alag process karein ya combined entry mein details note karke rakhein taaki audit mein problem na aaye.
Practical Insight: Yeh explanation real accounting experience par based hai aur common mistakes ko dhyan me rakhkar simplify kiya gaya hai.
👤 About the Author
Vaibhav Rajapkar is an accounting and GST professional with 7+ years of practical experience in taxation, bookkeeping, and financial management.
He shares easy-to-understand guides on GST, Income Tax, TDS, and Business Finance to help beginners, freelancers, and small business owners manage their finances better.
Connect with him:
