--- title: "Daily Sales Log and Cash Drawer Reconciliation, Step by Step" description: "One row per day: gross sales, tax, cash and card, refunds, tips, paid-outs, expected vs counted cash and over or short. About ten minutes after closing." url: "https://mcc-solutionsnj.com/bookkeeping/guides/daily-sales-log-and-cash-reconciliation-template" --- Bookkeeping guide · Updated October 12, 2026 # Daily Sales Log and Cash Reconciliation: A Simple Method A daily sales log turns a pile of receipts and a messy drawer into data your bookkeeper can use. It takes about ten minutes after closing, and it makes the monthly books much faster. Below is a method you can adapt to a shop, a salon, a studio or a market stall. By [Matthew Coleman](/about), MCC Solutions **Quick answer.** Keep a daily sales log with one row per day: date, gross sales, sales tax, cash and card sales, other payment types, gift cards, refunds, tips, paid-outs, expected cash, counted cash and over or short. It takes about ten minutes after closing. Want this handled for you? Monthly bookkeeping, cleanup and year-end close for small businesses. Start with a free health check of your books. [Free health check](/bookkeeping/health-check)[Get a quote](/bookkeeping/#interest) **Related:** [Void vs delete a transaction](/bookkeeping/guides/voiding-vs-deleting-transactions) · [NJ 1099 contractor rule (ABC test)](/bookkeeping/guides/nj-independent-contractor-rule-abc-test-2026) · [Trial balance explained](/bookkeeping/guides/trial-balance-explained) **Free tools:** [What should I charge per hour?](/bookkeeping/freelance-hourly-rate-calculator) · [Depreciation schedule calculator](/bookkeeping/depreciation-calculator) Sell in more than one place? The [Sales-Channel Profit Tracker](/toolkits/sales-channel-profit-tracker) shows which channel makes money after fees, costs and booth fees. [![Intuit ProAdvisor Gold tier badge](/img/credentials/intuit-proadvisor-gold.png)](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77)Gold tier in Intuit's ProAdvisor program. [See my Intuit listing](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77) Keeping your own books? Tallyfinch does invoices, bank import and reports on your computer. [See Tallyfinch](/bookkeeping/mcc-books-downloadable-bookkeeping-software) ## The columns on the sheet Use one row per day with columns for date, gross sales, sales tax collected, cash sales, card sales, other payment types, gift card sales, gift cards redeemed, refunds, tips collected, paid-outs, expected cash, counted cash and over or short. Fewer columns are fine for a simple business. Add more for the things you really have. Keep a notes column for anything unusual, such as a large order, a price change or a closure. ## Closing steps in order First, run the register report for the day or total your sales list. Second, count the drawer, remove the starting float, and write the counted cash. Third, compute expected cash from the report, which is cash sales minus refunds minus paid-outs. Fourth, write the difference. Fifth, prepare the deposit and note the amount. Do this at the same time every day and have a second person verify if you can. ## Handle special cases Gift cards sold are liabilities, not sales, until redeemed in many cases, so keep them in a separate column. Deposits taken for future orders likewise belong in a separate line. Voids and refunds should be backed by receipts or a manager's initials. Sales tax collected needs its own column so that the amount is clearly separated from sales. Record paid-outs with a slip showing what was bought, and put the slip in the envelope with the day's papers. ## Match the bank When the deposit arrives at the bank, mark the day it covers on the sheet. For cards, match the processor's payout report to the days it covers, noting fees and timing. Monthly, total each column and compare the deposits to the bank statement. Unmatched items need a note. If you use a payment processor, the daily report there can serve as the card column. Check that the sums agree with the register. ## Hand off to the books At month end, give your bookkeeper the totals by column. A single journal entry can record sales, tax, tender types, fees and over or short. Over or short is recorded in a separate account, so patterns show up. If you use a point-of-sale system that syncs with your accounting software, still keep the daily check. Integrations can break without warning. ## What the sheet is good for A complete daily log helps with sales tax returns, loan applications, insurance claims, and tracking trends by weekday or season. It also protects your staff, because errors can be traced to a day and a process rather than a person. Say a studio opens with a starting float, rings up sales on a register, and the register report shows a total split between cash, cards and a gift card redemption. The owner counts the drawer, subtracts the float, and finds it is a small amount short of the cash sales. She writes the shortfall in the over or short column, notes that a customer was given the wrong change at noon, and moves on. That note matters. A short with an explanation is ordinary business. A short with no explanation, repeated daily, is a process problem worth fixing. ## Worked example with numbers Opening drawer $200. Cash sales $640, card sales $1,150, card tips $90. At close, the drawer holds $830. Expected cash is $200 + $640 = $840, so the drawer is $10 short. Deposit $630 ($830 minus the $200 float) and record the $10 shortage to cash over/short. Card sales and tips total $1,240, and the processor report should show the same before fees. Tips owed to staff are a liability, not income. ## Mistakes that cost money Counting the drawer once. Mixing tips with sales. Not logging voids. Depositing amounts that differ from the log. ## Check your work Weekly, total the log and compare to bank deposits and processor reports. ## Common questions **Is a paper log acceptable?** Yes, as long as it is consistent and retained. Scan the pages monthly. **What if the drawer is short often?** Look for process problems like change errors or unrecorded refunds, and consider counting the drawer at shift changes. **Do I need this if I use only card payments?** A simplified version still helps, tying processor reports to your sales. This guide is general information, not tax, legal or accounting advice. Rules, fees and due dates change; check with the IRS, the NJ Division of Taxation or a licensed professional for your situation. Let us handle it [### Monthly bookkeeping Categorizing, reconciling and monthly reports, with cleanup, payroll and NJ filings available. Bookkeeping →](/bookkeeping/) More guides - [Cryptocurrency Records for Business Owners](/bookkeeping/guides/cryptocurrency-records-for-business-owners) - [Online Marketplace Seller Records: Income and Expenses](/bookkeeping/guides/online-marketplace-seller-income-and-expense-records) - [Reconciling Form 1099-K to Your Sales Records](/bookkeeping/guides/reconciling-form-1099-k-to-your-sales-records) - [Grant Funds: Bookkeeping and Documentation Basics](/bookkeeping/guides/grant-funds-bookkeeping-and-documentation) Free tool - [Bookkeeping health check](/bookkeeping/health-check) [All guides](/bookkeeping/guides) Reach small business owners, freelancers and bookkeepers who read this guide: [advertise here](/advertise#bookkeeping). Do it yourself ### Month-End Close Workbook A real month-end close in one Excel file. It tells you when a rec does not tie, which variances still need an answer, and when the period is ready to lock. [See what's inside ($19)](/toolkits/month-end-close-workbook)14-day full refund Course: [Small Business Bookkeeping Basics](/courses/small-business-bookkeeping-basics) ($49) covers chart of accounts, reconciliations, the monthly close, payroll and 1099 basics for owners. It is training with a certificate of completion, not a credential. [![Cover of Bookkeeping Fundamentals (ebook) by Matthew Colt](/img/toolkits/bookkeeping-fundamentals-ebook/cover.webp)](/toolkits/bookkeeping-fundamentals-ebook) From the bookshelf ### Bookkeeping Fundamentals A college-level bookkeeping course, without the tuition. By Matthew Colt, $9.99 as an ebook (EPUB and PDF). [See the book](/toolkits/bookkeeping-fundamentals-ebook) [Read the first pages free](/toolkits/bookkeeping-fundamentals-ebook#free-starter) Tallyfinch ### Books you keep on your own computer Tallyfinch does invoices, bills, bank import, reconciliation and the main reports, in a file you own. $99 once, then $5 a month for updates; the app keeps working if you stop the plan. It does not do payroll or sales tax filing. The free download records up to 60 entries. [See Tallyfinch](/bookkeeping/mcc-books-downloadable-bookkeeping-software) [Download it free](/tools/pro/trial/mccBooks) [Compare the three apps](/software) ## Rather have us keep the books? Ask for a quote. [Get a Quote](/bookkeeping/#interest)[Call (908) 444-6373](tel:+19084446373)