Bill history and GST reports

Find and reprint any bill, today's totals, GST totals, and the GSTR-1 file for your accountant.

Bill history

Today's sales, cash in the drawer, UPI and udhaar at the top, then every bill on this device, newest first. Search by bill number, buyer name or GSTIN, and press Reprint to open a bill and print it again with all its copies. A new or wiped device gets the last 90 days of bills back when it is set up.

GST reports

Totals from the bills and purchases on this device: sales before GST, GST collected (CGST, SGST and IGST), GST paid on purchases, and an estimate of GST to pay (collected less paid, before your CA's review). For every counter, use the GSTR-1 file below while online.

The GSTR-1 file

Pick the month (until the 13th it starts on last month, the one you file for) and, if your stores are under more than one GSTIN (stores in different states), the GSTIN: GSTR-1 is filed for each GSTIN separately. Then Download CSV. It gives your accountant one row per bill line: invoice number and date, customer and GSTIN, place of supply, payment mode, HSN, item, quantity, taxable value, GST rate, CGST, SGST, IGST and the invoice total including round-off.

  • Online, the file covers that month's bills from every counter, from Natium.
  • Offline, it has this device's bills only, and the file name says so.

Amounts are plain numbers (120242.00), so each stays in its own column in Excel. Phone numbers are never in the file.

For the GST portal

For the GST portal gives a ZIP with one CSV per GSTR-1 table, in the GST offline tool's import layout, made from the bills themselves:

  • b2b: sales to registered buyers, one row per invoice and GST rate (Table 4).
  • b2cl: interstate sales over ₹1 lakh to buyers without a GSTIN (Table 5).
  • b2cs: other sales to buyers without a GSTIN, added up by state and rate (Table 7).
  • exemp: nil-rated (0%) sales (Table 8).
  • hsn(b2b) and hsn(b2c): the HSN summary, split as the return asks (Table 12).
  • docs: the invoice numbers each counter issued (Table 13).

The README in the ZIP lists anything to fix before uploading: a GSTIN with a mistyped character (Natium checks the last character against the rest) or a product with no HSN code. When billing, a GSTIN that fails the check shows a warning under the field and asks before the bill is saved. Credit notes, advances and amendments are not in the files yet. Your CA should check the files and the return before filing. Your CA should check rates and the return itself before filing.