Accounting Package

Microsoft Office Excel

Excel is an electronic spreadsheet program that can be used for storing, organizing and manipulating data.

How to Open the Microsoft Office Excel 2007/2024?

·         Go to Start Button

·         Click on Programs

·         choose the Microsoft Office Excel 2007/2024

·         Click on Microsoft Office Excel 2007/2024

Or

·         Go to start button

·         Click on run

·         Type your program name Eg. Excel

·         Click on ok

Cell Pointer Movement

Right Arrow : Move the cell Pointer One cell Right.

Left Arrow : Move the cell Pointer One Cell Left.

Down Arrow : Move the Cell Pointer One Cell Down.

Up Arrow : Move the cell Pointer One Cell Up.

Ctrl +Right Arrow : Move the cell Pointer End of Column(XFD)

Cltrl +Left Arrow : Move the cell Pointer Beginning of Column(A)

Ctrl+Down Arrow : Move the cell Pointer End of Rows.(1048576)

Ctrl+UP Arrow : Move the cell Pointer Beginning of Row(1)

Ctrl+Home : Move the cell Pointer Begging of Cell (A1)

Tab : Move the Cell Pointer One Cell Right.

 

Bill

 

S.N.	Particular	Qty.	Rate	Amount	Discount	Net. Amount
1.	Book	12	155	?	?	?
2.	Copy	15	65	?	?	?
3.	Pen	18	25	?	?	?

 

To Find the Amount

=Qty Cell*Rate Cell

 

To Find the Discount

=Amount Cell *10%

 

To Find the Net. Amount

=Amount Cell-Discount Cell

 

 Salary Sheet

 

s.n.	Name	Address	Post	Salary	Bonus	Total	TAX	NET.  Amount
1	Ram	Ktm	Teacher	15000
2	Sita	Ktm	Doctor	25000
3	Gita	Ktm	Nurse	12500

 

To Find the Bonus

=Salary*10%

 

To Find the Total

=Sum(salary:bonus)

 

To Find the Tax

=total*5%

 

To Find the Net. Amount

=Sum(total-tax)

  

MarkSheet

S.N.	NAME		NEP	ENG	ACC	BOOM	ECO.	Tot	Per	Res	Div
1	Nitesh		45	85	95	55	85
2	Ayush		95	85	44	56	65
3	Susmita		55	78	75	67	57

 

To Find the total

=Sum(nep:eco)

To Find the Percentage

=Sum(total/No. of Subject)

 

To Find the Result

=if(and(nep>=35,eng>=35,acc>=35,boom>=35,eco>=35),"pass","fail")

 

To Find the Division

=if(result="fail","tryagain",if(percentage>=60,"1st",if(percentage>=45,"2nd",if(percentage<=45,"3rd"))))

 Nepal Election Report

To Find the Age

=datedif(dateofbirthcell,today(),"Y")

To Find the Remarks

=if(age cell>=18,"voter","underage")

Calculating Work Time

 Calculating Work Time Formula

=mod(endtime-starttime,1)

How to use the PMT function to get the monthly mortgage payment for a 1 million mortgage at 5% for 20 years.

Apply the sum function to calculate Debit Credit Running Balance

Formula

=sum(d4+b5-c5)

How to insert the border?

·         Select the Cell

·         Go to Home menu

·         Click on Border

·         Choose the border style

·         click it

How to Combine the Cell?

·         Select the cell

·         Go to home menu

·         Click on merge cell

How to set the alignment?

·         Select the cell

·         Go to home menu

·         Click on alignment

·         Choose the alignment style

·         Click it

How to Create the Chart?

·         Create the Salary Sheet

·         Select the salary sheet

·         Go to Insert menu

·         Click on Chart

·         Choose the Chart Style

·         Click it

How to Change the Background?

·         Go to page layout menu

·         Click on background

·         Choose the background style

·         Click on Insert

How to set the sort?

·         Select the Cell

·         Go to Data menu

·         Click on Sort

·         Choose the any one option

·         Click it

How to set the Filter?

