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
How do I catch up on months of neglected bookkeeping?
Gather all your documents, find the last accurate month in your books, and work forward chronologically. Start with bank reconciliation for each month, then categorize transactions. If you're more than a few months behind, professional help can save significant time.
Read answerHow do I handle bank fees on my IOLTA account?
Bank fees on IOLTA accounts cannot be paid from client funds under California State Bar rules. You must deposit your own money to cover any fees charged to the trust account and record the fee as a firm operating expense, not a trust account deduction.
Read answerWhat overhead benchmarks should my dental practice be tracking?
Track staff costs (25-30% of collections), facility (5-7%), supplies (5-8%), and lab fees (varies by service mix). Total overhead should land between 55-65% for a healthy practice, leaving room for owner compensation and profit.
Read answerHow do I clean up my books before selling my company?
Separate personal expenses from business transactions, reconcile every account, and fix categorization inconsistencies. Buyers examine two to three years of records during due diligence, so start cleaning up well before you plan to sell.
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 bookkeeping records do I need to keep as a real estate agent?
Keep commission statements, mileage logs, marketing receipts, professional dues documentation, and all business expense receipts. Vehicle mileage is especially important since agents drive constantly for showings and client meetings.
Read answer