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 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 reconcile my accounts in QuickBooks Online?
Reconciliation compares your QuickBooks records to your bank statement. Start with your statement ending date and balance, then match transactions one by one until the difference is zero.
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 answerCan you help me get my books ready for tax season if I'm behind?
Yes. Catch-up bookkeeping exists specifically for this situation. We gather your records, categorize and reconcile everything, and get your books into shape so your accountant can file your return.
Read answerWhat documents do I need to provide for catch-up bookkeeping?
Bank statements are the foundation. Credit card statements come next. Receipts, invoices, and payroll records help fill in the details, but you don't need perfect documentation to get started.
Read answerShould I use cash basis or accrual accounting for my business?
Most small businesses do fine with cash basis because it's simpler and matches what you see in your bank account. Accrual makes more sense when you need an accurate picture of profitability across longer billing cycles or carry significant inventory.
Read answer
