Myntra Seller Reconciliation Help | Queshift Accounting, Tally, BUSY & GST Guide

1. How to start Myntra

When Myntra is opened from the main Queshift dashboard, the company is already selected in Queshift. Myntra opens directly for that company. A second company-selection box is not shown.

If the developer/network test BAT is run directly, a company-selection box may appear. That is only for direct testing.

Saved settings: B2B/B2C, HSN/SKU mode, selected period, Tally/BUSY mode, State and Report Type stay saved until you change them.

2. Daily working sequence

IMPORT → import SALE first → RTO → RT → Process & Save.
VALIDATION → resolve State mapping and HSN/GST/Item errors.
GENERATE → select Real Invoice Wise, State Wise or Order Wise.
GENERATE TALLY or GENERATE BUSY.
Import Settlement / Unsettlement and run RECONCILIATION.
Review P&L, BI, TCS, Settlement Audit and GST Preview/JSON.

3. What each report mode does

Real Invoice Wise

Uses actual marketplace invoice/CN numbers and actual transaction dates. No custom invoice series is asked.

State Wise

Transactions for the selected month are grouped State-wise. A State uses the same generated invoice until the taxable invoice limit is reached; then the next invoice number is used. Tally/BUSY voucher date is the last date of that month. Reporting and analysis still use real dates.

Order Wise

Generated invoice series is applied Order-wise. RTO and RT are two reporting categories but accounting/GST/Tally/BUSY treats both as one RETURN stream.

HSN mode: inside the same generated State/Order invoice, same HSN + GST rate is merged into one item line. Qty, Taxable, GST and TCS are totalled. Narration contains all underlying marketplace invoice/CN numbers.

4. Validation errors and solutions

Error / Message	Meaning	What you should do
STATE MAPPING REQUIRED	The State name in the marketplace report is not yet linked to your Tally/BUSY State.	Open Validation. Select the correct searchable Tally State and BUSY State, save mapping, then validate again.
HSN MISSING - SALE LOOKUP REQUIRED	RTO/RT does not contain HSN and the software could not reliably find the matching SALE record.	Check Order ID, Packet ID and SKU. In the HSN review window accept the software suggestion or correct the HSN. Save mapping for future use.
HSN / GST RATE MISMATCH	Report HSN/GST does not match the saved Item Master.	Review HSN, GST rate and SKU/order. Correct only if required, then save mapping. Every final transaction must have a valid Item Name.
ITEM NAME BLANK / NOT FOUND	The software could not create or identify a valid accounting item.	Run Validation and resolve the shown HSN/SKU/GST combination. Do not generate the accounting report until Item Name is valid.
DUPLICATE / ALREADY IMPORTED	The same source transaction/file record appears to have been imported before.	Do not import the same report twice unless you intentionally want to replace/regenerate it. Check month/file before proceeding.
REPORT ALREADY GENERATED	The same month/report mode already exists.	Choose YES only when you want a fresh regeneration. Old generated rows are replaced and the original State/Order series is reused.
NO GENERATED REPORT ROWS	Tally/BUSY export has no current generated report.	Run Validation → Generate first, then export.
JOURNAL MAPPING REQUIRED	A required Tally/BUSY GST ledger or Journal setting is blank.	Open Client Settings → Tally Journal or BUSY Journal, fill the requested ledger/field and save.
PDF HEAD / LEDGER NOT MAPPED	A PDF bill description has no saved accounting ledger/head.	Open PDF Expense view, select the correct expense head/Tally ledger/BUSY ledger and save mapping.
NETWORK SERVER OFFLINE / UNREACHABLE	The client cannot reach the Queshift database server.	Confirm both PCs are on the same LAN/Wi-Fi, server PC is ON, then use Network Connection Check. If needed ask the office administrator to restart QueshiftDBServer.
NETWORK KEY PERMISSION DENIED	The local Queshift security key cannot be read.	Use the approved Queshift Network Client setup/repair. Do not create or replace the key manually.
TALLY EXPECTED TAX / MODIFIED TAX MISMATCH	Tally found a paise-level tax difference.	Use the latest Queshift version, regenerate that month and re-import the fresh Tally file. If the same voucher still appears, note the voucher number and contact support.

