Balance Sheet

 

Balance Sheet

Balance Sheet is the financial statement of a company which includes assets, liabilities, equity capital, total debt, etc. at a point in time. Balance sheet includes assets on one side, and liabilities on the other. For the balance sheet to reflect the true picture, both heads (liabilities & assets) should tally (Assets = Liabilities + Equity).

Enter & Create the Ledger A/c Under appropriate group with their opening balance as shown in following screen

M/S. SHRIRAM ELECTRONICS BALANCE – SHEET AS ON 31-03-2017
LIABILITIES	AMOUNT	ASSETS	AMOUNT
CAPITAL A/C R. C. Patel	6,18,474.00	FIXED ASSET (As Per List “C”)	2,74,654.00
BANK OD A/C COSMOS BANK	9,83,069.00	INVESTMENT (AS Per List “D”)	1,75,500.00
UNSECURED LOAN (As Per List “A”)	3,49,550.00	DEPOSIT (ASSETS) (As Per List “E”)	1,58,283.00
SUNDRY CREDITORS (as Per List “B”)	59,37,849.00	CLOSING STOCK	49,11,180.00
		SUNDRY DEBTORS (As Per List “F”)	21,01,606.00
		BANK & CASH BALANCE (As Per List “G”)	2,67,721.00
Total	78,88,944.00	Total	78,88,944.00

 

1)      R.C. Patel

·         Gateway of Tally > Account Info. > Ledger >Single Ledger > Create

Name	R.C. Patel
Alias	Enter
Under	Capital Account
Inventory Value are Affected	No & Press Enter
Opening Balance	6,18,476.00
Accept? Yes or No	Yes

2)      Cosmos bank

Field	Type
Name	Cosmos Bank
Alias	Enter
Under	Bank OD A/c
Opening Balance	9,83,069.00
Accept?  Yes or No	Yes

Press Enter & Return to Gateway of Tally

Entering Opening Balance of List “A” Unsecured Loan in Tally

·         Gateway of Tally > Account Info. > Ledger > Create (Multiple) > Enter the following Ledger with their opening balance under group Unsecured Loan

LIST “A” UNSECURED LOAN
Sr. No.	Name of Ledger	Amount (Rs.)
1.	Ashok C.B.	81,894.00 Cr.
2.	Chandrakant G.	56,958.00 Cr.
3.	Ramesh T.M.	109,450.00 Cr.
4.	Sangita D. G	26,248.00 Cr.
5.	Shivaji M. Stores	75,000.00 Cr.
Grand Total		3,49,550.00 Cr.

 Press Esc & return to Gateway of Tally

·         Gateway of Tally > Balance Sheet > Loans (Liabilities) > Unsecured loan > Enter.

Entering Opening Balance of List “B” Sundry Creditors in Tally

·         Gateway of Tally > Account Info. > Ledger > Create (Multiple) > Enter the following Ledgers with their opening balance under group Sundry Creditors

LIST “B” SUNDRY CREDITORS
Sr. No.	Name of Ledger	Address/ Location	GSTIN No.	Amount
1.	Baren International	Mumbai	27PAVSW9665P1Z5	4,04,020.00 Cr.
2.	LG India Ltd.	Pune	27LGIND7867A1Z2	24,04,500.00 Cr.
3.	Kitchen Appliance	Thane	27AAPLI7865A1Z2	16,38,302.00 Cr.
4.	Meena Agencies	Nasik	27VIGNE5832B1Z4	1,67,450.00 Cr.
5.	Nirmal Enterprises	Aurangabad	27ENTER2728J1Z5	19,142.00 Cr.
6.	Sharp Electronics	Pune	27ELETO7227M1ZP	1,25,900.00 Cr.
7.	Shilpa Electronics	Nasik	27TRAMB7011K1Z6	2,06,561.00 Cr.
8.	Shri Balaji Ltd	Aurangabad	27CARTSO482T1ZT	1,19,700.00 Cr.
9.	Sindhu Distributors	Pune	27VTUYI471701Z0	44,765.00 Cr.
10.	Sunny Enterprises	Nagpur	27SSSSS12345S1Z3	1,57,591.00 Cr.
11.	Suresh Agencies	Aurangabad	27UAUAU1234U1Z1	1,33,950.00 Cr.
12.	Unique Agencies	Thane	27SASAS1234S1Z3	25,956.00 Cr.
13.	Uptron India Ltd	Pune	27DFJK1234S1Z2	1,25,870.00 Cr.
14.	Videocon India Ltd	Nasik	27NANAN1234A1Z1	3,44,117.00 Cr.
15.	Vijay Electronics	Thane	27THTHA4521T1Z3	20,025.00 Cr.
Grand Total				59,37,849.00 Cr.

