Budgeting & Forecasting › Cash Budgeting
How do you calculate cash receipts from credit sales?
IntermediateAnswer
Apply the expected collection pattern to budgeted sales: e.g., if 30% is collected in the month of sale and 70% the following month, receipts in a month = 30% of this month's sales + 70% of last month's sales. Allow for bad debts and settlement discounts. This lag between sale and cash is central to the cash budget.
Sales: Jan 100k, Feb 120k. Collect 30% same month, 70% next.
Feb receipts = 30%x120k + 70%x100k = 36k + 70k = 106k.Real-world example The team applies the historical collection profile to phase budgeted sales into cash receipts.