5. Settlement and Reconciliation

100% SETTLED
Expected and received amount matched within tolerance.

PENDING / UNSETTLED
Not paid, partially paid, short paid, unsettled or missing settlement.

SUSPENSE / UNMATCHED
Settlement exists but a reliable imported SALE/order match was not found.

Negative values are important. A return/RTO/RT deduction stays negative. Example: Expected Payout -673.86 means this amount is deducted from your payment; it must reduce total pending, not increase it.

If marketplace Expected Payout is missing, Queshift calculates a transparent estimate using saved rules/history and shows the source/confidence.

6. P&L / BI / TCS / GST

P&L: Gross Sale, RT, RTO, Net Sale, Commission %, Shipping %, Fixed Fee %, Other Marketplace Fees, Expected/Received/Pending, TCS/TDS, Purchase Cost, Packaging, Advertising, Warehousing, PDF bill charges and Final True Profit/Loss.

BI: Top 10 SKU, Top 10 full State names, return %, graphs, reconciliation accuracy and suggestions.

TCS: State-wise and HSN-wise totals with Create Excel.

GST Preview: Summary, B2C State, B2B, CDNR, HSN, Documents → Create Excel / Create JSON.

7. Tally Journal and BUSY Journal

Tally Journal and BUSY Journal are independent. Changing BUSY Journal settings does not change Tally Journal settings.

Client Settings lets you save different IGST/CGST/SGST ledgers, Cash/Party A/C, Voucher Type, Sheet Name and Excel headers for Tally and BUSY.

CASH TOTAL is the full invoice amount including GST.

8. Keyboard shortcuts

The shortcut letter is underlined on the dashboard button. Press Ctrl + underlined letter for the main actions.

Action	Shortcut	Action	Shortcut
Import	Ctrl+I	Generate	Ctrl+G
Generate Tally	Ctrl+T	Generate BUSY	Ctrl+B
Reconciliation	Ctrl+R	P&L	Ctrl+P
Journal Export	Ctrl+J	Export Report	Ctrl+E
Help	F1

9. Network connection check

If Myntra shows Network Offline/Unreachable:

Check the server PC is ON.
Check both systems are connected to the same office network.
Open the Queshift Network connection tool/profile if provided by your office.
Do not open or copy MYTDatabase.db manually.

1. Myntra kaise start hoga

Jab Myntra Main Queshift ke dashboard se open hoga, company Queshift me pehle hi select ho chuki hogi. Myntra same company me direct open hoga. Dobara company wala box nahi aayega.

Agar developer/network test BAT direct run karoge to company selection box aa sakta hai. Wo sirf direct testing ke liye hai.

Saved settings: B2B/B2C, HSN/SKU, period, Tally/BUSY, State aur Report Type tab tak same rahenge jab tak client khud change na kare.

2. Daily working ka correct sequence

IMPORT → sabse pehle SALE → phir RTO → phir RT → Process & Save.
VALIDATION → State mapping, HSN, GST Rate aur Item Name errors solve karo.
GENERATE → Real Invoice Wise / State Wise / Order Wise select karo.
GENERATE TALLY ya GENERATE BUSY.
Settlement aur Unsettlement import karke RECONCILIATION run karo.
P&L, BI, TCS, Settlement Audit aur GST Preview/JSON check karo.

3. Report modes ka matlab

Real Invoice Wise

Marketplace ka actual invoice/CN number aur actual date use hoti hai. Custom invoice number nahi poocha jata.

State Wise

Selected month ka data State ke according group hota hai. Ek State ka same invoice tab tak chalta hai jab tak taxable invoice limit cross na ho; uske baad next invoice number lagta hai. Tally/BUSY date month ki last date hoti hai, lekin reporting me real date hi consider hoti hai.

Order Wise

