QuickBooks Subledger Controls & Merchant Batch Reconciliation
Undeposited Funds and clearing account reconciliation in QuickBooks
In QuickBooks Online, Undeposited Funds (now labeled Payments to deposit) is a temporary asset clearing account that holds customer invoice payments and daily POS or ecommerce sales until processor batches settle. Categorizing incoming Stripe, Shopify, Square, Toast, or field-service payouts straight to Income counts revenue twice and strands collected balances on the Balance Sheet.
Why this failure is everywhere: Across 1,275 public bookkeeping job postings analyzed by Level, 806 business owners (63.2%) hired help to fix bank-feed or Undeposited Funds errors, and 362 (28.4%) needed multi-month cleanup. In Level's published 30-fault SMB close catalog, unassisted AI routinely misbooks a $28,400 customer check or an $84,250 sister-entity ACH as new Sales instead of matching open AR (ERR-01). Across ecommerce, B2B services, and 2,242 contractors ($13.25B job revenue, 85.1% median collection), duplicate tax-time revenue creates immediate cash strain.
Why double-counted revenue happens in QuickBooks Online
Accrual accounting separates revenue recognition from cash settlement across three distinct ledger events. First, issuing a customer Invoice in QuickBooks or syncing daily sales from Shopify, Stripe, Square, or a field CRM credits Revenue and debits Accounts Receivable or Gateway Clearing. Second, recording Receive Payment credits Accounts Receivable and debits Payments to deposit. Third, creating a Bank Deposit credits Payments to deposit and debits Operating Checking.
Double-counted revenue happens at step three when the net processor payout hits the QuickBooks bank feed. Merchant fees reduce the deposit below the gross invoice total, so QuickBooks fails to suggest an automatic match. Clicking Add to assign that deposit to Sales records revenue a second time while stranding the original payment inside Undeposited Funds. Multi-account payout exports also create date-overlap traps: in one de-identified Level close benchmark (ERR-11), 43 of 80 processor export rows were prior-period cutoff duplicates, while January ACH payouts carried December 31 settlement memos (ERR-12).
| Clearing Account Name | QuickBooks Account Type | What Debits / Enters | What Credits / Clears | Month-End Control Target |
|---|---|---|---|---|
| Payments to deposit, or Undeposited Funds | Other Current Assets, Undeposited Funds detail type | Customer Receive Payment or Sales Receipt entries awaiting batch grouping | QuickBooks Bank Deposit transaction grouping checks or gross batch items | $0.00 after active 0 to 7 day deposit transit items clear |
| Merchant Processor & Gateway Clearing | Other Current Assets (or Other Current Liabilities) | Synced Stripe, Shopify, Square, Toast, or field-service gross batch settlements | Net bank feed payout plus monthly or per-batch merchant fees journal line | Equals only unsettled T+1 to T+5 processor batches at month-end |
| Inter-Account & Card Payment Clearing | Other Current Liabilities | Checking account outflow paying corporate credit cards or payroll sweeps | Matching credit card inflow or payroll liability debit on sibling feed | $0.00 once both bank feeds post within the settlement window |
Merchant payout timing and fee-netting schedules across payment platforms
Ecommerce checkouts, POS card batches, B2B ACH invoices, and field collections rarely hit your checking account on the same day or for the gross sale amount. Card settlements run 1 to 3 business days, ACH direct debits take 3 to 5 business days, and processors deduct merchant fees before wiring the net payout. Use the verified processor settlement rules below when tying month-end clearing balances to bank statements.
| Processor / Gateway Platform | Credit Card Settlement | ACH Direct Debit Lag | Batch Cutoff & Fee-Netting Mechanics |
|---|---|---|---|
| Stripe (SaaS, B2B Services & Ecommerce Cards / ACH) | 2 business days (T+2 standard) | 4 business days standard (2-day if eligible after 120 days) | Net payouts deduct card fees, refunds, and disputes automatically; standard ACH is 0.8% capped at $5.00 (9:00 PM ET cutoff). |
| Shopify Payments & Ecommerce Gateways | 2 to 3 business days (standard US payout schedule) | Separate schedules for Shop Pay Installments & PayPal | Payouts wire net of processing fees, refunds, chargebacks, and subscription or loan deductions; requires a Gateway Clearing account. |
| Square & Restaurant POS (Toast / Retail Card Batches) | 1 to 2 business days (standard) | 3 to 5 business days (ACH invoices) | Square closes daily at 5:00 PM PT (8:00 PM ET) with $0 standard transfer or 1.95% instant fee; POS batches net tips, refunds, and gift cards. |
| Field-Service CRMs (ServiceTitan, BuildOps & Payabli) | 1 to 3 business days | 3 to 5 business days | Auto-batching groups technician field collections into processor settlement batches (5:00 PM ET cutoff on BuildOps/Payabli) rather than single checks. |
5-step monthly Undeposited Funds and clearing account reconciliation
1. Route gateway, POS, and CRM syncs into clearing accounts
Map Stripe, Shopify, Square, Toast, or field-service customer payments to Payments to deposit or to a dedicated Merchant Processor Clearing account, never straight to Operating Checking. Enable daily batch grouping so ledger entries match processor payout reports.
2. Build the Bank Deposit net of merchant fees
Open + New and select Bank Deposit, then check off the exact customer payments inside the processor batch from the prior 0 to 7 days. Enter merchant fees as a negative line assigned to Merchant Processing Fees so the net deposit equals the bank wire to the cent.
3. Match (never Add) in the QuickBooks bank feed
When the net payout downloads into Banking, verify QuickBooks links it via Match to your Bank Deposit or clearing transfer. Audit every bank-feed rule so processor payouts from Stripe, Square, Intuit, or Payabli never auto-post straight to Sales.
4. Enforce clearing aging and sweep-divergence thresholds
Reconcile every clearing account at month-end just like a bank statement. Flag any clearing balance of $500+ inactive for 30 days, $5,000+ inactive for 14 days, or $10,000+ anytime. Investigate stale bank feeds whenever one cash account drops below -$5,000 while a sibling rises above +$25,000 without transfers for 10 days.
5. Tie Aged Receivables Detail to the Balance Sheet before closing
Run Aged Receivable Detail and Aged Payable Detail as of month-end and confirm both subledgers tie to the penny to Balance Sheet control accounts. On LevelBench-100 (38 evaluated systems across 100 binary checks), unassisted AI models averaged 55% overall accuracy and peaked at 75.0% on AR/clearing checks, whereas Level's rule-enforced workflow scored 100.0% with zero dangerous writes.
Sources, Scope & Verification Notes
Primary Vendor Documentation: QuickBooks Online Payments to deposit workflow per Intuit QuickBooks Official Help. Card and ACH settlement timing follows Stripe Payouts documentation (0.8% capped at $5.00 standard ACH, 4-day standard or 2-day eligible settlement) and Square Deposit Options Help (1.95% instant transfer fee, 5:00 PM PT cutoff). Field batch rules follow ServiceTitan Payments and BuildOps Payments+ alongside Payabli settlement guides.
Level Research & Close Controls: Bookkeeping error demand (806 of 1,275 postings, 63.2%) reflects Level's published job-posting study, and close failure cases (ERR-01, ERR-11, ERR-12) come from Level's de-identified SMB AI accounting fault taxonomy. Contractor collection rate median (85.1%, n=464 eligible contractors inside Level's 2,242-company, $13.25B dataset) was updated October 7, 2026. Clearing inactivity thresholds ($500 / 30d, $5,000 / 14d, $10,000 anytime) are Level's internal close controls, not survey medians.
Free 1-Click QuickBooks Chart of Accounts CSV Templates
Instant download · No email requiredFastest Start · 100% Credited Toward Ongoing Service
Start with the $300 Flat-Fee 48-Hour QuickBooks Fix Sprint
We audit your ledger, install clean clearing bridges for your software stack, reconcile 1 full month as live proof, and give you an exact catch-up or monthly quote.
Frequently asked questions
Intuit renamed Undeposited Funds to Payments to deposit in modern QuickBooks Online charts of accounts while keeping the exact same Other Current Assets account type and Undeposited Funds detail type. It holds customer invoice payments and sales receipts temporarily until your processor or bank groups them into a single Bank Deposit.
Recording a customer Invoice or Sales Receipt already posts revenue on your Profit and Loss statement. Receive Payment then moves that balance from Accounts Receivable into Undeposited Funds. Clicking Add in Banking to categorize the payout to Sales books revenue twice while stranding the original payment in Undeposited Funds.
Payment gateways, POS systems, and field CRMs batch customer payments together, enforce daily cutoffs, and hold ACH for 3 to 5 business days. Because they wire cash net of fees, refunds, and chargebacks, a $10,000 sales batch often lands at $9,710 after $290 in fees. QuickBooks will not auto-match without a Bank Deposit fee line or clearing account.
Under Level's monthly close controls, balances under $50 in a pass-through clearing account represent minor timing rounding. Any clearing account inactive for 30 days at $500+, 14 days at $5,000+, or reaching $10,000 anytime requires voucher-level reconciliation before closing.
Never bulk-delete historical customer payments or post a blind plug against Sales if prior years were already filed on Form 1120-S or Form 1065. Tie Aged Receivables Detail to the Balance Sheet first and verify each stranded item against bank statements by tax year. Clear current-year duplicates against duplicate income, and coordinate prior-year retained-earnings adjustments with your tax preparer.
Grow without losing control of the numbers
Drop your info and we’ll show your real margin across jobs, crews, products, and customers, where profit leaks to rework or hidden costs, and how much cash is sitting in unbilled work or inventory.
No commitment. Real numbers, not generic advice.