Debtors and Creditors statement to bank
This query is : Resolved
13 February 2021
Model of a debtors and creditors statement
12 July 2024
A debtors and creditors statement, often used in accounting and financial reporting, provides a summary of amounts owed to and by a business for goods or services rendered. Below is a model template for a debtors and creditors statement:
### Debtors Statement
**Date: [Date of Statement]**
| **Customer Name** | **Invoice Date** | **Invoice Number** | **Amount Due** |
|--------------------|------------------|--------------------|----------------|
| Customer A | DD/MM/YYYY | INV-001 | Amount |
| Customer B | DD/MM/YYYY | INV-002 | Amount |
| Customer C | DD/MM/YYYY | INV-003 | Amount |
| ... | ... | ... | ... |
| **Total Debtors** | | | **Total Amount** |
### Creditors Statement
**Date: [Date of Statement]**
| **Supplier Name** | **Invoice Date** | **Invoice Number** | **Amount Due** |
|--------------------|------------------|--------------------|----------------|
| Supplier X | DD/MM/YYYY | INV-001 | Amount |
| Supplier Y | DD/MM/YYYY | INV-002 | Amount |
| Supplier Z | DD/MM/YYYY | INV-003 | Amount |
| ... | ... | ... | ... |
| **Total Creditors**| | | **Total Amount** |
### Explanation of Terms:
- **Debtors Statement**: Lists customers who owe money to the business. Includes columns for customer name, invoice date, invoice number, and amount due. Totals the amount owed by all customers.
- **Creditors Statement**: Lists suppliers or vendors to whom the business owes money. Includes columns for supplier name, invoice date, invoice number, and amount due. Totals the amount owed to all suppliers.
### Additional Notes:
- Ensure the statements are updated regularly to reflect current amounts owed.
- Use these statements for reconciliation purposes and to track aging of debts and liabilities.
- Customize the template as per specific business needs, adding or modifying columns as necessary (such as aging buckets for debtors).
This model provides a basic structure that can be expanded or adjusted based on the complexity and specific requirements of your business operations. Adjustments may include incorporating aging analysis, currency information (for international transactions), or additional details as needed.
### Debtors Statement
**Date: [Date of Statement]**
| **Customer Name** | **Invoice Date** | **Invoice Number** | **Amount Due** |
|--------------------|------------------|--------------------|----------------|
| Customer A | DD/MM/YYYY | INV-001 | Amount |
| Customer B | DD/MM/YYYY | INV-002 | Amount |
| Customer C | DD/MM/YYYY | INV-003 | Amount |
| ... | ... | ... | ... |
| **Total Debtors** | | | **Total Amount** |
### Creditors Statement
**Date: [Date of Statement]**
| **Supplier Name** | **Invoice Date** | **Invoice Number** | **Amount Due** |
|--------------------|------------------|--------------------|----------------|
| Supplier X | DD/MM/YYYY | INV-001 | Amount |
| Supplier Y | DD/MM/YYYY | INV-002 | Amount |
| Supplier Z | DD/MM/YYYY | INV-003 | Amount |
| ... | ... | ... | ... |
| **Total Creditors**| | | **Total Amount** |
### Explanation of Terms:
- **Debtors Statement**: Lists customers who owe money to the business. Includes columns for customer name, invoice date, invoice number, and amount due. Totals the amount owed by all customers.
- **Creditors Statement**: Lists suppliers or vendors to whom the business owes money. Includes columns for supplier name, invoice date, invoice number, and amount due. Totals the amount owed to all suppliers.
### Additional Notes:
- Ensure the statements are updated regularly to reflect current amounts owed.
- Use these statements for reconciliation purposes and to track aging of debts and liabilities.
- Customize the template as per specific business needs, adding or modifying columns as necessary (such as aging buckets for debtors).
This model provides a basic structure that can be expanded or adjusted based on the complexity and specific requirements of your business operations. Adjustments may include incorporating aging analysis, currency information (for international transactions), or additional details as needed.
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
- Price inclusive or exclusive of GST while made entry in P& L Account
- Gst registered proprietorship firm
- TDS Challan - change of FY 2025-26 to TY 2026-27
- Minimum tax payable to file Updated return
- AUDITOR APPOINTMENT FOR THE YEAR ENDING MARCH 27
- TDS on Fixed Assets purchased
- TDS on purchase of under construction property from a reseller
- GST Intimation due to Government took possession of Business Premises under PPE Act
- Salary from Qatar in Dollars in India
- GST ISSUE OF INPUT AND OUTPUT GST
- How to Handle Active E-Invoices in GST Portal Deleted from Tally?
- IMPORT PURCHASE ENTRY PASSED IN BOOKS OF ACCOUNT
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- Starting trading business
- 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?
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
