GSTR-1 and GSTR-3B data, GSTR-2B match and bill of supply
For Indian entities: a month's GSTR-1 sheets and GSTR-3B summary as one Excel workbook for your accountant. Match the GSTR-2B against your supplier bills, and print bills of supply as a composition dealer.
PLANSEvery plan
Built; not yet tried end to end at a customer. Check the figures against the GST portal before filing.
The problem it solves
- Every month the accountant asks for the sales register, sorted by B2B, B2C and HSN, and someone spends two days on it.
- Input tax credit is claimed on supplier bills that the supplier never uploaded.
- A supplier's bill in the 2B is missing from your books, and the credit is lost.
- A composition dealer's bill goes out titled Tax Invoice.
How it works
- Post bills, returns and supplier bills with the right GST on each line, as you work.
- Open Trade > Reports > Tax and Accounts > GST Returns Data, choose the entity and the period (this month to start with), and press Make Workbook.
- Download the workbook: one sheet per GSTR-1 section, the HSN summary, the GSTR-3B summary and input tax credit bill by bill. Your accountant checks it against the portal and files.
- Download the GSTR-2B JSON from the GST portal. Open GSTR-2B Match, upload it and press Match.
- Read the result: bills in the 2B not in your books, bills with a different amount, and bills in your books not in the 2B.
- A composition dealer ticks Composition Dealer in Trade settings, and bills print headed Bill of Supply.
Everything it does
GSTR-1 sheets
- B2B: registered buyers
- B2CL: inter-state sales to unregistered buyers above Rs 1,00,000
- B2CS: other sales to unregistered buyers, by place of supply and rate
- EXP: exports and SEZ
- CDNR and CDNUR: credit and debit notes to registered and unregistered buyers
- HSN summary with tax by kind; an IRN column where bills were e-invoiced
GSTR-3B summary
- 3.1 (a) taxable outward supplies, (b) zero-rated, (c) nil rated and exempt, (d) inward supplies on reverse charge
- 4 (A) input tax credit, reverse charge and all other; 4 (C) net ITC
- Output tax less ITC before the portal's set-off order
- Input tax credit bill by bill on its own sheet
GSTR-2B match
- Reads the B2B invoices of the 2B JSON
- Matches on the supplier's GSTIN and the bill reference you entered on the supplier bill
- In 2B, not in our books; Different amount (more than Rs 1 apart); In our books, not in 2B
- Enter the supplier's bill number as the reference on every supplier bill, or nothing matches
- Credit notes in the 2B are not matched yet, and tax is compared through the bill total
Bill of supply
- Composition Dealer in Trade > Configuration > General > Settings > Billing: off to start with
- On, customer bills print headed Bill of Supply, with the composition line
- The setting changes the heading only: keep GST off your items so no tax is charged
Rate-wise figures
- Tax is split by rate from each bill's tax lines
- Check the figures against the GST portal before filing
- The portal's JSON is not made: use the GST offline tool with the Excel
Who uses it
AccountsMakes the workbook each month and runs the GSTR-2B match.
Your accountantChecks the workbook against the portal and files the returns.
Purchase OfficerEnters the supplier's bill number on every supplier bill, so the 2B matches.
Trade AdministratorSets Composition Dealer when it applies.
Where you use it
- Web: Trade > Reports > Tax and Accounts > GST Returns Data and GSTR-2B Match
- Web: Trade > Configuration > General > Settings > Billing (Composition Dealer)
- Scale: GSTR-1 and GSTR-3B also on screen in the full financial reports
- Not built: filing on the GST portal, and making the portal's JSON
What you control
Settings
- Period: this month to start with
- Composition Dealer: off
Works with
SmartMy Tally connectorIf your accountant files from Tally, posted invoices and payments go to Tally as well.
Questions
Does SmartMy Trade file our GST returns?
No. It makes the GSTR-1 and GSTR-3B data as Excel. Your accountant checks it against the portal and files.Why does a supplier bill not match the 2B?
The match uses the supplier's GSTIN and the bill reference. Enter the supplier's bill number exactly as on their bill.Does the 2B match cover only the month of the file?
Bills found in the file are matched whatever their date. The list of our bills not in the 2B is not yet limited to that month, so read it by date.We are a composition dealer. Is tax left off?
The bill prints as Bill of Supply. The setting does not remove tax, so keep GST off your items.Is this in the Starter plan?
Yes. GST returns data, the 2B match and the bill of supply come with the India pack on every plan.Related features
GST AND APPROVALSE-invoice and e-way billFor Indian entities, posting a B2B bill registers it on the government e-invoice system and prints the IRN and signed QR on it. E-way bills come from the bill, the delivery challan or a shop transfer, with the transporter, vehicle and LR already filled in.GST AND APPROVALSSupplier bills made from their e-invoiceWhen a supplier sends the JSON file of its GST e-invoice, upload it and SmartMy Trade makes the supplier bill. The supplier is found by GSTIN, with the bill number and date. Each line is matched to your item by name or HSN. Lines it cannot match are listed for you to fix before you post.CUSTOMERS, BROKERS AND REPORTSAccounting reports, stock value by location and pending listsTrial balance, profit and loss, balance sheet, day book, cash and bank books and ageing. Stock value per shop and godown, and a summary of each shop's sales, margin and net. And the lists of what is still to deliver and receive.ACCOUNTINGFull accounting with GST returnsEvery bill, return, receipt, supplier bill and cheque posts into your books as you work, with the shop on each bill. Growth adds accounting reports by shop. Scale adds the full accounting screens and Financial Reports, from ledgers to cash flow and consolidation, with GSTR-1 and GSTR-3B for India.WITH OTHER SMARTMY PRODUCTSBooks in Tally with the SmartMy Tally connectorBill, collect and keep stock in SmartMy Trade while your accountant keeps the books in TallyPrime. Every posted bill, credit note, supplier bill, receipt and payment goes to the Tally company by itself, through SmartMyTally on your office PC. Each party lands on its own ledger, the way your books keep them.
See your shop on it.
Tell us what you sell, how many shops and godowns you run and how you bill today. We will set up your items and parties with you and print your first bill.