How to Prepare a Schedule of Expected Cash Collections


Cash collections help a company pay for its normal operations. Sales revenue is the starting point of cash collections. Companies will sell goods or services in exchange for cash and/or credit. Credit sales result in accounts receivable; this indicates a company has customers who owe it money. A company must spend time collecting these open accounts in order to receive the cash owed to it. A schedule of cash collections helps accountants determine how much cash a company can expect to collect during an accounting period.

Review the previous annual credit sales and accounts receivable to determine the potential bad debts. Bad debts represent unpaid accounts receivable the company will not collect.

Divide cash collected from credit sales by total credit sales. This provides an average collection percentage for open accounts receivable.

Total all credit sales for the current accounting period.

Multiply the figure from Step 3 by the collection percentage from Step 2. List the computed figure on the cash collection report.

Add total cash sales to the figure from Step 4. This represents the total cash collected for an accounting period.

Complete Steps 3 through 5 for each accounting period in the year. This will provide a total cash collection schedule for the entire year.

Related Searches


  • "Intermediate Accounting"; J. David Spiceland, et al.; 2007
Promoted By Zergnet


You May Also Like

Related Searches

Check It Out

Are You Really Getting A Deal From Discount Stores?

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!