GST, Tally and Profit & Loss
These reports help you (and your accountant) with tax returns and your books.
GST Reports
How to open it: Reports › GST Reports
| Report | What it shows |
|---|---|
| GSTR1 | Every invoice of one store in the period with its invoice number, date, taxable amount, CGST, SGST, IGST and total amount — the details you need for filing GSTR-1. Choose a Store and dates, then click Show invoices |
| Invoice Based Tax Summary | Choose a Store and dates (up to one month, ending no later than today), then click Email tax summary. A CSV file with the tax summary, invoice by invoice, is sent to your account owner's email — it isn't shown on screen. A long period can take a while to arrive |
| HSN/SAC Based GST Sales | Sales from all your stores grouped by HSN/SAC code, with a store column: item type, total quantity, total value, CGST / SGST / IGST (rate and amount), total tax and total without tax. Choose your dates and click Show sales |
| HSN/SAC Based GST Purchase | Purchases from all your stores grouped by HSN/SAC code: item type, quantity, cost, whether prices included tax, and CGST / SGST / IGST. Choose your dates and click Show purchases |
Items without an HSN/SAC code are left out of the two HSN/SAC reports.
💡 These reports are only as accurate as your item setup. Make sure every item has the right HSN/SAC code and tax rates in Item Master, and that your store's GST number is correct in Settings › Back Office › Store Settings.
Tally Reports
🔑 Who can see this: the Tally Reports menu only appears if Export to Tally is switched on for your account.
How to open it: Reports › Tally Reports
Sales Export to Tally Prime Excel
Choose a store, Date From and Date To, and click Export to CSV to download your sales in a format ready to import into Tally Prime. Each file covers one store, so export once for each store.
Export to Tally XML Format
Choose the From Date and To Date (neither can be after today), then click the button for what you want to send to Tally. Each file covers all your stores and downloads to your computer:
| Button | Exports |
|---|---|
| Purchase Order Export | Your purchase orders |
| Receiving Order Export | Goods received |
| Vendor Master Export | Vendors added or changed in the dates you chose |
| Item Master Export | All your items (the dates make no difference) |
| Expenses Export | Your expenses |
| Sales of Items Export | Your item sales |
| Profit Loss of Item Export | Profit and loss by item |
💡 New to Tally imports? Send Vendor Master and Item Master first, so Tally knows the names used in the other files.
Profit and Loss
How to open it: Reports › Profit and Loss
Choose the Year and one Store, then click Generate report. You'll get a month-by-month statement for that store, one row per month (all twelve months are listed; months with nothing recorded show zero). It covers one store at a time, so run it once for each store.
| Column | Meaning |
|---|---|
| Product, Service, Package, Membership, Membership Wallet Sales | What you sold, by type, with tax |
| Gross Sales / Total Tax (Sales) / Total Sales | Sales without tax, the tax, and sales including tax |
| Total Purchase Amount / Total Purchase Tax | What you spent on stock (with tax), and the tax on it |
| Total Expense Amount / Total Tax (Expense) | Your expenses (with tax), and the tax on them. Store expenses and back office expenses for that store both count |
| Gross Expense | Purchases and expenses added together, less the purchase tax |
| Total Expenses | Purchases and expenses added together, with tax |
| Total Income | Sales less purchases less expenses, with the tax taken out of all three |
💡 For a richer, more visual view of profit — including profit per service, dead stock and discount leakage — see the Profitability Dashboard.