Short answer
A daily sales report summarizes one day's selling. For a sales rep, it lists activity (calls, emails, conversations, meetings booked), pipeline changes, deals won or lost, tomorrow's priorities and blockers. For a small business, it records gross sales, discounts and returns, net sales, sales tax, number of transactions, average sale, payments by method and a cash count. Both should compare the day with a target.
- Pick the right report: rep activity for sales teams, a sales summary for a shop, counter or order desk.
- Show ratios, not just counts: conversations per dial and meetings per conversation say where to coach.
- Net sales = gross sales minus discounts and returns; sales tax collected isn't income.
- IRS Publication 583 shows a sample daily summary of cash receipts that reconciles the register each night.
- Keep the supporting records (register tapes, deposit slips, invoices) at least as long as the IRS can audit the return, generally three years.
On this page
This page is for salespeople and sales managers who report on each day's work, and for small business owners and managers who close out each day's takings. It gives you six templates in a copyable format, a filled-in sample of each kind of report, the formulas behind the numbers and the record-keeping rules that apply to a business's daily sales records.
Which daily sales report do you need?
| You are | You need | It answers |
|---|---|---|
| A B2B sales rep | A rep activity report | What did I do today, what moved, what's next? |
| A sales manager | A team roll-up | Who needs help, and where in the funnel? |
| A shop, restaurant or counter business | A daily sales summary and cash count | What did we sell, and does the cash match? |
| A business that sells on orders and invoices | An order-based daily sales report | What did we book, invoice and collect? |
Daily reports work best for things that change daily: activity, orders and cash. Outcomes in a long B2B sales cycle (deals won, revenue) move slowly, so track them daily but judge them weekly or monthly. The sales report template covers the weekly and monthly versions.
Daily sales report for a sales rep
Rep: [name] Date: [date] ACTIVITY Calls: [number] Conversations: [number] Meetings booked: [number] Emails sent: [number] LinkedIn messages: [number] Meetings held: [number] PIPELINE New opportunities: [number], $[value] ([account names]) Moved forward: [account], [old stage] to [new stage], $[value] Won: [account], $[value] Lost: [account], $[value], reason: [why] TOMORROW Top 3 priorities: 1. [account and action] 2. [account and action] 3. [account and action] BLOCKERS [What you need, from whom, by when] ONE THING I LEARNED [An objection, a competitor move, a buying signal]
Keep it short enough to write in five minutes. The two sections managers read first are "blockers" and "one thing I learned", because those are where they can help or spot a pattern.
Sample: a solar EPC rep's daily report
Illustrative example. The company, people and figures are fictional, to show the method.
Lena sells commercial rooftop solar for Brightfield Solar Builders (brightfield.example), a solar EPC firm.
Activity: 42 calls, 9 conversations, 3 meetings booked. 18 emails, 6 LinkedIn messages. 1 site survey held (Harlan Plastics, Mesa). Pipeline: New opportunity: Harlan Plastics, 600 kW rooftop, $850,000. Moved forward: Copperline Foods, proposal sent, $1.1 million. Lost: Desert Ridge Storage, $400,000, chose a competitor's lower price. Tomorrow: 1. Call Copperline's CFO to walk through the proposal. 2. Prepare the survey report for Harlan. 3. Research the 20 West Valley warehouses on my list. Blockers: Need the interconnection timeline from engineering for Copperline by Thursday. Learned: Two prospects asked about battery storage unprompted. Worth a line in the opener?
Her ratios: 9 conversations from 42 calls is 21%, and 3 meetings from 9 conversations is 33%. Those two numbers matter more than the 42, because they say whether the list and the opener are working.
The spreadsheet version
If reps log activity in a sheet rather than a CRM, use one row per rep per day:
A: Date B: Rep C: Calls D: Conversations E: Meetings booked F: Emails G: Meetings held H: New pipeline ($) I: Won ($) J: Conversation rate =IFERROR(D2/C2,0) K: Meeting rate =IFERROR(E2/D2,0) L: Week to date meetings for this rep =SUMIFS(E:E,B:B,B2,A:A,">="&(A2-WEEKDAY(A2,2)+1),A:A,"<="&A2) Format J and K as percentages.
Daily team roll-up for sales managers
Date: [date] Team: [name] Rep | Calls | Conversations | Meetings booked | Pipeline added | Conv. rate | Meeting rate [name] | | | | $ | % | % Total | | | | $ | % | % Week to date: [meetings booked] vs target [number] Deals won today: [list] Deals at risk: [list] Blockers raised: [list, with owner]
Illustrative example. Lena's manager runs a team of four:
| Rep | Calls | Conversations | Meetings booked | Pipeline added | Conversation rate | Meeting rate |
|---|---|---|---|---|---|---|
| Lena | 42 | 9 | 3 | $850,000 | 21% | 33% |
| Marco | 55 | 8 | 1 | $0 | 15% | 13% |
| Priya | 30 | 7 | 2 | $1,200,000 | 23% | 29% |
| Dev | 48 | 12 | 2 | $300,000 | 25% | 17% |
| Team | 175 | 36 | 8 | $2,350,000 | 21% | 22% |
Marco made the most calls and booked the fewest meetings. His conversation rate is low (15%) and his meeting rate is the lowest on the team (13%), so the problem is both his list and his ask, not his effort. Dev reaches people well but converts few conversations, which points at the ask alone. Neither shows up in a report that only counts calls.
When a rep's conversation rate is low, the list is usually the cause: wrong companies or wrong people. Bebop builds lists from a plain-language description of the companies you want and explains why each one fits, which is a quicker fix than more calls.
Daily sales report for a small business
For a shop, café, salon or any business that takes payment at a counter. Most point-of-sale systems print most of these numbers in an end-of-day report; this summary puts them on one page with the comparisons that matter.
Business: [name] Date: [date] Prepared by: [name] SALES Gross sales: $[ ] Less discounts: $[ ] Less returns and refunds: $[ ] Net sales: $[ ] Sales tax collected: $[ ] (owed to the state; not income) Total collected: $[ ] TRANSACTIONS Number of transactions: [ ] Average sale (net sales / transactions): $[ ] Items sold: [ ] PAYMENTS Cash: $[ ] Card: $[ ] Other (gift cards, invoices, apps): $[ ] COMPARISON Daily target: $[ ] Net sales as % of target: [ ]% Same day last week: $[ ] Change: [ ]% Month to date: $[ ] Month target to date: $[ ] NOTES [Weather, events, staffing, stock-outs, anything that explains the day]
The formulas: net sales = gross sales − discounts − returns. Average sale = net sales ÷ transactions. Change vs last week = (today − same day last week) ÷ same day last week. Keep sales tax out of net sales: IRS Publication 583 removes it when it totals monthly net sales, because the tax is passed to the state and isn't income.
The daily cash count
A daily sales report isn't finished until the cash agrees with the sales. IRS Publication 583 (revised December 2024) includes a sample "Daily Summary of Cash Receipts" that does this. Here is its logic, using the IRS's own sample figures:
| Line | IRS sample |
|---|---|
| Cash sales | $263.60 |
| Sales tax | $4.20 |
| Total receipts | $267.80 |
| Cash in register (coins $23.75, bills $143.00, checks $134.05) | $300.80 |
| Add petty cash slips | $17.00 |
| Total cash | $317.80 |
| Less change and petty cash fund | $50.00 |
| Total cash receipts | $267.80 |
Total cash receipts ($267.80) matches total receipts ($267.80), so the register balances. If they differ, record the difference as cash over or short, and look into anything beyond small change before the next shift.
Date: [date] Register: [number] Counted by: [name] Checked by: [name] Cash sales (from register report): $[A] Sales tax on cash sales: $[B] Total cash receipts expected (A + B): $[C] Counted in register: coins $[ ] + bills $[ ] + checks $[ ] = $[D] Add petty cash slips (receipts for cash paid out): $[E] Less opening change and petty cash fund: $[F] Actual cash receipts (D + E - F): $[G] Over / (short) (G - C): $[ ] Deposit amount: $[ ] Deposit slip number: [ ]
Order-based daily sales report
For businesses that sell on orders and invoices rather than at a till: distributors, agencies, manufacturers and service firms.
Date: [date] ORDERS BOOKED TODAY Orders: [number] Gross order value: $[ ] Less discounts: $[ ] Less credits: $[ ] Net sales booked: $[ ] Cost of goods: $[ ] Gross profit: $[ ] Gross margin: [ ]% Average order value: $[ ] INVOICED AND COLLECTED Invoiced today: $[ ] Payments received: $[ ] Overdue invoices over 30 days: $[ ] ([number] customers) VS TARGET Daily target: $[ ] ([ ]%) Month to date: $[ ] vs $[ ] ([ ]%) NEW CUSTOMERS, LOST CUSTOMERS, LARGE ORDERS [list]
Sample: a print management company's day
Illustrative example. A print management company buys printing from suppliers and resells it to businesses with many locations.
| Line | Amount |
|---|---|
| Orders booked | 37 |
| Gross order value | $48,620 |
| Less discounts | $1,240 |
| Less reprint credits | $380 |
| Net sales booked | $47,000 |
| Supplier cost | $36,190 |
| Gross profit | $10,810 (23.0% margin) |
| Average order value | $1,270 ($47,000 ÷ 37) |
| Invoiced today | $52,300 |
| Payments received | $61,450 |
| Daily target | $50,000 (94% reached) |
| Same day last week | $44,200 (up 6.3%) |
| Month to date | $612,000 vs $650,000 target to date (94%) |
What the owner reads from it: the day was slightly under target, but margin held at 23% and collections ran ahead of invoicing, so cash is fine. The month-to-date gap ($38,000) is the number to act on.
Records to keep
For a business, the daily sales report is part of its tax records. IRS Publication 583 says to keep supporting documents that show the amounts and sources of gross receipts, and lists cash register tapes, bank deposit slips, receipt books, invoices, credit card charge slips and Forms 1099-MISC and 1099-NEC. Keep records until the period of limitations for the return runs out: generally three years, six years if you left out income worth more than 25% of the gross income shown on the return, and at least four years for employment tax records. A dated report filed with the day's tapes and deposit slip makes that easy.
Mistakes to avoid
- Counting activity without ratios. Fifty calls and one meeting is a problem a raw count hides.
- Reporting outcomes daily in a long sales cycle. Judge revenue weekly or monthly; use the daily report for activity and pipeline movement.
- Leaving sales tax in net sales. It inflates revenue and the tax isn't yours.
- Skipping the cash count. A shortage found a week later is much harder to explain.
- A report nobody answers. If blockers sit unread, reps stop writing them. Managers should reply to every blocker within a day.
Checklist
- You've picked the right report for your business or role.
- Every count has a comparison: a target, yesterday or the same day last week.
- Rep reports include conversation and meeting rates, blockers and tomorrow's top three.
- Small business reports show gross sales, discounts, returns, net sales and sales tax separately.
- The cash count reconciles, and any over or short is recorded.
- Register tapes, deposit slips and invoices are filed with the day's report.
Next step: roll your daily numbers into a weekly and monthly view with the sales report template.
Sources
- Publication 583, Starting a Business and Keeping Records (Rev. December 2024), Internal Revenue Service, December 2024
- How long should I keep records?, Internal Revenue Service, updated 30 June 2026, accessed 26 October 2026
Written by the Bebop team at Blackpearl Group. Last updated .
Questions people ask
What should be included in a daily sales report?
For a sales rep: calls, emails, conversations and meetings booked, pipeline added or moved, deals won or lost, tomorrow's top priorities and any blockers. For a small business: gross sales, discounts, returns, net sales, sales tax collected, number of transactions, average sale, payments by method and a cash reconciliation. Both should compare the day with a target or the same day last week.
How do I write a daily sales report?
Use the same template every day and fill it in at the end of the day, in five to ten minutes. Pull the numbers from your CRM or point-of-sale system, add the ratios or comparisons (conversion rates, percent of target, change from last week), then write a line on blockers and what you'll do tomorrow. Send it to the same person at the same time.
What is the format of a daily sales report?
A header with the date and who prepared it, then sections in a fixed order. A rep report runs activity, pipeline, tomorrow's priorities and blockers. A small business report runs sales (gross to net), transactions, payments by method, comparison with target and notes, followed by the cash count. A one-page email, a spreadsheet row or a short form all work.
How do you calculate net sales for a daily sales report?
Start with gross sales, then subtract discounts and returns or refunds. Sales tax collected is kept separate, because it's owed to the state rather than earned; IRS Publication 583 removes it when it totals monthly net sales. For example, $5,000 of gross sales with $150 of discounts and $90 of returns gives $4,760 of net sales.
How long should a business keep daily sales records?
IRS Publication 583 says to keep records until the period of limitations for the tax return runs out. That's generally three years, six if you left out income worth more than 25% of the gross income on the return, and at least four years for employment tax records. Keep the daily report with its supporting documents, such as register tapes, deposit slips, invoices and card slips.
Are daily sales reports worth it for B2B sales teams?
Yes, if they're short and someone acts on them. Activity and pipeline movement change daily, so a five-minute report helps managers spot a falling conversion rate or a stuck deal early. Revenue in a long sales cycle doesn't change daily, so judge it weekly or monthly. If nobody replies to the blockers, reps will stop writing the report honestly.