Debtors Report
Introduction
The Debtors Report in the Property Management Solution module provides a detailed breakdown of outstanding sales invoices for customers, including due dates, items, and amounts in different currencies (USD and TZS). This report is essential for tracking receivables, ensuring that customers pay their outstanding invoices on time, and managing the cash flow of the business.
1. Purpose of the Debtors Report
The Debtors Report is designed to:
Display customer invoices that are unpaid or overdue.
Track outstanding amounts in both USD and TZS currencies.
Summarize invoice details such as items sold, due dates, and cost centers.
Provide a roll-up summary of customer debts and total outstanding amounts.
This report helps businesses manage their receivables effectively, ensuring that overdue payments are addressed promptly.
2. Key Fields in the Report
The Debtors Report includes the following key columns:
Invoice No:
- Description: Displays the invoice number, which can be clicked to navigate to the specific sales invoice.
Customer:
- Description: Shows the name of the customer associated with the invoice.
Cost Center:
- Description: The cost center linked to the invoice for accounting purposes.
Items:
- Description: Lists the items included in the invoice. Multiple items are grouped and displayed in a single entry.
From Date:
- Description: The start date of the billing period or service period for the invoice.
To Date:
- Description: The end date of the billing period or service period for the invoice.
Due Date:
- Description: The date by which the invoice payment is due.
USD:
- Description: Displays the outstanding amount in USD (if the invoice is in USD).
TZS:
- Description: Displays the outstanding amount in TZS (if the invoice is in TZS).
Remarks:
- Description: Displays any remarks or tags associated with the invoice, allowing users to include additional information.
Totals and Roll-Up Summary
The report includes a roll-up summary that shows total outstanding amounts for all customers, as well as subtotals for each customer. The TOTAL row at the bottom provides the cumulative outstanding amounts in both USD and TZS.