CAETR ASSIGNMENT

(Submitted for the Degree of B.Com. Honours in Accounting & Finance

under the University of Calcutta)

Title of the Project

“COMPUTERISED ACCOUNTING SYSTEM & E-FILLING
OF TAX RETURN”
(B.Com. Semester -VI)

Submitted By
Name of the Candidate :VISHAL PRASAD

CU Registration No :126-1111-0856-22

CU Roll No :221126-21-0822

Name of the College :UMESCHANDRA COLLEGE

College Roll No :888

College Section :G
 ACKNOWLEDGEMENT

Firstly, I thank CALCUTTA UNIVERSITY for our partial

fulfilment of the B. Com 6th Semester (Honours)
Examination.
Also, I am thankful to my college, UMESCHANDRA
COLLEGE, for being a student of the college. So that I
can pursue my graduation.
I express my thanks to the respected Principal, Dr. MD. T.
Haque, of our college, for providing the excellent
infrastructure required for the completion of the project
work in our esteemed organisation, namely.
Huge thanks to all our professor, who helped us a lot in
making this wonderful project. It is a matter of great
satisfaction and pleasure to present this report on
“CAETR”.

.…………………………………….
Date: / /2025 Signature
 Lecture 1 on Ledger Creation

Introduction

Financial Accounting packages are tailor-made software used for preparation of Final Accounts, Cash/Funds
Flow Statement, Inventory Records, Bank Reconciliation Statement, Tax Related Reports and many other
important reports. Tally is one of such software, which is not only versatile but also easy to use.

Different versions of Tally

 First Version of Tally - in 1990 – Tally 3
 Second Version of Tally - in 1991 – Tally 3.12
 Third Version of Tally - in 1992 – Tally 4
 Next Version of Tally - in 1994 – Tally 4.5
 Next Version of Tally - in 1996 – Tally 5.4
 Next Version of Tally - in 2001 – Tally 6.3
 Next Version of Tally – in 2005 – Tally 7.2
 Next Version of Tally – in 2006 – Tally 8.1
 Next Version of Tally – in 2006 – Tally 9
 Next Version of Tally – in 2009 – Tally ERP 9
 Next Version of Tally – in 2020 – Tally Prime

Tally Prime: Accounting in digital format

 Tally Prime is one of the most popular accounting software used in India.
 It is complete enterprise software for small & medium enterprises.
 Maintaining accounts in manual books, we write accounting entries as debit and
credit. In Tally, we create entries the same way.

What The Software Will Automatically Do for Us?

At first, we will have to make the software ready before starting Journal Entries. Thereafter,
Journal Entries and some other entries are to be passed as a routine work.

The Software will:

 Make ledger postings;
 Prepare Trial Balance;
 Prepare Inventory records and value closing stock;
 Prepare Profit & Loss Account;
 Prepare Balance Sheet;
 Prepare Bank Reconciliation Statement;
 Prepare GST Report;
 Prepare Funds Flow & Cash Flow Statements;
  Work out Ratios;
 Show Cost-Centre wise results;
 Many other subsidiary accounting jobs;
 Help in auditing.

Lets start Accounting in TallyPrime

Step 1: Visit the official website of Tally solution with the help of any web browser you
like.
 Download the setup files.
 Go to https://tallysolutions.com/download/.
 Click Download.
The exe will get downloaded in the Downloads folder. You can copy and paste it to
any folder, if needed.
Step 2: Install TallyPrime.
 Double-click setup.exe.

 Double-click Install New.

 Configure Application Path, if needed.
By default, the application will be installed at C:Program FilesTallyPrime. Click
Configure.

 Double-click Application Path.

 Click … and change the path as needed.

Close the List of Configurations window.

 Click Install.
The application gets installed, and the following window opens.
 Press S (Start TallyPrime) to begin your journey with TallyPrime. If you would like to
explore additional options, then press C (Continue Setup).
 After installation, you will be asked to configure some basic settings such as the
data path, country, and accounting terminology, and so on. These settings will be
carried forward on your journey with TallyPrime.
 You will see the following welcome screen. Select the appropriate licensing option for
your TallyPrime installation.
At this point, Tally Prime is successfully installed on the system and an icon is created on
the desktop.

Major steps involved

Creation of Masters (i.e. one time):
A. Creation of Company:
B. Accounting Masters
C. Stock Master
D. Statutory Masters
Record of Transactions (i.e. repeated activity):

 Entry of Accounting Vouchers and Inventory Vouchers

 Entries for Bank Reconciliation Statements

