Skip to main content

How to download the GST report and the Tally import file

Applies toWeb dashboard· Updated

Short answer

Go to Dashboard → Analytics, pick the period and tap Export. GST report (Excel) downloads a workbook laid out like GSTR-1 sections. Tally import (XML) downloads one Sales voucher per bill that you import in Tally. Both are for one outlet at a time.

Steps

  1. Select the outlet and the period

    Open the outlet you are filing for. GST and Tally files always cover one outlet, because a GST return is filed per GSTIN and bill numbers are per outlet. Go to Dashboard → Analytics and choose the period, for example Last month.

  2. Download the GST report

    Tap Export → GST report (Excel). A file named gst-report with your outlet name and date downloads in .xlsx format.

  3. What is inside the GST workbook

    The sheets follow the GSTR-1 offline tool sections.

    • Summary: outlet, legal name, GSTIN, period, number of bills, invoice value, taxable value, CGST, SGST, nil rated value and notes. Use it to fill GSTR-3B.
    • b2b: bills that carry a buyer GSTIN.
    • b2cs: sales to unregistered customers, by rate.
    • hsn: summary by rate under the restaurant service code 996331.
    • exemp: nil rated and non-GST supplies. Liquor is reported here as non-GST supply.
    • docs: first and last bill number, total count and cancelled count.
    • bills: one row per bill with Bill No, GST Invoice No, Order ID, Date, Buyer GSTIN, Subtotal, Discount, Service Charge, CGST, SGST, Liquor Tax, Other Charges, Packing Charges, Round Off, Total and Payment Status.
  4. What is left out of the GST report

    Cancelled, rejected and refunded bills are left out of the tax figures. Refunded bills are listed in the Summary notes. Credit notes are not generated. GST on room rent is not in this file. For rooms, use Booking register (Excel) from the same Export menu.

  5. Download the Tally file

    Tap Export → Tally import (XML). A file named tally-vouchers with your outlet name and date downloads in .xml format.

  6. Import it in Tally

    In Tally, open the company you want the data in. Go to Gateway of Tally → Import → Vouchers and select the downloaded file. It imports into whichever company is open, so check the company first.

  7. What the Tally file creates

    One Sales voucher per bill. The file also carries the ledgers the vouchers use, so the import does not fail on a missing ledger: Cash, UPI Collections, Card Collections, Online Collections, Customer Wallet, Other Collections, Unsettled Bills, Restaurant Sales, Output CGST, Output SGST, Liquor Tax, Service Charge, Other Charges, Packing Charges, Discount Allowed and Round Off. Any unpaid part of a bill is posted to Unsettled Bills.

  8. If Export is locked

    GST report and Tally import are part of report export. If the button reads Export · Pro with a lock, the owner needs to upgrade from Dashboard → Billing.

Still stuck?

If you use RestroFi, sign in and raise a ticket from Dashboard → Support so we can see your outlet. You can also email [email protected].