·         Go to Data menu

·         Click on filter

How to insert the Comment?

·         Go to review menu

·         Click on Comment

·         Type the Comment text

How to set the Protect sheet?

·         Choose the sheet

·         Go to review menu

·         Click on protect sheet

·         Type the password no.

·         Click on ok

·         Again, Type the same password no.

·         Click on ok

How to hide and show the Gridlines?

·         Go to view menu

·         Active / Un active the gridline tab box

How to set the zoom?

·         Go to view menu

·         Click on zoom

·         Choose the zoom size

·         Click on ok

Tally

Computerize Accounting Package

Tally 9.0 ERP

Introduction:

The Security of Data, Financial or otherwise, has always been a matter of concern. Most businesses depend on the confidentiality of information. Tally Vault is an enhanced security system which allows for encryption of the company data with the most secure method of encryption being used. Tally Vault ensures that under no circumstances, the original information is available in any form. The technique could be likened to "encryption-decryption-on-the-fly", and the decrypted form of data is never stored in the system. Apart from this, it uses the "non-stored password" mechanism. By using highly advanced mechanisms to validate a new user without any prior knowledge of the original password. The combination of these facilities means, that Tally Vault becomes one of the most secure means of information storage.

1988 started tally solution from India.

Tally 4.5 Versions (V/S)

Tally 5.2 Versions (V/S)

Tally 5.4 Versions (V/S)

Tally 6.3 Versions (V/S)

Tally 7.2 Versions (V/S)

Tally 8.1 Versions (V/S)

Tally 9.0 Versions (V/S)

How to open Tally 9.0?

Process:

●      Go to the Start menu.

●      Select on All Program.

●      At last click on Tally 4.5, 5.2, 5.4, 6.3, 7.2,  8.1, 9.0.

Or

●      Show on the Tally 9.0 Icon in Desktop.

●      Select on Tally 9.0 Icon.

●      Right click on mouse in select icon.

●      Click in Open Button.

Note:- Tally System By (Dr) & To (Cr)

Shortcut Key of Tally

Esc                  =         Exit, Back, No

Enter               =         Open, Entry, Yes

Ctrl+A             =          Save

Alt+D              =          Delete

Company Info

●      Tally Company Creation

Company Info > Create Company > press “Enter” Key.

Gateway of Tally > press”Alt+F3”key > Company Info > Create Company > press “Enter” key.

Let us examine each option and its applicability.

1. Maintain: Specify whether you want to maintain only financial books of accounts or both accounts and inventory. Select from the popup list.
2. Accounts only: Select this only if you do not have any inventory transactions (suitable for professionals and corporate offices). Tally would not permit intrusion of Inventory related information that is not required.
3. Accounts-with-Inventory: This obviously allows you to maintain both financial accounts and inventory. You may choose not to use one or the other until the need arises.
4. Financial Year From: Enter Beginning date of Financial Year.      
5. Books beginning From: Normally it is same of Financial Year From, unless you stat Accounts from middle of financial year.                                                    

●      Select Company (F1)

Company Info > Select Company > press “Enter” Key.

Gateway of Tally> press”Alt+F3” key > Company Info >Select Company> Select a company which you want to select > press “Enter” key.

●      Shut Company (Alt+F1) (To hide unnecessary company from selected company list)

Company Info > Shut Company > press “Enter” Key.

Gateway of Tally > press “Alt + F3” key > Shut Company > Select a company which you want to shut > Press “Enter” Key.

●      Alter (Alternation of Company)

(To modify or delete company)

Company Info > Alter > press “Enter” key.

Gateway of Tally > press “Alt + F3” key > Company Info > Alter > select a company which you want to (Alter) modify or delete > press “Enter” key.

●      Delete Company

(To delete company)

Company Info > Alter > press “Enter” key > select a company which you want to delete > press “Enter” key > press “Alt+D” key.

Gateway of Tally > press “Alt + F3” key > Company Info > Alter > select a company which you want to delete > press “Enter” key > press “Alt+D” key.

●      Create Group Company

