हिन्दी

Reports

What you’ll do here: close the day and count the cash, read your sales and stock, and prepare GST returns for your CA.

How report screens work

Every report works the same way. Open one from the menus at the top. Then:

Alt+P asks: Yes to print, No to save as an Excel (CSV) file in Documents › Matih Setu Reports, Cancel to go back.

Some reports are only for the owner or managers, especially anything showing purchase costs or profit. A cashier who opens one sees “Only the owner or a manager sees purchase costs.”

Day closing

At the end of the day, count the cash in the drawer and close the day. This tells you at once if the cash is short or over.

Open it with 6 on the main menu or Daily Reports › Day closing (owner and manager). The screen is headed DAY CLOSING.

Day closing. Open it with 6 on the main menu, or Daily Reports › Day closing.

1. Count all the cash in the drawer.
2. Type it in Counted cash. Type 0 if the drawer is empty. You can also type the count of each note and coin, and Setu adds them up.
3. Add Notes if you like, for example “₹200 given to delivery boy”.
4. Check the figures: Setu shows the day’s bills and returns, the opening cash, cash received and paid, and the EXPECTED CASH.
5. Click Close the day (Ctrl+W), or press Ctrl+W or PgDn.

Setu says “Day closed. Cash matches.” or “Day closed. Short ₹… recorded.” (or Excess). UPI and card totals are as the counter confirmed them; check your bank statement for what actually arrived.

Once a day is closed, no more bills can be saved on that date.

Reopening a day

A late customer after you closed? The owner can reopen the day:

1. Open Daily Reports › Day closing for that day.
2. Type the Reason (goes in the audit log).
3. Click Reopen this day.

Bills can then be saved on it again. Close it again afterwards; Setu recounts the day.

If someone tries to bill on a closed day, Setu says “Day … is closed. Use today’s date, or the owner reopens it in Daily Reports › Day closing › Reopen this day.”

Daily reports

• Daily Reports › Daily sales (5 on the main menu): the day’s bills and totals.
• Daily Reports › Mode of payment report: how much came in cash, UPI, card and credit.
• Daily Reports › Sale returns: the day’s returns.

The owner and managers also see a Today panel on the main menu with the day’s sales and how they were paid.

Books

The Books menu has the shop’s account books: Cash & Bank book, Cash book, Bank book, Day book, Sale register, Purchase register, Party ledger, Debtors outstanding, Creditors outstanding and Outstandings (Alt+O). Managers also see analytical summaries, collection reports and UPI collection.

Ctrl+F10 opens a calendar. Pick a day and press Enter to see that day’s day book.

Stock reports

The Stocks menu: Current stock, Stock ledger, Low stock / reorder, Near expiry, Slow moving, Rack wise stock, Stock Status, Stock & Sales Analysis, Item Day Book, Stock by MRP, Old MRP stock, and Today’s Gross Profit (owner and manager). See Items and stock.

Sales and profit

Reports › Item-wise sales & margin and Reports › Category-wise (owner and manager) show what sold and what you made on it.

Financial Reports (owner): Trial balance, Profit & loss, Balance sheet, and versions by group. Auditor reports are for the owner and managers.

GST reports and returns

The GST menu (owner and manager) prepares your GST returns from your bills and purchases.

Setu prepares returns; it does not file them. Each return screen says “Check with your CA before filing.”

• GST summary (sales & purchase): tax collected and paid, at each rate.
• GSTR-1 (sales): choose the month (F2) and look through the tables with ← →. Alt+J saves the upload file (JSON) for the GST portal. Alt+P prints or saves a table as Excel.
• GSTR-3B: choose the dates (F2). F9 saves a JSON file for your CA.
• GSTR-2 (purchases & 2B match): matches your purchase bills against GSTR-2B from the GST portal. Download GSTR-2B from the portal (Returns Dashboard › GSTR-2B › Download › Generate JSON file to download), then press F3 to load it. Setu shows what matches and what doesn’t; F9 saves the mismatches as Excel.
• GST Register & Returns, Tax Registers & Summaries, Internal Audit (GST checks), GST Tax Rates, Misc. GST Returns (CMP-08, GSTR-4) for composition shops.

GSTR-1 (sales), from the GST menu. Check it with your CA before filing.

Give the saved files to your CA, or upload them yourself if you file your own returns.

Audit log

Reports › Audit log (owner) lists every important change: bills changed or cancelled, stock corrected, settings changed, sign-ins, and who did each.

When the owner signs in, Setu also lists what cashiers saved in the last 7 days that the owner should look at, such as big bill changes, with a pointer to the audit log.