Update client hours usage row from received payment
Update client hours usage row from received payment
You keep an Hours Used sheet, but some qualifying payments arrive without usage updates, causing reconciliation gaps. Automated updates align billing and usage for same-day reconciliation.
Overview
When payments for extra hours land without a usage update, billing waits until month end to reconcile and clients wait for invoices. This flow writes qualifying payments into your Hours Used sheet and alerts billing so reconciliations and client notifications can happen same day.