Square Restaurant Reconciliation: Stop Margin Leaks, Boost Cash Fast

Key takeaways

• Stop margin leaks fast by tying Square payouts to the penny, operators recover hundreds to thousands monthly when fees, promos, and chargebacks are booked right.
• See true take rates by channel, many restaurants uncover 10 to 30 percent swings and shift volume or pricing to protect cash.
• Cut audit and payroll risk by treating sales tax and tips as liabilities, not revenue, and clearing them on schedule.
• Unlock real credits, from the FICA tip credit to WOTC, putting four to five figures back into your pocket each year.
• Eliminate double counting from DoorDash, Uber Eats, and Grubhub, so your sales and taxes are accurate across every channel.

Why Square restaurant reconciliation matters now

If you are a growing US restaurant using Square for POS and card processing, reconciliation is where profit shows up or disappears. With pre-tax margins often under 10 percent, small misses on fees, chargebacks, or taxes can erase a whole month’s profit.

Build the habit to reconcile Square payouts and delivery channels to the bank, then measure the true take rate of each source monthly. Recent restaurant business performance data underscores how thin the room for error really is.

Delivery marketplaces in your reconciliation

DoorDash, Uber Eats, and Grubhub are not “just another Square channel.” They are separate processors with unique fees, promos, chargebacks, and payout calendars. Some orders route through Square for printing, many do not. Reconcile them separately and do not double count anything inside Square.

The anatomy of Square money flows using the Payout Report

Square collects the card, batches the day, takes fees, handles refunds and disputes, then sends a net deposit to your bank. Your job is to bridge gross to net using the Square Payout Report and record every adjustment along the way.

What shows up in a Square Payout Report

• Gross sales before deductions
• Refunds and voids
• Discounts and comps
• Sales tax collected
• Tips collected for staff
• Processing fees and instant transfer fees
• Disputes and chargebacks
• Net payout and the bank deposit date

Square documents these fields and how they roll into your bank transfer.

Why gross does not equal your bank deposit, and how to bridge it

• Start with gross card sales for the period.
• Subtract refunds, discounts, and chargebacks.
• Subtract Square processing and instant transfer fees.
• Keep sales tax and tips separate as liabilities, not revenue.
• The remainder equals the net payout you should see in the bank.

Example: 1,000 gross, 50 refunds, 20 discounts, 26 fees = 904 expected deposit. If the bank shows anything else, investigate the variance right away.

The core workflow that always ties out

Step one: set up your chart of accounts with a Square clearing account

Create Square Clearing in current assets. Add liability accounts for Sales Tax Payable and Tips Payable, expense lines for Square Processing Fees and Refunds and Chargebacks, and revenue accounts by channel for profitability analysis.

Step two: post your daily sales summary into Square Clearing

• Debit Square Clearing for total card sales including tax and tips.
• Credit In Store Card Sales for pre-tax sales.
• Credit Sales Tax Payable for collected tax.
• Credit Tips Payable for card tips captured.
• Credit Gift Card Liability for new gift cards sold.

Step three: record fees and deductions

• Debit Square Processing Fees for processing costs.
• Debit Refunds and Chargebacks for returns or disputes.
• Credit Square Clearing for the sum of those deductions.

Step four: move the net payout when it lands

• Debit Cash in Bank for the deposit amount.
• Credit Square Clearing for the same amount.

If entries are right, Square Clearing zeros after the deposit. If not, find the timing difference or error.

Step five: month-end tie out

Reconcile Square Clearing to zero. Any balance should be documented pending payouts or true timing differences. Fix everything else now, not next quarter.

Reconcile Square with delivery apps without double counting

There are two operating modes, and each needs a clean workflow.

Mode 1: marketplaces bypass Square entirely

• Create a clearing account per marketplace: DoorDash Clearing, Uber Eats Clearing, Grubhub Clearing.
• Record gross order value to Marketplace Revenue and the related clearing account.
• Record commissions to Marketplace Commissions, promos you fund to Promotional Expense Marketplace, then credit the clearing account.
• For refunds or chargebacks, debit Refunds and Chargebacks, credit clearing.
• If the marketplace is a facilitator for sales tax in your state, do not accrue that tax payable.
• When the bank deposit arrives, debit Cash, credit the marketplace clearing to zero it out.

Mode 2: marketplaces inject orders into Square but settle separately

Prevent double counting at the source. Configure Square or middleware so marketplace orders route to a dedicated pass-through revenue line, exclude them from Square-settled revenue posting, and reconcile those dollars only through marketplace statements and clearing. Learn how to prevent double counting at the source.

What to do with marketplace statements in practice

• Use the marketplace payout export as the source of truth.
• Post gross to Marketplace Revenue and the clearing account.
• Book commission, marketing, and delivery fees to the correct expense lines.
• Confirm facilitator-handled tax so you do not create a tax payable you do not owe.
• Tie the clearing account to the net bank deposit.