Create a Company:
1: On launching Tally Prime, select Create Company. You can do that with an easy shortcut i.e.
“Alt+K” or “F3” then click on “Create”.
2: Provide the Company details:
a) By default, your company data will be saved in the location specified under Company
Data Path (you can even change it as per your need)
b) Enter the Name, Mailing name, and Address.
c) Enter the State, Country, and other contact details
d) Set up financial year details and security options (This is optional. You can enable
security features such as Tally Vault and User controls for your company anytime
later by Pressing F12(configuration) then set the security option to yes.
3: Specify the Base Currency Information.
4: Accept the Company Creation screen. As always, you can press Ctrl+A to save or at last Accept
it to save the creation.
When creation of company is over, a screen will appear. This screen is called Gateway of Tally.

Recapitulation of Basic Accounting Rules

Rules of Debit and Credit

Items Increase Decrease
Expenditure/Loss Debit Credit
Assets Debit Credit
Income/Profit Credit Debit
Liabilities Credit Debit

8 Types of Journals in MANUAL accounting:

Journal Type Purpose

1.Cash Book All Cash/bank transactions including Contra entries
2. Purchase Day Book Only credit Purchases
3. Sales Day Book Only credit Sales
4. Purchase Return Book Only credit Purchases Returns
5. Sales Return Book Only credit Sales Returns
6. Bills Receivable Book B/R received
7. Bills Payable Book B/P accepted
8. Journal Proper Residual entries.
 Tally Groups

28 predefined groups in tally, primary groups are 15, and the sub-groups are 13. The different types
of groups are as follows:
Primary Groups - 15
This group is the main group at the top of the hierarchy
9 groups are balance sheets items, 6 groups are profit and loss a/c items

1. Branch/Division 6. Current Assets 11. Indirect Income

2. Capital Accounts 7. Fixed Assets 12. Misc. Expenses
3. Loans 8. Investments 13. Purchase Accounts
4. Suspense Account 9. Sales Accounts 14. Direct Income
5. Current Liabilities 10. Indirect Expenses 15. Direct Expenses

Sub Groups - 13

1. Sundry Creditors 6. Secured Loans 11. Bank Accounts

2. Stock in Hand 7. Deposits 12. Cash in Hand

3. Duties & Taxes 8. Banks OD Accounts 13. Loan &
4. Unsecured Loans 9. Provisions Advances (Assets)
5. Reserves & Surplus 10. Sundry Debtors

Creation of Ledger heads

 Now proceed to create ledger heads. Without creating ledger heads, journal
entries cannot be passed.
 Note that only Cash A/C and Profit & Loss Account are available by default.
 Other ledger heads have to be created, whenever a new company is created.
 For creation of ledger heads, choose the following menu/sub-menu at GOT:
Create >Ledgers

 Thereafter a screen for Ledger Creation will appear.

How to change/Alter Ledgers

Gateway of Tally (GOT) –>Alter -> Ledgers

All ledgers will be displayed here you can select that ledger that you want to change/alter. Make
the changes in the ledger and press “CTRL+A”
How to delete Ledgers?

Go to Gateway of Tally > Alter > Ledger > Press Alt+D

Note: You can delete the ledger if no vouchers have been created under it. If you want to delete
a ledger for which vouchers have been created, you have to first delete all the vouchers from
that ledger and then delete the ledger account.
 Lecture 2
How to Alter/ Delete/ Shut Company in Tally

How to Alter Company in TALLY

 After the company creation in Tally, the given information of the company can alter/
modify/ change as per requirement. Use the following steps to alter company in
Tally:
 Step 1: Gateway of Tally → Press F3 → Alter company → Select the company
name from the list of companies → Company alteration screen will appear for required
modification → Press Ctrl+A (Save) → Yes
How to Delete Company in TALLY
 In Tally, if we delete the company, it can remove the company's complete
information from the Hard disk. All the directories and files that are associated with
the company will be permanently deleted. This information cannot be reserved.
 In Tally Prime, use the following path to delete the company:
 Gateway of Tally → F3 → Alter company → Alt+D → Yes
 Step 1: The company information will display on the screen after using F3 keys. Here,
the delete option will not be available. Now, click on the alter option.
 Step 2: Now, click on Select Company and then click Alt+D. After this, click on the YES
option to delete the company.

How to Shut/Close Company in TALLY

 In Tally, shut a company does not mean that delete a company, it means close.
After working with the company, choose the "Quit" button to close the present
company or press F3 from the Gateway of Tally then Select Shut Company.
 Select the company from the list of companies
 Press Yes

How to set business preferences in Tally

When you create a company in Tally Prime, the key features required to start recording your
business transactions are set by default. As per your business requirements - such as inventory
management, tax-based invoicing, payroll management, audit and security management - you
can set your preferences using the company features (F11).
Company Features in Tally Prime

Description
Features
Accounting
Maintain Accounts When you create a company in Tally Prime, the key features
required for your bookkeeping needs are all set. You can create
a ledger, record sales/purchase transactions, and view the
transaction details in your reports.

Enable Bill-wise entry You can maintain your credit sales and purchase amounts in
separate bills for tracking against the payments and receipts.
When this option is Yes, the ledger master displays Maintain
Balances bill-by-bill for sundry debtors and creditors. Refer
to Maintain Credit Sales Bill-by-Bill for more information.

Enable Cost Centres Enable Cost Centres if you need to allocate expenses to different
cost centres.

Inventory

Maintain Inventory Tally Prime provides the basic inventory features by default to
maintain your stock or inventory. You can create masters such
as stock items, stock groups, units and so on.

Integrate Accounts with Using Tally Prime, enable this option to include the stock or
Inventory inventory balance from your inventory records.
Stock records may contain errors caused by wrong allocation to
items. Using this feature, you can finalise your financial reports
without having to wait for the reconciliation of stocks. You can
drill down from Balance Sheet to Stock Register. Disable this
option to maintain accounts and inventory separately.
Enable multiple Price If you maintain different prices for your stock items, depending
Levels on your business type, you can create multiple price levels for
your stock items.

Enable Batches If you sell or purchase your stock in different lots or batches,
you will need to store them accordingly. In Tally Prime, you can
assign batches to your stock when recording transactions.
 Use Discount column If you provide discounts to your parties on the sale or purchase
in invoices of items, you can manage trade discounts for each item during
the corresponding voucher entry.

Use separate Actual In case the billed quantity is usually different from the actual
and Billed Quantity quantity of stock items when recording transactions, you can
columns in invoices track such details by setting this option to Yes.

Taxation

Enable Goods and If your business is under the GST regime, you can specify the
Services Tax (GST) GST Details for your company.

Enable Tax Deducted at If your business is under the TDS regime, set this option
Source (TDS) to Yes and specify the TDS details for your company.

Enable Tax Collected at If your business is under the TCS regime, set this option
Source (TCS) to Yes and specify the TCS details for your company.

Online Access

Enable Browser Access Tally Prime facilitates viewing reports on the browser using any
for Reports device. You can view the reports supported for viewing on the
browser when you are traveling or at the client‟s place – away
from your office computer.
Enable Tally.NET If you need to access your company data from a location away
Services for Remote from your office or synchronize company data available on
Access & different computers, set this option to Yes. You can use the
Synchronization Tally.NET services to connect your company to a centralized
server.

How to open Company Features

In Tally Prime, we can use one of the following methods to open company features:
Path: Tally Prime > Gateway of Tally > F11: Company Features
 Lecture on Order Processing (without GST)

Prof. Piyali Mullick

1. Order Processing
It is the process by which trader purchase/ sale goods from/ to any party. There are two types of
order processing:
a) Purchase Order Processing
b) Sales Order Processing
 Purchase Order Processing is the process of placing orders with suppliers for a
