Why Your Square Sales Don't Match Your Bank Deposits

If Square says you sold $20,000 and only $17,000 hit the bank, that does not automatically mean something is wrong. It's quite common.

Part of that money may still be in transit. There may be processing fees, refunds, chargebacks, timing differences, or other activity between the sale and the actual deposit. That's why we use a Square clearing account.

The clearing account gives us a place to hold the card activity until the money actually settles. Instead of pretending the Square sales number and the bank deposit should be the same number on the same day, we track the difference and make sure we can explain it. Square records the sales activity when it happens, while the bank records the cash when it actually settles. For owner-operators, that timing difference can create complexity they didn't anticipate.

The important thing is that we need to know what Square says happened, what your bank records, and what the difference is and how to explain it properly.

We have to make the two systems talk to each other properly in order for everything to be accurately reflected in QuickBooks.

The $20,000 and $17,000 above are an illustration, not a client result.

These are the ordinary reasons a Square sales number and a bank deposit differ. None of them is an error by itself.

• Sales that have not settled yet. Square's help pages say standard transfers for payments taken before 5 PM Pacific generally arrive the next business day, and later payments a day after that. Weekends and bank holidays push it out further.
• Processing fees. Square takes its fee out of each payment before it sends the rest to your bank, and the fee applies to the whole charge, tax and tip included.
• Discounts and refunds. Both reduce the money actually collected, and a refund can reduce a deposit on a different day than the original sale.
• Sales tax and tips. They are part of what the customer paid and part of the deposit, but they are not your revenue. Depending on which Square report you are looking at, your sales number may not include them, so the gap does not always run in one direction.
• Disputes and chargebacks. Square may hold the disputed amount while the cardholder's bank decides the case, which can lower a deposit well after the sale.
• Money Square sets aside. If you use Square's automatic savings, part of your card sales is moved into a savings folder instead of your bank. It is still your money. In our books it is a movement between balance sheet accounts, not income and not an expense.
• Cash. A cash sale can show up in your Square totals, but Square never deposits it, because Square never held it.

Together these explain most gaps. What is left after them is the part worth investigating.

A Square clearing account is a balance sheet account that holds what Square owes you. Think of it as a waiting room for card sales. A sale goes in, net of Square's fee, on the day it happens. A deposit comes out on the day it reaches your bank. What is sitting in the room at any moment is money you earned and have not been paid yet.

That is what separates recording the sale from receiving the cash. The revenue lands in the right period because it is recorded when the sale happens. The bank balance matches the bank because only real deposits touch it.

A clearing account does not have to equal zero. At the end of a week or a month, some sales are normally still in transit, and a positive balance can be completely healthy. A negative or unexpected balance is different. It means something needs an explanation, such as deposits with no matching sales entry or a deposit counted twice. The goal is zero unexplained difference. Every dollar left in clearing should be something you can name.

1. Square activity. The sale happens.
2. The sale is split. The sale is income, and discounts and refunds reduce it. Sales tax and tips are liabilities, not income. Square's fee is an expense.
3. Card net goes to clearing. That is what Square owes you after its fee.
4. Square pays out. It groups settled payments into a transfer and, if you use automatic savings, sets part of it aside.
5. The deposit reaches your bank.
6. The deposit reduces clearing. Whatever has not been paid out yet is still in clearing, and that is a timing item, not a problem.

Cash and other payment types that Square does not settle should not be mixed into card clearing. Square never deposits them, so they would leave a balance in clearing that can never be paid off.

We work from three layers and tie them together. The first is the transaction activity: each sale, discount, refund, tax amount, tip, and fee as Square recorded it. The second is the transfer activity: what Square actually paid out and what it held back. The third is the bank. Lynn Solutions currently uses Square's Transactions and Transfer Details exports for the first two.

Those two exports share a deposit ID, which links each payment to the transfer that settled it. So a deposit can be traced back to the sales inside it, and the deposit has to match what the bank shows. Sales that have not been paid out yet stay in clearing. Whatever is left after that gets investigated.

Before a period is closed, the arithmetic has to work. Each Square row has to add up: sales, less discounts, plus tax and tips, less fees, equals what Square owes you for that payment. The entry has to balance. Revenue less discounts and refunds has to equal supported net sales. Each deposit has to tie to the bank. And the difference nobody can explain has to be zero.

I trust the Square accounting when I can trace the activity back to Square, trace the deposits to the bank, and explain what is still left in the clearing account.

I am completely comfortable with money remaining in clearing if I know exactly why it is there. Maybe the payment has not settled yet. Maybe there are processing fees, a refund, a dispute, or another timing item. That's completely fine.

What isn't okay is when there is a number that can't be explained.

I don't plug a number in just to make the books reconcile. There is always an explanation, so when something is off, I get to investigate and figure it out for my clients.

Over time you also learn the normal settlement pattern for that business. Some transactions settle faster than others, and temporary holds or other processing differences can affect when the money reaches the bank.

The point is not to force everything to zero immediately. The point is to understand what Square owes the business, what has already been deposited, and what is still in transit.

When we close the period, I want the Square activity, the bank deposits, and the clearing balance to tell one coherent story with no unexplained difference.

• Coding Square deposits straight to income. If the sales were already booked, a bank rule that labels every Square deposit as sales can count the same revenue twice.
• Expecting the Square sales number to equal the bank deposit. They are different measurements, and the gap is normal.
• Forcing clearing to zero. Something that is still in transit is supposed to be in there.
• Plugging an unexplained variance. A variance account or a reconciliation adjustment makes the screen balance and leaves the question unanswered.
• Mixing cash into card clearing. Square never deposits it, so it sits there with nothing to clear it.

Two other guides cover the wider picture. One explains why books can look current without being reconciled. The other compares cleanup and monthly bookkeeping.