Debtors and Creditors How to make
This query is : Resolved
13 May 2025
How to make Debtors and Creditors Reco.
What to add In Debtors and Less Creditors
What to add in Creditors and Less Creditors
If Transaction involves
Sale - Purchase
Payment -Received
Discount Given- Discount Received
TDS paid - TDS Receivable
Round off.
What to add In Debtors and Less Creditors
What to add in Creditors and Less Creditors
If Transaction involves
Sale - Purchase
Payment -Received
Discount Given- Discount Received
TDS paid - TDS Receivable
Round off.
12 August 2025
Sure! Here’s a simple guide on how to prepare **Debtors and Creditors Reconciliation** considering the transactions you mentioned:
---
## 1. **Debtors Reconciliation**
### Start with:
* **Opening Debtors balance** (from books)
### Add:
* **Sales on credit** (amounts billed to customers)
* **TDS Receivable** (if deducted by customers but not yet received/refunded)
* **Discount Received** (if applicable, usually not on debtors side, so usually ignored here)
* **Any other receivables or adjustments related to customers**
### Less:
* **Payments received from customers**
* **Discount Given to customers** (reduces amount receivable)
* **TDS Paid (if you have paid on behalf of customer, but mostly TDS Receivable is more relevant here)**
* **Round off adjustments**
---
## 2. **Creditors Reconciliation**
### Start with:
* **Opening Creditors balance** (from books)
### Add:
* **Purchases on credit** (amounts purchased from suppliers)
* **TDS Paid** (if deducted on your payment to suppliers)
* **Discount Given** (usually discount allowed by suppliers reduces amount payable, so it’s deducted, not added)
* **Any other payables or adjustments related to suppliers**
### Less:
* **Payments made to suppliers**
* **Discount Received from suppliers** (reduces your payable)
* **TDS Receivable (if any, normally less common on creditors side)**
* **Round off adjustments**
---
### Notes:
* **Discount Given:** When you give a discount to customers, it reduces your debtors. When a supplier gives a discount, it reduces your creditors.
* **TDS Paid:** If you have deducted TDS on payments to suppliers, that amount is reduced from the payable to creditors and recognized as TDS Receivable.
* **Round off:** Adjust any rounding differences separately.
---
### Sample format:
| Particulars | Amount (₹) | Particulars | Amount (₹) |
| --------------------------- | ---------- | ----------------------------- | ---------- |
| **Debtors Opening Balance** | X | Payments Received | X |
| Add: Sales on Credit | X | Less: Discount Given | X |
| Add: TDS Receivable | X | Less: Round off | X |
| Less: Discount Given | X | | |
| **Closing Debtors Balance** | X | **Creditors Opening Balance** | X |
| | | Add: Purchases on Credit | X |
| | | Add: TDS Paid | X |
| | | Less: Payments Made | X |
| | | Less: Discount Received | X |
| | | Less: Round off | X |
| | | **Closing Creditors Balance** | X |
---
If you want, I can help you prepare a detailed reconciliation statement with example figures. Would you like that?
---
## 1. **Debtors Reconciliation**
### Start with:
* **Opening Debtors balance** (from books)
### Add:
* **Sales on credit** (amounts billed to customers)
* **TDS Receivable** (if deducted by customers but not yet received/refunded)
* **Discount Received** (if applicable, usually not on debtors side, so usually ignored here)
* **Any other receivables or adjustments related to customers**
### Less:
* **Payments received from customers**
* **Discount Given to customers** (reduces amount receivable)
* **TDS Paid (if you have paid on behalf of customer, but mostly TDS Receivable is more relevant here)**
* **Round off adjustments**
---
## 2. **Creditors Reconciliation**
### Start with:
* **Opening Creditors balance** (from books)
### Add:
* **Purchases on credit** (amounts purchased from suppliers)
* **TDS Paid** (if deducted on your payment to suppliers)
* **Discount Given** (usually discount allowed by suppliers reduces amount payable, so it’s deducted, not added)
* **Any other payables or adjustments related to suppliers**
### Less:
* **Payments made to suppliers**
* **Discount Received from suppliers** (reduces your payable)
* **TDS Receivable (if any, normally less common on creditors side)**
* **Round off adjustments**
---
### Notes:
* **Discount Given:** When you give a discount to customers, it reduces your debtors. When a supplier gives a discount, it reduces your creditors.
* **TDS Paid:** If you have deducted TDS on payments to suppliers, that amount is reduced from the payable to creditors and recognized as TDS Receivable.
* **Round off:** Adjust any rounding differences separately.
---
### Sample format:
| Particulars | Amount (₹) | Particulars | Amount (₹) |
| --------------------------- | ---------- | ----------------------------- | ---------- |
| **Debtors Opening Balance** | X | Payments Received | X |
| Add: Sales on Credit | X | Less: Discount Given | X |
| Add: TDS Receivable | X | Less: Round off | X |
| Less: Discount Given | X | | |
| **Closing Debtors Balance** | X | **Creditors Opening Balance** | X |
| | | Add: Purchases on Credit | X |
| | | Add: TDS Paid | X |
| | | Less: Payments Made | X |
| | | Less: Discount Received | X |
| | | Less: Round off | X |
| | | **Closing Creditors Balance** | X |
---
If you want, I can help you prepare a detailed reconciliation statement with example figures. Would you like that?
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
- Difference between Date of Payment and Date of Deduction?
- ITDS U/S.194T of Firm
- TDS CREDIT MISMATCHING
- Buy back of shares u/s69
- Unregistered suppliers utility
- Tax Audit Applicability – Newly Formed Partnership Firm with Profit Below 6%/8%
- EXPORT COMMERCIAL INVOICE HSN CODE
- URGENT-Eligible leaves being shown as 24 days for 3 years Articleship instead of 156 days in 108
- ADDITION OF CHALLAN IN TDS RETURN FORM 140
- Cash balance limit and property purchases limit
- Non-Compliance documents have not been submitted by the contractors debited
- RCM @ 5% on Hamali charges, Transport Charges, Unloading charges we take ITC or not
- CALCULATION OF DEFFERED TAX - OP BL IS DTL & CURRET IT DTA
- LLP audit under companies act
- Experienced CA recommendation from Kolkata for FNO return filing
- Interest Reporting in Form 168
- Sales of goods of amount Rs77 lakhs to a party
- Tax Demand of ₹4,650 for AY 2026-27
- Concept of Vendor and customner reconciliation
- Mistake in e-invoice identified after 24 hours
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
