Trial balance
This query is : Resolved
Amit Kumar
(Querist)
15 December 2014
Dear Sirs,
How can find out / check error thru trial balance (Using Tally ERP 9.0)& please let me the procedure to make balance sheet in excel thru trial balance.
How can find out / check error thru trial balance (Using Tally ERP 9.0)& please let me the procedure to make balance sheet in excel thru trial balance.
15 December 2014
what exactlu u want to check?
Amit Kumar
(Querist)
15 December 2014
to find out arthimetical error
02 August 2025
Got it! You want to **find/check errors through Trial Balance in Tally ERP 9** and also want a **procedure to prepare Balance Sheet in Excel using Trial Balance**. Here's a simple guide:
---
### 1. **Checking Errors in Trial Balance Using Tally ERP 9**
* **Trial Balance Not Balancing?**
If the trial balance in Tally is not balancing (i.e., Debit ≠ Credit), it means there is some error such as:
* Incorrect ledger entry (wrong debit/credit)
* Transaction entered in wrong ledger
* Wrong amount entered
* Missing entries
* Arithmetic errors
* **Steps to Identify Errors in Tally:**
1. **Run Trial Balance Report:**
Gateway of Tally → Display → Trial Balance
2. **Check for difference amount** between Debit and Credit.
3. **Use Exception Reports:**
Gateway of Tally → Display → Exception Reports → List of Unadjusted Entries or other exception reports that can help spot anomalies.
4. **Use Day Book:**
Check day book entries for any wrong postings.
5. **Drill down into ledgers** with large balances and check entries.
6. **Check for Round off or Rounding errors** in Tally Configuration.
* **If Trial Balance balances, arithmetic errors are unlikely.**
---
### 2. **Preparing Balance Sheet in Excel from Trial Balance**
* **Step-by-step procedure:**
1. **Export Trial Balance from Tally:**
* Gateway of Tally → Display → Trial Balance → Export → Choose Excel format → Save file.
2. **Open exported Trial Balance in Excel.**
3. **Identify Categories:**
Classify accounts into Assets, Liabilities, Income, and Expenses.
4. **Create Separate Sections in Excel:**
* **Assets:** Fixed Assets, Current Assets, Investments, Cash & Bank balances, etc.
* **Liabilities:** Capital, Reserves & Surplus, Long-term liabilities, Current liabilities, Provisions, etc.
5. **Calculate Totals:**
Sum up total assets and total liabilities separately.
6. **Check that Assets = Liabilities:**
Balance Sheet must balance.
7. **Formatting:**
Use Excel features like borders, bold, and alignment to make it presentable.
---
### **Sample Layout in Excel:**
| Particulars | Amount (₹) | Particulars | Amount (₹) |
| ---------------- | ---------- | ------------------------------ | ---------- |
| **Assets** | | **Liabilities & Equity** | |
| Fixed Assets | 1,00,000 | Capital | 1,20,000 |
| Current Assets | 50,000 | Reserves & Surplus | 20,000 |
| Cash & Bank | 20,000 | Current Liabilities | 30,000 |
| **Total Assets** | 1,70,000 | **Total Liabilities & Equity** | 1,70,000 |
---
If you want, I can help you prepare a **Balance Sheet template in Excel** or guide you through the Tally steps in more detail. Just let me know!
---
### 1. **Checking Errors in Trial Balance Using Tally ERP 9**
* **Trial Balance Not Balancing?**
If the trial balance in Tally is not balancing (i.e., Debit ≠ Credit), it means there is some error such as:
* Incorrect ledger entry (wrong debit/credit)
* Transaction entered in wrong ledger
* Wrong amount entered
* Missing entries
* Arithmetic errors
* **Steps to Identify Errors in Tally:**
1. **Run Trial Balance Report:**
Gateway of Tally → Display → Trial Balance
2. **Check for difference amount** between Debit and Credit.
3. **Use Exception Reports:**
Gateway of Tally → Display → Exception Reports → List of Unadjusted Entries or other exception reports that can help spot anomalies.
4. **Use Day Book:**
Check day book entries for any wrong postings.
5. **Drill down into ledgers** with large balances and check entries.
6. **Check for Round off or Rounding errors** in Tally Configuration.
* **If Trial Balance balances, arithmetic errors are unlikely.**
---
### 2. **Preparing Balance Sheet in Excel from Trial Balance**
* **Step-by-step procedure:**
1. **Export Trial Balance from Tally:**
* Gateway of Tally → Display → Trial Balance → Export → Choose Excel format → Save file.
2. **Open exported Trial Balance in Excel.**
3. **Identify Categories:**
Classify accounts into Assets, Liabilities, Income, and Expenses.
4. **Create Separate Sections in Excel:**
* **Assets:** Fixed Assets, Current Assets, Investments, Cash & Bank balances, etc.
* **Liabilities:** Capital, Reserves & Surplus, Long-term liabilities, Current liabilities, Provisions, etc.
5. **Calculate Totals:**
Sum up total assets and total liabilities separately.
6. **Check that Assets = Liabilities:**
Balance Sheet must balance.
7. **Formatting:**
Use Excel features like borders, bold, and alignment to make it presentable.
---
### **Sample Layout in Excel:**
| Particulars | Amount (₹) | Particulars | Amount (₹) |
| ---------------- | ---------- | ------------------------------ | ---------- |
| **Assets** | | **Liabilities & Equity** | |
| Fixed Assets | 1,00,000 | Capital | 1,20,000 |
| Current Assets | 50,000 | Reserves & Surplus | 20,000 |
| Cash & Bank | 20,000 | Current Liabilities | 30,000 |
| **Total Assets** | 1,70,000 | **Total Liabilities & Equity** | 1,70,000 |
---
If you want, I can help you prepare a **Balance Sheet template in Excel** or guide you through the Tally steps in more detail. Just let me know!
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Depreciation Chart Companies Act
- GST Audit whether Govt Companies are exempt?
- PTRC Show Cause Notice on Email
- Unable to File TDS Q2 Return – New TRACES Portal Error
- Capital Gail Exemption Certificate
- Taxation of crypto futures in India Fy 2026- 2027
- EPF ECR NEW RULES Sep 17th 2026
- Not ordinarily resident having partnership income in India and salary in USA is any form to filed be
- Issuing of delivery challan by seller of goods
- MSME disclosure and disallowance
- Accounting treatment of AMC alongwith the purchase of Laptop
- GST Treatment of Purchases with GST Paid where Outward Supplies of Manufactured CattleFeed Exempt
- Expert Help Required for TDS Refund 100000 Through TRACES – AY 2022–23
- IMPORT PURCHASE ENTRY PASSED IN BOOKS OF ACCOUNT
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- Regime change
- Goods sold but invoice not issued
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
