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
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.
Download the GST report
Tap Export → GST report (Excel). A file named gst-report with your outlet name and date downloads in .xlsx format.
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.
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.
Download the Tally file
Tap Export → Tally import (XML). A file named tally-vouchers with your outlet name and date downloads in .xml format.
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.
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.
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.
Related articles
How to download sales data as CSV, Excel or PDF
Go to Dashboard → Analytics, pick the date range and tap Export. Choose Download PDF report or Download CSV (Excel). The export uses the same dates and numbers as the screen. If the button shows a lock, report export is not on your plan.
How bill numbers and invoice numbers work
A bill gets its bill number the first time it is printed, from one running series for the outlet, and keeps it on every reprint. A GST invoice gets a separate invoice number in the form INV-FY2627-0001 that restarts every financial year. The order number shown to staff is a different, daily number.
How to add GSTIN and set GST on the bill
Add the GSTIN in Dashboard → Settings → Business → Contact & compliance, then set Default GST rate in Dashboard → Settings → Payments → Tax & service charge. GST cannot be saved until a valid GSTIN is on file.
Bill total or GST amount looks wrong
The bill is item total plus GST on each item, plus service charge, takeaway or packing charge and liquor tax, minus discounts, then rounded to the nearest rupee. Most wrong totals come from the Default GST rate, a different GST rate saved on one item, or a charge that is switched on in Dashboard → Settings → Payments.
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].