Create failed payment rows for billing coordinators today

Failed card charges arrive untracked and leave billing staff without a single list to chase. Log each failed payment row so coordinators can triage and act before the next reconciliation.