purchase to be made from them.
 Sales Order Processing is the process of receiving orders from customers for the
purpose of selling.
 In Tally Prime, Order Processing is linked to Inventory. This allows tracking of the order
position for a stock item.
2. Path for Purchase and Sales Order Activation
GOT > Press Alter (Masters)> Press Voucher type> Select Particular Voucher> Activate this
voucher type: “Yes”
For Purchase Order Processing

Activate the following vouchers:

a) Purchase order (Ctrl+F9)
b) Receipt Note (Alt+F9)
c) Rejection Out (Ctrl+F5)
d) Purchase (F9)
For Sales Order Processing

Activate the following vouchers:

a) Sales Order (Ctrl+F8)
b) Delivery Note (Alt+F8)
c) Rejection In (Ctrl+F6)
 d) Sales (F8)
3. Purchase Order Processing
• Purchase Order
• GOT > Vouchers > Press Ctrl+F9 (Purchase Order)
• Put all the relevant information
• Save the Purchase Order voucher
• Receipt Note
• Press Alt+F9
• Put all the relevant information
• Save the Receipt Note voucher
• Rejection Out
• Press Ctrl+F5
• Put all the relevant information
• Save the Rejection Out voucher
• Purchase
• Press F9
• Put all the relevant information
• Save the Purchase voucher
Steps for Purchase Bills Details

GOT > Display More Reports > Statement of Inventory > Purchase Order Outstanding > All
Orders > Alt+F1 (for Detail Report) > Print
For other vouchers

GOT> Day Book> Select Particular Voucher> Press Enter> Print

4. Sales Order Processing
• Sales Order
• GOT > Vouchers > Press Ctrl+F8 (Sales Order)
• Put all the relevant information
• Save the Sales Order voucher

• Delivery Note
• Press Alt+F8
 • Put all the relevant information
