Manual deposit errors cost ecommerce businesses hours each week and can leave you guessing about your true cash flow.
When deposits are recorded incorrectly in QuickBooks Online, you risk cash flow blind spots, tax reporting headaches, and margin confusion that can stall your growth.
The impact goes beyond lost time; a single deposit error can distort your financial reports and lead to costly decisions.
This guide shows how to record a deposit in QuickBooks Online for every business type, tackle real-world challenges, and automate your workflow as you grow.
Accurate deposit recording is the backbone of financial clarity. Manual reconciliation can consume 8–16 hours per week for growing ecommerce businesses, especially as order volume and sales channels increase.
When deposits are not recorded correctly, you risk missing revenue, making tax mistakes, and losing sight of your true cash position. For example, a $10,000 deposit error could make you think you have cash for inventory when you do not, leading to overspending or missed opportunities.
Single-channel businesses may only need to match a few deposits to invoices. Multi-channel sellers, however, must untangle deposits that combine sales, fees, and refunds from multiple sources.
First, let us identify the deposit workflow that matches your business type.
Deposit recording varies by business model. Knowing your workflow is the first step to accuracy.
Service businesses, such as consultants or agencies, typically receive payments by check, ACH, or card, then batch these into weekly or bi-weekly deposits. The process is straightforward:
Here is how this looks in practice: A yoga studio deposits five checks every Friday. Each check links to a customer invoice, and the total matches the bank deposit exactly.
Retail and ecommerce businesses face more complexity. Payment processors deposit funds on varying schedules, deduct fees before settlement, and combine multiple sales into one deposit. Timing differences between order and payout dates create reconciliation challenges.
For example, an Amazon seller receives daily ACH transfers that combine hundreds of orders, minus referral fees, with occasional reserve holds.
Hybrid businesses operate both physical and online channels. They must track revenue by source, as POS systems deposit separately from online sales, and different fee structures apply to each channel. Deposits may combine or stay separate, but accurate tracking requires channel-specific accounts.
For example, a boutique runs Square POS in-store and Shopify online. Square deposits daily, Shopify deposits weekly, and both feed the same bank account, but need separate tracking.
Multi-channel businesses often need more advanced workflows, covered later in this guide. If you sell on multiple channels or use several payment processors, deposit recording gets even more complicated.
Suggested Read: Best Shopify QuickBooks Integration
Multi-channel selling turns deposit recording into a coordination puzzle. Manual methods quickly become unsustainable as complexity grows.
To understand the challenge, consider a typical Monday morning scenario. You receive a single $8,500 bank deposit. Behind that deposit lies a web of transactions:
Your bank shows one number, but your accounting system needs to track dozens of individual components. Matching one deposit to dozens of orders and fees is time-consuming. You must reconcile different payout schedules and fee structures, and as order volume grows, the risk of error increases.
Manual reconciliation can take 30 minutes or more per deposit for high-volume sellers. Sellers commonly report spending hours each week updating QuickBooks with deposit information.
As order volume grows, manual reconciliation is no longer viable. Accounting automation tools exist to solve this, but first, here is how to do it manually. Let us break down how to record a deposit in QuickBooks Online for your business type.
With the right steps, you can record deposits accurately in QuickBooks Online, regardless of your business type.
Service businesses receive individual payments, then deposit them together at the bank.
Step 1: Verify payments in Undeposited Funds: When you receive customer payments against invoices, QuickBooks automatically places them in the Undeposited Funds account. This is your holding area before creating the actual deposit.
Step 2: Create the bank deposit: Go to + New > Bank Deposit. Select your bank account from the dropdown. Enter the actual deposit date from your bank statement. QuickBooks displays all payments waiting in Undeposited Funds.
Step 3: Select payments to include: Check the boxes for each payment included in this deposit. Only select payments that match your physical deposit slip.
Step 4: Confirm the total matches your deposit slip: The total in QuickBooks must match your bank deposit exactly. If there is a discrepancy, review your selections.
Step 5: Save the deposit: Click Save and Close. QuickBooks moves the payments from Undeposited Funds to your bank account.
Tip: Double-check deposit dates and amounts to avoid reconciliation mismatches.
Retail and ecommerce businesses receive deposits from payment processors, not directly from customers.
Step 1: Review your payout report: Download the payout report from your payment processor (e.g., Stripe, PayPal, Amazon). Identify the gross sales, fees, refunds, and net deposit.
Step 2: Go to Bank Deposit: Go to + New > Bank Deposit. Select your bank account and deposit date.
Step 3: Enter deposit details: Add a line for gross sales (map to your sales revenue account). Add a line for processing fees (map to your merchant fees expense account, enter as a negative amount). Add a line for refunds or adjustments (if applicable). The net total must match the deposit that appears in your bank feed.
Step 4: Save the deposit: Click Save and Close. The deposit now matches your bank statement and reflects both revenue and fees.
Hybrid businesses must track deposits from multiple sources, even if they hit the same bank account.
Step 1: Set up clearing accounts: Create a clearing account in QuickBooks for each payment source (e.g., Square, Shopify, Amazon).
Step 2: Record deposits by channel: For each deposit, create a separate bank deposit in QuickBooks, routing the amount to the appropriate clearing account.
Step 3: Reconcile clearing accounts: At month-end, transfer balances from each clearing account to your main checking account. This keeps your revenue by channel clear and your bank reconciliation clean. You may need to reconcile clearing accounts regularly.
Real-world deposits often include fees, refunds, and mixed payment types. Here is how to handle those.
Suggested Read: Maximizing Efficiency in QuickBooks Enterprise
Real-world deposits rarely match sales totals. Fees, refunds, and mixed sources create reconciliation headaches.
Payment processors deduct fees before depositing funds. To record this in QuickBooks:
This ensures your profit and loss statement shows both revenue and fee expenses.
Refunds and chargebacks reduce your next payout. Record refunds as separate transactions (credit memos or negative payments) in QuickBooks. Make sure the net deposit matches your bank statement after refunds are deducted.
Marketplaces may hold a portion of your payout in reserve. Record the held amount in a separate "Marketplace Reserve" account. When the reserve is released, transfer it into your main account.
Tip: Document every fee and refund line to avoid audit issues.
Accounting automation tools can parse fees and refunds from multiple sources, reducing manual entry and errors. Here is how to keep your deposits and bank statements perfectly in sync.
Regular, accurate reconciliation is essential. Manual or automated, it is the only way to ensure your books are right.
If a deposit does not match your bank statement, review each component: sales, fees, refunds, and holds, to find the discrepancy. For high-volume or multi-channel sellers, automated reconciliation ensures every deposit matches the bank feed, saving hours each month.
As your business grows, manual reconciliation may not be enough. Here is how automation can help.
Manual deposit recording becomes a bottleneck at 50 or more deposits per month or with multiple channels. Manual reconciliation can take 30 minutes or more per deposit, increasing error risk and making it easy to miss fees or refunds.
With automation, every order, fee, and payout syncs instantly. Automation parses fees and refunds, matches deposits to the bank feed, and flags mismatches in real time.
For example, PartyMachines used to spend hours each week reconciling deposits from Shopify, Amazon, and Stripe. After automating with Webgility, they saved up to 90 percent of reconciliation time and closed their books three times faster.
Watch the video: How a Party Equipment Rental Business Gained Efficiency and Reduced Stress with Webgility
Webgility connects QuickBooks Online with all your sales channels, posts orders, fees, and payouts automatically, and ensures every deposit matches your bank feed. You can handle ten times more orders with the same team and track true margins down to the SKU.
To learn more, get a demo.
Create a bank deposit in QuickBooks, add each payment type as a separate line, and ensure the total matches your bank deposit.
Download the settlement report, break out sales, fees, and refunds, and enter each as a separate line in your bank deposit. For multi-channel sellers, use a clearing account for each marketplace.
Yes. Automation tools like Webgility sync orders, fees, and payouts from all channels directly into QuickBooks, saving hours and reducing errors.
Check for missing fees, refunds, or holds. Review your payout reports and ensure every component is recorded in QuickBooks.