·         Gateway of Tally > Balance Sheet > Current Liabilities > sundry creditors > Enter.

Press Esc & return to Gateway of Tally

Entering Opening Balance of List “C” Fixed Assets in Tally

·         Gateway of Tally > Account Info. > Ledger > Create (Multiple) > Enter the following Ledgers with their opening balance Under Group Fixed Assets

LIST “C” FIXED ASSETS
Sr. No.	Name of Ledgers	Amount
1.	Computer	25,950.00 Dr.
2.	Cycle	1,286.00 Dr.
3.	Furniture	13,131.00 Dr.
4.	Hero Honda	48,623.00 Dr.
5.	Ornaments	1,85,664.00 Dr.
Grand Total		2,74,654.00 Dr.

Press Enter & Accept the Screen & Return to Gateway of Tally

·         Gateway of Tally > Balance Sheet > Fixed Assets > Enter.

Press Esc & return to Gateway of Tally

Entering Opening Balance of List “D” Investment in Tally

·         Gateway of tally > Account Info. > Ledger > Create (Multiple) > Enter the following Ledger with their opening balance under group Investment

LIST “D” INVESTMENT
Sr. No.	Name of Ledger	Amount (Rs.)
1.	Bank of Baroda Shares A/c	26,000.00 Dr.
2.	Indira Vikas Patra	16,500.00 Dr.
3.	N.S.C.	1,00,000.00 Dr.
4.	Sachin R.D. A/c	16,500.00 Dr.
5.	Surbhi R.D. A/c	16,500.00 Dr.
Total (Rs.)		1,75,500.00 Dr.

Check whether you have entered correctly

·         Gateway of Tally > Balance Sheet > Investment > Enter.

Press Esc & return to Gateway of Tally

Entering Opening Balance of List “E” Deposits (Assets) in Tally

·         Gateway of Tally > Account Info. > Ledger > Create (Multiple) > Enter the following Ledgers with their opening balance under group Deposits (Assets)

List “E” Deposits (Assets)
Sr. No.	Name of Ledger	Amount (Rs.)
1.	Aiwa India	5,000.00 Dr.
2.	Kisan Tractors	1,015.00 Dr.
3.	Mukesh Chaudhari	25,000.00 Dr.
4.	Rahul R.D. A/C	16,500.00 Dr.
5.	Sangli Bank	1,08,768.00 Dr.
6.	Vijay R.D. A/C	2,000.00 Dr.
Total (Rs.)		1,58,283.00

Check whether you have entered correctly

·         Gateway of Tally > Balance Sheet > Current Assets > Deposit (Assets) >Enter.

Press Esc & return to Gateway of Tally

Entering Opening Balance of list “F” Sundry Debtors in Tally

·         Gateway of Tally > Account Info. > Ledger > Create (Multiple) > Enter the following with ledgers with their opening balance. Under group Sundry Debtors

