End of Day Sales Report Template: Fields and How to Use It

An end-of-day sales report template is a reusable form for recording a business’s daily sales, discounts, refunds, payment totals, and closing notes. Use the blank template below to create a consistent daily record, then compare its totals with your register, payment records, and cash count.

What an End-of-Day Sales Report Does

An end-of-day sales report summarizes activity for a defined business day. It helps an owner or manager see what was sold, how customers paid, and whether the closing figures agree with the records used to process transactions. The report can be completed by a cashier, shift lead, or other person responsible for closing, depending on the business’s procedures.

It is a practical operating record, not necessarily a complete accounting statement. A sales report may show sales before and after discounts, refunds, taxes collected, and payment methods, but those figures do not automatically answer every accounting or tax question. Businesses may define a “business day” by store hours, a register’s closeout period, or another internal cutoff, so the chosen period should be stated clearly.

Regular reports also make it easier to compare days and spot questions that merit follow-up, such as an unusually high refund total or a difference between expected and counted cash. A report does not explain the cause by itself; it gives the team a consistent place to record facts and investigate differences.

End-of-Day Sales Report Template

Fields to Include and What They Mean

Keep the report detailed enough to be useful but not so complex that staff skip fields or enter the same information in several places. At a minimum, identify the date and shift, name the person preparing the report, and record the sales and payment totals. If more than one register or location is involved, give each its own identifier or explain how the figures were combined.

• Sales before adjustments: The value of sales before subtracting discounts and refunds, according to the business’s reporting convention.
• Discounts and refunds: Record these separately so a reader can distinguish price reductions from returned transactions. If relevant, add a short reason or reference number.
• Net sales: State how this figure is calculated. One common operational formula is sales before adjustments minus discounts and refunds, but systems and business definitions can differ.
• Taxes, tips, and other amounts: Keep separately tracked amounts distinct from sales when the report needs to reconcile them. Do not assume that every register uses the same labels or treatment.
• Payment breakdown: Summarize tender by type, such as cash and non-cash payments, using categories that match the records available to the business.
• Cash closeout: Record the starting float, cash movements, expected cash, counted cash, and any difference. Explain whether cash removed during the day was deposited, transferred, or handled another way.
• Notes and review: Write concise, factual notes about voids, equipment issues, unusual transactions, or unresolved differences. A reviewer’s name and date help show that the report was checked.

How to Complete the Report at Closing

A consistent closing routine reduces missed fields and makes one day’s report easier to compare with another’s. Follow the business’s established process if it differs from this general sequence, and make sure the report covers the same date and cutoff as the underlying transaction records.

1. Set the reporting period. Enter the business date, shift hours, location, and register or terminal. If the business day crosses midnight, use the organization’s stated business-date rule rather than guessing from the calendar date.
2. Collect the source totals. Obtain the register or transaction summary and the records needed for cash and non-cash payments. Avoid estimating a figure when a source record is available.
3. Enter sales adjustments. Record discounts, refunds, and returns in their intended categories. Check that canceled or voided transactions have not been treated as completed sales.
4. Reconcile payment totals. Compare recorded payment amounts with the applicable closeout information. Keep tender types separate when the records report them separately.
5. Count and compare cash. Apply the business’s cash-count procedure, account for the opening float and documented movements, and write down the counted amount. Do not silently change an expected figure to make it match.
6. Explain exceptions and review. Note any unresolved difference or unusual event with enough detail for a later follow-up. Submit or store the report according to the workplace’s normal process.

Understanding the Totals and Reconciliation

Several figures that look similar answer different questions. Sales describe completed transactions under the reporting rules; payment totals describe how amounts were tendered or recorded; cash on hand is a physical count. These amounts may not be identical because taxes, tips, refunds, payment timing, or other separately handled items can affect how totals appear. The report should make its labels and calculation rules clear rather than treating every total as interchangeable.

For a simple sales summary, a business may calculate net sales as sales before adjustments less discounts and refunds. For example, if a day shows 2,000 in sales before adjustments, 100 in discounts, and 50 in refunds, that formula gives 1,850 in net sales. This arithmetic is only an example of a stated reporting convention; the report should follow the definitions used by the business’s records.

Cash reconciliation is a separate check. A basic expected-cash calculation may start with the opening float, add cash received, and subtract documented cash refunds or removals. Compare that expected amount with the physical count and record the difference as over or short. If the business uses a different procedure, use its approved method and make the components visible. A difference is a prompt to review the records, not proof by itself that someone made an error.

