Table of debtors reconciliation ?

A table of debtors reconciliation typically includes the following columns:

1. Debtor Name: The name of the individual or company who owes money to the business.

2. Invoice Number: The unique identifier for the invoice that the debtor is being reconciled against.

3. Invoice Date: The date on which the invoice was issued to the debtor.

4. Invoice Amount: The total amount of the invoice that the debtor is required to pay.

5. Payment Date: The date on which the debtor made a payment towards the invoice.

6. Payment Amount: The amount that the debtor paid towards the invoice.

7. Outstanding Amount: The remaining balance that the debtor owes after making the payment.

8. Status: Indicates whether the invoice has been fully paid, partially paid, or remains unpaid.

By organizing this information in a table format, businesses can easily track and manage their outstanding debts, monitor payment statuses, and ensure that all invoices are reconciled accurately.

| Debtor | Outstanding Balance | Adjusted Balance | Variance |
|---|---|---|---|
| ABC Corp. | $10,000 | $12,000 | -$2,000 |
| XYZ Ltd. | $5,000 | $7,000 | -$2,000 |
| JKL Co. | $2,000 | $1,500 | $500 |
| MNO Inc. | $3,000 | $3,200 | -$200 |
| PQR LLC | $1,000 | $800 | $200 |
| Total | $21,000 | $24,500 | -$3,500 |