How to prepare a Balance Sheet in Tally ?
For last few months, I am selecting topic to post on this blog is from the search term my reader use to find the item they requires. Today, I will let you know how to prepare balance sheet in Tally.As frequently I am finding this term at my Lijit.com Search Box
First of all, we will look this matter from the view of manual accounting system
The process of Manual accounting is :
1. Preparing Vouchers/Bills etc.
2. Preparing Cashbook, Journals, Purchase and Sales Register and Bank book
3. Preparing Ledgers by posting items to individual ledger account from the item no. 2 as above
4. Preparing a Trial Balance
5. Preparing Trading and profit & Loss Account
6. Preparing Balance Sheet
Now, Vouchers, Bills ,cheques are the base of accounting system they forms a transactions which are recorded in day book,cash book,bank register,purchase/sales register
then each transaction has been posted to related ledger account.
then on a particular date, Dr. and credit balance of each ledger trasferred to Trial balance, including closing cash on and bank balance on that date.
by following this process, the unit prepars A trial balance
Thus, A trial balance sheet shows summary of sales,purchase,assets and liabilty, expenses and income during that period.
Now from the trial balance sheet all items relating to revenue expenses,revenue incomes, sales, purchase etc are transferred to trading and profit and loss account.
Also stock on that date is to be valued and effected into the profit and loss account.
now if any provision for interest, taxes have to be made then the same are effected into Profit and loss account.
The result will be the Net profit and loss account.that will be transferred to Capital Account
Now items representing capital assets, cash/bank balance, capital and sundry debtors and sundry creditors in the trial balance are transferred to the Balance sheet
also stock to be shown in the balance sheet.
Now your balance sheet is ready.
In Any computerization Accounting system, preparation of balance sheet is relatively very different then as stated above.
In computerisation Acccounting software, all you need to create ledger accounts under proper grouping and t hen start entering vouchers only.
You don’t need to prepare any register
No need of posting to any ledgers
No need to prepare a Trial balance sheet
No need to prepare a Balance sheet
Because once you post a voucher in a proper way, all the above reports the system will prepare automatically without any error or calculation.
In tally, you need to specify closing stock as on the given date to prepare a balance sheet which I have shown in my earlier posting.
Please read how to put closing stock in tally
Accounting for Non-Accountants, 2E: The Fast and Easy Way to Learn the Basics
Related posts:
![How to prepare a Balance Sheet in Tally ? Reblog this post [with Zemanta]](http://img.zemanta.com/reblog_e.png?x-id=528487c5-5fca-4ed9-808f-9c271ff7134a)

I HAVE GETTING MESSAGE “Tally connect licence about to expired !”. I want to know that how many days are required to updated the licence. How much time to Update licecce in within time. Please suggest me immediately. Presently we are running two diffrent release tally (1) Tally 9.3 beta (2) Tally.erp 9 so i would like to inform you for your current situation.
Dear Rupesh,
I have sent you personal message and an invitation to Gtalk.
We will speak over the issue there
Dear Sir
What is yur id…Actually i wanna some disus.. abt
tally 9.0..pls help me abt..
thnx
SAMEER
mkr2005 at gmail
We have noticed that we can’t tally stock in tally software. Opening + Inward – Consumption = Closing stock. We have check all parameter but can’t get solution. Then i reset all coniguration. Difference is display in consumption.
Dear Rupesh,
Have you posted Consumption and Inward Entries through Inventory vouchers ? If possible please send me screen shot of 2-3 entries
Dear Sir,
Our company incorporated on 20.10.2009, all expenses including fixed assets are purchased before incorporation.
how can i prepare Balance Sheet, how I show before incorporation exps. to Balance Sheet.
Kindly give your suggestion, its urgent.
Thanks & Regards,
Priti
Dear Priti,
Expenses prior to incorporation are generally treated as normal expenses however as on date of incorporation they are transferred to pre operative expenses (under misc. expenses) which comes under balance sheet.
In case of further clarification, please do not hesitate to contact me
Thanks for your reply.
I need some more help, if you have any gmail id. then we can chat online.
Thanks & Regards,
Priti
mkr2005 gtalk/gmail id
Dear Sir,
I have made entries in tally 7.2. Being the first year, I have entered the opening balances of the balance sheet items in tally, and thereafter did all the entries. Now, while seeing the balance sheet in tally, I am finding a difference of Rs 1,200 in the B/S (assets being on higher side). I have thoroughly rechecked the opening balances and all other possibile reasons which i could have thought of but unsucessful to resolve the problem. Please help. Even, I tried to rewrite the company using the function Ctrl+Alt+R, but it gives an error message Internal Error – Memory Control Violation.
Please solve it asap.
Thanks & Regards, Ateesh
Dear ateesh,
If there is a difference in opening balance, then you do not need to re write the company. it is not software error but 100% mistake in writing opening balance.
What is the FY for which you have are preparing your books of account ? then compare the opening balance in tally you have entered with the closing balance as per your balance sheet of the last FY.
In case problem still not solved, you may contact me on yahoo messenger at oz0021 or Gtalk at mkr2005
best regards
Hi sir
1-Explain the complete details about how to create Trail Balance,Trading , Profit & Loss a/c and Balance sheet
2-How should i transfer the previous year profit to the next year,
what is the procedure.
3-pls explain in details regarding Rectification on Errors
Saleem,
In tally, you dont need to prepare trial balance etc. just go to display. P & L and balance sheet are there on the main menu of the tally software. you do not need to create the same
for transfer from PY to New year, select F2 from the main menu of tally software and select period of the new year and its all done.
for rectificaiton of entry, you have to recall the original voucher in edit mode and make changes after that save it
Hi,
I’m in trouble using tally erp 9. can u please help me to solve it.? Our company is A construction company, i will entry all the expenses, and all the cheque we issued. My problem is How can I set up the Chart of accounts or a ledger? If i will make cheque payment i will name it to the person or subcontractor for Debit entry or i will put entry instead? thanks a lot.
chris
Dear Sir,
I am working as a Finance executive in manufacturing business firm.But I am facing a lot of problems to prepare financial statement.So I decided to buy software based accounts system.So please know me how can Tally help me . As I am fresher so I have some problem to prepare trial balance, income statement , and balance sheet . So can Tally make me easy to learn and prepare financial statement? I will be very gratefull as you reply promptly .
Monvar,
I had just sent you a personal mail on your yahoo ID on the subject matter. Alternatively you may contact me at mkr2005 at gmail.com
Hi Sir,
I am working in the private firm and wants to prepare Balance Sheet, but I am Not able to increase the profit. Is there any way to increase the profit. Somebody told me that by increasing ratio we can increase the profit. and also let me know know how to calculate TDS.
Namita,
You can play with profit by increasing/decreasing value of your stock. Increase value of stock and your profit will increase. Decrease some expenses and profit will increase. But do this to a reasonable level only to avoid income tax office far away. Be sure Income Tax people also reading this blog.kidding….
Now, about TDS entries, please read my post under tds category. be sure it requires latest version of tally.erp 9 release 1.52 or higher.
Hello sir,
I am working to electrical company(transformer). here how to preparing the daily expenses are note in to the tally book… please help me…… how to prepare the daily expenses….plz tell me sir………
Yogalakshmi,
Use F5 payment voucher and start entering voucher.
Hello,
I have completed MBA in finance i want to learn tally but i dont have such type of knoledge about accontancy and i want make my future as a finance manager what can do.
I want to use more then one unit. in some commodity like cotton bale, should maintain both nos and kgs. i think the alternate unit did not work as i expect. if each bale have same weight. you can use alternate unit (eg : 1 bag=100 kgs).
but some commodity like cotton bale, each bale carries different weight
for eg :41 bags = 3807 kg, tally take as one bag is 92kg. now i entry a stock journal voucher 322 kg consumes. tally shows as no of bags is 3, but by physical stock 322 kgs is 4 bags.
so mult units could solve this solution.
is there solve any way to solve this problem? customization is the solution.
if ther is a solution. could you please guide as step by step..
Ram,
At the moment customization is the only solution to this problem. If you need customise from us, then please do let me know, I will be glad to quote for the best.
and if you do not wish for customisation, then you may raise your query officially in our favor. The method I have already informed at the support forum and I will discuss the matter with Tally’s R & D team so that they will incorporate the same in their upcoming release.