• Save the Delivery Note voucher
• Rejection In
• Press Ctrl+F6
• Put all the relevant information
• Save the Rejection In voucher
• Sales
• Press F8
• Put all the relevant information
• Save the Sales voucher
Steps for Sales Bills Details

GOT > Display More Reports > Statement of Inventory > Sales Order Outstanding > All
Orders
> Alt+F1 (for Detail Report) > Print
For other vouchers

GOT> Day Book> Select Particular Voucher> Press Enter> Print

Assignment should be attached here after the handwritten notes.

List of reports to be printed for Assignment

1. For Purchase order Processing

Assignment -1
a) Purchase Order Voucher
b) Receipt Note Voucher
c) Rejection out Voucher
d) Purchase Voucher paste output of these reports
e) Purchase Order Outstanding
2. For Sales order Processing
a) Sales Order Voucher
b) Delivery Note Voucher
c) Rejection In Voucher
d) Sales Voucher
e) Sales Order Outstanding
 Lecture 3 on Accounting Vouchers and Memorandum Voucher
Voucher

 A voucher is a document that is used by the accounting department in an organisation or a

business. Vouchers are used for the systematic compilation and collection of data in the form
of invoices, purchase order, certificates, along with other information required to process the
payment.
 Vouchers can be majorly divided in two categories, inventory vouchers, and accounting
vouchers in Tally Prime.
 Under each category, there are numerous different types of vouchers in Tally Prime that the
accounting professionals use.

Predefined Vouchers in Tally

Tally comprises of the following predefined Vouchers, to suit different business
requirements for recording various transactions. Tally also allows users to create
user-defined Vouchers (Voucher Types) as per requirements.
● Sales Voucher / Invoice

● Purchase Voucher / Invoice

● Payment Voucher

● Receipt Voucher

● Contra Voucher

● Journal voucher

● Debit Note Voucher

● Credit Note Voucher

Sales Voucher in Tally

Sales voucher is one of the most used accounting vouchers in Tally. Users can
create this voucher in two different formats; as an invoice, or as a voucher. The
invoice format enables users to print a copy of invoices for customers. The
voucher format can be used to store transactional records electronically and it
doesn‟t need a paper copy for the customer.
Sales Entry‟s shortcut key is F8

Purchase Voucher in Tally

Like sales vouchers, purchase voucher belongs to the accounting category and is
available in both invoice and voucher formats. Editing and modifying receipt
entries in Tally are easy, as its voucher format helps accountants to do so
quickly. Moreover, Tally also helps in converting a purchase voucher in the
invoice format to the voucher format.
For Purchase Entry the shortcut is F9

Payment Voucher in Tally

 The payment voucher is another accounting voucher in Tally that helps create and
print cheques against the order. Once the payment voucher gets passed, the
corresponding cheque can be printed by clicking on „banking‟ and then on
„cheque printing‟.
For Payment Entry the keyboard shortcut is

F5 Receipt Voucher in Tally

When accountants make a receipt voucher in Tally, all the invoices which have
pending payments pop up as a reminder. As soon as the client makes the
payment through any mode, the receipt can be updated with the payment
method details. In addition, all the details of this receipt can be sent to the
customer. Thus, receipt vouchers make payment monitoring easy.
For Receipt Entry the keyboard shortcut is F6

Contra Voucher in Tally

Contra vouchers are used to withdraw or deposit money from/in banks with the
help of instruments such as cheques/ATM/DD or e-transfer to another account
through NEFT/IMPS. With the help of contra vouchers in Tally, accountants
can also generate deposit slips for recordkeeping.
Tally also provides exact currency denominations to monitor and print the
deposit slip while also depositing the amount.
For Contra Entry the function key shortcut is F4

Journal Voucher in Tally

Unlike other vouchers, a journal voucher in Tally can come under the roof of both
accounting and inventory vouchers. There are multiple uses of a journal
voucher in Tally depending on the type of business it is being used for.
It can be found as an optional voucher in Tally to make sales and purchase by
accountants. Professionals can also use it for the adjustment or transferring of
stock from one warehouse to the other.
Journal Entry’s function key shortcut is

F7 Debit Note Voucher in Tally

Debit note voucher is one of the most-used types of voucher in Tally Prime, that is
used for managing purchase returns. With the help of this, accountants can
generate a debit note for invoicing as well as a voucher. Like credit note
voucher in Tally, debit note too can easily be configured by pressing F11 and
configuring it manually.
Debit Note’s keyboard shortcut is

Alt+F5 Credit Note Voucher in Tally

 Credit note voucher in Tally has to be enabled manually. It is usually enabled by
pressing F11 and they manually configuring its features. Credit note can also
be passed by checking the original invoice. When a client is selected, Tally
shows the transaction invoice history that have been raised.
Credit Note’s shortcut key is

