How do I record daily sales from my POS system in QuickBooks?
The goal is matching your daily sales to your bank deposits. Your POS system knows what was sold. Your bank account shows what was deposited. QuickBooks needs to reflect both accurately so you can reconcile and confirm your numbers are right.
Most businesses shouldn’t record every individual transaction from the POS. If you’re running 50 or 200 transactions a day, entering each one creates chaos and doesn’t help you. Instead, record a daily sales summary based on your end-of-day POS report.
Pull your daily report from the POS. This shows total sales broken down by payment type: cash, credit cards, gift cards, and any other methods you accept. You’ll record this as a single sales receipt or journal entry in QuickBooks.
Break out the payment types. Create a sales receipt with the total sales amount as income, then record how it was paid. Cash goes to your cash drawer account or straight to your bank if you deposit daily. Credit cards go to a clearing account because the money doesn’t hit your bank immediately. Gift card redemptions reduce your gift card liability account.
The timing matters. When a customer pays with a credit card on Tuesday, that sale happened Tuesday. But the deposit from your processor might not hit your bank until Thursday. Using a clearing account for credit card sales lets you record the sale when it happens and match the deposit when it arrives. This keeps your books accurate and makes reconciliation possible.
Credit card fees need to go somewhere. Your processor takes their cut before depositing the money. If you sold $1,000 in credit card transactions and $970 lands in your bank, that $30 difference is processing fees. Record this as an expense when you record the deposit, not when you record the sale.
Some POS systems integrate directly with QuickBooks. Square, Toast, Clover, and others can sync automatically. When integration works well, it saves time. When it doesn’t, you get duplicate entries, miscategorized transactions, and reconciliation problems. Restaurants and bars often find that testing any integration carefully before trusting it to run on autopilot saves headaches down the road.
Manual entry takes longer but gives you control. You see exactly what’s going into your books and can catch problems immediately. Many business owners start with manual entry to understand how POS and accounting connect before trying automation.
Set up a consistent process. Record sales from the previous day every morning, or batch them weekly if daily feels like too much. The longer you wait, the harder it gets to remember why the numbers don’t match when something looks off.
Common mistakes include recording gross sales without accounting for fees, forgetting to track cash over or short from the drawer, and ignoring gift card transactions entirely. Each of these makes your books wrong and creates problems at reconciliation time or when your accountant needs accurate numbers for taxes.
If your POS reports and bank deposits never seem to line up, the problem is usually in how the sales are being recorded. Getting this right is foundational for any business running transactions through a register. Bookkeeping services in Richmond can help you set up a system that matches your specific POS and workflow so you’re not guessing every time you reconcile.
Greater Richmond's Small Business Bookkeeper
The Next Step:
A Short Conversation
Fifteen minutes to tell us what you're dealing with. We'll let you know how we can help and give you a clear price quote.
More Questions
Should my restaurant use cash or accrual accounting?
Most small restaurants do well with cash accounting. It's simpler, matches cash flow reality, and the IRS allows it for businesses under $29 million in annual revenue.
Read answerHow do I calculate how much sales tax I owe?
Multiply your taxable sales for the period by the applicable tax rate. In most of the Richmond area, that's 5.3%. The key is making sure you've correctly identified which sales are taxable and reconciling against what you actually collected.
Read answerWhat does a fractional CFO do and do I need one?
A fractional CFO provides part-time strategic financial guidance like cash flow forecasting, budgeting, and financial planning. You likely need one when you're making growth decisions that require more than historical bookkeeping can tell you.
Read answerShould I connect my bank account to QuickBooks or enter transactions manually?
Connect your bank account. Bank feeds save hours of data entry time and reduce typing errors. You'll still need to review and categorize transactions, but you'll start from accurate data instead of hoping you entered everything correctly.
Read answerHow do I set up job costing in QuickBooks Online?
Enable the Projects feature in QBO Plus or Advanced, then configure your chart of accounts to track costs by category. The software setup is straightforward but the structure you choose determines whether your job reports are actually useful.
Read answerWhat's the best way to track business expenses?
The best expense tracking system is one you'll actually use consistently. Separate business and personal finances, capture receipts immediately, and reconcile weekly instead of waiting until month-end.
Read answer
