Trial balance

This query is : Resolved

Amit Kumar (Querist)
Follow

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.

CS,CA F,Numrologi TusharSampat

CS,CA F,Numrologi TusharSampat (Expert)
Follow

15 December 2014 what exactlu u want to check?

Amit Kumar

Amit Kumar (Querist)
Follow

15 December 2014 to find out arthimetical error

Aashok Kumar Sharma online

Aashok Kumar Sharma online

(Expert)
Follow

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!

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

Similar Resolved Queries

Unanswered Queries

Popular
Recent

Trending Online Classes

Direct Tax Laws & International Taxation May 26,Sept 26 & Jan 27

CA Arvind Tuli

Enroll Now
Audit Fast Track Recorded Batch For May 26,Sept 26 & Jan 27

CA Aarti Lahoti

Enroll Now
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English

CA Bhanwar Borana & CA Shubham Keswani

Enroll Now

view all classess

Meet our CAclubindia PRO Members

divakar podaturu

Richa Bajoria

Shraddha Pangam

Shailesh Prajapati

Mukund Thakur

Subscribe Now

Trial balance

Similar Resolved Queries

Trending Online Classes

Meet our CAclubindia PRO Members

Quick Links

Browse by Category

Latest Job Openings

Senior Executive

GST CONSULTANCY

Manager- Finance and Compliance

GST CONSULTANT

Accountant

CA Final