Alt+F6 Memorandum Voucher

Register

Memorandum Vouchers is a non-accounting voucher and the entries made using

the memo voucher will not affect your accounts. In other words, Tally does
not post these entries to ledgers but stores them in a separate Memorandum
Register.

Use of Memorandum Vouchers

You can use the Memorandum Vouchers for:
● Payments towards suspense accounts - consider a company gives its employee cash for
Conveyance expenses, the exact nature and cost of which are unknown. For such transactions, you
can enter a voucher for the petty cash advance. A voucher to record the actual expenditure details
when they are known, and another voucher to record the return of surplus cash. However, a simpler
way of doing it is to enter a Memo voucher when the cash is advanced, and then turn it into a
Payment voucher for the actual amount spent, when the actual details are known.

● Vouchers not verified at the time of entry - if you do not understand the details of a voucher you
are entering, you can enter it as a Memo voucher and amend it later when the details are available.

● Items given on approval - Generally completed sales are entered into books. In case items are
given on approval, use a Memo voucher to track and convert it into a proper Sales voucher. You can
delete the memo voucher if the sale is not made.

How to enable memorandum voucher?

Enable the option Use memorandum vouchers from the Gateway of Tally select ‘Charts of
Accounts’ under Masters > Vouchers types > Memorandum > Activate the voucher type ‘yes’

To View Memorandum Voucher Register

Go to Gateway of Tally > Display more reports > Exception Reports > Memorandum register >
select the particular month > Enter

You can also view memorandum vouchers from the Day Book.
Assignment 2 OF TALLY (don’t copy Red text or highlighted
text) Assignment 3

SL
Date Transactions for
No
the month
1 Started business with cash Rs 5,00,000.
02/04/202
5
02/04/202
2 5 Cash deposit into SBI Rs. 1,00,000
02/04/202
3 5 Cash withdrawn from SBI for office use Rs 70,000
02/04/202
4 5 Transfer Rs 20,000 from SBI to HDFC Bank.
02/04/202
5 5 Cash withdraw by the owner Rs 2,500 for personal use.

6 02/04/20 Commission received in HDFC Bank of Rs 25000

25
02/04/202
7 5 Purchase Furniture of Rs 15000 by cheque (SBI).
02/04/202
8 5 Paid Salary to Ram in cash Rs 9,500 in cash.

9 02/04/20 Electricity Charges paid Rs 650 in cash

25
02/04/202
10 5 Paid Audit Fee of Rs 3000 in cash.
02/04/202
11 5 Received Interest from SBI of Rs 600.
02/04/202
12 5 Depreciation charged @ 10% on furniture

Assignment to attached:
Day Book in detail
Assignment 3 OF TALLY (don’t copy Red text or highlighted
text)
Assignment on Ledger Creation
Create a company with ‘Your Name (Cu Roll No.)’ then prepare the following
ledgers for the Financial Year 2025-26

Sl. Particulars Amount Balanc

No. Rs. e
1 Advance Salary 15000.00 Dr
2 Avani Traders (Cr.) 25000.00 Cr
3 Capital Account 410000.00 Cr
4 Cash-in-hand 101800.00 Dr
5 Credit Card Citi Bank- 7300.00 Cr
Payable
6 Drawings 8000.00 Dr
7 Furniture & Fixture 90000.00 Dr
8 General Reserve 195000.00 Cr
9 Investment in Shares 25000.00 Dr
10 Loan from HDFC Bank 32200.00 Cr
11 Loan from ICICI Bank 54000.00 Cr
12 Outstanding Rent 12500.00 Cr
13 Outstanding Wages 7400.00 Cr
14 Plant & Machinery 135000.00 Dr
15 ICICI Bank 155000.00 Dr
16 Stock in Hand 73000.00 Dr
17 Trade Receivables 150000.00 Dr
18 CGST Payable 7200.00 Cr
19 SGST Payable 7200.00 Cr
20 TDS Receivable 5000.00 Dr
Assignment 4 Practicle sum
Company Name: Your Name (CU Roll No)

Date: 1-Apr-2025

Item: HCL Computer

Quantity: 50 units @ ₹25,000

Total Purchase Order Value: ₹12,50,000

Received: 40 units

Returned: 10 damaged units

Final Stock: 30 units

Step-by-Step in Tally

1. Create Ledgers

1. ABC Company
o Under: Sundry Creditors
2. Purchase A/c
o Under: Purchase Account
3. Purchase Returns (optional)
o Under: Purchase Account or Direct Expenses (for clarity)
4. HCL Computer (Stock Item)
o Under: Stock Item
o Units: Nos.
o Rate: ₹25,000

2. Create Stock Group

 Name: Computers
 Under: Primary