Company Info > Create Group Company > press “Enter” Key.

Gateway of Tally > press “Alt + F3” key > Company Info > Create Group Company > press “Enter” key.

(Show the minimum two companies in the list of selected companies.)

●      Security Control

Company Info > Security Control > press “Enter” Key.

Gateway of Tally > press “Alt + F3” key > Company Info > Security Control > select a company which you want to security control > press “Enter” key.

Items	Details	Example
User Name	Shortcut Name of Company	Unitech
Password	Character or Number	*****

●      Change Tally Vault

Company Info > Change Tally Vault > press “Enter” Key.

Gateway of Tally > press “Alt + F3” key > Company Info > Change Tally Vault > select a company which you want to password > press “Enter” key > give a tally vault password.

Backup and Restore:

If is use to restore file from Computer to Pendrive, Floopy, Local Disk :D, :E. This menu is specially use for tacking a data form one storage in to another storage medium. In back up we have to keep the source and destination of the data.

 

●      Backup

Company Info > Backup > press “Enter” Key.

Gateway of Tally > press “Alt + F3” key > Company Info > Backup > select a company which you want to store > press “Enter” key.

Select your Backup Location from Destination.

Source	C:\Tally\Data (Transfer Location)
Destination	D:\New Folder (Store Location)
Selected Companies	Unitech IT Solution

●      Restore:

It is use to store files from Pendrive, Floopy, Local Disk :D, :D, to Computer. In this mode the sources & destination have found. We should also give the source & destination in restore option. We can't bring back the data from any medium in others medium. We have to do this if we wish to restore this data again in the disk.

Company Info > Restore > press “Enter” key.

Gateway of Tally > press “Alt + F3” key > Company Info > Restore > select a company which you want to restore > press “Enter” key.

Select your Restore Location from Destination.

Destination	C:\Tally\Data (Transfer Location)
Source	D:\New Folder (Store Location)
Selected Companies	Unitech IT Solution

Ledgers

The ledgers are actual heads to which the transactions are identified. We have to make voucher entries in these accounts. As mentioned earlier, we have to classify all ledgers into groups

Single Ledger creation

Gateway of Tally > Accounts Info > Ledgers > Create

Name   : Enter the name of account

Alias    : Give the alternative name if required

Under  : Select the Group under which the Ledger is created from the list of Groups.

Item	Name
Name of Account	Salary Paid
Alias
Under	Indirect Expenses

Display of Ledger

Getaway of Tally > Accounts Info > Ledgers > Display

Alternation of Ledger

Gateway of Tally > Accounts Info > Ledgers > Alter

Deletion of Ledger

Gateway of Tally > Accounts Info > Ledgers > Alter > Select a Ledger which you want to delete > press “Alt + D” Key.

Name of Ledger	Under
Sales	Sales Account
Purchase	Purchase Account
Capital	Capital Account
Salary	Indirect Expenses
Rent	Indirect Expenses
Furniture	Fixed Assets
Bank	Bank Account
Land and building	Fixed Assets
TAX	Duties and Taxes
Service Tax	Duties and Taxes
VAT	Duties and Taxes

 

 

Voucher

Accounting Voucher

Inventory Buttons : F1

Date : F2

Company : F3

Contra : F4

Payment : F5

Receipt : F6

Journal : F7

Sales : F8

Credit Note : CTRL+F8

Purchase : F9

Debit Note : CTRL+F9

Reversing Journal Voucher : F10

Memos : CTRL+F10

Features : F11

Configure : F12

 

Contra Voucher :

Cash Deposited in to Global Bank 5000/-

Bank : DR        - 5000

Cash CR           - 5000

Naration : Being cash deposited

 

Cash withdraw from Global Bank 2000/-

Cash : DR - 2000/-

Global Bank : 2000/-

Payment :

Salary Paid 6000/-

Salary : DR

Cash : CR

 

Rent Paid :  4000

Rent : DR

Cash CR

 

Receipt Voucher : (Ledger Create : Alt C : Interest Receiptà  Indirect Income)

