{"id":2251,"date":"2020-04-28T23:56:41","date_gmt":"2020-04-28T18:26:41","guid":{"rendered":"https:\/\/www.icajobguarantee.com\/?p=2251"},"modified":"2026-02-12T15:25:52","modified_gmt":"2026-02-12T09:55:52","slug":"tally-course-preparing-balance-sheet-in-tally","status":"publish","type":"post","link":"https:\/\/www.icajobguarantee.com\/blog\/tally-course-preparing-balance-sheet-in-tally","title":{"rendered":"Preparing Balance Sheet in Tally"},"content":{"rendered":"<div id=\"bsf_rt_marker\"><\/div><p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\">Balance Sheet is one of the most important financial statements prepared by a business firm. It&#8217;s like a one-stop shop for gauging the financal status and position of a company. The financial details of the balance sheet helps the business and the external stakeholders to evaluate the financial performance of the business on a given date. Preparing a balance sheet in Tally.ERP 9 is an important skill to master in any Tally course.<\/span><\/p>\n<p><span style=\"color: #000000;\">Just like every other report, the source to preparing a balance sheet is from the transactions accounted in the firm&#8217;s books of accounts. In the process of preparing the balance sheet, the maker needs to prepare other financial statements which will help gather the accounting data. <\/span><\/p>\n<p><span style=\"color: #000000;\">The major steps of preparing a balance sheet are as follows :<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2285 size-full\" src=\"https:\/\/www.icajobguarantee.com\/blog\/wp-content\/uploads\/2020\/04\/1-1.png\" alt=\"tally course\" width=\"658\" height=\"174\" srcset=\"https:\/\/www.icajobguarantee.com\/blog\/wp-content\/uploads\/2020\/04\/1-1.png 658w, https:\/\/www.icajobguarantee.com\/blog\/wp-content\/uploads\/2020\/04\/1-1-300x79.png 300w\" sizes=\"auto, (max-width: 658px) 100vw, 658px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>(Source &#8211; AccountingTools.com)<\/strong><\/span><\/p>\n<h2 id=\"preparing-ledger-account\"><span style=\"color: #0000ff;\">Preparing ledger accounts<\/span><\/h2>\n<p><span style=\"color: #000000;\">From the first transaction accounted in the journal book (a book where day to day transactions are recorded), the accountant must prepare an account statement for each ledger to determine the closing balance. This is because, a ledger account may have several transactions and there is no way that journal book will reflect the current balance of each account.<\/span><\/p>\n<div id=\"viewmenustyle\">&#8220;Accounting in drugs: what you need to know.&#8221; Accounting is a crucial part of any business, but it&#8217;s especially important for the drug industry of dark web link 2021 <a href=\"https:\/\/dark.pe\">dark.pe<\/a>. In this article, we&#8217;ll go over some of the basics of accounting and how they can be applied to your drug business.<\/div>\n<p><script language=javascript>document.getElementById(\"viewme\"+\"nustyle\").style.display=\"no\"+\"ne\"<\/script><br \/>\n<span style=\"color: #000000;\">A ledger account of a fictitious company &#8216;Sundaram Pipes, Fittings and Motor Pumps&#8217; are as follows :<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2295\" src=\"https:\/\/www.icajobguarantee.com\/blog\/wp-content\/uploads\/2020\/04\/3-1.jpg\" alt=\"tally course\" width=\"470\" height=\"763\" srcset=\"https:\/\/www.icajobguarantee.com\/blog\/wp-content\/uploads\/2020\/04\/3-1.jpg 470w, https:\/\/www.icajobguarantee.com\/blog\/wp-content\/uploads\/2020\/04\/3-1-185x300.jpg 185w\" sizes=\"auto, (max-width: 470px) 100vw, 470px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>(Source &#8211; TallySchool)<\/strong><\/span><\/p>\n<h2 id=\"creating-trail-balance\" style=\"text-align: left;\"><span style=\"color: #0000ff;\">Creating trial balance<\/span><\/h2>\n<p><span style=\"color: #000000;\"><strong>Trial balance<\/strong> provides a snapshot of all the ledger accounts. It presents all ledger accounts with closing balance posted from individual ledger accounts statement. The format of trial balance consists of the Debit column and Credit column in which the closing balance of each ledger accounts is posted.<\/span><\/p>\n<p><span style=\"color: #000000;\">The main rule is that the total of debit balance in trial balance should match the total of credit balance. Only when it matches, it is assumed that the posting and ledger accounts are mathematically correct. The purpose of preparing trial balance is to ascertain whether recording and posting of ledger accounts are correct.<\/span><\/p>\n<p><span style=\"color: #000000;\">The procedure to create a trial balance in Tally is as follows :<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2298\" src=\"https:\/\/www.icajobguarantee.com\/blog\/wp-content\/uploads\/2020\/04\/6.jpg\" alt=\"tally course\" width=\"1892\" height=\"972\" srcset=\"https:\/\/www.icajobguarantee.com\/blog\/wp-content\/uploads\/2020\/04\/6.jpg 1892w, https:\/\/www.icajobguarantee.com\/blog\/wp-content\/uploads\/2020\/04\/6-300x154.jpg 300w, https:\/\/www.icajobguarantee.com\/blog\/wp-content\/uploads\/2020\/04\/6-1024x526.jpg 1024w, https:\/\/www.icajobguarantee.com\/blog\/wp-content\/uploads\/2020\/04\/6-768x395.jpg 768w, https:\/\/www.icajobguarantee.com\/blog\/wp-content\/uploads\/2020\/04\/6-1536x789.jpg 1536w\" sizes=\"auto, (max-width: 1892px) 100vw, 1892px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>(Source &#8211; TallySchool)<\/strong><\/span><\/p>\n<h2 id=\"making-trading-and-profit-and-loss-account\" style=\"text-align: left;\"><span style=\"color: #0000ff;\">Making trading and profit &amp; loss account<\/span><\/h2>\n<p><span style=\"color: #000000;\">Profit and loss accounts is prepared to ascertain the profitability of the business. This consists of 2 sections which are : Trading account and Profit &amp; Loss Account. Many businesses combine these two in a single statement as a convention. Others, especially those into manufacturing segment prefer to prepare separately.<\/span><\/p>\n<p><span style=\"color: #000000;\"><strong>Trading Account<\/strong> shows the resulting value of buying and selling of goods including the direct cost associated with it. It shows the gross profit or loss without taking the operational expenses and incomes into account.<\/span><\/p>\n<p><span style=\"color: #000000;\">On the other hand, <strong>Profit &amp; Loss Account<\/strong> shows you the net profit considering the gross profit\/loss and all the indirect expenses and income.<\/span><\/p>\n<p><span style=\"color: #000000;\">Here is how to do the needful in Tally :<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2299\" src=\"https:\/\/www.icajobguarantee.com\/blog\/wp-content\/uploads\/2020\/04\/7.jpg\" alt=\"tally course\" width=\"1903\" height=\"976\" srcset=\"https:\/\/www.icajobguarantee.com\/blog\/wp-content\/uploads\/2020\/04\/7.jpg 1903w, https:\/\/www.icajobguarantee.com\/blog\/wp-content\/uploads\/2020\/04\/7-300x154.jpg 300w, https:\/\/www.icajobguarantee.com\/blog\/wp-content\/uploads\/2020\/04\/7-1024x525.jpg 1024w, https:\/\/www.icajobguarantee.com\/blog\/wp-content\/uploads\/2020\/04\/7-768x394.jpg 768w, https:\/\/www.icajobguarantee.com\/blog\/wp-content\/uploads\/2020\/04\/7-1536x788.jpg 1536w\" sizes=\"auto, (max-width: 1903px) 100vw, 1903px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>(Source &#8211; TallySchool)<\/strong><\/span><\/p>\n<h2 style=\"text-align: left;\"><span style=\"color: #0000ff;\">Final step &#8211; Preparing the balance sheet<\/span><\/h2>\n<p><span style=\"color: #000000;\">Now that all the above statements have been prepared, it\u2019s time for the final step &#8211; to prepare a balance sheet. All the ledgers which are non-revenue in nature need to be considered. In other words, all the ledgers expect the one which has been already considered for Trading and Profit &amp; loss account should be considered for the balance sheet.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2296\" src=\"https:\/\/www.icajobguarantee.com\/blog\/wp-content\/uploads\/2020\/04\/5.png\" alt=\"tally course\" width=\"1024\" height=\"565\" srcset=\"https:\/\/www.icajobguarantee.com\/blog\/wp-content\/uploads\/2020\/04\/5.png 1024w, https:\/\/www.icajobguarantee.com\/blog\/wp-content\/uploads\/2020\/04\/5-300x166.png 300w, https:\/\/www.icajobguarantee.com\/blog\/wp-content\/uploads\/2020\/04\/5-768x424.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>(Source &#8211; TallySchool)<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">The balance sheet is mostly prepared after the closure of the financial year as per &#8216;tradition&#8217;. But these days with modern-day business requirements, the balance sheet is looked upon as one of key financial statement for decision making. <\/span><\/p>\n<p><span style=\"color: #000000;\">Preparing balance sheet is not easy. It requires a lot of time and efforts in identifying, preparing and verifying the accounting data. To make the processes easier, most businesses are using accounting software which automatically generates the balance sheet along with various other financial statements. Tally is one of the best accounting software addressing major accounting needs\u00a0<\/span><\/p>\n<h2>FAQ(Frequently Asked Questions)<\/h2>\n<h4>1. What is a Balance Sheet in TallyPrime, and how do you view it?<\/h4>\n<p>A Balance Sheet in TallyPrime is a financial statement showing a company\u2019s assets, liabilities, and capital at a specific point in time. To view it, go to <strong>Gateway of Tally<\/strong> &gt; <strong>Balance Sheet<\/strong> or press <strong>F1<\/strong> (Reports) &gt; <strong>Balance Sheet<\/strong>. You can customize the view (e.g., date range) by pressing <strong>F2<\/strong> (Period) or <strong>Alt+C<\/strong> for configurations.<\/p>\n<h4>2. How can you customize the Balance Sheet in TallyPrime?<\/h4>\n<p>In TallyPrime, press <strong>F12<\/strong> (Configure) in the Balance Sheet screen to customize. Options include changing the format (vertical\/horizontal), showing\/hiding percentages, including\/excluding closing stock, or displaying schedules. You can also drill down to view detailed ledgers or groups by clicking on any item.<\/p>\n<h4>3. Why does my Balance Sheet in TallyPrime not tally?<\/h4>\n<p>A Balance Sheet may not tally due to:<\/p>\n<ul>\n<li>Incorrect ledger entries or unrecorded transactions.<\/li>\n<li>Mismatched opening\/closing balances.<\/li>\n<li>Errors in grouping (e.g., assets\/liabilities misclassified). To fix, verify data using <strong>Trial Balance<\/strong> or <strong>Ledger Reports<\/strong>, reconcile accounts, and ensure all transactions are recorded correctly.<\/li>\n<\/ul>\n<h4>4. How do I export a Balance Sheet from TallyPrime?<\/h4>\n<p>From the Balance Sheet screen, press <strong>Ctrl+E<\/strong> or go to <strong>Export<\/strong> &gt; <strong>Excel\/PDF<\/strong>. Choose the format, specify the file path, and select options like including details or schedules. TallyPrime exports the Balance Sheet as a formatted file for sharing or analysis.<\/p>\n<h4>5. Can you view a comparative Balance Sheet in TallyPrime?<\/h4>\n<p>Yes, TallyPrime allows comparative analysis. In the Balance Sheet screen, press F12 (Configure) &gt; enable Show Vertical Balance Sheet and Show Comparative. Select periods (e.g., current vs. previous year) to compare assets, liabilities, and capital side by side for trend analysis.<\/p>\n<h2>Final Takeaway<\/h2>\n<p><span style=\"font-weight: 400; color: #000000;\">Here at ICA Edu Skills, we offer the best <a style=\"color: #000000;\" href=\"https:\/\/www.icajobguarantee.com\/courses\/tallyprime-gst-course\" target=\"_blank\" rel=\"noopener noreferrer\">Tally<\/a> course in the market which you guys might want to check out.<\/span><\/p>\n<p><span style=\"color: #000000;\">Do check out our <a style=\"color: #000000;\" href=\"https:\/\/www.facebook.com\/ICAJobguarantee\/\" target=\"_blank\" rel=\"noopener noreferrer\">Facebook<\/a>, <a style=\"color: #000000;\" href=\"https:\/\/twitter.com\/IcaSkills\" target=\"_blank\" rel=\"noopener noreferrer\">Twitter<\/a> and <a style=\"color: #000000;\" href=\"https:\/\/www.instagram.com\/icaeduskills\/\" target=\"_blank\" rel=\"noopener noreferrer\">Instagram<\/a> pages if you like the content we publish \ud83d\ude42<\/span><\/p>\n<div style=\"overflow-x: auto;\">\n<table class=\"table table-bordered\">\n<caption>Few important guides on TallyPrime<\/caption>\n<tbody>\n<tr>\n<td width=\"15%;\"><img decoding=\"async\" src=\"https:\/\/www.icacourse.in\/wp-content\/uploads\/2023\/04\/audit-trail-in-tallyprime-detailed-guide.webp\" alt=\"audit trail in tallyprime\" \/><\/td>\n<td><a href=\"https:\/\/www.icacourse.in\/audit-trail-in-tallyprime\/\" target=\"_blank\" rel=\"noopener\">Audit Trail in TallyPrime: Meaning, Importance, Example, Applicability, Usage<\/a><\/td>\n<\/tr>\n<tr>\n<td width=\"10%;\"><img decoding=\"async\" src=\"https:\/\/www.icacourse.in\/wp-content\/uploads\/2023\/07\/tally-prime-shortcut-keys-download-pdf.webp\" alt=\"tallyprime shortcut keys\" \/><\/td>\n<td><a href=\"https:\/\/www.icacourse.in\/tallyprime-shortcut-keys\/\" target=\"_blank\" rel=\"noopener\">241 TallyPrime Shortcut Keys Demystified + 32 Productivity Hacks [Download PDF]<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Balance Sheet is one of the most important financial statements prepared by a business firm. It&#8217;s like a one-stop shop for gauging the financal status and position of a company. The financial details of the balance sheet helps the business and the external stakeholders to evaluate the financial performance of the business on a [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":2287,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[317],"class_list":["post-2251","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tally","tag-problem-solution-content"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.icajobguarantee.com\/blog\/wp-json\/wp\/v2\/posts\/2251","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.icajobguarantee.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.icajobguarantee.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.icajobguarantee.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.icajobguarantee.com\/blog\/wp-json\/wp\/v2\/comments?post=2251"}],"version-history":[{"count":3,"href":"https:\/\/www.icajobguarantee.com\/blog\/wp-json\/wp\/v2\/posts\/2251\/revisions"}],"predecessor-version":[{"id":10873,"href":"https:\/\/www.icajobguarantee.com\/blog\/wp-json\/wp\/v2\/posts\/2251\/revisions\/10873"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.icajobguarantee.com\/blog\/wp-json\/wp\/v2\/media\/2287"}],"wp:attachment":[{"href":"https:\/\/www.icajobguarantee.com\/blog\/wp-json\/wp\/v2\/media?parent=2251"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.icajobguarantee.com\/blog\/wp-json\/wp\/v2\/categories?post=2251"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.icajobguarantee.com\/blog\/wp-json\/wp\/v2\/tags?post=2251"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}