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.

Update client hours usage row from received payment

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.

Update client hours usage row from received payment