Interest Receipt  4000

Cash DR :

Interest Receipt : CR

 

Journal (Ledger Crate : ALT +C : Carriage Inward Paid à Indirect Expenses)

Carriage inward paid 100/-

Carriage Inward : DR

Cash : CR

 

Sales

Sold on Goods 11100/-

Cash : DR

Sold Goods/ Sales : CR

2 types of sales mode (Press CTRL+V to change mode)

 

Purchase : (Press CTRL+V change mode)

 

Purchage on  Goods 11100/-

Sold Goods/ Sales : DR

Cash : CR

 

Display/Editing

Displayà daybook à

Ledger Under Group 

s.n.	Ledger	Under	Balance
1.	Advertisement	Indirect Exp.	DR
2.	Audit Fees	Indirect Exp.	DR
3.	Bad Debts	Indirect Exp.	DR
4.	Bad Debts (New)	Indirect exp.	DR
5.	Bad Debts recovered	Indirect exp.	CR
6.	Bank	Bank	DR
7.	Bank Charges	Indirect Exp.	DR
8.	Bank Overdraft	Bank Overdraft	CR
9.	Bills Payable  or (B/P)	Current Liabilities	CR
10.	Bills Receive or (B/R)	Current Assets	DR
11.	Boxes & Labels	Direct Exp.	DR
12.	Brokerage	Indirect Exp.	DR
13.	Business Premises	Fixed Assets	DR
14.	Capital	Capital	CR
15.	Carriage	Direct Exp.	DR
16.	Carriage Inward	Direct Exp.	DR
17.	Carriage On Purchase	Direct Exp.	DR
18.	Carriage Outward	Indirect Exp.	DR
19.	Cartage	Direct Exp.	DR
20.	Cash at Bank	Bank	DR
21.	Cash in Hand	Cash	DR
22.	Charity	Indirect Exp.	DR
23.	Commission	Indirect Exp.	DR
24.	Commission (CR)	Indirect Income	CR
25.	Conveyances	Indirect Exp.	DR
26.	Custom Duty on Import	Direct Exp.	DR
27.	Depreciation	Indirect Exp.	DR
28.	Discount	Indirect Exp.	DR
29.	Discount on (CR)	Indirect Income	CR
30.	Discount on (DR)	Indirect Exp.	DR
31.	Distributive Exp.	Indirect Exp.	DR
32.	Dock Charges	Direct Exp.	DR
33.	Drawing	Capital	DR
34.	Electric Charge	Direct Exp.	DR
35.	Entertainment Exp.	Indirect Exp.	DR
36.	Establishment Exp.	Indirect Exp.	DR
37.	Export Duty	Indirect Exp.	DR
38.	Factory Exp.	Direct Exp.	DR
39.	Factory Exp. & Insurance	Direct Exp.	DR
40.	Freehold / Leasehold Land	Fixed Assets	DR
41.	Freight Inward	Direct Exp.	DR
42	Freight Outward	Indirect Exp.	DR
43	Fuel Heating & Lighting	Direct Exp.	DR
44	Furniture & Fitting	Fixed Assets	DR
45	Gas Water & Oil	Direct Exp.	DR
46	General Exp.	Indirect Exp.	DR
47	Goodwill	Fixed Assets	DR
48	Grease	Direct Exp.	DR
49	Horses & Carts	Fixed Assets	DR
50	Insurance	Indirect Exp.	DR
51.	Interest	Indirect Exp.	DR
52	Interest (CR)	Indirect Income	CR
53	Interest Capital	Indirect Exp.	DR
54	Interest on Drawing	Indirect Income	CR
55	Investments	Investment	DR
56	Land & Building	Fixed Assets	DR
57	Legal Charges & Law Fees	Indirect Exp.	DR
58	License Fees	Indirect Exp.	DR
59	Loan & Advance	Current Assets	DR
60	Loan (CR)	Loan (Liability)	CR
61	Loan (DR)	Current Assets	DR
62	Loss By theft. Fire	Indirect Exp.	DR
63	Manufacturing Exp.	Direct Exp.	DR
64.	Miscessanceous Exp.	Indirect Exp.	DR
65.	Motive Power Coal	Direct Exp.	DR
66	Octori	Direct Exp.	DR
67	Office Exp.	Indirect Exp.	DR
68	Office Lightings	Indirect Exp.	DR
69	Outstanding Exp.	Current Liability	CR
70	Outstanding Income	Current Assets	DR
71	Packing Charges	Indirect Exp.	DR
72	Patents and Trade Marks	Indirect Exp.	DR
73	Plant & Machinery	Fixed Assets	DR
74	Postage & Telegram	Indirect Exp.	DR
75	Prepaid Exp.	Current Assets	DR
76	Prepaid Income	Current Assets	DR
77	Provision For Bad Debts (New)	Indirect Exp.	DR
78	Provision For Bad Debts (Old)	Indirect Exp.	DR
79	Purchase	Purchase A/c	DR
80	Purchase return	Purchase A/c	DR
81.	Radio Set	Fixed Assets	DR
82	Rent	Indirect Exp.	DR
83	Rent From Tenants	Indirect Exp.	CR
84	Repair Renewals	Indirect Exp.	DR
85	Repair to typewriter	Indirect Exp.	DR
86	Reserve Fund	Reserve & surplus	DR
87	Return Inward	Sales	CR
88	Return Outward	Purchase	DR
89	Royalties Based on Production	Direct Exp.	DR
90	Salary	Indirect Exp.	DR
91	Sales	Sales	CR
92	Sales Return	Sales	DR
93	Stable Exp.	Indirect Exp.	DR
94	Stationery & Printing	Indirect Exp.	DR
95	Stationery	Indirect Exp.	DR
96	Stock	Stock in Hand	DR
97	Sundry Creditors	Sundry Creditors	CR
98	Sundry Debtors	Sundry Debtors	DR
99	Sundry Receipts	Indirect Income	CR
100	Sundry Trade Exp.	Indirect Income	DR
101	Telephone Exp.	Indirect Exp.	DR
102	Tools	Fixed Assets	DR
103	Travelling Exp.	Indirect Exp.	DR
104	Unexpired Insurance	Current Assets	DR
105	Up Keep of Cars & Vans	Indirect Exp.	DR
106	Wages	Direct Exp.	DR
107	Wages & Salary	Direct Exp.	DR

