Workflow – Track Outstanding Property Tax Balances

Goal

Monitor and manage outstanding property tax balances systematically to maximize collection efficiency, identify priority accounts for follow-up action, and protect municipal revenue through effective collection activities.

When to Use

Weekly collection reviews to monitor outstanding balance trends
Aging analysis to categorize balances by delinquency period
Collection priority setting based on balance amounts and aging
Performance monitoring of collection activities and success rates
Policy evaluation for collection procedures and effectiveness
Resource allocation for collection staff and external agencies

Prerequisites

Complete payment data including all transactions and adjustments
Aging parameters properly configured (30, 60, 90+ day categories)
Collection policies documented and authority levels defined
User permissions for accessing collection and financial reporting
Integration with collection management systems
Historical collection performance data for comparison

Step-by-Step Instructions

1. Run Outstanding Balance Report

Navigate to Collections > Outstanding Balances > Aging Report

[Screenshot: Collections navigation menu showing Outstanding Balances section and Aging Report option]

Select current tax year and include prior years if needed
Set balance threshold filters (minimum amounts for collection action)
Choose geographic boundaries or districts for analysis
Include payment plan accounts based on collection policy

[Screenshot: Outstanding balance report configuration with tax year selection, threshold filters, and geographic boundaries]

2. Categorize Balances by Age

Generate aging report with standard categories (current, 30, 60, 90+ days)
Review balance distribution across aging categories
Identify accounts moving into higher aging brackets
Flag accounts with increasing balance trends
Consider seasonal payment patterns in aging analysis

[Screenshot: Aging report results showing balance distribution across time categories with highlighted trend indicators]

3. Identify Collection Priorities

Sort balances by amount and aging to determine priority accounts
Apply collection policy criteria for different balance ranges
Consider property type and ownership factors in prioritization
Flag accounts with special circumstances (hardship, appeals, etc.)
Generate priority collection lists for staff action

[Screenshot: Collection priority dashboard with sorted account lists and priority ranking algorithms]

4. Initiate Follow-up Actions

Generate collection notices for appropriate aging categories
Schedule phone calls for high-priority accounts
Prepare accounts for collection agency referral if applicable
Update account status and collection activity tracking
Coordinate with legal counsel for potential lien actions

[Screenshot: Collection action workflow interface showing notice generation, scheduling, and status tracking options]

5. Monitor and Track Progress

Update collection activity logs with actions taken
Track response rates and payment results from collection efforts
Monitor accounts moving between aging categories
Generate performance metrics for collection activities
Schedule follow-up reviews and next action dates

[Screenshot: Collection progress tracking dashboard with activity logs, response rates, and performance metrics]

Example

Identify $450,000 in overdue balances older than 90 days across 285 accounts for collection agency referral, representing 2.3% of total tax levy with average balance of $1,579 per account requiring immediate collection action.

[Screenshot: Sample aging analysis report highlighting $450,000 in 90+ day balances with account counts and averages]

Sample Outstanding Balance Analysis:

Current (0-30 days): $125,000 across 450 accounts, average $278
Past Due (31-60 days): $89,000 across 195 accounts, average $456
Delinquent (61-90 days): $156,000 across 168 accounts, average $929
Severely Delinquent (90+ days): $450,000 across 285 accounts, average $1,579
Total Outstanding: $820,000 representing 4.2% of annual levy

[Screenshot: Detailed balance aging table showing amounts, account counts, and percentages for each category]

[Screenshot: Collection efficiency chart showing historical performance and current period comparisons]

[Screenshot: Geographic distribution map showing outstanding balance concentrations by municipal district]

Common Errors & Fixes

Payment Timing Issues

Error: Recent payments not reflected in outstanding balance calculations
Fix: Ensure payment processing cutoff dates align with report generation
Prevention: Run payment posting updates before generating collection reports

[Screenshot: Payment timing validation interface showing cutoff date alignment and processing status]

Partial Payment Handling

Error: Partial payments incorrectly calculated in balance aging
Fix: Review partial payment allocation rules and aging calculation logic
Prevention: Implement automated partial payment processing with proper aging

[Screenshot: Partial payment allocation configuration screen with aging calculation rules]

Exemption Status Confusion

Error: Exempt properties included in collection priority lists
Fix: Update exemption status filters in collection reporting parameters
Prevention: Regular exemption status review and automated filtering

Collection Hold Oversight

Error: Accounts under collection holds included in active collection lists
Fix: Review and update collection hold status for affected accounts
Prevention: Implement automated hold status checking in collection workflows

[Screenshot: Collection hold management interface showing hold status and exemption filters]

Data Synchronization

Error: Outstanding balances don't match general ledger totals
Fix: Reconcile collection system data with financial system records
Prevention: Regular automated reconciliation processes and exception reporting

[Screenshot: Data reconciliation dashboard showing collection system vs general ledger comparison]

What Happens After

Collection Actions Initiated: Priority accounts receive appropriate collection activities
Priorities Set: Staff focus efforts on highest-value and most aged accounts
Performance Tracked: Collection success rates and revenue recovery monitored
Revenue Protected: Municipal revenue safeguarded through systematic collection efforts
Policy Evaluation: Collection procedures assessed and improved based on results
Resource Optimization: Collection resources allocated based on account priority and potential recovery
Compliance Maintained: Collection activities conducted within legal and policy frameworks

Screenshot Placeholders

[Screenshot: Collection management dashboard showing real-time outstanding balance trends and collection activity status]

[Screenshot: Advanced analytics interface with predictive modeling for collection success probability]

[Screenshot: Collection agency referral preparation screen with account packaging and transfer protocols]

[Screenshot: Legal action workflow interface for lien preparation and court proceeding management]

[Screenshot: Collection performance analytics with staff productivity metrics and success rate tracking]

[Screenshot: Payment plan management interface showing enrolled accounts and compliance monitoring]

[Screenshot: Collection communication templates for notices, letters, and phone call scripts]

[Screenshot: Resource allocation dashboard for optimizing collection staff assignments and territory management]

[Screenshot: Revenue recovery projection tool showing expected collections based on historical patterns]

[Screenshot: Collection policy compliance monitoring interface with audit trails and regulatory reporting]

[Screenshot: Integration status dashboard showing data synchronization between collection and financial systems]

[Screenshot: Collection calendar and scheduling interface for coordinating follow-up actions and deadlines]

[Screenshot: Exception reporting interface highlighting unusual collection patterns and potential system issues]

[Screenshot: Collection ROI analysis dashboard showing cost-effectiveness of different collection strategies]