Create rows that reflect reality: upfront deposits, mid‑project milestones, and final balances, each with expected collection delay. Add a gentle penalty or early‑pay incentive assumption if you use them. This helps you forecast not only how much arrives, but precisely when. If you change terms on new contracts, tweak one assumption and watch the cash curve shift immediately. When your team understands collections cadence, follow‑ups become disciplined, client communication improves, and your bank balance stops swinging wildly without clear cause or control.
Deposits stabilize cash yet represent obligations. Track them as cash in but deferred until earned work occurs. The one‑page view prevents accidental double counting while highlighting delivery commitments still on the calendar. When work runs ahead or behind plan, update a single completion percentage and watch recognition adjust. This transparency supports trust with clients and advisors, proving you respect both cash prudence and accounting integrity. It also informs scheduling, because you can see where obligations cluster before capacity becomes dangerously thin.