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 accrual vs cash basis accounting and which should I use?
Cash basis records income when you receive payment and expenses when you pay them. Accrual records both when they're earned or incurred. Most small businesses use cash basis because it's simpler and offers tax timing flexibility.
Read answerWhat is three-way trust reconciliation for law firms?
Three-way trust reconciliation compares your bank statement, your checkbook register, and the total of all individual client ledger balances. All three numbers must match exactly. This process is required by the California State Bar to ensure client funds are properly safeguarded.
Read answerWhat tax deductions are available for construction businesses?
Construction businesses can deduct vehicle costs, tools and equipment, materials, subcontractor payments, insurance, job site expenses, and licensing fees. The key is tracking everything properly throughout the year.
Read answerWhat should I look for when hiring a bookkeeper?
Look for industry experience, clear communication, and genuine interest in understanding your business. Technical skills matter, but so does whether they ask the right questions and explain things in ways you understand.
Read answerWhat red flags should I look for in a seller's financial statements?
Watch for revenue concentration in few customers, personal expenses mixed with business costs, sudden improvements right before the sale, and gaps between tax returns and financial statements. Any of these warrant deeper investigation before you commit.
Read answerWhat are the consequences of commingling client funds in my law firm?
Commingling client funds can result in State Bar discipline up to and including disbarment, criminal charges if funds are misused, civil liability for breach of fiduciary duty, and lasting reputational damage.
Read answer