Skip to content 
Your Square dashboard says you sold $5,000 on Saturday. On Monday, $5,216 lands in your bank. Wait, more than you sold? Then Tuesday’s deposit is short. By the end of the month, nothing in QuickBooks matches anything, and you have stopped trying.
You are not doing anything wrong. Your POS and your bank are measuring two different things. The POS counts what you sold. The bank counts what the processor paid you, after fees, refunds, tips, taxes, and a delay of a day or three.
House of Bookkeepers is an Intuit-certified bookkeeping team serving 17,500 clients across 131 countries, including restaurants, retailers, and online stores. This post explains why POS sales never match bank deposits, and walks through the system we use to fix it: one clearing account and one summary journal entry per day.
Why Your POS Sales Never Match Your Bank Deposits
Your sales and your deposits will almost never match line for line, and that is normal. A deposit is not a sale. It is a bundle of sales, minus a stack of things that were taken out along the way.
Here is what sits between the two numbers.
Processing fees. Square, Toast, and Shopify Payments take their fees before the money reaches you. A $10,000 day might deposit $9,700.
Batching. Processors group sales into payouts. Friday, Saturday, and Sunday sales often arrive as one Monday deposit. Late-night sales can roll into the next day’s batch.
Refunds. A refund can come out of a later payout than the original sale. So Tuesday’s deposit drops for a sale you made last week.
Tips. Card tips flow through the processor, but they belong to your staff. They are not your revenue.
Sales tax. You collect it from customers, but it belongs to the state. It is in your deposit, but it is not income.
Gift cards. A gift card sold today is cash in, but no sale yet. A gift card redeemed today is a sale, but no cash in.
Cash. Cash sales show up in your POS report but never in the processor deposit.
Chargebacks and holds. Disputes, dispute fees, and reserves can pull money out of a payout with little warning.
That is why the deposit can be larger than gross sales on one day and smaller the next. Tax and tips push it up. Fees, refunds, and gift card redemptions push it down.
The Mistake That Doubles Your Income
Before the fix, here is the most common problem we see in a new client’s file.
The POS integration sends every sale into QuickBooks as income. Then the bank feed brings in the deposit, and someone clicks “Add” and categorizes it as sales too. Now the same money is counted twice. Revenue looks great. The tax bill that follows does not.
The rule is simple. Income gets recorded once, from the POS side. The bank deposit only moves money from a holding account into the bank. It is never income on its own.
Why Not Sync Every Single Transaction?
Many POS systems can push every sale into QuickBooks one by one. For a coffee shop doing 300 tickets a day, that is about 9,000 entries a month.
That creates three problems.
Nothing matches. Your bank shows one deposit. QuickBooks shows 300 sales. Matching them by hand is slow and error-prone.
The file gets heavy. Thousands of tiny entries, and often thousands of one-time customer names, clutter every report.
Errors hide. When a sync breaks for a day, the gap is buried in a sea of small numbers.
A daily summary fixes all three. One entry per day captures every sale, fee, tip, tax, and refund in totals. Your POS keeps the item-level detail. QuickBooks gets the accounting.
The Clearing Account Method, Step by Step
This is the framework we set up for POS-heavy clients. It works the same way for Square, Toast, and Shopify Payments.
Step one. Create a clearing account for each processor. In your chart of accounts, add a bank-type account called “Square Clearing” (or Toast Clearing, or Shopify Clearing). This is a holding spot for money the processor owes you but has not paid yet.
Step two. Set up the accounts the entry needs. You need income accounts for sales, contra accounts for discounts and refunds, an expense account for merchant fees, and liability accounts for sales tax payable, tips payable, and gift card liability.
Step three. Pull the daily summary report. Every major POS has an end-of-day sales summary. It shows gross sales, discounts, refunds, tax, tips, gift card activity, and payment types.
Step four. Post one journal entry for the day. The full sales picture goes in, and the net amount the processor owes you goes to the clearing account. A worked example follows.
Step five. Match deposits to the clearing account. When the payout hits your bank, the bank feed transaction is categorized as a transfer from the clearing account. Not as income.
Step six. Reconcile the clearing account at month end. Its balance should equal the payouts still in transit. If Saturday’s and Sunday’s sales are paid on Monday, the March 31 balance is whatever has not landed yet.
A Worked Example
Here is one Saturday at a small restaurant using Square. The numbers are hypothetical and round, so you can follow the logic.
| Saturday, from the POS daily summary | Amount |
| Gross sales | $5,000 |
| Discounts | ($200) |
| Refunds | ($100) |
| Net sales | $4,700 |
| Sales tax collected | $376 |
| Card tips | $600 |
| Gift cards sold | $250 |
| Total collected | $5,926 |
| Paid in cash | ($400) |
| Paid with gift cards (redeemed) | ($150) |
| Card payments through Square | $5,376 |
| Processing fees | ($160) |
| Net payout owed by Square | $5,216 |
The deposit math: $4,700 in net sales, plus $376 in tax, $600 in tips, and $250 in gift cards sold, comes to $5,926 collected. Take out $400 paid in cash and $150 paid with gift cards, and the card total is $5,376. Subtract $160 in fees, and the processor owes you $5,216.
That is how a $5,000 sales day turns into a $5,216 deposit.
Here is the journal entry for the day.
| Account | Debit | Credit |
| Square Clearing | $5,216 | |
| Merchant Fees (expense) | $160 | |
| Cash on Hand | $400 | |
| Gift Card Liability (redemptions) | $150 | |
| Sales Discounts | $200 | |
| Sales Refunds | $100 | |
| Gross Sales | $5,000 | |
| Sales Tax Payable | $376 | |
| Tips Payable | $600 | |
| Gift Card Liability (new cards sold) | $250 | |
| Totals | $6,226 | $6,226 |
Debits and credits both total $6,226, so the entry balances.
On Monday, the $5,216 payout lands. In the bank feed, it is recorded as a transfer from Square Clearing to your checking account. Square Clearing goes back to zero for that day, and no income is counted twice.
Later, when you pay out tips through payroll, the tips payable account clears. When you file sales tax, the sales tax payable account clears. Each liability empties when the money actually leaves.
Platform Notes: Square, Toast, and Shopify
The method is the same. The quirks differ.
Square. Square batches multiple days into one payout and can apply refunds to a later payout. Square’s own Transfer report is the best source for matching each payout to the days it covers. Instant transfers carry an extra fee, so watch for it on the fee line.
Toast. Restaurants carry heavy tip volume, so tips payable matters more here than anywhere. Also watch for third-party delivery apps like DoorDash or Uber Eats. Those orders often pay out separately, with their own fees, and in many states the app collects and remits sales tax for you. Treat each app as its own clearing account, and confirm the tax treatment with your tax professional.
Shopify. Shopify Payments payouts can bundle several days, with fees, refunds, and chargebacks netted out. If you also take PayPal or other gateways, each one pays out separately and needs its own clearing account. Shopify sellers carrying inventory also need cost of goods sold recorded, which a daily sales summary does not cover by itself.
Gift Cards: The Liability Nobody Tracks
A gift card is not a sale until someone uses it.
When you sell a gift card, record it as a liability. You owe the customer goods or services. When the card is redeemed, move that amount out of the liability and into sales.
If gift cards are recorded as sales on the day they are sold, revenue gets counted early, and the liability disappears from your balance sheet. Over a holiday season, that can make December look far better than it was.
Unused gift cards add one more layer. Some balances are never redeemed. How and when that becomes income, and whether your state requires unclaimed balances to be reported, depends on state law. Rules vary widely, so this is a question for your CPA.
When Your Clearing Account Will Not Zero Out
A clearing account that drifts is a signal, not a disaster. Here is where to look.
A chargeback or dispute fee came out of a payout. Record it against the clearing account when it happens.
A refund was paid from a later day. It belongs on the day it was processed, not the day of the original sale.
Your POS day ends at a different time than the calendar day. Late-night sales may land in the next business day. Use the same cutoff every day.
A reserve or hold. Some processors hold back part of a payout. That money is still owed to you, so it stays in clearing until released.
A sync posted something on top of your summary. If an integration is still pushing individual sales, you are counting income twice. Turn one of them off.
Investigate any balance older than a few days. Timing differences clear themselves within a payout cycle. Anything older is a real error.
How We Set This Up
When a restaurant, retailer, or online store comes to us, the first thing we check is how POS sales hit QuickBooks. Most files have the double-income problem, gift cards booked as sales, or tips sitting in revenue.
If the file needs fixing, that happens first. Our QuickBooks cleanup service rebuilds the chart of accounts and corrects past entries, starting at $360 for a full year of simple books. Most cleanups finish in 5 to 7 business days.
After that, our monthly bookkeeping services keep the clearing accounts reconciled every month, in QuickBooks, Xero, Wave, or Zoho Books. You get a Profit and Loss statement that shows real sales, real fees, and real profit, with tips, tax, and gift cards kept out of your revenue. Our monthly bookkeeping cost breakdown shows how pricing works by transaction volume, and a daily summary keeps that volume low.
Frequently Asked Questions
Why don’t my Square sales match my bank deposits?
Square deducts fees, groups several days into one payout, and can apply refunds to later payouts. Tips and sales tax also flow through the deposit. The deposit is the net of all of these, not your sales total.
Should I record each POS transaction in QuickBooks?
Usually not. A single daily summary journal entry records all sales, fees, tips, tax, and refunds in totals. Your POS keeps the item-level detail, and your books stay clean.
What is a clearing account?
A clearing account holds money a processor owes you but has not paid yet. Daily sales go in. Deposits come out. At month end, the balance should equal payouts still in transit.
Are tips income for my restaurant?
No. Card tips collected through your POS belong to your staff. Record them as a liability until they are paid out through payroll.
How do I record gift card sales in QuickBooks?
Record a gift card sale as a liability, not income. When the card is redeemed, move the amount from the liability to sales.
How do I record merchant fees from Square, Toast, or Shopify?
Record them as an expense in the daily summary entry. That way your sales show the full amount, and your fees are visible in their own account.
Why is my income doubled in QuickBooks?
Usually because sales come in from the POS integration and the bank deposit was also categorized as income. The deposit should be a transfer from the clearing account, not new income.