3. Create Stock Item

 Name: HCL Computer

 Under: Computers
 Units: Nos.
 Cost: ₹25,000

4. Enter Purchase Voucher

 Gateway of Tally → Accounting Vouchers → F9: Purchase

 Party A/c Name: ABC Company
 Purchase Ledger: Purchase A/c
 Stock Item: HCL Computer
o Quantity: 40
o Rate: ₹25,000
o Amount: ₹10,00,000
  Narration: Being 40 out of 50 HCL Computers received @ ₹25,000 each from ABC Company

5. Enter Purchase Return (Debit Note)

 Gateway of Tally → Accounting Vouchers → Ctrl + F9: Debit Note

 Party A/c Name: ABC Company
 Debit Ledger: ABC Company
 Credit Ledger: Purchase Return (or adjust in Purchase A/c)
 Stock Item: HCL Computer
o Quantity: 10
o Rate: ₹25,000
o Amount: ₹2,50,000
 Narration: Being 10 damaged HCL Computers returned to ABC Company

Stock Summary
Item Quantity Value

HCL Computer 30 Nos. ₹7,50,000

Final Balances
Ledger Amount

ABC Company ₹7,50,000 Cr (Payable)

HCL Computers 30 Nos.

Company Name: Your Name (CU Roll No)

Date: 1-Apr-2025

Item: LED TV

Total Sale: 80 units @ ₹20,000 = ₹16,00,000

Delivered Initially: 60 units

Returned: 20 units by customer

Sent Again: 40 units (final delivery)

Step-by-Step in Tally

� 1. Create Ledgers

1. XYZ Company
o Under: Sundry Debtors
2. Sales A/c
o Under: Sales Account
3. Sales Return A/c (optional)
 o Under: Sales Account or Indirect Incomes (Negative)

2. Create Stock Group & Item

 Stock Group:
o Name: Electronics
o Under: Primary
 Stock Item:
o Name: LED TV
o Under: Electronics
o Units: Nos.
o Rate: ₹20,000

Voucher Entries

1. Sales Entry for 60 Units

 Go to: Gateway of Tally → Accounting Vouchers → F8: Sales

 Party A/c: XYZ Company
 Sales Ledger: Sales A/c
 Stock Item: LED TV
o Quantity: 60
o Rate: ₹20,000
o Amount: ₹12,00,000
 Narration: Being 60 LED TVs sold @ ₹20,000 each to XYZ Company

2. Sales Return Entry for 20 Units

 Go to: Gateway of Tally → Accounting Vouchers → Ctrl + F8: Credit Note

 Party A/c: XYZ Company
 Credit Ledger: Sales Return A/c (or Sales A/c)
 Stock Item: LED TV
o Quantity: 20
o Rate: ₹20,000
o Amount: ₹4,00,000
 Narration: Being 20 LED TVs returned by customer

3. Additional Sales Entry for 40 Units

 Go to: Gateway of Tally → Accounting Vouchers → F8: Sales

 Party A/c: XYZ Company
 Sales Ledger: Sales A/c
 Stock Item: LED TV
o Quantity: 40
o Rate: ₹20,000
o Amount: ₹8,00,000
 Narration: Being 40 LED TVs delivered to customer
� Final Status
Particulars Quantity Amount

Sold (Total) 100 ₹20,00,000

Returned 20 ₹4,00,000

Net Sales 80 ₹16,00,000

Stock Reduced 80 Units

� Company: Your Name (CU Roll No)

� Day Book - Detailed Format

� Date: 02-Apr-2025

Sl. Voucher Debit Credit

Particulars Narration
No. Type (Dr) (Cr)

Cash A/c Dr
1 Journal ₹5,00,000 ₹5,00,000 Being business started with cash
To Capital A/c

SBI A/c Dr
2 Contra ₹1,00,000 ₹1,00,000 Being cash deposited into SBI
To Cash A/c

Cash A/c Dr Being cash withdrawn from SBI for

3 Contra ₹70,000 ₹70,000
To SBI A/c office use

HDFC Bank A/c Dr Being amount transferred from SBI to

4 Contra ₹20,000 ₹20,000
To SBI A/c HDFC

Drawings A/c Dr Being cash withdrawn by owner for

5 Drawing ₹2,500 ₹2,500
To Cash A/c personal use

HDFC Bank A/c Dr Being commission received in HDFC

6 Receipt ₹25,000 ₹25,000
To Commission A/c bank

Furniture A/c Dr Being furniture purchased through SBI

7 Payment ₹15,000 ₹15,000
To SBI A/c cheque

Salary A/c Dr
8 Payment ₹9,500 ₹9,500 Being salary paid to Ram in cash
To Cash A/c