Generated invoice series Order ke according use hoti hai. RTO aur RT reporting me alag dikh sakte hain, lekin GST/Tally/BUSY/accounting me dono RETURN ka part hain.

HSN mode: same generated State/Order invoice me same HSN + same GST rate ki Qty, Taxable, GST aur TCS ek line me total hoti hai. Narration me sab actual marketplace invoice/CN numbers aate hain.

4. Validation errors aur unka solution

Error	Iska matlab	Kya karna hai
STATE MAPPING REQUIRED	Report ka State abhi Tally/BUSY State se map nahi hai.	Validation me correct Tally State aur BUSY State searchable dropdown se select karo, Save Mapping karo, phir Validation dobara run karo.
HSN MISSING - SALE LOOKUP REQUIRED	RTO/RT me HSN nahi mila aur SALE se reliable match nahi bana.	Order ID, Packet ID aur SKU check karo. Software ka suggested HSN accept ya correct karo. Save Mapping karne par future me automatically use hoga.
HSN / GST RATE MISMATCH	Report ka HSN/GST saved Item Master se match nahi kar raha.	HSN, GST Rate, SKU/Order ko review karo. Correct mapping save karo. Final report me Item Name blank nahi hona chahiye.
ITEM NAME BLANK / NOT FOUND	Valid accounting item create/find nahi hua.	Validation error window me HSN/SKU/GST combination resolve karo. Jab tak Item Name valid na ho Generate mat karo.
DUPLICATE / ALREADY IMPORTED	Same source transaction/report pehle import ho chuka lag raha hai.	Same file ko dobara import mat karo. Agar report replace karni hai to correct month/report confirm karke regenerate karo.
REPORT ALREADY GENERATED	Same month/report pehle se bana hua hai.	YES tab karo jab fresh regenerate karna ho. Old generated rows replace hongi, append duplicate nahi hoga aur original series reuse hogi.
NO GENERATED REPORT ROWS	Tally/BUSY export ke liye report generate nahi hai.	Validation → Generate → phir Tally/BUSY.
JOURNAL MAPPING REQUIRED	Tally/BUSY Journal ka required GST ledger ya setting blank hai.	Client Settings → Tally Journal ya BUSY Journal me requested field bhar ke Save karo.
PDF HEAD / LEDGER NOT MAPPED	PDF bill description ka expense head/ledger save nahi hai.	PDF Expense view me correct head, Tally Ledger aur BUSY Ledger select karke Save Mapping karo.
NETWORK SERVER OFFLINE / UNREACHABLE	Client Queshift DB Server tak nahi pahunch raha.	Server PC ON hai? Same LAN/Wi-Fi hai? Network Connection Check use karo. Zarurat par office admin se server restart karwao.
NETWORK KEY PERMISSION DENIED	Queshift security key read nahi ho rahi.	Approved Network Client setup/repair use karo. Key ko manually replace/create mat karo.
TALLY EXPECTED TAX / MODIFIED TAX MISMATCH	Tally ko paise level tax difference mila.	Latest Queshift me same month ko YES Regenerate karo aur fresh Tally file import karo. Same voucher fir bhi aaye to voucher no. note karke support ko do.

5. Settlement / Unsettlement / Reconciliation

100% SETTLED
Expected aur Received tolerance ke andar match.

PENDING / UNSETTLED
Unpaid, short-paid, partially paid, unsettled ya missing settlement.

SUSPENSE / UNMATCHED
Settlement mila lekin imported SALE/order se reliable match nahi mila.

Negative value ko positive mat samjho. Return/RTO/RT deduction negative hi rahega. Example -673.86 ka matlab payment se ₹673.86 cut hona hai; ye total Pending ko reduce karega.

Agar marketplace Expected Payout missing ho to Queshift saved charge rules/history se transparent estimate banata hai aur source/confidence show karta hai.

6. P&L, BI, TCS aur GST

BI: Top 10 SKU, Top 10 full State names, Return %, graphs, Reconciliation Accuracy aur suggestions.

TCS: State Wise + HSN Wise total with Create Excel.

