Marketplace books, reconciled to the rupee.
Match every order's payout against its sale, file GSTR-1 from your sales register, and post entries to TallyPrime without retyping. Reports are read in your browser.
- Works on reports exactly as the marketplace gives them, zip files included
- Excel with live formulas you can audit, not pasted values
- Sales, incl. GST
- 1,299.00
- Commission
- −142.89
- Logistics
- −71.00
- TCS · 0.5% of 1,100.85
- −5.50
- TDS · 194-O, 0.1%
- −1.10
- Receipt in settlement
- −1,078.51
- Net receivable
- 0.00
Nine tools, one workspace
Each company keeps its own workspace, Tally ledger names and saved work.
Reconcile Marketplace payouts
Every order's sales, returns, commission, logistics, TCS and TDS matched against what the marketplace paid. Then bank, fee invoice, TCS, TDS and ageing checks.
AmazonMyntraSwiggyZepto B2B ledgerInstamart B2B ledgerFlipkart · soonFirstCry · soonShopify · soon Reconcile payouts → sales.xlsx → GSTR1_072026.jsonSales to GSTR-1
Tally sales and credit note registers, the standard template or marketplace reports become the GSTR-1 file for each GSTIN: B2B, B2C large and small, credit notes, HSN summary split B2B/B2C, documents issued, and Table 14 for e-commerce operators. A Sales analysis tab reads any client's sales working and gives the month's MIS (channels, categories, India and export maps, SKUs, GST checks) as Excel with formulas and a PDF.
Portal JSONOffline Tool ExcelTally registersAmazon · Myntra · Flipkart · Meesho · ShopifyQuick commerce and food delivery Make GSTR-1 → vouchers.xlsx → Tally_Import.xmlExcel to TallyPrime
Sales and purchase invoices, credit and debit notes, bank statements with matching rules, journals, stock journals, and masters (groups, ledgers, units, stock items, cost centres), from one Excel template into TallyPrime.
Vouchers and mastersBank rulesChecked against your Tally Make Tally entries → invoice.pdf → invoices.xlsxPDF to Excel
Purchase and sales invoices as PDFs, scans or phone photos, marketplace commission invoices, bank statements of any bank (in common columns) or any PDF with tables, read into Excel: supplier, buyer, GSTINs, SKU, HSN, quantity, rate and CGST/SGST/IGST for every line, ready for Tally. Each invoice is checked against its own totals.
Purchase invoicesSales invoicesScans and photosFee invoicesBank statementsAny PDF table Convert PDFs → GSTR2B.xlsx + Purchase_Register.xlsx → ITC_reco.xlsxGSTR-2B to Books reconciliation
Your Tally purchase register and debit notes matched to GSTR-2B, invoice by invoice, for every GSTIN at once: matched, tax differences, invoices missing from 2B, 2B invoices not in your books, credit notes, RCM and ISD. Unclaimed invoices are carried forward month to month.
GSTR-2B and 2ATally registers as exportedSupplier-wise follow-up Reconcile ITC → TDS_working.xlsx → Form138 / Form140 for CompuTaxTDS returns for CompuTax
The quarter's TDS working and challans become CompuTax's import sheet for Form 138 (salary, old 24Q) or Form 140 (non-salary, old 26Q): the Challan sheet filled first, then every deductee row matched to the challan it was paid in, so each challan adds up exactly. Form 140 uses CompuTax's own layout with section codes, deductee codes and rates. Rows paid in the next month's challan are found and flagged. Change any match from the Challan Detail dropdown.
Form 138 · salaryForm 140 · non-salaryChallans auto-matchedIncome-tax Act 2025 Make TDS return → Cohort-Aug.xlsb + Sales_Register.xlsb → Cohort-Sep-26.xlsxCustomer cohorts
Last month's Amazon or Website cohort workbook and this month's sales register become the updated cohort file: revenue, customer and order cohorts by first-purchase month, credit notes cancelled against their invoice and financial year, Amazon buyer e-mails filled from the order and fulfilment reports, with live Microsoft 365 formulas.
AmazonWebsiteRevenue · customers · ordersLive formulas Update cohorts → salary sheet.xlsx → payslips + ECR + ESIC + TDSPayroll
Salary structures, PF, ESI, professional tax and labour welfare fund for every state and union territory, income tax under the old and new regime with monthly TDS, payslips with your logo emailed to each employee, the EPFO ECR and ESIC upload files, PT and LWF workings and a compliance calendar. Import your existing salary sheets.
36 states & UTsOld & new regimeECR · ESICPayslips by email Run payroll → sales + GRN + closing stock → SKU-wise COGS by channelStock & COGS
Opening plus purchases less closing stock, SKU by SKU, matched to units sold (combos split into their components), with direct expenses, the Tally purchase difference and packing material from your BOM loaded on. COGS and gross margin by month, channel, category and SKU, unsold-stock checks, and a full stock costing workbook with live formulas.
Any sales layoutCombos & BOMChannel P&LLive formulas Work out COGS →From seller panel to filed return
- Download the reportsMTR and settlement reports from Amazon Seller Central; GSTR and settlement reports from the Myntra partner portal; or your own sales register.
- Drop them inWhole folders or zip files. Months and report types are read from names and contents, and you can correct them before running.
- Review, then downloadExceptions first, then Excel with live formulas, the GSTR-1 JSON and TallyPrime XML. Nothing is filed or posted until you do it.
Reports are read inside your browser tab. Only what you choose to keep, and your saved reconciliations, are stored in your workspace.
Loading Reconova…