Cash transactions can be easy to lose track of when sales, expenses, refunds, and deposits happen throughout the day. A daily cash sheet template gives a business a consistent way to record those movements, compare the expected cash balance with the amount actually counted, and investigate differences promptly.
Whether you run a small shop, manage a café till, or oversee petty cash, a well-designed sheet can make daily closeout more orderly. Here’s what a daily cash sheet should include, how to use one, and what to keep in mind when adapting it for your business.
What Is a Daily Cash Sheet?
A daily cash sheet is a record of cash received and paid out during a particular business day. It typically tracks the opening cash balance, incoming cash, outgoing cash, deposits, and closing balance.
The sheet may be completed by a cashier, a shift supervisor, or an employee responsible for petty cash. Its purpose is to create a clear record that can be checked against the cash physically on hand and, where applicable, against sales records, receipts, and deposit slips.
A cash sheet is not necessarily a full accounting ledger. Instead, it is a practical daily record that supports bookkeeping and cash-control procedures.
Why Use a Daily Cash Sheet Template?
Using the same template each day helps staff follow a repeatable process. It can also make review and reconciliation easier because information is recorded in the same format.
A daily cash sheet can help a business:
- Spot discrepancies: Compare the cash balance calculated from recorded activity with the amount counted.
- Document transactions: Record the reason, amount, date, and supporting receipt for cash paid out.
- Improve handoffs: Give the next shift or manager a clear starting point.
- Support bookkeeping: Provide organized records for entering transactions into accounting software.
- Strengthen cash controls: Encourage consistent counting, review, and sign-off.
A template does not prevent mistakes or fraud on its own. It works best alongside clear procedures, appropriate approvals, and regular review.
What to Include in a Daily Cash Sheet
The right layout depends on how your business handles cash, but most daily cash sheets include the following fields.
1. Business and shift details
Identify the business location, date, register or cash box, and shift. Include the name or initials of the employee completing the sheet and, if appropriate, the reviewer.
2. Opening cash balance
Record the cash present at the beginning of the day or shift. This is sometimes called the opening float or starting cash. If the float is intended to stay at a fixed amount, note that amount clearly.
3. Cash received
Record cash inflows during the day. Depending on your operation, these might include:
- Cash sales
- Customer payments on accounts
- Cash received for services
- Other cash receipts
Keep the categories aligned with your sales and bookkeeping records. If a point-of-sale system separates cash, card, and other payment types, use its cash totals rather than treating all sales as cash received.
4. Cash paid out
Record cash leaving the till or cash box, such as approved petty-cash purchases or refunds. Include the amount, reason, recipient or vendor, and receipt or voucher reference.
For businesses that issue cash refunds, record them separately from other expenses. This makes it easier to compare refund activity with sales and point-of-sale reports.
5. Cash deposits or transfers
If cash is removed from the till and moved to a safe or bank deposit, record the amount and when it was transferred. A deposit is usually a movement of cash, not an expense, so it should be shown separately from operating costs.
6. Expected closing cash
A basic calculation is:
Opening cash + cash received − cash paid out − cash removed = expected closing cash
The exact calculation may vary depending on how your business treats refunds, transfers, and register float. Define the method in your instructions and use it consistently.
7. Actual cash count and variance
Count the physical cash at close and record the actual amount. Then calculate:
Variance = actual closing cash − expected closing cash
A positive variance means the count is higher than expected; a negative variance means it is lower. Record the difference rather than changing the figures to make them match. Any explanation or follow-up can be added in a notes field.
8. Sign-off and supporting documents
Provide space for the preparer and reviewer to sign or initial. Attach or reference receipts, register summaries, refund records, and deposit slips as appropriate. Follow your organization’s record-retention and privacy policies.
Sample Daily Cash Sheet Layout
You can create a simple template in a spreadsheet, accounting system, or printed form:
| Field | Entry |
|---|---|
| Business / location | |
| Date and shift | |
| Register or cash box | |
| Prepared by | |
| Opening cash balance | |
| Cash sales received | |
| Other cash received | |
| Cash refunds | |
| Approved cash expenses | |
| Cash transferred or deposited | |
| Expected closing cash | |
| Actual closing cash | |
| Variance | |
| Notes / receipt references | |
| Prepared by: signature or initials | |
| Reviewed by: signature or initials |
This layout is a starting point, not a one-size-fits-all accounting form. For example, a business with several registers may need one sheet per register, while a business tracking a single petty-cash fund may need fields for voucher numbers and replenishments.
How to Complete the Sheet
A consistent routine is more useful than a complicated form. Consider the following process:
- Count the opening float. Confirm the amount before transactions begin and record it.
- Use transaction records for totals. At close, obtain cash-sales and refund totals from the register or point-of-sale system.
- Document cash paid out. Match each cash expense or refund to an approved record or receipt.
- Record transfers and deposits. Note cash removed from the register so it is not mistaken for a shortage.
- Count the remaining cash. Follow a consistent counting method, ideally with a second person verifying the count where practical.
- Calculate and review the variance. Compare expected cash with the physical count and investigate differences under your organization’s procedure.
- Sign off and file the records. Keep the sheet with its supporting documents according to your recordkeeping policy.
For businesses with multiple shifts, make the handoff explicit: document the amount transferred, who handed it over, and who received it.
Tips for a More Reliable Cash-Handling Process
Keep responsibilities clear
Where practical, separate duties such as handling cash, preparing deposits, recording transactions, and reviewing reconciliations. In a small business, one person may perform several of these tasks, but an owner or manager can still review the records regularly.
Use numbered records for cash payouts
Petty-cash vouchers or payout forms can make it easier to connect a cash withdrawal to its purpose and supporting receipt. Require approval for payouts according to your business’s rules.
Investigate differences promptly
If the count does not match the expected balance, recount the cash and check the underlying records. Look for common causes such as a miscount, a transaction entered under the wrong payment type, an unrecorded refund, or an undocumented transfer. Document the outcome rather than silently adjusting the sheet.
Protect sensitive information
A daily cash sheet generally needs transaction details and staff identification, not unnecessary personal information. Store completed sheets and attachments securely, with access limited to people who need them.
Review the template periodically
As your business changes, your sheet may need to change too. Review it when you add registers, locations, payment methods, or new approval requirements. Avoid adding fields that staff do not understand or use.
Common Mistakes to Avoid
- Mixing cash and non-cash sales: Card and electronic payments should not be counted as physical cash.
- Treating deposits as expenses: Moving cash to a safe or bank changes its location; it does not necessarily represent a business expense.
- Leaving cash payouts undocumented: A missing receipt or explanation makes review harder.
- Changing numbers to eliminate a variance: Record what happened and investigate the difference.
- Using inconsistent counting methods: A standard procedure makes counts easier to compare.
- Relying on the sheet alone: Reconcile it with register reports, receipts, deposit records, and accounting records.
Choosing a Digital or Paper Template
A paper template can be quick to use at a till, especially where staff need to record information during a shift. It should be legible, easy to file, and protected from loss or damage.
A spreadsheet template can calculate expected cash and variances automatically. Use formulas carefully, protect cells containing formulas, and restrict access to prevent accidental changes. Keep a record of edits if the sheet is used for formal financial processes.
An accounting or point-of-sale system may already provide cash-close reports. In that case, check whether a separate sheet adds useful information—such as a second-person count, payout documentation, or shift handoff details—rather than duplicating records without purpose.
Conclusion
A daily cash sheet template helps turn cash handling into a clear, repeatable routine. By recording the opening balance, receipts, payouts, deposits, and closing count, a business can compare expected cash with what is actually on hand and follow up on discrepancies.
The best template is one that matches your workflow, uses clear categories, and is completed consistently. Pair it with supporting receipts, appropriate review, and secure recordkeeping, and it can become a useful part of your daily financial controls.
Sources
- U.S. Small Business Administration, Manage your finances — guidance on maintaining organized business financial records: sba.gov/business-guide/manage-your-business/manage-your-finances
- Internal Revenue Service, Publication 583: Starting a Business and Keeping Records — general guidance on business records and supporting documents: irs.gov/publications/p583
- Association of Certified Fraud Examiners, Fraud Prevention Check-Up — resources on internal controls and reducing fraud risk: acfe.com/fraud-prevention-check-up
This article provides general operational information, not tax, accounting, or legal advice. Follow the requirements that apply to your location and business.