Inventory Info

Stock Groups

Stock Items

Units of Measure

Voucher Types

Copy allocations Details

Units of  Measure

Create>Pc>Piece

 

Stock Group

Computer> Primary

Stock Items

Mouse

Under : Computer

Keyboard > Computer

Ram> Computer

MB> Computer

HDD>Computer

CPU FAN > Computer

Accounting voucher

Purchase> Reference 01

Party Name : Cash

 

 

Sales(F8)

Reference : 01

Party Name  : Cash

 

How to Check Stock ?

Gateway of tally> Display>Statements of Inventory>

Print Bill

Gateway of Tally>Display> ALT+P

Setting : 

Day : 4

Gateway of Tally

Inventory Voucher

Ledger

Sales= Sales Accounts

Purchase>=Purchase Accounts

Cash Transactions

Inventory Info

Units of Measure>Create>pc>piece

Stock Groups

Create>Computer>primary

Stock Items: 

Mouse>computer>Under pc

Keyboard>Computer>under pc

Motherboard>Computer>under Pc

Accounting Voucher

Purchase(Voucher Mode change : ctrl+V)(Cash Transaction)

Party A/c Name : Cash

Purchase Ledger : purchase

(narration : being purchase)

 

Sales(F8) Buyer Cash

Sales Ledger : Sales

(Naraction : Goods Sold)

display OPTION

Statement of inventory

Stock query

Choose product.

Profit and loss account

Day 5 

Features : (Discount Offer)

Inventory Features(F11)> Use separate actual and billed quantity column>Yes>

Account Info>Leader > Create> Sales>Sales Account

