Skip to content
Tutorials Center
My learning

Topics

Lesson 36 of 38 ยท Projects and Practice

Project: Run a Trading Company's Books in Tally Prime

A guided Tally Prime project for a small trading company: masters, stock, GST sales and purchases, bank, month-end checks and statements, with a Python ledger simulator.

This project ties the chapters together. You will set up and run the books of Brightline Traders, a small fictional company in Maharashtra that buys electronics accessories and sells them to shops. Follow the steps in your own Tally Prime installation (use a practice company), and use the Python stand-in on this page to check your numbers. The product itself cannot run on this site, and all names, amounts and tax rates here are invented for practice.

The business

  • Buys cables, mice and keyboards from two suppliers.
  • Sells to retailers in Maharashtra (intra-state) and Karnataka (inter-state).
  • Banks with one current account; keeps a little petty cash.
  • GST registered (regular), with 18% on all items for this exercise.

Step 1: masters

  1. Create the company with the financial year start, state Maharashtra, and enable GST and inventory (enabling GST).
  2. Create units (Nos), stock groups (Cables, Input Devices) and stock items with HSN, 18% GST and opening balances (stock items).
  3. Create ledgers: Bank, Cash, Capital, Sales - Taxable, Purchase - Taxable, Output and Input CGST, SGST and IGST, Rent, Salaries, Bank Charges; and parties: two creditors and three debtors (one in Karnataka) with state and GSTIN (GST masters).

Step 2: opening and first-month entries

Enter these in order (amounts are before GST):

Day Voucher Details
1 Journal/opening Capital 200,000 in the bank
2 Purchase (F9) From Supplier A: 100 cables at 45
4 Purchase (F9) From Supplier B: 40 mice at 310
8 Sales (F8) To Retailer 1 (Maharashtra): 60 cables at 80
12 Sales (F8) To Retailer 2 (Karnataka): 20 mice at 520
15 Payment (F5) Rent 12,000
20 Receipt (F6) Retailer 1 pays in full by bank
25 Payment (F5) Salaries 30,000
28 Contra (F4) Withdraw 5,000 cash from the bank

Use bill references on every sale and purchase, and receive and pay against reference (registers and outstandings).

Step 3: check with a simulator

The stand-in below posts the same entries into a tiny double-entry ledger, prints a trial balance and computes gross profit. Compare it with Tally's own reports.

Python Stand-in: Brightline's first month as a mini ledger

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

The trial balance's debit and credit totals must be equal (the assert inside post guarantees each voucher balances). Check Retailer 2's invoice: IGST on 10,400 at 18% is 1,872.00 and the receivable is 12,272.00.

Step 4: stock and profit

At month end the unsold stock is 40 cables and 20 mice. Closing stock at cost (average cost, no opening stock) is 40 x 45 + 20 x 310 = 8,000. Cost of goods sold is purchases minus closing stock.

Python Stand-in: month-end gross and net profit

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

The result is a net loss of 35,700 for the month: rent and salaries are fixed costs and the first month's sales are small. That is a realistic lesson: gross profit is positive (6,300) but expenses exceed it.

Step 5: GST for the month

Output tax: 864 (CGST 432 + SGST 432) on Retailer 1 plus 1,872 IGST on Retailer 2, i.e. 4,800 x 18% = 864 and 10,400 x 18% = 1,872. Input tax: 16,900 x 18% = 3,042 (CGST 1,521 + SGST 1,521). In GSTR-3B the IGST output of 1,872 is first offset by input credit, then CGST and SGST are offset. Work it through with the returns lesson and compare with Tally's GSTR-3B report.

Step 6: month-end checklist

  1. Clear uncertain GST transactions.
  2. Reconcile the bank (bank reconciliation) with a statement that includes a charge of 118 you must still enter.
  3. Review receivables ageing and stock summary; fix negative stock.
  4. Verify the trial balance, P&L and balance sheet (financial statements).
  5. Back up the company (security and backup).

Extensions

  • Add a purchase return and a sales credit note.
  • Add TDS on a professional-fee bill (TDS).
  • Split rent and salaries between two cost centres.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. Brightline sells to Karnataka. Which tax applies?

    The buyer is in another state, so IGST applies.
  2. 2. Purchases 16,900 and closing stock 8,000 (no opening stock). COGS is:

    COGS = opening stock + purchases - closing stock = 0 + 16,900 - 8,000 = 8,900.
  3. 3. Why does each voucher in the simulator assert that its lines sum to zero?

    Every voucher must balance, which keeps the trial balance balanced.
  4. 4. What should you do before relying on the month-end statements?

    Those checks catch the typical errors that distort profit and tax.

Summary

  • A complete cycle: masters, stock and GST entries, bank, month-end checks, statements, backup.
  • Verify with a small ledger simulator to prove that debit equals credit.
  • Gross profit can be positive while net profit is negative if fixed costs are large.
  • Use the month-end checklist every month.

Next: Project: manufacturing month-end close