A cash receipts schedule is a short form to show your quarterly intake of cash sales. When you're running a retail business, one of the most difficult day-to-day jobs is to track your cash receipts. It's difficult to keep a running total of daily sales, especially cash sales, because unlike credit card sales, no automatic record is generated when a cash sale is completed (unless the sale is made at a register with a receipt printer). Whenever you accept cash sales, you must be committed to writing down every dollar and penny received in order to create an accurate cash receipts schedule.
Create a blank Microsoft Excel sheet. Also, if you have an Excel spreadsheet for all of your financial statements already, you can just create a new worksheet named "Cash Receipts Schedule."
Keep a cash receipts book handy. This way, whenever you receive a cash sale you can jot down the amount received and provide the customer with a receipt. Having a cash receipts book will reduce your need to enter cash receipts into your schedule on a daily basis.
Total up your cash sales for each quarter of the year. Quarters for a standard business year are January to March, April to June, July to September and October to December. (This will vary depending on the month your company uses as the beginning of your fiscal year.)
Download a summary of your credit card receipts for each quarter of the year. Add the quarterly credit card receipts to your cash receipts for each quarter to get the total cash receipts.
Enter the total cash receipts for each quarter into each row. You should have five rows listed in your Excel sheet: one for each quarter and one to total up all cash receipts for the year.
In most cases, you will want to include invoices due but not yet paid on your cash receipts schedule, but if for some reason, the invoice is never collected, you should deduct the amount when you decide to write off the debt on a future cash-receipts schedule. Be sure to keep a separate record of the unpaid invoice for your accounting records. Break down the quarterly rows into months (January, February, March for the first quarter) if you want to track this information. This way you can see which months are the best for sales.