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
How do I know if my books are a mess?
There are clear warning signs: bank accounts that don't reconcile, surprise tax bills, financial statements that don't match reality, and transactions piling up uncategorized. If you're avoiding your books, that's usually confirmation enough.
Read answerCan my accountant access my QuickBooks file?
Yes, and you should set this up. QuickBooks Online includes a free accountant user slot specifically for this purpose. QuickBooks Desktop requires sharing the file directly or sending an accountant's copy.
Read answerShould I use accrual accounting for my e-commerce store?
In most cases, yes. Accrual accounting matches revenue with the costs that generated it, which matters when you hold inventory and sell through platforms with delayed payouts. Cash basis works for very small stores but starts creating blind spots as you grow.
Read answerWhat does it mean to reconcile my accounts?
Reconciling means comparing what your bank statement shows against what your accounting software shows, then fixing any differences. It confirms your books match reality.
Read answerHow do I record Shopify sales in QuickBooks?
Record gross sales separately from the bank deposit since Shopify deducts fees and refunds before paying you. Use a clearing account to track what Shopify owes you, then match payouts to your bank deposits.
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 answer
