i am working as accountant any one can help me please
i want to prepare Detailed creditors/debtors statements on date of application and certified by auditor. for the purpose of renewal of working capital please tell me how to prepare with example of format
21 July 2024
Certainly! Below is a detailed format for preparing creditor/debtor statements, suitable for the purpose of renewal of working capital, certified by an auditor. This format is typically used to provide a snapshot of the outstanding balances owed by or to the company's creditors and debtors on a specific date.
### Creditor Statement Format:
**Creditor Name:** **Statement Date:**
| Sr. No. | Invoice No. | Invoice Date | Due Date | Invoice Amount | Amount Paid | Balance Due | |---------|-------------|--------------|----------|----------------|-------------|-------------| | 1 | INV-001 | DD/MM/YYYY | DD/MM/YYYY | Amount | Amount | Amount | | 2 | INV-002 | DD/MM/YYYY | DD/MM/YYYY | Amount | Amount | Amount | | ... | ... | ... | ... | ... | ... | ... | | Total | | | | Total Amount | Total Paid | Total Due |
### Debtor Statement Format:
**Debtor Name:** **Statement Date:**
| Sr. No. | Invoice No. | Invoice Date | Due Date | Invoice Amount | Amount Paid | Balance Due | |---------|-------------|--------------|----------|----------------|-------------|-------------| | 1 | INV-001 | DD/MM/YYYY | DD/MM/YYYY | Amount | Amount | Amount | | 2 | INV-002 | DD/MM/YYYY | DD/MM/YYYY | Amount | Amount | Amount | | ... | ... | ... | ... | ... | ... | ... | | Total | | | | Total Amount | Total Paid | Total Due |
### Explanation of Columns:
1. **Sr. No.:** Serial number for each transaction. 2. **Invoice No.:** Number of the invoice issued. 3. **Invoice Date:** Date when the invoice was issued. 4. **Due Date:** Date by which the payment is due. 5. **Invoice Amount:** Total amount billed in the invoice. 6. **Amount Paid:** Total amount paid by the debtor/creditor against the invoice. 7. **Balance Due:** Outstanding amount after deducting payments made.
### Additional Notes:
- Ensure all entries are accurate and match with the accounting records. - The statement should be prepared as of a specific date, typically the date of application for renewal of working capital. - Include any additional relevant information requested by the auditor or required by the lender for the renewal process. - The auditor should verify and certify the accuracy of the statement.
```
### Certification:
The statements should be certified by the auditor, confirming the accuracy and completeness of the information provided. The auditor may also include their contact information and signature to authenticate the statement.
This format should help you prepare detailed creditor and debtor statements effectively for the purpose of renewal of working capital, ensuring compliance and clarity in financial reporting.
CAclubindia
