Pledges should be automatically marked as "Completed" when the last installment is committed and the balance is zero. Status Date would be the gift date of the installment payment.
It is more efficient to automate this process rather than running a query to identify active pledges with zero balances and then updating the records. Since pledges have payment schedules, RE should know when the last installment is being processed.