CREDIT CONTROL AND COLLECTIONS WORKFLOW

Created by ChecklistGuro (https://checklistguro.com)

[ ] Retrieve Overdue Invoices: Fetch all invoice entries from the Data Model where the due date is less than the current date and status is 'Unpaid'.
[ ] Calculate Total Outstanding Debt: Sum the 'Amount Due' property of all retrieved overdue invoice entries to determine total exposure.
[ ] Calculate Days Overdue: Calculate the number of days between the 'Due Date' and the 'Current Date' for each entry.
[ ] Update Invoice Status to 'In Collection': Change the status field of the identified overdue invoices to 'In Collection' to prevent duplicate processing.
[ ] Assign Collection Officer: Create a task for the Credit Control Manager to review the high-value overdue accounts.
[ ] Get Customer Contact Details: Retrieve email addresses and phone numbers from the Customer Data Model linked to the overdue invoices.
[ ] Send First Dunning Notice: Send an automated polite reminder email to the customer regarding the unpaid balance.
[ ] Send Payment Reminder SMS: Send a short SMS notification to the customer's registered mobile number for invoices overdue by more than 7 days.
[ ] Determine Risk Score: Calculate a new Risk Score based on the ratio of overdue amount to the total credit limit.
[ ] Update Customer Credit Limit: Automatically decrease the customer's available credit limit if the risk score exceeds a predefined threshold.
[ ] Escalation Task: Legal Review: Create a high-priority task for the Legal Department for accounts that have reached 60 days overdue.
[ ] Generate Weekly Aging Report: Create a summary report showing the distribution of receivables across 30, 60, and 90+ day buckets.
[ ] Archive Resolved Disputes: Remove entries from the 'Active Disputes' data model once a resolution or payment has been confirmed.

--- END OF TEMPLATE ---
Transform this text into a digital, automated, and trackable mobile app!
Visit: https://checklistguro.com/workflow-templates/accounting-management/credit-control-and-collections-workflow
(Click "Install Template" to launch your digital inspection tool immediately)