Cadence matters, because marketplace statement timing will differ from Square and from each other.

Minimal chart of accounts for Square restaurants

Revenue accounts you will actually use

• In Store Card Sales
• Online Ordering Sales
• Square Delivery Sales (if Square runs delivery end to end)
• DoorDash Sales Revenue (gross)
• Uber Eats Sales Revenue (gross)
• Grubhub Sales Revenue (gross)

Expense buckets that explain channel take rate

• Square Processing Fees
• Marketplace Commissions by platform
• Promotional Expense Marketplace
• Delivery Service Fees
• Refunds and Chargebacks

Balance sheet accounts that keep you compliant

• Cash in Bank
• Square Clearing and one clearing per marketplace
• Tips Payable
• Sales Tax Payable (Square-collected and self-remit as needed)
• Gift Card Liability

Common Square reconciliation pitfalls, and how to catch them early

Missing or duplicate days

Busy weeks cause skipped downloads or repeats. Compare Payout Report ranges to the calendar, every day should appear once. Build a simple month-end continuity checklist.

Negative deposits

One-offs may follow large refunds or chargebacks. Repeated negatives usually mean fraud, operational issues, or booking errors. Pull dispute and refund logs and fix the root cause immediately.

Tips booked as expense instead of liability

Card tips are not revenue. Record them to Tips Payable and clear through payroll. A month-end Tips Payable balance means unpaid tips or timing—resolve before it becomes a wage issue.

Sales tax errors when Square collects versus marketplaces remit

This is the most expensive reconciliation mistake. Brush up on restaurant sales tax compliance and document rules by channel and state so your team books it consistently.

Gift cards recognized as revenue at sale

Gift card cash is a liability until redemption. Recognize revenue only when redeemed. Know your state’s unclaimed property rules for breakage.

Instant transfers and timing differences

Instant transfers add transactions and fees, so post each transfer and its fee the same day. Expect weekend cutoffs to leave a valid Square Clearing balance at month end.

Use variance checks to protect the bank reconciliation

Set a small threshold, like $50 or 0.5 percent of sales. If the net bank deposit does not match the payout report within that threshold, stop and fix. A quick bank reconciliation guide mindset saves month-end hours.

Turn reconciled data into decisions that raise margin

Net take rate by channel

Total channel fees plus restaurant-funded promos, divided by gross channel sales, times 100. Compare DoorDash, Uber Eats, Grubhub, Square in-store, and Square Online, then shift volume or pricing accordingly.

Menu profitability after delivery fees

Evaluate items net of channel-specific fees. Feature items that travel well and keep margin after commission, and consider channel-specific pricing when justified.

Promo burn rate

Split marketplace-funded versus restaurant-funded promos. If your spend creeps above plan, you are buying orders at a loss. Redirect offers to pickup where take rate is lower.

Refund and chargeback trend lines

Rising refunds often signal accuracy or packaging issues. Clusters of chargebacks suggest training or fraud concerns. Fixes here pay back quickly.

Payout timing by channel

Track days to cash per channel. Slow and expensive channels are using your working capital, price or promote accordingly.

Credits, deductions, and incentives restaurants leave on the table

FICA tip credit

The federal credit equals the employer share of Social Security and Medicare taxes on reported tips above the amount needed to reach federal minimum wage. Claim it on Form 8846. Even modest volumes can add thousands back each year.

Work Opportunity Tax Credit

Hiring from WOTC target groups can earn $1,500 to $9,600 per eligible hire. You must pre-screen and secure state certification within 28 days of the start date, then track hours to maximize the credit.

Small Business Health Care Tax Credit

If you have fewer than 25 FTEs, cover at least half of employee premiums, and stay under wage caps, you may qualify for up to 50 percent credit on employer-paid premiums. Model it at renewal time.

Depreciation levers

• Section 179 for qualifying equipment and software up to annual limits.
• Bonus depreciation for a scheduled percentage of qualified property.
• MACRS for remaining basis and non-qualifying assets.

Employee Retention Credit, proceed cautiously

No new ERC claims for 2024 or 2025 wages. Only amend past quarters if you were truly eligible, and use IRS withdrawal or voluntary disclosure options if needed.

State and local incentives

States and cities run grants, hiring credits, and abatements that change frequently. Put a quarterly check on your calendar with your state economic development agency.

Opportunity Zones

If you are in a Qualified Opportunity Zone and raising capital, investors through a Qualified Opportunity Fund can gain deferral or reduction on prior gains, making your project more attractive.

Policy radar

Local minimum wage changes move labor cost far more than federal headlines. The IRS is ramping enforcement, especially on improper ERC filings. Clean books and clear positions reduce exposure.

Contrarian view: reconciliation is not about software

Reframe: Tools do not fix reconciliation, discipline does. Own the bridge from Square and marketplaces to your bank, then measure what you keep by channel. That is how margin is protected, weekly, not annually.