9 Payment Electricity Charges ₹650 ₹650 Being electricity charges paid in cash
A/c Dr
Sl. Voucher Debit Credit
Particulars Narration
No. Type (Dr) (Cr)

To Cash A/c

Audit Fees A/c Dr

10 Payment ₹3,000 ₹3,000 Being audit fee paid in cash
To Cash A/c

SBI A/c Dr
11 Receipt To Interest Received ₹600 ₹600 Being interest received from SBI
A/c

Depreciation A/c Dr Being depreciation charged @10% on

12 Journal ₹1,500 ₹1,500
To Furniture A/c ₹15,000 furniture

� Ledger Heads Used:

Ledger Name Group Head

Cash A/c Cash-in-Hand

SBI A/c Bank Accounts

HDFC A/c Bank Accounts

Capital A/c Capital Account

Drawings A/c Capital Account

Furniture A/c Fixed Assets

Salary A/c Indirect Expenses

Electricity Charges A/c Indirect Expenses

Audit Fees A/c Indirect Expenses

Commission A/c Indirect Incomes

Interest Received A/c Indirect Incomes

Depreciation A/c Indirect Expenses

 Assignment5 OF TALLY (don’t copy Red text or
highlighted text)

"a" to "d" are theory Questions. Ask googles about these

que.

i.e "e" is assignment. i will send solution for this

que.
"e" continues here. and write down steps also
 Payroll Accounting
Assignment 6 OF TALLY (don’t copy Red text or
highlighted text)
 DBMS
Definition:ÿA Database Management System (DBMS) is software that allows users to
create, manage, and interact with databases. It provides a structured way to store,
retrieve, and manipulate data, ensuring data integrity and ÿaccessibility
Functions of a DBMS:
1. Data Storage –:Organizes data in tables or files.ÿ
2. Data Manipulation – Enables inserting, updating, deleting, and querying data.
3. Data Security – Provides access control and user permissions.
4. Data Integrity – Ensures accuracy and consistency of data.
5. Backup & Recovery – Supports regular backups and restores in case of failure.
6. Multi-user Access – Allows multiple users to work with the data simultaneously.:

Example of DBMS

 MySQL
 Oracle
 Microsoft SQL Server
 PostgreSQL
 MongoDB (for NoSQL databases)

Benefits of Using a DBMS:

 Reduces data redundancy

 Enhances data security
 Facilitates data sharing
 Maintains data integrity
 Simplifies backup and recovery

Definition of Query:

A query in a database is a request for information from a

database management system (DBMS), which is the software
program that maintains data. Users can make a query to
retrieve data or change information in a database, such as
adding or removing data.
Definition of Computerized Accounting System:

A computerized accounting system is software that automates the process

of recording and managing financial transactions within an organization. It
replaces manual data entry with computer-based execution, streamlining
accounting tasks and improving accuracy.

What is Spread sheet?

A spreadsheet is a computer application for computation, organization, analysis and
storage of data in tabular form. Spread sheets were developed as computerized analogs
of paper accounting worksheets. The program operates on data entered in cells of a
table.� Formal Definition:

Examples of Spreadsheet Software:

 Microsoft Excel
 Google Sheets
 LibreOffice Calc
 Apple Numbers

Definition of Primary Key:

A primary key is the column or columns that contain values

that uniquely identify each row in a table. A database table
must have a primary key for Optim to insert, update, restore, or
delete data from a database table.

what is relational database?

A relational database is a database based on the relational model of data, as

proposed by E. F. Codd in 1970. A Relational Database Management System is
a type of database management system that stores data in a structured format
using rows and columns.
Notes
What is DBMS?
A Database Management System (DBMS) is software that allows users to create, manage, and
interact with databases. It provides a way for organizations to store, organize, and retrieve large
amounts of data efficiently. DBMSs offer functionalities like data definition, data manipulation,
data storage, and data security.

2.What is query?
A query language, also known as data query language or database query language, is a
computer language used to make queries in databases and information systems. In database
systems, query languages rely on strict theory to retrieve information. A well known example is
the Structured Query Language.

3.What is computerized accounting system?

A computerized accounting system is a software application that automates and manages a
company's financial records and reporting processes. It uses computers and software to record,
analyze, and manage financial transactions, aiming for greater speed, accuracy, and efficiency in
financial management. This system helps businesses streamline accounting steps, minimize
errors, and improve reporting mechanisms.
 4.What is spreadsheet?
A spreadsheet is a digital tool, typically arranged in rows and columns, used for storing, manipulating,
and analyzing data. It's a versatile application that allows users to organize information, perform
calculations, create visualizations, and much more.

5.What is primary key ?

A primary key is a column or a set of columns in a database table that uniquely identifies each row
(record) in that table. It ensures data integrity by preventing duplicate values and null values. Think of it
as a unique ID for each entry in the table.

