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 often should I reconcile my business bank accounts?
Reconcile at least once a month, though weekly is better for most businesses. Weekly reconciliation takes less time per session and catches errors while you still remember what happened.
Read answerHow do optometrists track inventory and frame costs?
Track each frame as an individual SKU with its cost, vendor, and category. Use practice management software or QuickBooks inventory features to connect purchases to sales, and run physical counts regularly to catch shrinkage and slow-moving stock.
Read answerHow do I assess the true profitability of a business for sale?
Start by normalizing the financials. Sellers present adjusted numbers that add back owner salary, personal expenses, and one-time costs. Your job is to verify those adjustments and determine what profits will look like under your ownership.
Read answerHow long does it take to get my books sale-ready?
Most small businesses need three to six months to get their books ready for sale. The timeline depends on your current bookkeeping state, years of records needed, and business complexity.
Read answerWhat is work-in-progress accounting for contractors?
Work-in-progress accounting tracks costs and revenue on jobs that span multiple reporting periods. It prevents your financials from showing huge losses during construction and massive profits when projects complete.
Read answerHow do I calculate food cost percentage for my restaurant?
Divide your food costs by your food sales and multiply by 100. For overall restaurant food cost, you need to calculate cost of goods sold using beginning inventory, purchases, and ending inventory.
Read answer