hasdakjsdjk
hasdakjsdjk
hasdakjsdjk
Books
Opcning of TALLY
Chck on Tally ERP 9 software>Alt+W.
Click on Tally shortcut softwarc>Al+W>Alt+.
Creation of a Company
Gateway of Tally (GOT)>Company Info (Alt+F3)>Create Company(C)>Fill the detail in the Company Creation
Screen>To save press "y" or "ENTER" or "Crl+A".
Company Name DELL INDIA LTD. (college roll no.)
Mailing Name [email protected]
Address GARIAHAT, KOLKATA
Country INDIA
State WEST BENGAL
Pin Code 700029
Mobile Number STUDENT CONTACT NUMBER
E-mail Address [email protected]
Financial Year From a1/4/2024
Books BeginningFrom 1/4/2024
Back Un:
Back Up refers to storing of data from the computer to sccondary storage devices like Compact Disk, Floppy Disk
or Pen Drive
Company nfo. (Al+F3)> Back Up(B)>Press Backspace> Select Destination>Select tine Company Name>Select
End of LisPicss "Y".
Restore:
Resture rcfers to installing the tally data from the sccondary storage devices like Compact Disk, Floppy Disk or
Pen Drive.
prapice
KCompany Info. (Alt+F3)> Restore(R)>Press Backspace> Select Destination>Select the Company Name>Sclcct
End of Lis>Press *y".
Export of data:
Export of data refers ransferring of companies' data from one party to another party through mail or any other
modes.
GOT>Display (D)>Day book (D)>Press Alt+E>Select the Default (All languages) in the language ficld>Sclect
EXCEL (Spreadsheet) in the Format Field>Enter the path of the location where the Gles are to be exported in the
cxport location ficld>Press "Y to cxport the companics Data.
Import of data:
Import of data refers recciving of companics data from one party to another party through mail or any other
modes.
GOT>Imporl of Data>Select the required field (Masters, Vouchers, Bank Details)>Enter the reguired filename in
Import File Name (Exccl Sprcadsheet) ficld.
(2 9ud Clags
LEDGER CREATION:-GOT>Accounts Info(A)>Ledgcrs(L)>Create(C>Give a name of the ledger>Sclect a
group(under)>Give the Opening Balance>CirltA.
Name of thc Ledger Accounts Name of thc Groups Opening Balancc Dr/Cr.
Equity Share Capital A/C Capital Account 450000 Cr.
General Reserve Reserves & Surplus 75000 Cr.
Overdraft Balance at UBI Bank O/D A/C 25000 Cr.
Loan from IDBI Secured Loan 55000 Cr.
Loan from GE Finance Unsecured Loan 33000 Cr.
Outstanding Sales Tax Current Liabilitics 2800 Cr.
Building Fixed Assets 300000 Dr
Chowdhury Brothers Sundry Dcbtors 30000 Dr
Sinha &Sons Sundry Creditors 150000 Cr
State Bank of ndia Bank Accounts 100000 Dr
Accounting Voucher:
Accounting Vouchers are mainly of four types:- CONTRA. PAYMENT, RECEIPT &JOURNAL voUCHERS.
From GOT press F12>Voucher Entry>Make the option Use Single Entry Mode for Payment/Reccipt/Contra
YES">Ctrl+A
Alternatively, to pass entries in double cnty mode, from GOT press FI2>-Voucher Enury>Make the opton Use
Single Entry Mode lor Paymen/ReceipUConra NO>Crl+A.
CONTRA VOUCHER:- GOT>Accouning Voucher(V)>Press F4 lor Contra Entry>F2 for Changing
Date>-SclecUCrcatc Onlinc(Alt+C) the account to be credited>Give the amount in the credit coloumn Press
"Enier twice>SclecvCrecatc online Alr+C) the account to be deoited Give the amoun in the dcbi
Coloumn>Press "Enier"'>G ve the narrationCrltA.
Entties:- T) Cash Rs 500c0 withdrawn from SBI bank.
V I) Cash Rs 25000, depositedinto SBI Bank.
PAYMENT vOUCHER:- GOT>Accounting Voucher(VPPress FS for Payment Entry> F2 for Changina
Date>SélectCrcate Oniinc( Alt+C) the account to be dcbitcd>CGive the amount in thc debit coloumn> Press "Enter
tyice>SclectCrcate online (Alt+C) the account to be creditcd>Give the amount in the credit Colounr Press
Enter'>Give thc narration>Ctrl+A.
Entries;- I) Paid Cash Rs 20000 to Sinha &Sons.
II)Salary Paid to Shyam Roy by Cheque of SBI Rs 20000
RECEIPT VOUCHER:- GOT>Accounting Voucher(V)>Press F6 for Reccipt Entry>F2 for Changing
Date>SelccuCrcate Online( Alt+C) the account to be credited>Give the amount in the credit coloumn-Pres
"Eater" twice>SclccvCreate online (Al+C) the account to be debited>Give the amount in the debit
ColomnPress "Enter>Give the narration>Curl+A, g
Epries:- ) Cash Rs 10000 reccived from Chowdhury Brohers.
II) Amount Rs 5000 Received From Chowdhury Brothers through NEFT (National Electronic Funds
Transfer),
JOURNAL VOUCHER:- GOT>Accounting Voucher(V)>Press F7 for Joumal Entry>F2 for Changing
Dale>SclecuCrcaie Online(Al+C) the account to be dcbitcd>Give the amount in the debil coloumn-Pres "Enter
twice>SclecUCreate online (Alt-C) the account to be credited>Give theamount in thecredit Colounu Press
"Enter>Give the narration> C1rl+A.
Entries:- 1) Stationary purchased from Ganguly Papers Lid Rs 2000,
II) Purchased Gdods from Sinha & Sons Rs,. 25000,
REPORT:-G0T>Display (D>Day book (D),.
Debenhuze-Non
Prepaid wsamee Exp
NOE-To activatc Caleulator in Tally ERP Press "Crl+N". To deactivate Calculator in Tally ERP Press
"Crl+M
MEMORANDUM VOUCHER:-Memorandum Voucher is anon- accounting voucher and the entrics made
using the memo vouchcr will not allcct accounts.
From GOT press "F1|" Accounting Features>Make the option "Use reversing journals and optional vouchers"
under budget andscenarno management "YES">Go to Galeway Of Tally (GOT)> Accounting Vouchers/Inventory
Vouchers>Press "Curl+F10" for MEMOS Entry.
REPORT:- GOT-Display (D)>Exception Reports>Memorandum Vouchers.
AANUEACTURING ENTRY &STOCK JQURNAL:
Step 1:-F12>Accounts/Inventory Info. (A)>Allow Component ListDetails (Bill of Materials)-"YES">Ctrl+A.
Step 2:-G0T> Inventory Info. ()>Stock Items (0>Create(C) Finished Goods(c.g. Computer)>Set the option
"Alter Componcnts (BOM)"YES>Sct the "Unit of Manufacture" as 1>SelccvCreate theraw materials (c.g.,
CDD, HDD, FDD, Monitor, Keyboard, Mouse. RAM, Motherboard, Scanner, etc) with godown name and
quantily required to manulacturelunit of the finished goods>Cul+A(wice).
Step 3:-GOT>Inventory Info. (I)>Voucher types (V)Create (C)
Name: Manufacturing Joumal
Type of Voucher: Stock Jounal
Use as a Manufacturing Journal- "YES"
CuitA
Step 4:-G0T inveniory Voucher (T>Alt-F7>sclect the Voucher Typeas"ManufacturingJounal'".
Narneof the Product: Finished Product (c.g.. Computer)
S he ra'cs lor ilrc-raw materals, if not set previously, and go on pressing ENTER till voucome to the right hend
se ti ddito.aai cos ieid, Cieaierselect Freg1t (under: Direct Expemses), Carriage( under: Direct
ExDenses). or othcr dircct and indircct expenses incurrcd in relation to manufacturing of the product> Give the
narration>Ctri+A
RÉPORT:- GOT>Display (D)>Inventory Books (I)>Stock Transfer (T).
ASSiGNAIENT
ihe HP LTD decided to produce "COMPUTER'. The following ingredients are required to
Manufhciure I oicce of COMPUTER to ALIPUR godown. Produce 25 picces of COMPUTER at ALIPUR
godownwith adaitional charges:
Wages - Rs G809, Power- Rs i500, freight &Cariagc charge - Rs 2500
Name Quantity/Unit RateJnit(Rs)
INTEI. PROCESSOR I3 IPcs SA8000
Motherboard 1Pcs 3500
RAM 8GB 2 Pcs 950
SSD 512 GB 1Pcs 3000
LED Monitor IPcs 5000
Step 3:-GOT> Accounts Info (APCust Centre (C)>Create (C)>Select the name of the cost-eaegory >Press
"ENTER">Give the name of the Cost Centre (e.g., Eastern or Westemn under Branch, Sales/Accounts uTider
Department, Mr. Roy/Mr. Sinba under Employec Name etc)>CrltA.
Step 4:-GOT>Accounting Voucher (V)>F5/F6>Select/Create online (Alt+C) the account to be debitea or credited
(while crcating he nccessary account, the option "Cost Centre are Applicable" should be made YES" Give the
amount in the debit or creditcoloumn as the case may be> Press ENTER">in the Cost Allocation box that opens,
select the cost category, cost centre and respective amountCrl+A> Press "ENTER"> Selec/Create online
(Alt+C) the account to be debited or credited>Give the amount in the debit or credit coloumn> Press "ENTER">
Give Narration>Cirl+A.
ASSIGNMENT
Paid Traveling expenses Rs 3000/- by cash as per following cost centre &Cost categories:
Branch Department Manager
Mumbai Marketing Sales Manager
REPORT:- G0T>Display (D> Statement of Accounts (S)>Cost Centres (C>Category Sunumary (C) Cost Centre
Brcak-JP (0)/Ledger Brcak-Up (L)/Group Brcak-Up(G).
BANK RECONCILIATION:
Step 1:-GOT>Display (D)>Accounts Books (A> Cash/Bank book.
Step 2:-Selectthe required Bank Account> Press "ENTER" on the required month (or press F2 function button on
the keyboard and specify the required period from which date you want to rcconcile your bank account)Press
"FS" for bank reconciliation>Give the date of clearing from the bank statements into Bank Date coloumn next to
voucher type coloumn to reconcile the statements>CrltA to accept/save the reconciliation statenment prepared
Wor k iu folui mode fAIE +W)
S’ seleetcompany
comary TDel indin (21094)
SIVANATH SASTRCOLLKGE
Department of Commerce (Hons. in Accounting&Finance),
Paper: Computerized Accounting and e-filing of Tax Return (SEC 6.1 Chg)
REPORT:- GOT>Display (D)º StatutoryReports (0)> TDS Report (R)> Print Form 16A
(T)/E-TDS Form (Ey Print Form 27A (A).
Assignment:-Paid Rs95000 to Sinha &Sons. For legal services provided by them subject
to deduction of TDS.
GOODS AND SERVICE TAX:- Goo and service tax means tax on supply of goods or serviccs.
or þoth, cexcept taxes on supply of alcoholic quor for human consumption.
Iypes of GST-3B, GSTRI, GSTR2 (SERV EPROFILE)
3B- business to business
GSTRI- SALE (OUTPUT)
GSTR2- PURCHASE (INPUT)
GSTIN NUMBER- WB CcODE (19) --LA 3digit is sclected by GST registercd office.
Maximum GST deals with purchase. and sales of company.
SGST- State Goods and Service Tax
CGST-Central Goods and Service Tax
IGST- Integrated Goods and Service Tax (mainly de with cxport and import)
INVENTORY VOUCHER, ORDER PROCES. NG &INVOICING-The purchase and saie
entries can be made in tally in two formats. viz. "As V cher" or "As Invoice". To shift betvween both
the modes, the key combination used is "Alt+r" In gei al, the invoice mode is used (except entries
for Fringe Bencfit Tax and Job Costing).
The purchase and sale entries are passed in three stages:
" Order
" Challan
" Invoice
The first two steps are parts of invcntory voucher (Purchase Ordc 'Al+F4" for Purchase and Sales Ordct
"Alt+F5" for Sales, Reccipt Note-"Alt+F5" for Sales. Rcccipt N e-Al+F9" for Purchase Chalian and
Delivery Note-"Alt-F8" for Sales Challan) and the last step is part o. ccounting voucher (Purchase-"F9 for
Purchase and Sales-"F8" for Salcs).
While preparing the order challan, only Quantity of thc item must be me oncd and not the rate. The ratc is ko
be given along with the quantity in the invoice only.
SIVANATHSASTRICOLLEGE
Department of Commerce (Hons. in Accounting &Finance),
Paper: Computerized Accounting and e-filing of Tax Return (SEC 6.1 Chg)
Unit-I Duration: 2hrs
Semester-VI
PAYROLL ACCOUNTING:- Payrollenables users to set up and implement salary structures, ranging
from simple to complex, as per the organizations requirements.
1Sep 1:-Fl1>Accounting Features (A)>Maintain Payrol|-"YES">Maintain Cost Centre -"YES">More than
ONE Payroll/Cost Category "YES">Ctrl+A.
Step 2:-GOT>FI2>Payroll Configuration (Y)>Make allthe options YES> Ctrl+A.
Step 3:-GO-Payroll Info. (L)>Attendance/Production Type (A)>Create (C)
Attendance
Under: Primary - Varmetlut
Incom Snding
Attendance Type: Attendance/Leave with Pay
p4:- GOT> Payroll Info. (L)>Pay Heads (P)>Create (C)
(a) Basic Salary (b) Dearness Allowance
Pay Head Type: Earning For Employees Pay Head Type: Earning For Employees
Under: Indirect Expenses Under: Indirect Expenses
Net affect in salary: Yes Net affect in salary: Yes
Name to appear in Pay slip: Basic Salary Name to appear in Pay slip: Dearness Allowance
fnnUsed in Gratuity: Yes Used for Gratuity: Yes
Calculation Type: On Attendance Calculation Type: As Computed Value
Attendance/Leave with Pay: Attendance Compute: OnCurrent Sub-Total
Calculation Type: Months Siab Type: Percentage
Per day Calculation Basis: As Per Calendar Period,| Value Basis: Give the rate as applicable
(c) House Rent Allowance (d) Medical Allowance
Raunding Under:
Pay Head Type: Earning For Employees
Indirect Expenses
Pay Head Type: Earning For Employees
Under: Indirect Expenses
Net affect in salary: Yes Net affect in salary: Yes
Name to appear in Pay slip: House Rent Name to appear in Pay slip: Medical Allowance
Allowance
Used for Gratuity: No Used for Gratuity: No
Basje Calculation Type: As Computed Value Calculation Type: On Attendance
Compute: On Specified Formula (Basic Salary +
Attendance/Leave with Pay: Attendance
Dearness Allowance)
Slab Type: Percentage Calculation Type: Months
Value Basis: Give the rate as applicable Per dayCalculation Basis: As per Calendar Period.
(e)Conveyance Allowance () ProfessionalTax
Pay Head Type: Earning For Employees Pay Head Type: Deduction from Employees
heod Under: Indirect Expenses
Under: Current Liabilities
Net affect in salary: Yes Net affect in salary: Yes
Name to appear in Pay slip: Conveyance Name to appear in Pay slip: Professional Tax
Allowance
Used for Gratuity: No Calculation Type: As Computed Value
Calculation Type: On Attendance
Compute: OnSpecified Formula (Basic Salary +Deamess
Allowance)
Give the slab range, corresponding slab type as
Attendance/Leave with Pay: Attendance Percentage as Rates of Taxes as Applicable.
Calculation Type: Months
Per day Calculation Basis: As per Calendar Period.