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
What records do I need to keep for the IRS?
Keep documentation for all income and expenses reported on your tax return. This includes bank statements, receipts, invoices, payroll records, and asset purchase documentation.
Read answerWhat's the best way to categorize expenses in QuickBooks?
Consistency matters more than the specific categories you choose. Use QuickBooks defaults as a starting point, keep things simple, and match categories to tax return line items for easier year-end prep.
Read answerDo I need to offer benefits if I have employees?
Most employee benefits are optional for small businesses with fewer than 50 employees. Health insurance, retirement plans, and paid time off aren't required under federal or Virginia law. Workers' comp and payroll taxes are mandatory regardless of size.
Read answerWhat's the Best Way to Track Inventory for a Restaurant?
Count weekly, track waste daily, and compare what you should have used against what you actually used. The gap between those two numbers tells you where your food cost is leaking.
Read answerHow do I set up classes and locations in QuickBooks Online?
Go to Settings, then Account and settings, then Advanced. Enable class and location tracking there. The harder part is deciding how to structure them before you start.
Read answerWhat financial reports should I be reviewing every month?
Start with the profit and loss statement, balance sheet, and cash flow statement. Add accounts receivable and payable aging reports to track money coming in and going out. Monthly review catches problems while they're still small.
Read answer
