Filed under: things that eat your month-end
Guides for GSTR‑1 and bank statements
Plain, checked explanations for CA firms and online sellers: which marketplace report goes where in GSTR-1, how to get a bank statement PDF into Excel or Tally, and the rules that changed recently.
Latest · GSTR-1 & e-commerce
GSTR-1 for e-commerce sellers: a table-by-table guide
Which GSTR-1 tables marketplace sales go into, how returns and TCS work, what Table 14 asks for, the due dates, and the mistakes that lead to GST notices.
Read the guide →- Sales to consumers go to B2CS (Table 7), grouped by the customer's state and the tax rate, net of returns. Inter-state invoices above ₹1 lakh to unregistered buyers go to B2CL (Table 5).
- Sales to GST-registered buyers go invoice by invoice to B2B (Table 4A), and their returns go as credit notes in Table 9B.
- Table 14 repeats your marketplace sales per e-commerce operator GSTIN. It is a disclosure and adds no extra tax.
GSTR-1 & e-commerce
GSTR-1 & e-commerceGSTR-1 for e-commerce sellers: a table-by-table guideWhich GSTR-1 tables marketplace sales go into, how returns and TCS work, what Table 14 asks for, the due dates, and the mistakes that lead to GST notices.7 November 2026GSTR-1 & e-commerceAmazon MTR report to GSTR-1: B2C and B2B, step by stepHow to download Amazon's Merchant Tax Reports (MTR B2C and B2B) and turn them into GSTR-1: B2CS by state, B2B invoices, refunds, HSN and Table 14.7 November 2026GSTR-1 & e-commerceMeesho GST report: how to download it and file GSTR-1Which files are in Meesho's monthly GST report, how forward minus reverse becomes B2CS, where invoices and adjustments fit, and mistakes to avoid.7 November 2026GSTR-1 & e-commerceB2B, B2CL or B2CS? Where each sale goes in GSTR-1A three-question test for putting any sale in GSTR-1: B2B, B2CL or B2CS, with the ₹1 lakh B2CL limit, worked examples and credit notes.7 November 2026
Bank statements
Bank statementsHow to convert a bank statement PDF to Excel, and prove it's rightThree ways to turn a bank statement PDF into Excel, why copy-paste breaks, and the one balance formula that shows whether every transaction came across.7 November 2026Bank statementsHow to import a bank statement into TallyPrimeTwo ways to get bank transactions into TallyPrime: the bank statement import for reconciliation, and an XML voucher import, plus fixes for the usual errors.7 November 2026Bank statementsPassword-protected bank statement PDF? How to open, unlock and convert itWhere to find a bank statement PDF's password, how to remove it from your own copy on Windows, Mac or the command line, and how to convert it safely.7 November 2026Bank statementsBank reconciliation in TallyPrime, step by stepHow to reconcile a bank account in TallyPrime: manual bank dates, auto reconciliation from an imported statement, reading the BRS and clearing what's left.7 November 2026Bank statementsPayment, Receipt, Contra or Journal: the right Tally voucher for every bank entryWhen to use Payment (F5), Receipt (F6), Contra (F4) or Journal (F7) for bank statement entries in Tally, with a reference table for 18 everyday transactions.7 November 2026Bank statementsUPI, NEFT, NACH and the rest: mapping bank transactions to Tally ledgersWhat common Indian bank transaction types mean, which Tally ledger each usually belongs to, and how a per-client ledger map speeds up month-end entries.7 November 2026Bank statementsTally XML for bank vouchers: the format, a working example and the usual errorsWhat a Tally XML file for bank entries contains, a sample Payment and Receipt voucher read line by line, the debit/credit sign rule, and import fixes.7 November 2026Bank statementsMarketplace payout entries in Tally: sales, fees, TCS, TDS and the bank creditHow to record an Amazon, Flipkart or Meesho payout in Tally: gross sales, returns, fees with GST, GST TCS, 194-O TDS and the bank receipt, with an example.7 November 2026Bank statementsTallyPrime vs Tally.ERP 9: how importing bank entries differsWhere the import menus are, which file types each version accepts, what changed in TallyPrime 4.0, and how to handle clients split across both versions.7 November 2026Bank statementsMonth-end bank entries: a checklist for CA firms with many clientsA repeatable month-end routine for posting client bank statements to Tally: collect, check, classify, import, reconcile, close and review, with a tracker.7 November 2026
Skip the spreadsheet work
FileKey turns marketplace reports into GSTR-1 and bank statement PDFs into Excel or Tally XML. Free to try.