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 bookkeeping records do I need for a Texas franchise tax report?
Texas franchise tax requires clean revenue records, documentation for any deductions you claim, and current entity information. The specific records depend on which calculation method you use, but all businesses need accurate total revenue tracking as the starting point.
Read answerHow should salons and spas track product sales separately from services?
Set up separate income accounts for service revenue and retail product sales in your accounting software. This separation is essential for accurate sales tax calculation, inventory tracking, and understanding profitability by revenue stream.
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 answerHow do I collect W-9s before 1099 season?
Collect W-9s from contractors and vendors before you pay them, not in January when 1099s are due. The W-9 provides the legal name, TIN, and entity type you need for accurate 1099 reporting.
Read answerShould contractor reimbursements be included in 1099 totals?
Usually yes. Reimbursements paid to contractors are generally included in the 1099-NEC total unless you have documented receipts and a formal expense arrangement that meets IRS requirements.
Read answerHow should plumbers, electricians and HVAC companies track parts and truck expenses?
The key is separating direct job costs from overhead with distinct categories for job parts, warranty parts, truck stock inventory, and tools. Tracking what goes on each job versus what's general overhead determines whether you know your true profitability.
Read answer