Account Info>Leader > Create> Purchase>Purchase Account

Units of Measure : pc > Piece(decimal 0)

Group > Shirt>primary

Stock Items>Neel M Size>under shirt

Accounting Voucher >

purchase(F9)> Party Name(ABY)Under Sundry Creditors)

Purchase Ledger > Purchase

 

Debit Note or Credit note

Features(F11)> Inventory  Features > Use Debit and Credit notes(Yes), Record Credit Notes in Invoice Mode(Yes), Record Debit Notes in Invoice Mode > Yes(Save)

Ledger > Purchase Return>Purchase Accounts

Sales return> Sales Return

ABC or Rahul >Sundry Creditors

XYB or Anil > sundry Debtors

Inventory Info > Units of Measure > Pc>piece

Stock Group> Create > Cloth>primary

Stock Items>Create>shirt M Size> Cloth>pc

Stock Items>Create>T- shirt M Size> Cloth>pc

Accounting Voucher

Purchase>Rahul>Purchase>Shirt M size>100Pc>520, T Shirt M size 150 Pc > 430(Naraction)

Purchase Return :

Debit Note : CTRL+F9) : Original Invoice No: 01, Party Name : Rahul, Purchase ledger: Purchase Return

Shirt M size : 10, Rate Default, T Shirt M Size : 15, Rate Default(Narration : being Purchase Return)

Credit Note:CTRL+F8>Original invoice No.: 02 > Party A/c Name : Anil, Sales Ledger> Sales Return> shirt M size> 5 pc> Rate Default.

Day 6

Purchase order

Features (F11)

Inventory Features > Enable Purchase Order Process (Yes), Enable Sales order Processing

Use Tracking Numbers (enables delivery and receipt Notes) (Yes)

 

Accounting Vouchers

Purchase order(ALT+F4)

Party a/c Name (ALT +C), Anil > Sundry Creditors, Maintain Balance Bill by Bill (No)

Purchase order : (Alt+C) > Purchase Accounts> Inventory values are affected(Yes)

Name : shirt (100X900), T-shirt(100X1200), Jacket(10X1500)

 

Receipt Note : ALT+F9

Ref No. 02, Party Name : Anil, Purchage order, Press Down Arrow, narration

 

Sales Order

ALT+F5, Party Name : Amit-Under sundry Debtors

Sales> Sales Account(Inventory Value Affected(Yes) : Shirt(50), T-shirt50), Jacket(50): Naration Being saels order

 

Delivery Note : (ALT+F8)

Reference No: 04

