Update client billing status and tracker for failed payments

Failed payments arrive without follow-up, leaving billing records stale and collections unclear. Get rows added and client records marked failed so billing staff can prioritize collections same day.