Undeposited Funds is a holding account in QuickBooks that sits between receiving a customer payment and recording the bank deposit. Intuit's help documentation describes it as an account that holds customer payments until you deposit them at your real-life bank, and compares it to the drawer or lockbox where payments wait before someone takes them to the branch.
It is classified as an Other Current Asset. It is not a bank account, which is why QuickBooks offers no reconcile function for it. Intuit's documentation states that all payments sitting in Undeposited Funds automatically appear in the Bank Deposit window, ready to be grouped.
The account solves a matching problem that predates ecommerce.
A retail shop takes eleven payments on Tuesday: four checks, six card swipes, one cash. On Wednesday the owner walks the checks and the cash to the bank as one deposit. The bank statement shows one line. QuickBooks, if each payment posted directly to the bank account, would show eleven.
Undeposited Funds lets you record eleven payments against eleven invoices, then group them into one deposit record matching the one line the bank will show. Customer detail is preserved and the reconciliation still works.
That is the whole idea. Individual receipt, grouped deposit.
Marketplace and cart selling breaks the shop analogy, and the account starts collecting things it was never meant to hold.
Payments recorded without a matching deposit. If a connector or a manual process posts sales receipts to Undeposited Funds but nobody ever groups them into a deposit, the balance grows forever. It is the most common form of the problem and the easiest to spot.
Duplicate payment records. A payment entered manually and then imported again lands twice. One version clears in a deposit and the other sits in Undeposited Funds indefinitely.
Net versus gross confusion. Marketplace deposits arrive net of fees. If the payment recorded was gross and the deposit recorded was net, the difference is stranded. Do that weekly for a year and the residue is substantial.
Refunds and chargebacks posted to the wrong side. A refund recorded as a negative payment into Undeposited Funds rather than as a reduction of revenue produces a balance that no deposit will ever clear.
For a business that genuinely receives payments and deposits them in batches, a small balance at any moment is normal. It represents money received but not yet taken to the bank. It should clear within days.
For a marketplace-first ecommerce business, the honest answer is that the account should usually be near zero. You are not physically carrying checks to a branch. Money arrives as an ACH from a platform, already netted, on a schedule the platform controls. There is no batching step for the account to represent.
If your Undeposited Funds balance has a five-figure number in it and you sell exclusively through Amazon, Shopify, Walmart, eBay, or TikTok Shop, that is not a timing difference. It is a pile of errors with a date range.
A Shopify seller records daily sales receipts into Undeposited Funds at gross order value, then records each payout as a deposit at the net amount, without accounting for the difference.
Take one week in July 2026:
| Day | Gross recorded | Payout deposited | Stranded |
|---|---|---|---|
| Mon | 12,480.00 | 11,742.20 | 737.80 |
| Tue | 9,915.00 | 9,326.90 | 588.10 |
| Wed | 14,220.00 | 13,376.60 | 843.40 |
| Thu | 11,060.00 | 10,404.00 | 656.00 |
| Fri | 18,340.00 | 17,251.60 | 1,088.40 |
| Sat | 15,780.00 | 14,843.20 | 936.80 |
| Sun | 10,205.00 | 9,599.40 | 605.60 |
| Total | 92,000.00 | 86,543.90 | 5,456.10 |
$5,456.10 stranded in one week. Annualized at the same rate, roughly $284,000 accumulates in an account that should hold nothing.
The stranded amount is not a mystery. It is processing fees and refunds that were never booked to an expense or contra revenue account. Which means two things are wrong at once: Undeposited Funds is overstated by $5,456.10, and merchant processing expense is understated by the same amount. Gross margin looks better than it is, every week, permanently.
The fix is not to journal the balance away. The fix is to record the fees and refunds where they belong, so each deposit entry fully clears the sales it relates to.
Correcting payments that were already deposited or reconciled requires care, because touching a reconciled period changes prior financial statements. Intuit publishes specific guidance for that situation, and it is worth following rather than improvising. If the period is closed and filed, involve your CPA before editing anything.
Can I just delete the Undeposited Funds account?
No. It is a default account in QuickBooks and the software uses it automatically for sales receipts and certain payment types. You can stop routing payments through it, but the account stays.
Why can I not reconcile Undeposited Funds?
Because it is not a bank account. There is no external statement to reconcile it against. You verify it by inspecting the detail, not by reconciling.
Should an ecommerce seller use it at all?
Usually not for marketplace payouts. A payout is already a batch. Recording the sales and the fees directly against a clearing account per channel is cleaner and makes the balance meaningful. Reserve Undeposited Funds for the cases it was built for: physical payments you actually carry to a bank.
Is a large balance always an error?
Not always, but for a marketplace seller it usually is. A wholesale business collecting checks might legitimately carry a balance for a few days. A business whose entire revenue arrives by ACH from platforms should not.
Undeposited Funds problems are almost always a symptom of a recording method that does not match how the money actually moves. When each channel's payout is decomposed into its real components and posted against a per-channel clearing account, the holding account has nothing to accumulate.
That is how ConnectBooks posts marketplace activity into QuickBooks and Xero, including Shopify into QuickBooks Online and eBay, with entries that tie to the deposit and stand behind an accuracy guarantee. The wider QuickBooks integrations set and the accounting overview cover the rest of the structure.
Running an e-commerce business comes with plenty of challenges, but ConnectBooks is here to make your life easier. With real-time insights, seamless integrations, and detailed tracking of your profitability and inventory, you can stay ahead of the game. Whether you’re selling on Amazon, Shopify, Walmart, TikTok or eBay, ConnectBooks helps you manage your finances with 100% accuracy and confidence, so you can focus on growing your business.
Ready to level up? Start making smarter, data-driven decisions every step of the way. Try ConnectBooks Free Today or Schedule a Demo
