How to Create Cash Receipts Schedule

by Louise Balle ; Updated July 27, 2017

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.

Step 1

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."

Step 2

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.

Step 3

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.)

Step 4

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.

Step 5

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.

Video of the Day

Brought to you by

About the Author

Louise Balle has been writing Web articles since 2004, covering everything from business promotion to topics on beauty. Her work can be found on various websites. She has a small-business background and experience as a layout and graphics designer for Web and book projects.

Cite this Article | A tool to create a citation to reference this article Cite this Article

Related pages

executed lease agreementbursary motivation letter templateunited states treasury check verificationliving trust beneficiaryfafsa part timevanilla prepaid visa registerira contribution deductioni cosigned for a car that was repossessedstarting salary mswhow do i calculate my agi from my w2can you get paid for donating plasmahow many times can you withdraw from 401khow to get back in school with defaulted loanssubscriber account usaawhen your car is repossessed what happenshow to get a cosigner off a car loanvanilla visa balance checkcost to amend tax returnwhats a detached housewells fargo dollar to euro exchange ratewhat does etux meanwhere can i sell blood plasma for moneyflorida gulf coast university cheerleadingaccounts receivable aged trial balance examplewhat is the average expense ratio for a mutual fundland contracts pros and constlc extreme couponbmo checking accountseservice gap com paymentlottery winnings calculatoropposite of unearned revenuedividend per share formulaelestic clausegeico car rental coveragehow to fill out chequebasis points calculatorpowerball annuity payout schedulemoneygram lost money order formproperty taxes paid in arrearscara transfer credit celcomwhat does bullish meanbest scratch off tickets in illinoismortgage grants for single motherstax return for mileageebt card new yorkhow to remove a judgement lientax deduction laptopwww easy web td canada trustsalary with bonus calculatordispute letter for credit card chargesanthem blue cross policy number on cardpaypal transfer to prepaid cardassets on fafsaare reit dividends taxablewhat is the difference between subsidized and unsubsidized loansnebraska dmv change of addressw2 gross income1099 tax deductions allowedira vs brokerage accountis financial aid taxabletexas repossession lawdelinquency meaning in bankingppo vs pos plancan you deduct home improvements on your taxesbank of america atm machinesespp cost basis calculatorfile tax married jointly or separatelycocacola scholarshipsrollover 401k to ira without leaving jobgross profit rate calculatorchild support and alimony calculator floridatax return status h&r blockdoes goodwill take bikesjcp card payment