GST: Summary, B2C State, B2B, CDNR, HSN, Documents → Create Excel / Create JSON.

7. Tally Journal aur BUSY Journal

Dono ki mapping alag save hoti hai. BUSY Journal me change karne se Tally Journal change nahi hoga.

Client Settings me IGST/CGST/SGST Ledger, Cash/Party A/C, Voucher Type, Sheet Name aur Excel headers alag-alag save kar sakte ho.

CASH TOTAL = full invoice total including GST.

8. Shortcut

Dashboard button me shortcut letter underline hoga. Main shortcuts ke liye Ctrl + underlined letter press karo.

Kaam	Shortcut	Kaam	Shortcut
Import	Ctrl+I	Generate	Ctrl+G
Tally	Ctrl+T	BUSY	Ctrl+B
Reconciliation	Ctrl+R	P&L	Ctrl+P
Journal Export	Ctrl+J	Export Report	Ctrl+E
Help	F1

1. Myntra कैसे शुरू होगा

जब Myntra मुख्य Queshift Dashboard से खुलेगा, कंपनी Queshift में पहले ही चुनी जा चुकी होगी। Myntra उसी कंपनी में सीधे खुलेगा। दूसरी बार Company Selection बॉक्स नहीं आएगा।

यदि Developer/Network Test BAT सीधे चलाया जाता है तो Company Selection बॉक्स आ सकता है। वह केवल परीक्षण के लिए है।

सेटिंग सुरक्षित रहती है: B2B/B2C, HSN/SKU, अवधि, Tally/BUSY, State और Report Type तब तक नहीं बदलते जब तक उपयोगकर्ता स्वयं न बदले।

2. रोज़ का सही कार्य क्रम

IMPORT → पहले SALE → फिर RTO → फिर RT → Process & Save.
VALIDATION → State Mapping, HSN, GST Rate और Item Name की त्रुटियाँ ठीक करें।
GENERATE → Real Invoice Wise / State Wise / Order Wise चुनें।
GENERATE TALLY या GENERATE BUSY.
Settlement और Unsettlement Import करके RECONCILIATION चलाएँ।
P&L, BI, TCS, Settlement Audit और GST Preview/JSON देखें।

3. Report Mode का अर्थ

Real Invoice Wise

Marketplace का वास्तविक Invoice/CN Number और वास्तविक Date उपयोग होती है। Custom Invoice Series नहीं पूछी जाती।

State Wise

चुने हुए महीने के Transaction State के अनुसार समूहित होते हैं। Taxable Invoice Limit तक एक ही State Invoice चलता है; Limit पार होने पर अगला Invoice Number लगता है। Tally/BUSY Voucher Date महीने की अंतिम तारीख होती है, लेकिन Reporting में वास्तविक तारीख उपयोग होती है।

Order Wise

Generated Invoice Series Order के अनुसार लगती है। RTO और RT Reporting में अलग दिख सकते हैं, लेकिन GST/Tally/BUSY/Accounting में दोनों RETURN का भाग हैं।

HSN Mode: एक ही Generated State/Order Invoice में समान HSN + समान GST Rate की Qty, Taxable, GST और TCS एक पंक्ति में Total होती है। Narration में सभी वास्तविक Marketplace Invoice/CN Number आते हैं।

4. Validation Error और समाधान