Party a/c Name : Amit> Sales Ledger : Sales(Shirt, T-shirt, Jacket: naration : Being sold.

 

Details :

Display: Daybook, Statement of Inventory, Sales order, Record Stats, Stock Query,

Cost Center/Payroll- Salary Related

Cost Center : Normal Salary

Payroll : Salary+TA+DA+Bonus.....

Cost Center: Features(F11)> Accounting Features> Maintain Cost Center(Yes) : 

Account Info> Ledger> Salary>Indirect Expenses (Cost Center Application(Yes) 

Account Info> cost Center > Create > Anil Kumar, Sunil Kumar, Amit Kumar, Sonu Kumar, Ajay Kumar (Primary)

Accounting Voucher

Payment > Salary > 56000

Anil Kumar 12500, Sunil Kumar 13500 ... total 56000 ( Cash)

Payroll 

Features(F11) > Maintain Payroll > Yes

Payroll info> Employee Group> Engnieer/Workers/Supervisour>Primary

Employee> Create >Rahul Kumar > Engineer

Raju>Worker

Bishal> Supervisour

Pay Head> Create > Basic Salary > pay Head Type> Earning for Employee >Fixed > Under>Indirect Expenses > Effect Net Salary (Yes) Calculation Type : As User defined value

TA(Travels Allounces)/DA/HRA(House Rent Allowance)/PF(Provident Found

Payroll Vouchers

Cash>Rahul(Basic Salary+DA+HRA+TA(DR)-PF(CR)

Second Employee

Day 7

Bill By Bill (pwf/f]df ;fdfg vl/b ljqmL, k]d]G6_

F11-Features : Accounting Features : maintain Bill wise Details(Yes), For non Trading accounts also(Yes)

Gateway of Tally>Accounts Info> Ledger>Create Sales/Purchase Account.

Raj> sundry Creditors>Maintain balance Bill by Bill(Yes),

Dip Kumar>Sundry Debtors>Maintain balance bill by bill (Yes)

Inventory info>  Units of Measure> pc>piece

Stock Group>Cloth>primary

Stock Items>Shirt/T-shirt/Jacket>Cloth>pc

Accounting voucher> Purchase>Party Name: Raj>Shirt(1200X360)>Bill wise Details for : Raj

New Ref>Raj>Due Date:10 Days: Narration Being Credit Purchase

After 10 Days : Purchase > Raj>total balance> Bill will Details for : Raj > Agst Ref(Raj)>

Payment Method(Cash)CR> Narration : Being Cash Paid by Cash.

Sales(F8)

Party Name : dip Kumar > Sales > Shirt(1X960)> New Ref(Sonu) Credit Days 5: Narration Being credit Sales)

Receipt : Dip Kumar>Agst ref > Dip>(Payment method:(Cash) DR > 960: Being Cash Receipt. 

Day 8

Voucher Type

Cheque Related Topics(By Bank)

Salary Paid : 50000

Salary Paid by Cheque : 50000

Acounts Info

Voucher Typs

Create

Bank Payment> payment

Bank receipt>Receipt

Accounting vouchures(Press F5)

Payment>

Create Ledger>Salary>indirect Expenses> 

Salary > 50000(DR)

Cash> 50000(CR)naration : being salary paid

Salary paid By Bank

Press F5(Bank payment)

Salary > 50000

Create Bank ledger>Bank> Under bank Account> 50000(Cheque Details )

Receipt Entry (Press F6)

Receipt(Cash)

Create Ledger> Interest Receipt>Indirect Income>2000(CR)

Cash 2000(DR): naration > Being int receipt.

Bank Receipt

Interest Receipt(3000)CR

Bank>3000(DR) Being Int receipt by cheque.

Display> Day Book

Day 9

Cost Centre

F11>Accounting Features> Cost Centers>Yes

Account Info>Ledger>

Salary>indirect Expenses>

Account info>Cost Center> Create>

Employee Name(5) person

Puja, sunil, Ansu, Srijana, Pratima

Accounting vouocher

F5>Salary> 50000

Puja>10000,Sunil>10000, Ansu>10,000, Srijana > 10000, Pratima>10000

payment By Cash/Bank>being salary paid.

saman udharo kharid, bikri, payment, receipt

F11>Features>Accounting Feature>Main billwise>Yes, For Non Trading Accounts also>yes

Accounts Info>Ledger>Create>Like Samir(Jaha batw saman udharo ma kharid garinxa)>Sundry Creditors>Maintain Balance Bill by Bill>Yes

Next Ledger>Aaditya(Jaslai saman bikri garne>Sundry Debtors>Maintain bill by bill>Yes>

Create Ledger> Sales>Sales Accounts

Purchase Ledger>Purchase Accounts

Units of Measure>Create>Pcs>piece

Stock Group>Computer>primary

Stock Item>Mouse>Computer>pcs

SSD>computer>pcs

Accounting Vouchure(F9)

01, date, party Name : Samir, purchase

Mouse>1200X100

SSD>1000X500>New Ref(Error aayema Press F12(Use Default for bill Allocation (Yes/No)

Credit Days(6/10/15)(Naration being credit sold.

Payment(F5)

Samir> 62000>Agst Ref>samir

Cash>62000(naration : Being Cash Paid.)

Sales>party name > Aaditya>Sales>Mouse>200X300

SSD>300X900>New Ref > Aaditya>6/8/15>Naration Credit sold.

Payment Receipt > F6>

Aaditya>33000>Agst>Cash>Naration : being cash recipt.