Retail Bookkeeping in QuickBooks Online: End-of-Day Reports and Daily Sales

A cash register or point-of-sale (POS) system is not a bookkeeping system. It tells you what you sold today. It doesn’t tell you whether the money made it to the bank, what you owe in sales tax, or whether the business is actually making a profit.

The bridge between the two is a simple routine: close out the register the same way every day, then record a summary of your sales in QuickBooks Online, daily, weekly or monthly, depending on how often you want updated financials. Done consistently, it keeps your books current, catches cash shortages while they’re still easy to trace, and makes your bank reconciliation and sales tax return almost automatic.

This guide walks through both halves: the end-of-day closing procedure at the store, and how to record the day’s sales in QuickBooks Online.

Step 1: Close out the register the same way every day

Your two most valuable liquid assets are cash and inventory, and the end-of-day close is how you protect the cash. Set a written procedure and have every manager or cashier follow it every time the store closes.

Run the end-of-day report

Every POS has a closing report, though the name varies: Z report, end-of-day report, close-out or daily summary. (The terms come from old cash registers: an X report is a mid-day snapshot that doesn’t reset anything; a Z report closes the day and resets the totals.) The closing report should show:

  • Gross sales, discounts, returns and net sales
  • Taxable and non-taxable sales, and sales tax collected
  • Payments by type: cash, each card brand, gift cards, store credit, mobile payments
  • Tips, if you take them
  • Payouts and paid-ins (cash taken out of or put into the drawer)

What your POS calls the report

Here’s the report to pull from some of the most popular systems:

POS system Report to use Where to find it
Square Sales Summary Square Dashboard: Reports > Sales summary
Shopify POS Finances summary Shopify admin: Analytics > Reports > Finances > Summary (filter by the POS channel)
Clover Sales Report (Sales Overview) Clover Web Dashboard: Reporting > Sales Report
Toast Sales Summary (or the printed Z Report) Toast Web: Reports > Sales > Sales summary
Lightspeed Retail (X-Series) Register closure report Reports > Register closures
Lightspeed Retail (S-Series, formerly ShopKeep) Z Report Register Shift Report in the POS app

POS companies rename and redesign their reports from time to time, so if you can’t find one, search your POS help center for “sales summary” or “end of day report.”

If you take cash: count the drawer

If your store accepts cash, the drawer needs to be counted and recorded every day. Count the cash by hand at the end of each shift or at closing, before looking at what the POS says it should be. Then:

  1. Start with the opening cash (the drawer’s starting float, for example $200).
  2. Add cash sales from the closing report.
  3. Subtract any payouts, such as cash used to buy supplies or make change.
  4. Compare that expected total to the actual count. The difference is your cash over or short.
  5. Set aside the starting float for tomorrow and prepare the rest as the bank deposit.

Example: counting the drawer. First, count what’s actually in the drawer, bill by bill and coin by coin:

Bills and coins How many Amount
$20 bills 15 $300.00
$10 bills 6 $60.00
$5 bills 9 $45.00
$1 bills 27 $27.00
Quarters 16 $4.00
Dimes 12 $1.20
Nickels 9 $0.45
Pennies 60 $0.60
Total cash counted $438.25

Then compare it to what should be there:

Daily cash reconciliation Amount
Opening cash (starting float) $200.00
Plus cash sales (from the closing report) $240.25
Minus payouts (from the closing report or payout slips) $0.00
Expected cash in the drawer $440.25
Actual cash counted $438.25
Cash over or (short) ($2.00)
Minus starting float kept for tomorrow ($200.00)
Cash to deposit $238.25

In this example the drawer is $2 short, and $238.25 goes to the bank. If $18.75 had been paid out of the drawer for supplies, you’d subtract it on the payouts line, and the expected cash would be $421.50.

Small differences happen. A pattern of shortages on the same shift is a signal to look closer.

Document payouts

Every time cash leaves the drawer for a store expense, record it. Many POS systems let you enter a payout (sometimes called a “paid out” or cash movement) right in the register, so it shows up on the closing report and is already subtracted from expected cash. If yours does, use it. Either way, keep the receipt or write a payout slip with the date, amount, what it was for and who took it. Unrecorded payouts are the most common reason the cash never balances, and the expense never makes it into the books.

If you take cash: keep a daily cash count sheet

Your POS closing report already shows the day’s sales, sales tax and payments by type. What it can’t show is what’s actually in the drawer. If you only take cards, the closing report is all you need. If you take cash, add a one-page cash count sheet each day: the cash count, payouts, over/short and the deposit amount, signed by whoever closed. Keep it with that day’s closing report and payout receipts. Together they’re what you’ll use to record sales in QuickBooks.

My Retail Daily Cash and Sales Kit includes a printable daily cash count sheet, a monthly log for your POS totals and a worksheet that builds the QuickBooks journal entry for you.

Step 2: Record your sales in QuickBooks Online

You don’t need to enter every sale. One summary entry, built from your POS closing reports (and your cash count sheets, if you take cash), gives you accurate books. How often you enter it is up to you: daily if you want to watch sales and cash closely, weekly, or monthly if you only need financials at month end. Most small shops do fine monthly, as long as the closing reports and cash counts are done every day so the totals are there when you need them.

