Sundry debtors

This query is : Resolved

Share Report Follow Query Ask a Query

Utpal roy

Utpal roy (Querist)
Follow

13 June 2017 Sir,
I want to export sundry debtors ledger in eccell and find the balance how do I do it

Nischit Sanghavi

Nischit Sanghavi (Expert)
Follow

13 June 2017 from where you want to export?

Aashok Kumar Sharma

Aashok Kumar Sharma (Expert)
Follow

26 July 2025 To export your **Sundry Debtors ledger to Excel** and find the balance, here’s a general step-by-step guide (assuming you are using popular accounting software like Tally, QuickBooks, or similar):

---

### Export Sundry Debtors Ledger to Excel

#### 1. **In Tally:**

* Go to **Gateway of Tally > Display > Account Books > Ledger**.
* Select the **Sundry Debtors ledger**.
* Set the date range you want.
* Press **Alt + E** to export.
* Choose **Excel (Spreadsheet)** format.
* Select the location and export.

#### 2. **In QuickBooks:**

* Go to **Reports > Customers & Receivables > Customer Balance Summary** or **Aged Receivables**.
* Set the date filter.
* Click on **Export** and choose **Export to Excel**.

#### 3. **In Excel (If you already have data):**

* Open the exported file.
* To find total balance:

* Use **SUM** function on the balance column.
* Example: `=SUM(B2:B50)` where B2\:B50 is the balance column range.

---

### If you want to calculate balance manually:

* Sum all the debit entries.
* Subtract all the credit entries.
* The difference will be your **net balance** of Sundry Debtors.

---

If you tell me which software you are using, I can give you more precise instructions!

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