10 · Project — One Month of Books for a Trading Business¶
Put Level 1 together: record a full month of transactions for a new trading business in TallyPrime and produce its reports. (GST is configured in Level 2, so this month uses amounts excluding tax.)
1. Company setup¶
- Create Kaveri Kitchenware (Coimbatore, Tamil Nadu), financial year from 1 April 2026, with inventory enabled.
- Create ledgers: Capital – Anitha (₹6,00,000 Cr), Canara Bank, Cash, Rent, Salary, Electricity, Freight Inward, Discount Allowed, Interest Received, Furniture, Sales, Purchases, Salary Payable; customers: Home Needs Store, Annapoorna Hotel; suppliers: Prestige Distributors, Steelcraft Industries.
- Create units (Nos, Set), stock groups (Cookware, Utensils) and items: Pressure Cooker 5L (opening 40 @ ₹1,450), Non-stick Tawa (60 @ ₹520), Steel Plate Set (30 sets @ ₹780).
2. Transactions for the month¶
- Capital ₹6,00,000: ₹4,50,000 deposited in Canara Bank, ₹1,50,000 cash (opening + Contra).
- Bought furniture ₹38,000 by bank transfer.
- Purchased 50 pressure cookers @ ₹1,420 from Prestige Distributors on credit; freight inward ₹1,200 cash.
- Purchased 40 tawas @ ₹500 from Steelcraft Industries on credit.
- Sold 30 pressure cookers @ ₹1,950 and 25 tawas @ ₹720 to Home Needs Store on credit.
- Sold 12 steel plate sets @ ₹1,100 to Annapoorna Hotel for cash.
- Received ₹40,000 from Home Needs Store by NEFT, allowing ₹500 discount.
- Paid Prestige Distributors ₹60,000 by cheque.
- Paid rent ₹18,000 and electricity ₹2,900 by bank.
- Salary for the month ₹30,000: ₹20,000 paid in cash, ₹10,000 outstanding.
- Interest credited by bank ₹350; bank charges ₹236.
- Physical count: 2 tawas damaged — record via Stock Journal to a "Damaged Stock" item or as a loss.
3. Reconcile and review¶
- Reconcile Canara Bank assuming the ₹60,000 cheque hasn't been presented yet.
- Review the Day Book; fix any errors.
- Check the Trial Balance balances and has no odd balances.
4. Reports to produce¶
- Stock Summary with closing quantities and values.
- Profit & Loss Account — note gross profit and net profit.
- Balance Sheet at month end.
- Outstanding balances of customers and suppliers (Group Summary).
- Export all reports to PDF/Excel.
Deliverable checklist¶
| Item | Done? |
|---|---|
| Company, ledgers, items with opening balances | |
| All 12 transaction groups recorded with narrations | |
| Bank reconciliation completed | |
| Trial Balance agrees | |
| Stock Summary, P&L, Balance Sheet exported | |
| One-paragraph summary of results |
How It Actually Works¶
This project mirrors a real month-end: transactions flow in from bank, cash, sales and purchases; reconciliation and stock counts verify them against independent evidence; and the reports summarise performance and position. The order matters — reconciling and checking the Trial Balance before reading profit ensures the numbers you report are trustworthy. Employers testing Tally skills usually give exactly this kind of task.
Exercise¶
Complete the month for Kaveri Kitchenware, then write a short management summary: sales, gross profit margin (%), net profit, cash and bank position, top-selling item, and amounts receivable and payable. Keep this company — you'll add GST to similar transactions in Level 2.