त्रुटि	अर्थ	समाधान
STATE MAPPING REQUIRED	Report का State अभी Tally/BUSY State से जुड़ा नहीं है।	Validation में सही Tally State और BUSY State चुनकर Save Mapping करें, फिर Validation दोबारा चलाएँ।
HSN MISSING - SALE LOOKUP REQUIRED	RTO/RT में HSN नहीं मिला और SALE से भरोसेमंद Match नहीं बना।	Order ID, Packet ID और SKU जाँचें। Software का सुझाया HSN स्वीकार या सही करें और Mapping Save करें।
HSN / GST RATE MISMATCH	Report का HSN/GST Saved Item Master से मेल नहीं खा रहा।	HSN, GST Rate, SKU/Order जाँचकर सही Mapping Save करें। Final Report में Item Name खाली नहीं होना चाहिए।
ITEM NAME BLANK / NOT FOUND	Valid Accounting Item नहीं मिला/बना।	Validation में HSN/SKU/GST Combination ठीक करें। Item Name सही होने से पहले Generate न करें।
DUPLICATE / ALREADY IMPORTED	वही Source Transaction/Report पहले Import हो चुका है।	एक ही File दोबारा Import न करें। Replace करना हो तो सही Month/Report चुनकर Regenerate करें।
REPORT ALREADY GENERATED	उसी महीने की Report पहले से बनी हुई है।	Fresh Report चाहिए तो YES चुनें। पुरानी Generated Rows Replace होंगी, Duplicate Append नहीं होगा।
NO GENERATED REPORT ROWS	Tally/BUSY Export के लिए Generated Report नहीं है।	Validation → Generate → फिर Tally/BUSY.
JOURNAL MAPPING REQUIRED	Required GST Ledger या Journal Setting खाली है।	Client Settings → Tally Journal या BUSY Journal में मांगी गई Setting भरकर Save करें।
PDF HEAD / LEDGER NOT MAPPED	PDF Bill Description का Expense Head/Ledger Save नहीं है।	PDF Expense View में सही Head, Tally Ledger और BUSY Ledger चुनकर Save Mapping करें।
NETWORK SERVER OFFLINE / UNREACHABLE	Client Queshift DB Server तक नहीं पहुँच पा रहा।	Server PC चालू रखें, दोनों PC एक ही LAN/Wi-Fi पर हों, फिर Network Connection Check करें।
NETWORK KEY PERMISSION DENIED	Queshift Security Key पढ़ी नहीं जा रही।	Approved Network Client Setup/Repair उपयोग करें। Key को Manual Replace/Create न करें।
TALLY EXPECTED TAX / MODIFIED TAX MISMATCH	Tally को Tax में Paise-Level अंतर मिला।	Latest Queshift में उसी Month को YES Regenerate करें और नई Tally File Import करें। वही Voucher फिर आए तो Voucher Number Support को दें।

5. Settlement और Reconciliation

100% SETTLED
Expected और Received राशि निर्धारित Tolerance में Match है।

PENDING / UNSETTLED
Unpaid, Short Paid, Partially Paid, Unsettled या Missing Settlement.

SUSPENSE / UNMATCHED
Settlement मिला लेकिन Imported SALE/Order से विश्वसनीय Match नहीं मिला।

Negative Value महत्वपूर्ण है। Return/RTO/RT Deduction Negative ही रहेगा। उदाहरण -673.86 का अर्थ Payment से ₹673.86 कटना है; यह कुल Pending को कम करेगा।

6. P&L, BI, TCS और GST

BI: Top 10 SKU, Top 10 पूरे State Names, Return %, Graph, Reconciliation Accuracy और Suggestions.

TCS: State Wise और HSN Wise Total with Create Excel.

GST: Summary, B2C State, B2B, CDNR, HSN, Documents → Create Excel / Create JSON.

7. Tally Journal और BUSY Journal

दोनों की Mapping अलग-अलग Save होती है। BUSY Journal बदलने से Tally Journal नहीं बदलेगा।

Client Settings में IGST/CGST/SGST Ledger, Cash/Party A/C, Voucher Type, Sheet Name और Excel Headers अलग-अलग Save किए जा सकते हैं।

CASH TOTAL = GST सहित पूरी Invoice Amount.

8. Shortcut

Dashboard Button में Shortcut Letter Underline रहेगा। मुख्य कार्यों के लिए Ctrl + Underlined Letter दबाएँ।

कार्य	Shortcut	कार्य	Shortcut
Import	Ctrl+I	Generate	Ctrl+G
Tally	Ctrl+T	BUSY	Ctrl+B
Reconciliation	Ctrl+R	P&L	Ctrl+P
Journal Export	Ctrl+J	Export Report	Ctrl+E
Help	F1