Filled-In Sample

Sample only — all details below are fictional. This compact example illustrates how a report might communicate figures; it is not a universal accounting format.

In this illustration, the three payment amounts total 2,018, matching the example’s net sales plus separately recorded tax and tips. The example assumes those are the only amounts included and that no other adjustments apply. Actual reports may use different categories, and the figures should only be compared when their definitions and reporting periods match.

Adapting the Template to Different Businesses

A small shop may need one report per day, while a business with multiple tills or departments may need a separate closeout for each register and a combined summary. A service business might track appointments, service categories, deposits, or cancellations rather than product quantities. A business that sells through several channels can add rows for each channel, provided the categories do not double-count transactions already included in a general total.

For a busy operation, include a reference to the source report or register closeout instead of copying every transaction into the daily form. For a simple operation, a short product or category table may be enough to show what drove the day’s sales. Decide which details are genuinely useful for review, and keep the same definitions from day to day. If a field is not relevant, mark it not applicable or remove it from the working version rather than leaving staff uncertain about whether they missed it.

Common Reporting Problems to Avoid

• Mixing dates or shifts: A closeout that combines different reporting periods without saying so can make comparisons misleading. Write down the cutoff and label any combined report.
• Combining discounts and refunds: These adjustments have different causes. Separate entries make it easier to understand the day’s activity and find a transaction when a question arises.
• Confusing sales with money received: Taxes, tips, payment timing, and refunds can make the amounts differ. Label each total and preserve separate categories where needed.
• Counting the same transaction twice: When information comes from more than one register or sales channel, define which summary is the source of each figure before adding totals together.
• Leaving unexplained differences: Record the amount and known context, even if the cause is not yet clear. Avoid changing source figures merely to force agreement.
• Using vague notes: “Problem” is less useful than a concise description such as “cash count is 10 below expected; recount requested.” Notes should stick to observable facts and the action taken.
• Changing the template without updating instructions: If a field or formula changes, tell the people who prepare and review reports so that old and new figures are not compared as if they mean the same thing.

Choosing a Format and Keeping Reports Useful

A printed sheet works well when the closeout is completed at a physical register or needs a handwritten cash count. A spreadsheet or digital form can make repeated entry and summaries easier, but it should still show the reporting period, calculation definitions, and source of each total. The best format is one staff can complete consistently and that a manager can review without guessing what a field means.

Set a clear owner for preparation and a separate review step where practical. Store reports in a predictable order, such as by business date and location, and retain supporting closeout records according to the organization’s recordkeeping process. Limit access to sensitive transaction details to people who need them, and avoid putting unnecessary customer information in a general daily summary. If the figures affect tax or accounting treatment, ask a qualified professional how they should be classified or retained.

Frequently Asked Questions

What should an end-of-day sales report include?
A useful report identifies the date, location or shift, preparer, sales and adjustments, payment breakdown, cash closeout, and notes for exceptions. Add fields such as product category or transaction count when they help answer a real operating question.

How do you calculate net sales in a daily report?
State the definition used by your business. A common simple calculation is sales before adjustments minus discounts and refunds, but reporting systems may define or display totals differently. Keep taxes, tips, and other separately tracked amounts clearly labeled.

Is a sales report the same as a cash reconciliation?
No. A sales report summarizes transaction activity, while a cash reconciliation compares expected cash with a physical count after accounting for documented cash movements. One report may include both sections, but the figures serve different purposes.

How often should a sales report be completed?
Complete it at the end of each reporting period the business needs to monitor, commonly a daily close or a specific shift. Use consistent cutoffs so that reports can be compared; the right schedule depends on how the business operates.

What should I do if the totals do not match?
Record the difference, check the reporting period and source totals, and review adjustments and documented cash movements. Follow the organization’s escalation procedure if it remains unresolved. Do not alter source figures just to make totals agree.

Can I use this template for a service business?
Yes. Replace product fields with service categories, appointments, or other relevant units, and retain the date, sales adjustments, payment breakdown, and closeout notes. Use labels that match the business’s actual records.

Related

• Electronic Rent Receipt Template: What to Include
• Electrical Service Invoice Template: What to Include
• Election Flyer Template: What to Include and How to Use It