6.What is relation data base?

A database structured to recognize relations between stored items of information. It is a way of
structuring information in tables, rows, and columns.

Assignment 1,2 OF DBMS (don’t copy Red text or highlighted

text)

1st 7.Create a student database table where the column names are as follows- (10 entries)
Name
Class
Student_id
Ph_no
Address

2nd 8. Record journal entries in a MSaccess table named as Accounts Table where the fields are as follows-
Date
Transaction _ID
Voucher number
Transaction statement
Amount.
 E-FILING
SECTION B
E – FILING OF TAX RETURN
1. Who can use ITR – 1?
Ans: ITR – 1 can be filed by a Resident Individual whose Total income does not exceed
₹50 lakh during the Financial Year.
a. Income is from salary, One house property, Family pension income, Agricultural
Income (up to ₹5000/- ), and Other Sources, which include: Interest from Savings
Account, Interest from deposits ( Bank/Post Office/Cooperative Society ), Interest
from Income Tax Refund, Interest received on Enhanced Compensation, Any other
Interest Income.
b. Income of Spouse (other than those covered under Portuguese Civil Court) or Minor
is clubbed (only if the source of income is within the specified limits as mentioned
above).
2. Mention the due date of furnishing return of Income Tax?
Ans: Any return filed under section 139(4A), 139(4B), 139(4C) or 139(4D) needs to be
filed on or before 31st October of the relevant Assessment Year. However, in any other
case, the due date for filing a return of income would be the 31st July of the relevant
Assessment Year. Individual/HUF whose accounts are to be audited or working partner of
a firm whose accounts are to be audited (30th September of the A.Y) and in case of an
assessee having an international transaction (30th November of the A.Y).
3. Mention the information/documents required for filing ITR – 1?
Ans: From 16, Salary Slips, Interest Certificate from the Post Office and Banks, Form
16A/16B/16C, Form 26AS, Tax Saving Investment proof, Deduction under the section
80D to 80U, Home Loan statement from the NBFC or the Bank.
4. Write in brief the process for filing up the form ITR – 1 and submission?
Ans: You can file and submit your ITR through the following methods:
a. Online Mode – through e-filing portal.
b. Offline Mode – through offline utility. You can refer to the Offline Utility (for ITRs)
user manual to learn more. Follow the steps below to file and submit the ITR through
online mode:
Step 1: Log in to the e-filing portal using your user ID and password.
Step 2: On your Dashboard, click e-file > Income Tax Returns > File Income Tax
Return.
Step 3: Select Assessment Year as 2021 – 22 and click Continue.
Step 4: Select Mode of Filing as Online and click Proceed.
Step 5: Select Status as applicable to you and click Continue to proceed further.
Step 6. You have two options to select the type of income Tax Return. If you are not
sure which ITR to file, you may select Help me decide which ITR Form to file and
 click proceed. Once the system helps you determine the correct ITR, you can proceed
with filing your ITR.
Step 7: Once you have selected the ITR applicable to you, note the list of documents
needed and click Let’s Get Started.
Step 8: Select the check boxes applicable to you and click Continue.
5. What are the reasons for you to file a Tax Return?
Ans: Reasons to file an income tax return:
a. It makes loan processing easier.
b. It helps you claim any carried forward losses.
c. It allows you to claim TDS refunds.
d. It contributes to nation-building.
e. It will help you with visa or credit card applications.
6. What are the types of way to file of e-filing income tax return electronically?
Ans: There are three ways to file Income Tax Returns electronically:
Option 1: Use Digital Signature Certificate (DSC) to e-file. There is no further action
needed, if filed with a DSC.
Option 2: E-filing without Digital Signature Certificate. In this case an ITR-V Form is
generated. The Form should be printed, signed and submitted to CPC, Bangalore using
Ordinary Post or Speed Post (without Acknowledgement) ONLY within 120 days from
the date e-filing. There is no further action needed, if ITR-V Form submitted.
Option 3: E-file the Income Tax Return through an e-Return Intermediary (ERI) with or
without Digital Signature Certificate (DSC).
7. How many types of ITR files are there?
Ans: There are seven ITR forms for individuals, namely, ITR 1, ITR 2, ITR 3, ITR 4, ITR
5, ITR 6 and ITR 7.
8. How can you file an income tax return in India?
Ans: You can file your income tax returns online, either on the income tax department’s
website i.e www.incometaxindia.gov.in
 Assignment 1 OF E-FILING (don’t copy Red text
or highlighted text)

Your Name

Calculate Total Income and Tax liability then file ITR-1.

Solve this sums by hand in and match you solution with e-filing
excel sheet solution.
if solution match then assignment compeleted.

Solution Niche hai