Debtor Movement

Debtor Movement Report

The Debtor Movement Report provides a consolidated view of customer account activity over a specified period. It is essential for understanding how each customer's balance has changed due to sales, payments, and journal entries.

This report helps businesses track financial interactions with customers and ensures accounts receivable are accurate and up to date.

Each line in the report represents a single customer and includes the following fields:

Field	Description
Cust No	The customer’s unique account number.
Company	The trading name or company name.
First Name / Surname	The primary contact's name.
Current Balance	The current (regardless of the date range selected) outstanding balance for the customer.
Sales	Total sales posted to the account during the report period.
Payments	Total payments received against the account.
Journals	Journal adjustments such as credit notes or manual entries.
Movement	Net movement = Sales + Journals − Payments. This indicates if the account grew or was reduced in value.

💡 Note: Negative movement typically reflects overpayment or credit activity.

Why It’s Important

✅ Cash Flow Monitoring: Quickly identify customers whose accounts are growing or decreasing.
✅ Credit Control: Spot customers who are accumulating debt without matching payments.
✅ Reconciliation: Ensure payments and adjustments have been correctly applied to customer accounts.
✅ Transparency: Provides auditors or stakeholders a full, summarized view of debtor performance.

📤 Exporting & Sharing

The report can be:

Previewed on screen
Printed
Saved as PDF
Emailed to accountants, branch managers, or finance teams

Usage Example

A finance officer runs this report monthly to review all account movements and follow up with overdue customers. If a customer shows high sales but no payments, they may be flagged for credit hold or contacted for follow-up.