List “F” Sundry Debtors
Sr. No.	Name of Ledger	Address/ Location	GSTIN No.	Amount (Rs.)
1.	Aditi Agencies	Pune	27POILU7410A1Z1	2,95,377.00 Dr.
2.	A.I. Electronics	Mumbai	27ASDFG9685A1Z2	91,743.00 Dr.
3.	Amol T.V Center	Nasik	27QWASD1523T1Z3	21,970.00 Dr.
4.	Bangad sales	Nasik	27GHJJK4561T1Z1	1,98,000.00 Dr.
5.	Bhagat Electronics	Aurangabad	27ABHTU7990A1ZA	2,61,300.00 Dr.
6.	Bhavsar T.V. Center	Thane	27AAAAL7878ASZL	15,802.00 Dr.
7.	Darshan Agencies	Nasik	27POPLI4455Y1ZQ	1,42,256.00 Dr.
8.	Ganesh Electricals	Mumbai	27TUTUT7530Q1ZU	5,980.00 Dr.
9.	Hitesh Agencies	Pune	27VMVMM9510Q1Z1	67,961.00 Dr.
10.	Jain Electronics	Nasik	27XCVBN9636Z1Z2	4,740.00 Dr.
11.	Jalaram T.V. Center	Aurangabad	27LKJHI8867Y1Z0	2,093.00 Dr.
12.	Jawahar Electronics	Mumbai	27ERTYU4141U1Z1	5,265.00 Dr.
13.	Jitendra Electricals	Mumbai	27YUIOP9896Q1Z1	3,636.00 Dr.
14.	Laxmi Agencies	Mumbai	27AZXCV4102W1Z9	12,140.00 Dr.
15.	Madhur Electronics	Thane	27TTHJK0096K1ZL	8,660.00 Dr.
16.	Mahavir T.V. Center	Thane	27BHUIJ4010N1ZM	2,12,785.00 Dr.
17.	Mamta Electronics	Aurangabad	27ETYTT7890Y1ZM	4,830.00 Dr.
18.	Manish Electronics	Pune	27EDCVB4455N1ZN	39,902.00 Dr.
19.	Pardeshi Radio	Nasik	27DDDDD8889S1Z2	17,863.00 Dr.
20.	Pooja Agencies	Nagpur	27CBCNM4142L1ZX	31,636.00 Dr.
21.	Poojara Agencies	Pune	27RAJAS9663A1ZC	79,845.00 Dr.
22.	Sagar Enterprises	Nagpur	27OKBYE0143L1ZX	18,125.00 Dr.
23.	Saibaba Furniture	Nasik	27CVUBM8246G1ZH	64,035.00 Dr.
24.	Sarika Agencies	Mumbai	27EGHJK7319A1Z5	90.00 Dr.
25.	Seven Star	Pune	27AUIOP9135T1Z0	2,600.00 Dr.
26.	Shakti Electronics	Thane	27VBGHU4912W1Z7	9,150.00 Dr.
27.	Shraddha Electronics	Nasik	27TYSMU9990P1ZK	9,137.00 Dr.
28.	Shri Agencies	Aurangabad	27WWSSD4546W1ZU	425.00 Dr.
29.	Sonu Agencies	Nagpur	27IHTAE6960A1Z8	19,097.00 Dr.
30.	Sony Electronics	Mumbai	27UOKLU1230X1ZZ	97,520.00 Dr.
31.	Sumeet Electronics	Nagpur	27DFGTY8750I1Z1	3,140.00 Dr.
32.	Surbhi Electricals	Nasik	27NASKN1515C1ZM	335.00 Dr.
33.	Tirupati Electricals	Thane	27MTHNE7167D1ZK	16,550.00 Dr.
34.	Tulsi Departmental Stores	Pune	27SAMPR2207A1ZN	2,62,505.00 Dr.
35.	Vikas Electronics	Aurangabad	27RAMHI4799K1ZA	1,200.00 Dr.
36.	Vishal Electricals	Mumbai	27TUSHR8844A1ZB	48,757.00 Dr.
37.	Zankar Agencies	Pune	27TTTTT5656B1ZG	25,156.00 Dr.
Total				21,01,606.00 Dr.

·         Gateway of Tally > Balance Sheet > Current Assets > Sundry Debtors > Enter.

Press Esc & return to Gateway of Tally

Entering Opening Balance of List “G” Bank Account in Tally

Gateway of Tally > Account Info. > Ledger > Create (Multiple) > Enter the following ledger with their opening balance under group Bank Account

LIST “G” BANK ACCOUNT
Sr. No.	Name of Ledger	Amount (Rs.)
1.	HDFC Bank	88,765.00 Dr.
2.	ICICI Bank	19,974.00 Dr.
3.	State Bank of India	2,434.00 Dr.
Total		2,67,721.00 Dr.

Check whether you have entered correctly

·         Gateway of Tally > Balance Sheet > Current Assets > Bank account > Enter

Press Esc & return to Gateway of Tally

Alter Cash Ledger

·         Gateway of Tally > Account Info. > Ledger > Alter (Single)

·         Select the Cash Ledger & Enter Opening Balance as 1, 56, 548. 00

·         Gateway of Tally > Balance Sheet > Current Assets > Cash-in-Hand > Enter

Press Esc & return to Gateway of Tally

Note: - While entering the opening balance of Cash in Hand there is no need to create a new ledger account as Cash because when you create the company by default two ledger two ledger accounts are already i.e. Cash & Profit & Loss A/c. So just Alter the ledger Cash & enter the opening balance.