Sundry debtors
This query is : Resolved
13 June 2017
Sir,
I want to export sundry debtors ledger in eccell and find the balance how do I do it
I want to export sundry debtors ledger in eccell and find the balance how do I do it
Nischit Sanghavi
(Expert)
13 June 2017
from where you want to export?
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!
---
### 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
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Depreciation Chart Companies Act
- EPF ECR NEW FILE SEP 17TH 2026
- Capital Gail Exemption Certificate
- Oct 2025 Invoices
- Import of Software Service.
- SECTION 393(3) TAX ON CASH WITHDRAWAL
- Clarification Requested: Gift → NRO → NRE → Overseas Transfer - USA/CANDA (FEMA & Tax Compliance)
- Under marginal scheme
- Capitalgain tax purposes for valuation report compulsory
- GST on Renting godown to KFCSC for Storage of Raagi
- GST Audit whether Govt Companies are exempt?
- 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
- FAST-DS 2026 Under Tax Law - No recourse or support for person declaring via this scheme?
- Guidance Needed: Linking Multiple Form 26QB Payments and Responding to ITD Defaulter Notice
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