A brief note on Korefi and why a Do It For You approach works

Korefi is a full-stack accounting partner built for US restaurants. It rides on top of your existing systems, handles bookkeeping, filings with CPA validation, and proactive advisory, so money is found, credits are caught, and your books reconcile weekly without adding work to your plate.

A day in the life: entries that make Monday tie out

Monday: $2,000 Square gross, including $150 tax and $200 tips, $50 fees, no refunds.

• Debit Square Clearing $2,000
• Credit In Store Card Sales $1,650
• Credit Sales Tax Payable $150
• Credit Tips Payable $200
• Debit Square Processing Fees $50
• Credit Square Clearing $50

Tuesday bank shows $1,950 deposit:

• Debit Cash in Bank $1,950
• Credit Square Clearing $1,950

Square Clearing is zero. Tips flow out through payroll by crediting Cash and debiting Tips Payable.

A week in the life with DoorDash added

DoorDash: $1,000 gross, $250 commission, $20 marketplace-funded promo, $30 store-funded promo, marketplace remits tax, $700 deposit.

• Debit DoorDash Clearing $1,000
• Credit DoorDash Sales Revenue $1,000
• Debit Marketplace Commissions DoorDash $250
• Credit DoorDash Clearing $250
• Debit Promotional Expense Marketplace $30
• Credit DoorDash Clearing $30
• Debit Cash in Bank $700
• Credit DoorDash Clearing $700

Take rate: ($250 + $30) ÷ $1,000 = 28 percent.

Month-end close checklist that takes minutes, not hours

• Confirm every day appears once in the Square Payout Report.
• Tie the sum of net payouts to bank deposits within your variance threshold.
• Reconcile Square Clearing to zero except documented pending payouts.
• Reconcile marketplace clearing accounts to zero except pending deposits.
• Verify Tips Payable clears after payroll, investigate any residuals.
• Confirm Sales Tax Payable matches intended filings by jurisdiction.
• Scan Refunds and Chargebacks for spikes and pull detail if trending up.
• Update your take rate dashboard by channel.

What changes when you add gift cards

At sale, credit Gift Card Liability and debit Cash or the clearing account, no revenue yet. At redemption, recognize revenue and reduce the liability. For dormant cards, follow your state’s unclaimed property rules before considering breakage income.

How reconciled books change your pricing on delivery apps

With clear take rates and item profitability by channel, you can price delivery menus to protect margin, feature bundles that raise average order value, and steer promos toward pickup. Do not guess, let reconciled data set the rules and adjust monthly.

A second brief note on Korefi for owners who want the outcome without the busywork

If you want this rigor without adding a back office to your week, Korefi can run it end to end. Expect tight reconciliations, filings handled, and credits found before deadlines, without logging into another tool.

Final thought: take back control of margin one reconciliation at a time

Post daily to a clearing account, separate taxes and tips as liabilities, reconcile marketplaces without double counting, and measure take rates. Pick one improvement from this playbook and implement it this week. In a month, you will feel the cash and see the clarity.

FAQ

How do I handle Square instant transfers and weekend cutoffs?

Treat each instant transfer as its own bank transaction and expense the instant fee the same day. Weekend sales often batch and deposit Mondays or Tuesdays, so if month-end lands on a weekend, the Square Clearing balance should equal pending transfers.

What do I do when refunds cross months?

Book the refund in the month it processes, not the month of the sale. Reduce revenue that month or use a Refunds and Chargebacks expense line, and keep the audit trail tied to the cash movement.

How do I stop double counting DoorDash orders that print in Square?

Route marketplace-injected orders to a dedicated pass-through revenue line in Square or your middleware, exclude them from Square-settled revenue postings, and reconcile those orders only via the marketplace statement and its clearing account.

How do I figure out my true take rate by channel?

Add total channel fees plus restaurant-funded promos, divide by gross channel sales, then multiply by 100. Compare channels monthly and adjust pricing, promos, or volume accordingly.

Do I need a separate clearing account for each delivery marketplace?

Yes, one clearing per marketplace keeps statements clean, prevents cross-channel pollution, and makes bank matching fast. It also lets you see take rate and timing by platform.

Can my restaurant claim the FICA tip credit, and how do I actually get the money?

Yes, if employees report tips above the amount needed to reach federal minimum wage, you can claim a federal income tax credit equal to the employer share of FICA on those tips. Your CPA claims it with your return using Form 8846, so make sure tips are reported and reconciled accurately.

What’s the right way to book chargebacks and reversals?

Expense the chargeback when it hits, because the cash is gone. If you dispute and expect to win, set up a short-term receivable and clear it when resolved; write it off if you lose.

I do not have time to do this weekly—can a partner run it without me switching software?

Yes. A Do It For You partner like Korefi can sit on top of your existing systems, post daily summaries, reconcile payouts, handle filings, and surface take-rate and tax-credit opportunities, so you get outcomes without managing another tool.