Frizzi

Money & the counter

Tally for salons: what your accountant needs each month

Tally for salons: the monthly pack your accountant needs (sales by GST rate, credit notes, cash, bank, expenses, salaries, advances), ledgers and importing.

For Tally, a salon’s accountant needs the same things every month: sales split by GST rate (5% services, 5% and 18% products), credit notes and cancelled bills, cash and bank movements including UPI, expenses with bills, salaries, commission and staff advances, and prepaid money such as wallets, dues and gift vouchers. Send it as a tidy pack a few days after month-end, or as an export the accountant can import. Either way the month should be closed first, so the numbers don’t change after they’ve gone in.

The monthly pack, item by item

What to sendWhy the accountant needs it
Sales by GST rate and SAC/HSN, with the first and last invoice numberThe GST returns (GSTR-1 and GSTR-3B) and the HSN summary
Cancelled bills and credit notes, with the original bill numbersTo reduce sales and GST in the right month
Payments by method: cash, UPI, cardTo match sales with the bank statement and cash book
Daily cash tally, deposits and cash given to the ownerThe cash-in-hand ledger, and owner drawings
Expenses by head, with billsExpense ledgers, and any GST that can or can’t be claimed
Purchases and supplier paymentsStock, creditors, and retail versus back-bar purchases
Salaries, commission, tips and advancesSalary ledgers, staff loans and what was recovered
Wallet top-ups, dues, gift vouchers sold and usedMoney you owe clients, and money clients owe you

Sales by GST rate, and why the split matters

A salon now has at least two rates on its bills: 5% on services, and 5% or 18% on products. Your accountant can’t file from one “total sales” figure. They need taxable value and tax for each rate, the HSN or SAC summary, and the documents issued: invoice numbers from first to last, how many were cancelled, and the credit notes. Nearly all salon bills go to people, not businesses, so they are reported together as B2C sales rather than bill by bill.

If you have more than one GSTIN (branches in two states), each one is a separate set of numbers and a separate company in Tally. Read GST on salon products if your product rates need a check first.

Ledgers and voucher types in Tally

Your accountant will set these up once. Knowing the names helps you talk the same language.

  • Sales accounts: “Service sales 5%”, “Product sales 5%”, “Product sales 18%”.
  • Duties and taxes: Output CGST and Output SGST.
  • Cash-in-hand: one per branch drawer, if you like.
  • Bank accounts: where UPI and card money lands.
  • Sundry debtors: clients who owe you (dues).
  • Current liabilities: wallet balances and unused gift vouchers, money you owe clients.
  • Loans and advances: staff advances not yet recovered.
  • Indirect expenses: rent, electricity, salaries, commission and the rest.

Entries go in as voucher types: Sales for bills, Credit Note for refunds, Receipt for money in (dues, top-ups), Payment for money out, Contra for cash taken to the bank, Journal for adjustments, and Purchase or Debit Note for stock.

Export to Tally, or type it in?

Typing in from reportsImporting an export file
Time each monthHours for a busy salonMinutes, once set up
Typing mistakesLikelyNone, if the file is right
DetailUsually one entry a dayOne entry per bill, or one a day per branch
Set-upNoneLedger names must match the accountant’s
RiskSmall, slow errorsA wrong file can add many wrong entries at once

Many accountants prefer one entry a day per branch. It keeps Tally light while the bill-wise detail stays in your salon software. Ask yours which they want.

Your first month with an import

  1. Take a backup of the company in TallyPrime, or work in a copy of it. Tally’s own help says to back up before importing.
  2. Match ledger names. Rename the ledgers in the export to your accountant’s names before the first import, so nothing new is created by accident.
  3. Import ledgers first (masters), then the entries (transactions).
  4. Check the totals against your sales and GST report: sales, GST, cash and bank.
  5. Decide on re-imports. TallyPrime has an import setting for vouchers with the same GUID. Set it so a corrected file replaces the old entries instead of doubling them, and test it on the copy.

Closing the month

  • Last day: count the cash, and mark bank deposits received.
  • Finish cancellations, refunds and bill corrections for the month.
  • Check the GST report against the sales report. They should agree.
  • Check that advances, salaries and supplier payments are all entered.
  • Close the month so nothing dated in it can change. Corrections then go in the current month, where your accountant can see them.
  • Send the pack or the export, well before your CA’s filing dates.

Credit notes for last year’s bills have a hard stop on 30 November. The invoice format guide explains it.

Frizzi’s Tally export, honestly

Frizzi has a Tally export for owners, in Plus and Pro. Switch it on in Settings, then Reports → Accounts → Tally export. It makes two XML files for one company and one month: Ledgers (import first, as masters) and Entries (transactions), one per bill or one a day per branch. You choose what goes in: sales and credit notes, wallets, dues and vouchers, expenses, cash in and out, stock and suppliers, salaries and advances. Before you download, it checks the entry counts and money against the Monthly GST report, warns if the month isn’t closed, and lets you rename ledgers to match your accountant’s. Each record keeps a fixed ID, so a corrected file can replace the old one.

Not yet tried in a real TallyPrime. The export was built from Tally’s help pages and is checked by automated tests, but it hasn’t been imported into a live TallyPrime yet. Do your first month with your accountant, on a copy of the company, and compare the totals before using it on your real books. It covers accounts only: no stock items, no IGST and no B2B invoices.

See Tally export and reports.

Questions

Should each salon bill be a separate entry in Tally?

It can be, but many accountants prefer one sales entry a day per branch, split by GST rate. The bill-by-bill detail stays in your salon software for anyone who needs it. Ask your accountant which they want.

Can my accountant import Frizzi data into TallyPrime?

Frizzi makes a Ledgers file and an Entries file in Tally’s XML format. It hasn’t been tried in a real TallyPrime yet, so do the first month together with your accountant on a copy of the company and check the totals.

What does my accountant need for the GST return?

Taxable value and tax for each rate, the HSN/SAC summary, the range of invoice numbers with cancelled ones, and credit notes issued in the month. A monthly GST report from your billing software usually has all of it.

Run your salon on Frizzi, free for 35 days

Every feature of Pro for 35 days. No card needed. Your data stays yours, and you can export it any time.

Plans from ₹99 a branch a month, plus GST. Monthly or yearly.

Chat on WhatsApp