How do I reconcile my POS system with my accounting software?
The main challenge with POS reconciliation is that your gross sales never match your bank deposits. Payment processors take fees before depositing funds. Tips collected get paid out to employees. Some days batch out after midnight and deposit the next business day. If you just record the deposit amount as sales, your books will be wrong and your fee tracking will be nonexistent.
Start by pulling daily sales reports from your POS system. These should show gross sales, broken down by payment type (credit, debit, cash). Compare these to your payment processor statements which show the fees deducted before deposit. The math should work out: gross card sales minus processing fees equals net deposit.
Record the full gross sale as revenue in your accounting software, then record the processing fee as a separate expense. This gives you accurate sales figures and lets you track what you’re actually paying in fees. Many business owners are surprised to find they’re paying 3% or more on every card transaction when they finally see the total.
Tips add another layer. If customers tip on cards, that money comes through your processor but belongs to your employees. You need to track tips as a liability until you pay them out. When you run payroll or distribute cash tips, you clear that liability. Recording tips as income and then as payroll expense overstates both your revenue and your expenses.
Cash sales require separate handling. Cash should be deposited intact and recorded as revenue. If you’re using cash from the register to make change, pay tips, or cover small expenses, your reconciliation gets messy fast. Keep cash handling simple and your monthly bookkeeping stays clean.
Check your deposit timing. Most processors deposit funds one to two business days after the batch closes. A Friday night batch might not hit your bank until Tuesday. When you reconcile, match the deposit to the correct sales date, not the date it appeared in your bank account.
Many POS systems offer direct integrations with QuickBooks. These can save time but they also create problems if not configured correctly. The integration might record net deposits instead of gross sales, or dump everything into a single sales account without breaking out tips or fees. Automatic doesn’t mean accurate.
For restaurants and retail businesses, POS reconciliation should happen weekly at minimum. Waiting until month-end makes it harder to track down discrepancies and easier to miss theft or errors. A few minutes each week prevents hours of detective work later.
LA's Small Business Bookkeeper
The Next Step:
A Short Conversation
Tell us about your business and what you're dealing with. We'll listen, ask a few questions, and give you a clear price for the work.
More Questions
What is the difference between employees and independent contractors?
The core difference is control. Employees work under your direction while contractors control how they complete the work. California's AB5 law makes the distinction stricter than federal standards, and getting it wrong can result in back taxes, penalties, and lawsuits.
Read answerHow do I track accounts receivable and follow up on late payments?
Use an aging report to see all outstanding invoices grouped by how long they've been unpaid. Build a consistent follow-up schedule with reminders before due dates and escalating contact as invoices age. The key is having a system and sticking to it.
Read answerHow do I track marketing expenses for my real estate business?
Separate listing-specific marketing costs from general brand marketing and track them in different categories. Set up subcategories in QuickBooks for photography, staging, advertising, and similar expenses. For property-level analysis, use classes or projects to see costs per listing.
Read answerWhat are the biggest bookkeeping challenges for restaurants?
Restaurants deal with daily cash reconciliation, complex tip tracking, perishable inventory, and payroll for tipped employees. These challenges compound because thin margins mean small errors have outsized impact on profitability.
Read answerHow do chiropractors handle bookkeeping for their practice?
Chiropractic bookkeeping involves tracking multiple revenue streams including insurance reimbursements, cash payments, and product sales. Most practices integrate their practice management software with QuickBooks and either handle bookkeeping themselves or outsource to someone familiar with healthcare billing.
Read answerWhat tax deductions can tutoring business owners claim?
Tutoring businesses can deduct teaching materials, home office expenses, software subscriptions, mileage for traveling to students, and professional development. The key is tracking these expenses properly throughout the year.
Read answer