Trial balance
This query is : Resolved
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?
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
- Change details filed in original return
- Delay in Processing of return
- Query on applicability of Small Company, CARO & IFC
- Negative liability in GSTR-3B
- Applicability of GST on Paying Guest
- International Mutual fund redemption
- RCM PAYMENT BY SERVICE PROVIDER
- QUERY STOCK TRANSFER
- GST NOTICE DISCRIPENCIES
- GSTR 9 table 4 and table 10 query
- Applicability of GST on Hiring of Tipper to foreign Country at BHUTAN and elgibility of ITC on said
- FACELESS APPEALS
- Debt mutal fund redemption
- DEMAND UNDER SECTION 143 (3)
- "Please ensure that the Total of the Deductions u/s 54F match the same in Table D in Sch CG"
- Composition Dealer GST Annual Return Filing process
- TDS under section 195.
- Filing GST Returns after death of proprietor
- Registered Required in GST Act
- Switch over to Composition Scheme
Trending Online Classes
CAclubindia