Set up your accounts once

  • Income accounts: Taxable Sales, Non-Taxable Sales, and Discounts & Returns (a negative income account). Add more if you want to track categories, such as Merchandise and Services.
  • Clearing accounts (Other Current Asset type): one for cash waiting to be deposited, and one for each card processor, such as “Square Clearing.” Money sits here until it shows up in the bank.
  • Sales Tax Payable – POS (Other Current Liability type) for sales tax collected.
  • Gift Card Liability (Other Current Liability type), if you sell gift cards.
  • Cash Over/Short (expense) and Merchant Fees (expense).

Record your sales as a journal entry

A journal entry is the cleanest way to record a sales summary in QuickBooks Online, especially when your POS calculates the sales tax. Here’s an example day:

Account Debit Credit
Cash Clearing (cash counted) $238.25
Card Clearing (card sales) $1,000.00
Cash Over/Short $2.00
Discounts & Returns $50.00
Taxable Sales $1,000.00
Non-Taxable Sales $200.00
Sales Tax Payable – POS $90.25
Total $1,290.25 $1,290.25

In this example the store sold $1,000 of taxable goods and $200 of non-taxable goods, gave $50 in discounts, and collected $90.25 in sales tax. The drawer came up $2 short.

If cash was paid out of the drawer for a store expense, add a debit line for that expense (such as Supplies) and reduce the cash line by the same amount.

The example shows one day, but the entry works the same for a week or a month: just total the closing reports and cash counts for the period, or run the POS report for the whole week or month. To save time, create the entry once with your usual accounts, then use Make recurring and choose the Unscheduled type. Each time you record sales, open the template, fill in the amounts and save.

Match the deposits

When the money reaches the bank, record the deposit from the clearing account:

  • Cash: the bank deposit moves money from Cash Clearing to your bank account.
  • Cards: processors usually deposit your sales minus their fees. If $1,000 of card sales arrives as $971, record the deposit as $1,000 from Card Clearing and a $29 line to Merchant Fees.

When everything has been deposited, each clearing account should be back to zero. A balance that won’t go away means a deposit is missing or an entry is wrong, and that’s exactly what you want to catch early.

Sales tax and gift cards

  • Sales tax isn’t income. It’s money you’re holding for the state. Recording it to Sales Tax Payable – POS lets you see what you owe at any time on the Balance Sheet. When you pay your sales tax return, record the payment against that account. Your POS sales tax report is usually what you’ll use to prepare the return.
  • Gift cards aren’t income when you sell them, only when a customer uses them. Record gift card sales to Gift Card Liability, and record redemptions as a payment that reduces it.

What about POS apps that sync with QuickBooks?

Many POS systems, including Square, Shopify POS, Clover and Lightspeed, offer a direct connection to QuickBooks Online. They can save time, but they don’t all post the same way. Some send every individual sale, which clutters your books with hundreds of transactions; others record card sales at the full amount and leave the fees for you to sort out; and a sync that fails quietly can leave days missing.

If you use a sync, choose the option to post a daily summary rather than each sale if it offers one, check that card fees and sales tax land in the right accounts, and reconcile your clearing and bank accounts every month. If the sync is causing more cleanup than it saves, the journal entry above is a reliable fallback.

Common mistakes

  • Recording bank deposits as sales. Card deposits are net of fees and arrive days later. Record sales from the closing report and match the deposits separately.
  • Counting sales tax or gift card sales as income. Both are money you owe, not money you earned.
  • Skipping the cash count. Without it, shortages turn into a mystery months later.
  • Losing payout receipts. The cash is gone, and the expense never gets recorded.
  • Letting clearing accounts grow. A clearing account with an old balance is a sign something didn’t get deposited or recorded.

Want help setting it up?

I’ve set up end-of-day procedures and QuickBooks bookkeeping for retail stores, from single shops to inventory spread across multiple warehouses. If you want your daily close to flow straight into QuickBooks, a QuickBooks Check-Up will review your setup, or QuickBooks training can teach your team the routine. You can also book a free call.

Questions people ask

What is a Z report?

A Z report is the end-of-day report from your cash register or POS. It totals the day’s sales, sales tax and payments by type, and resets the totals for the next day. An X report shows the same information mid-day without resetting anything.

Should I record every sale in QuickBooks?

No. For most retail stores, one summary entry taken from the POS closing reports is enough for accurate books, whether you record it daily, weekly or monthly. The POS keeps the detail of each sale.

How do I record credit card fees in QuickBooks?

Record the full card sales to a clearing account when you enter the day’s sales. When the processor’s deposit arrives, record it from the clearing account and add the fee as a separate line to a Merchant Fees expense account.

Where does cash over or short go?

Record it to a Cash Over/Short expense account. Being short increases the expense; being over reduces it.

Are gift card sales income?

Not when you sell them. A gift card sale is a liability until the customer uses it. The income is recorded when the card is redeemed.