Accountant (Tally, GST, Excel: India) roadmap

Accounting means recording money transactions in a fixed way, then summarising them into reports. A transaction is any event with money, like buying stock, selling goods or paying rent. These records are also needed by law for taxes and audits.

Traditional Indian books group accounts as personal (people and firms), real (things like cash and furniture) and nominal (income and expenses). Each type has a golden rule, for example for real accounts "debit what comes in, credit what goes out". Many teachers also use the modern way: assets, liabilities, capital, income and expenses.

In double entry, the total debit always equals the total credit. If a shop buys goods for ₹5,000 in cash, purchases are debited and cash is credited with ₹5,000. The journal is the book where you first write each entry in date order with a short narration.

After the journal, each entry is posted to its ledger account, such as Cash, Bank, Sales or Ramesh Traders. The ledger shows all debits and credits and the closing balance of that account. Tally does this posting for you, but you must understand it to find mistakes.

A trial balance lists every ledger balance with debits on one side and credits on the other. If the totals do not match, there is a mistake somewhere. Even when they match, some errors (like posting to the wrong account) can still hide, so check carefully.

The Trading and Profit and Loss Account shows income, expenses and the profit or loss for the year. The Balance Sheet shows what the business owns (assets) and owes (liabilities and capital) on the last day. Learn adjustments like depreciation, outstanding expenses and prepaid expenses.

On a cash basis, you record income when you receive money. On an accrual basis, you record it when it is earned, even if payment comes later. Companies in India must use the accrual basis, so learn it well.

Learn to enter data cleanly, use SUM, IF, ROUND and date functions, and format numbers in rupees. Sorting and filtering help you find entries fast. Keep one row per transaction and do not merge cells in data tables.

XLOOKUP (or VLOOKUP in older versions) finds a value from another table, such as a customer GSTIN from a customer list. A pivot table sums data by group, for example total sales by month or by party. These two skills save hours in reconciliation and reports.

In Tally Prime you create a company, then ledgers grouped under heads like Sundry Debtors, Sundry Creditors and Bank Accounts. Tally builds the trial balance, Profit and Loss and Balance Sheet automatically. Learn to move around with the keyboard, because accountants rarely use the mouse.

The main vouchers are Contra (cash to bank and back), Payment, Receipt, Journal, Sales and Purchase, with Credit Note and Debit Note for returns. Each has a shortcut key, such as F5 for Payment and F8 for Sales. Always add a clear narration so others understand the entry later.

Create stock groups, stock items and units like Nos, Kg or Box. When you enter sales and purchases in item invoice mode, stock goes up and down automatically. Stock summary reports show what is left and its value.

Bill-wise details in Tally link payments to specific invoices. Ageing reports show how long each bill has been unpaid. Following up on old dues is one of the most useful things a junior accountant does.

Take regular backups of Tally data, and keep one copy outside the office computer. Use user passwords and give each person only the access they need. Never share login details of GST or bank portals over WhatsApp.

GST (Goods and Services Tax) is a tax on supply of goods and services. Inside one state, CGST and SGST are charged; between states, IGST is charged. Each item has an HSN code (or SAC for services) and a tax rate; rates change from time to time, so always check the latest list.

A business must register when its turnover crosses the limit, or in some cases from the first sale, such as many inter-state or e-commerce sellers. Registration gives a 15-character GSTIN. Read the current rules on gst.gov.in, because limits and conditions can change.

A tax invoice must show details like GSTIN, invoice number, date, HSN or SAC, taxable value and tax amount. Bigger businesses must create e-invoices through the government system, and e-way bills are needed to move goods above a value limit. Tally Prime can prepare all of these.

If you paid ₹1,800 GST on a purchase and collected ₹3,000 GST on a sale, you usually pay only ₹1,200 more in cash, if all conditions are met. You can claim ITC only when the supplier has reported the invoice, which shows in GSTR-2B. Some items, like many personal expenses, are blocked from ITC.

GSTR-1 reports your sales invoices; GSTR-3B is the summary return where you pay the tax. Most businesses file them monthly, while small taxpayers may choose quarterly filing. Before filing, match your books with GSTR-2B, and check the due dates on the portal each time.

TDS (tax deducted at source) means the payer cuts some tax from a payment and deposits it with the government. Each type of payment has its own rate and limit. Quarterly TDS returns are filed, and the deductee can see the credit in Form 26AS and AIS on the income tax portal.

Learn heads of income (salary, house property, business, capital gains, other sources), the old and new tax regimes, and which ITR form fits whom. A new Income-tax Act, 2025 replaces the 1961 Act from April 2026, so section numbers in older books may differ. Always confirm current rules on incometax.gov.in.

A bank reconciliation statement explains why the bank balance in your books is different from the bank statement. Common reasons are cheques not yet cleared, bank charges and interest you have not entered, and UPI or card receipts not yet recorded. Tally has a bank reconciliation screen to do this monthly.

A salary has earnings (basic, HRA, allowances) and deductions (PF, ESI, professional tax, TDS). Tally Prime has payroll features to create employees, pay heads and salary slips. Keep attendance and leave records, because salary depends on them.

PF (Provident Fund, run by EPFO) is a savings fund where both employer and employee contribute a share of pay. ESI (Employees' State Insurance, run by ESIC) gives medical and other benefits to employees below a wage limit. The rates, limits and due dates are set by law and can change, so check epfindia.gov.in and esic.gov.in.

Professional tax is collected by some states, like Maharashtra and Karnataka, with their own slabs. Salary TDS depends on the tax regime the employee chooses and their declarations. Collect proof of investments when the employee claims deductions.

At month end, enter all bills, provisions for expenses, depreciation and bank reconciliation. At year end, also check stock, debtors, creditors and prepare for audit. A checklist makes sure nothing is forgotten.

Tools like Zoho Books let you create GST invoices, connect bank feeds and work from anywhere. The accounting ideas are the same as Tally. Knowing more than one tool makes you easier to hire.

MIS (management information system) reports are regular summaries like monthly sales, expenses by type, profit by product, debtor ageing and cash flow. Make them in Excel with pivot tables and simple charts. A good MIS report is short and highlights what changed and why.

A budget is a plan of expected income and expenses for the year. A cash flow forecast shows money coming in and going out week by week or month by month. Compare actual numbers with the budget every month and explain big differences.

An auditor checks if the books are true and fair. You help by keeping vouchers, bills, agreements and reconciliations ready and well filed. Answer questions honestly and quickly; never change old entries without a clear record.

Controls are simple rules, like two people approving payments, matching every purchase bill with a purchase order and goods received, and locking old periods in the software. Keep duties split so one person does not handle everything. These habits build trust with owners and auditors.

Learn Power Query to clean and combine bank and GST data automatically. Build templates that refresh with new data each month. Some teams also use Power BI for dashboards.

Follow official updates on the GST, income tax, EPFO and ESIC portals. Read ICAI updates and trusted professional newsletters. When unsure, ask a CA rather than guessing.

Many accountants grow with a B.Com and strong Tally, GST and Excel skills. For higher roles, some choose M.Com, CA (from ICAI), CMA (from ICMAI) or CS (from ICSI), which take several years of study. Pick a path that fits your time, money and goals.