How should boutiques reconcile POS deposits, refunds and gift cards?
Point-of-sale reconciliation for boutiques isn’t just about matching your bank deposit to a sales total. The deposit reflects gross sales minus several adjustments, and tracking each component separately keeps your books accurate and helps you understand where the money actually goes.
Start with gross sales from your POS system. This is everything rung up at the register before discounts, returns, or any other adjustments. Then subtract discounts applied during the day, whether from promotions, loyalty programs, or employee pricing. Subtract returns and refunds processed. What you have now is net sales for the day.
But net sales won’t match your bank deposit. Several more items affect the cash that actually lands in your account.
Sales tax collected shows up in your deposit but isn’t revenue. You collected it on behalf of the state and owe it when your filing is due. Track sales tax in a liability account, not as income. When you remit the tax, that payment clears the liability.
Gift cards require careful handling because they affect cash flow and revenue timing differently. When a customer buys a $50 gift card, you receive $50 in cash, but you haven’t earned that money yet. Record it as a liability, typically called gift card liability or unredeemed gift cards. When someone redeems a gift card, you recognize the revenue even though no new cash came in that day. This is why deposits on heavy gift-card-sale days run higher than revenue, and deposits on heavy redemption days run lower.
Merchant processing fees, usually 2-3% of credit card transactions, get deducted before your deposit arrives or charged as a separate monthly transaction. Either way, track them as an expense. If they’re deducted from each deposit, your reconciliation needs to account for the difference between what the POS shows and what the bank received.
The reconciliation formula works like this. Gross sales minus discounts minus returns plus gift cards sold minus gift cards redeemed equals your adjusted cash activity. Add sales tax collected and subtract merchant fees deducted at settlement. The result should match your bank deposit. If it doesn’t, something coded wrong or a transaction didn’t record properly.
Most POS systems generate end-of-day reports with all these figures. Square, Shopify, Lightspeed, and similar platforms break out gross sales, discounts, refunds, gift card activity, and fees. Pull that report daily and compare to what hits your bank account. The few minutes this takes each day saves hours of detective work at month end trying to figure out why nothing ties.
Retail shop accounting often trips up owners who record only the net deposit as sales. Your books will understate actual revenue, miss the expense from merchant fees, and fail to track sales tax liability properly. Breaking out each component means your financial statements reflect what’s happening in the business.
If setting up these accounts and processes feels overwhelming, working with small business bookkeeping and tax services in The Woodlands can help you get the structure right. Once the chart of accounts handles gift card liability, sales tax payable, and merchant fees correctly, daily reconciliation becomes routine instead of a monthly headache.
Greater Houston's Small Business Bookkeeping Partner
The Next Step:
A Quick Conversation
Tell us about your business and what you need help with. We'll listen, ask a few questions, and give you a straightforward quote.
More Questions
What QuickBooks Online settings matter most before connecting bank feeds?
Configure your accounting method, fiscal year, chart of accounts, and sales tax settings before connecting bank feeds. These foundational settings are difficult to change later and affect how every transaction gets recorded.
Read answerHow do I clean up old accounts receivable balances in QuickBooks?
Cleaning up old AR requires reviewing each invoice individually. Look for unapplied payments, duplicate invoices, bad debt that needs to be written off, and payments received outside QuickBooks that were never matched.
Read answerWhen does a business need fractional CFO support instead of basic bookkeeping?
Bookkeeping records what happened. A CFO helps you decide what should happen next. When you're facing major decisions, pricing questions, or growth challenges, you've likely outgrown basic bookkeeping.
Read answerWhat should a contractor include on invoices for progress billing?
Progress billing invoices should include the original contract amount, approved change orders, completion status, previous billings, deposits applied, and retainage held. This clarity prevents confusion between revenue earned and cash collected while reducing client disputes.
Read answerWhat bookkeeping records should a new business in The Woodlands set up before its first tax season?
Set up a separate business bank account, configure QuickBooks Online properly, and register for Texas sales tax if applicable. Be aware of franchise tax filing requirements and establish a monthly reconciliation routine before tax season arrives.
Read answerHow can a home builder see profit by subdivision or project?
Set up your accounting software to track income and expenses by subdivision using classes, locations, or projects in QuickBooks. When every transaction is coded to a specific development, you can run reports showing profitability for each one.
Read answer