Updated January 04, 2026
Sundry Debtors/Creditors
The Sundry Debtors/Creditors report in EquiBillBook provides a comprehensive view of all outstanding amounts owed to your business (debtors) and amounts your business owes to others (creditors). It helps you track receivables and payables, manage collections and payments, and maintain accurate accounts receivable and accounts payable records. This guide explains how to generate and understand the Sundry Debtors/Creditors report.
What is Sundry Debtors/Creditors Report?
The Sundry Debtors/Creditors report shows:
- Sundry Debtors: Amounts owed to your business by customers and others
- Sundry Creditors: Amounts your business owes to suppliers and others
- Individual debtor/creditor balances
- Total outstanding receivables
- Total outstanding payables
- Aging analysis of outstanding amounts
- Transaction details for debtors/creditors
Purpose of Sundry Debtors/Creditors Report
The Sundry Debtors/Creditors report is used to:
- Track accounts receivable (debtors)
- Track accounts payable (creditors)
- Monitor outstanding balances
- Manage collections from debtors
- Plan payments to creditors
- Analyze aging of receivables and payables
- Identify overdue amounts
- Support cash flow management
Accessing Sundry Debtors/Creditors Report
To generate a Sundry Debtors/Creditors report:
- Navigate to Reports from the main menu
- Go to Accounts Reports
- Select Sundry Debtors/Creditors or Debtors & Creditors
- Select report type (Debtors, Creditors, or Both)
- Set the As of Date (the date for which you want the report)
- Select branch (if using multi-branch setup)
- Configure additional filters if needed
- Click "Generate" or "View Report"
Understanding Sundry Debtors/Creditors Structure
1. Sundry Debtors Section
Shows amounts owed to your business:
- Customer Balances: Outstanding amounts from customers
- Other Debtors: Other parties who owe money to your business
- Individual Balances: Balance for each debtor
- Total Debtors: Sum of all debtor balances
- Aging Analysis: Breakdown by age of outstanding amounts
2. Sundry Creditors Section
Shows amounts your business owes:
- Supplier Balances: Outstanding amounts to suppliers
- Other Creditors: Other parties to whom your business owes money
- Individual Balances: Balance for each creditor
- Total Creditors: Sum of all creditor balances
- Aging Analysis: Breakdown by age of outstanding amounts
3. Aging Analysis
Shows outstanding amounts by age:
- Current: Not yet due
- 0-30 Days: Due within 30 days
- 31-60 Days: 31 to 60 days overdue
- 61-90 Days: 61 to 90 days overdue
- Over 90 Days: More than 90 days overdue
- Total Outstanding: Sum of all aging categories
Report Configuration Options
1. Report Type Selection
Choose what to include:
- Sundry Debtors Only: Show only receivables
- Sundry Creditors Only: Show only payables
- Both Debtors and Creditors: Show both sections
2. Date Selection
Choose the date for the report:
- Today: Current date's outstanding balances
- End of Month: Month-end balances
- End of Quarter: Quarter-end balances
- End of Financial Year: Year-end balances
- Specific Date: Any date you want to review
3. Filter Options
Filter the report:
- Show Zero Balances: Include parties with zero balance
- Hide Zero Balances: Exclude parties with zero balance
- Show Only Overdue: Show only overdue amounts
- Filter by Customer/Supplier: Select specific parties
- Filter by Amount Range: Show balances within range
4. Display Options
Customize report display:
- Show Aging Analysis: Display aging breakdown
- Show Transaction Details: Include transaction list
- Group by Customer/Supplier: Organize by party
- Show Contact Information: Include contact details
- Show Payment Terms: Display payment terms
Understanding Sundry Debtors
1. Customer Receivables
Shows outstanding amounts from customers:
- Sales invoices not yet paid
- Advance payments received (shown as negative)
- Credit notes issued
- Outstanding balances per customer
2. Other Debtors
Shows other parties who owe money:
- Loans given to others
- Advances given
- Other receivables
- Miscellaneous debtors
3. Debtor Analysis
Provides insights into:
- Total receivables
- Average collection period
- Overdue amounts
- Collection risk
Understanding Sundry Creditors
1. Supplier Payables
Shows outstanding amounts to suppliers:
- Purchase bills not yet paid
- Advance payments made (shown as negative)
- Debit notes issued
- Outstanding balances per supplier
2. Other Creditors
Shows other parties to whom you owe money:
- Loans taken
- Advances received
- Other payables
- Miscellaneous creditors
3. Creditor Analysis
Provides insights into:
- Total payables
- Average payment period
- Overdue amounts
- Payment obligations
Report Formats
1. Summary Format
Shows summary information:
- Total debtors and creditors
- Aging summary
- Key totals
2. Detailed Format
Shows complete details:
- Individual debtor/creditor balances
- Transaction details
- Aging breakdown
- Contact information
3. Aging Format
Focuses on aging analysis:
- Aging buckets prominently displayed
- Overdue amounts highlighted
- Collection/payment priorities
Exporting Sundry Debtors/Creditors
Export the report in various formats:
- PDF: For printing and official records
- Excel: For further analysis and calculations
- CSV: For importing into other systems
- Print: Direct printing
Using Sundry Debtors/Creditors for Analysis
1. Collection Management
Use for debtors to:
- Identify overdue receivables
- Prioritize collection efforts
- Track collection progress
- Manage customer relationships
2. Payment Planning
Use for creditors to:
- Plan payment schedules
- Prioritize payments
- Manage cash flow
- Maintain supplier relationships
3. Cash Flow Management
Use the report to:
- Forecast cash inflows (from debtors)
- Forecast cash outflows (to creditors)
- Manage working capital
- Plan financing needs
Common Sundry Debtors/Creditors Scenarios
1. Monthly Debtors/Creditors Review
Generate monthly to:
- Review outstanding balances
- Identify overdue amounts
- Plan collections and payments
- Monitor aging trends
2. Collection Follow-up
Use for debtors to:
- Generate collection reports
- Identify customers for follow-up
- Track collection efforts
- Manage receivables
3. Payment Management
Use for creditors to:
- Generate payment schedules
- Prioritize payments
- Track payment obligations
- Manage payables
Tips for Using Sundry Debtors/Creditors
- Generate report regularly (monthly recommended)
- Review aging analysis for overdue amounts
- Follow up on overdue debtors promptly
- Plan payments to creditors strategically
- Monitor trends in receivables and payables
- Use for cash flow forecasting
- Export reports for record-keeping
- Compare reports across periods
Sundry Debtors/Creditors vs. Other Reports
Sundry Debtors/Creditors vs. Accounts Receivable
- Sundry Debtors/Creditors: Shows both debtors and creditors
- Accounts Receivable: Shows only receivables
- Sundry Debtors/Creditors provides comprehensive view
- Accounts Receivable focuses on receivables only
Sundry Debtors/Creditors vs. Accounts Payable
- Sundry Debtors/Creditors: Shows both debtors and creditors
- Accounts Payable: Shows only payables
- Sundry Debtors/Creditors provides comprehensive view
- Accounts Payable focuses on payables only
Troubleshooting Sundry Debtors/Creditors Issues
Missing Debtors/Creditors
- Check date selection is correct
- Verify transactions are posted
- Review filter settings
- Check branch selection
Incorrect Balances
- Verify transaction amounts
- Check payment entries
- Review invoice/bill dates
- Ensure all transactions are included
Best Practices
- Generate Sundry Debtors/Creditors regularly
- Review aging analysis for overdue amounts
- Follow up on overdue debtors promptly
- Plan payments to creditors strategically
- Monitor trends in receivables and payables
- Use for cash flow management
- Export reports for records
- Maintain historical reports
Need Help?
If you need assistance with Sundry Debtors/Creditors:
- Ensure you have proper permissions to view reports
- Verify date selection is correct
- Check that transactions are properly posted
- Review filter and display settings
- Verify customer/supplier balances are correct
- Contact support for help with complex queries
The Sundry Debtors/Creditors report is essential for managing accounts receivable and accounts payable, tracking outstanding balances, and supporting effective cash flow management. Regular review of this report helps ensure timely collections, strategic payments, and optimal working capital management.