Undeposited Funds QuickBooks: clear stuck Amazon and Walmart deposits

Undeposited Funds QuickBooks setups break down fast for marketplace sellers. You record Amazon, Walmart or eBay sales as sales receipts that land in Undeposited Funds, then wait for the bank feed to offer a match. Instead you see a single Amazon deposit for a smaller net amount, and none of the open receipts add up to it. The balance sheet shows a growing Undeposited Funds total that never clears, while the bank account is already correct. The mismatch is structural: Undeposited Funds expects you to deposit the same dollars you recorded as receipts, and marketplace payouts are net settlements, not piles of customer checks.

Undeposited Funds QuickBooks: what the account is for

In QuickBooks Online, Undeposited Funds is a default other-current-asset account. When you create a sales receipt or receive payment on an invoice and choose Undeposited Funds as the deposit-to account, the money sits there until you create a Bank Deposit. On the Bank Deposit screen you tick several payments, add them up, and post one deposit that should equal the amount that hits your bank the same day. That workflow is excellent for a retail shop that walks a stack of checks to the bank, or for a service business that batches Stripe payouts that already match the receipt total one for one.

The account is temporary by design. After you deposit the selected payments, Undeposited Funds for those lines goes to zero, and the bank account rises by the same amount. If something is left behind, either you forgot to include a payment in the deposit, or you recorded a payment that never actually arrived. The Match and Find features in the bank feed look for open Undeposited Funds lines that equal the bank amount. When they do, the books stay clean with almost no journal work.

None of that assumes fees come out of the deposit before it lands. The assumption is that the sum of the receipts equals the bank line. Marketplace settlements break that assumption every time.

Why marketplace sellers end up stuck in Undeposited Funds

Many Amazon and multi-channel sellers start with a familiar pattern. An order sync app pushes each order into QuickBooks as a sales receipt. The receipt credits sales income and debits Undeposited Funds for the order total. It feels complete: revenue is in the P&L, and cash is waiting in Undeposited Funds for the Amazon transfer. Then the bank feed shows an Amazon ACH for far less than the sum of those receipts, and Match offers nothing useful.

Three things make the gap inevitable:

1. The deposit is a settlement, not a batch of receipts. Amazon groups roughly two weeks of activity into one disbursement. That disbursement is the net of product sales, shipping credits, refunds, referral fees, FBA fees, advertising charged to the balance, storage, subscriptions, reimbursements and reserve movements. One bank line covers hundreds of orders and dozens of charge types.
2. Gross sales receipts ignore fees and refunds. If each sales receipt only recorded the customer order total, Undeposited Funds is overstated by every fee and refund that Amazon subtracted before paying you. The bank is right; Undeposited Funds is incomplete.
3. Timing and period mixing. Refunds in this settlement may belong to sales from an earlier period. A reserve held this period may release next period. Trying to tick open receipts until they somehow equal the deposit forces you to leave some receipts forever unmatched or to write off the difference as a vague "Amazon fees" expense.

Walmart Marketplace and eBay payouts follow the same net-settlement logic. Shopify or Stripe payouts that land as net amounts create a similar trap when receipts sit in Undeposited Funds at the gross order total. The account name sounds like the right place for "money that has not hit the bank yet," but for marketplaces the better holding place is a dedicated clearing account that is allowed to carry the net amount, not the gross.

Marketplace clearing account vs Undeposited Funds

A marketplace clearing account is usually an other-current-asset account named something like "Amazon Clearing," "Walmart Clearing" or "Marketplace Clearing." You post one summarized journal entry per settlement that puts the total paid into clearing as a debit, records sales, refunds, fees and reserves on the other side, and then matches the bank deposit against clearing for the same amount. When the match posts, clearing for that settlement returns to zero. That zero balance is your proof that the entry and the bank agree.

Compare that to Undeposited Funds:

You can still use Undeposited Funds for true customer checks, cash, or any channel where the money you recorded is the money you deposit. Keep marketplace settlements out of it. Mixing both workflows in one Undeposited Funds balance is how sellers end up with a five-figure suspense account and a bank feed that never matches.

For the full posting pattern through clearing, see the step-by-step settlement reconciliation guide. The Amazon to QuickBooks integration page shows how ClearPayout posts that same pattern automatically.

Scenario: bank deposit vs stuck Undeposited Funds

Walk through a concrete situation. A seller has recorded Amazon sales receipts into Undeposited Funds for a two-week period. The open Undeposited Funds lines for those receipts total 10,000. Amazon's settlement for the same period shows a total paid of 4,700, and that exact amount lands in the bank feed as an Amazon transfer. Nothing in Undeposited Funds equals 4,700. The Match tab is empty. Someone previously categorized a few Amazon deposits to "Sales" or "Owner's draw" just to clear the bank, which made Undeposited Funds grow while income was either double-counted or never tied to the settlement.

An illustrative summary of that settlement (round numbers for arithmetic only):

Undeposited Funds still holds 10,000 of gross receipts. The bank has 4,700. No combination of open receipts will equal the deposit without inventing a plug. The fix is to stop treating those receipts as depositable cash and to record the settlement the way Amazon paid it.

Steps to clear stuck Undeposited Funds for marketplace deposits

Work one settlement at a time. Do not try to clear months of Undeposited Funds in a single bank deposit screen.

1. 1

   Confirm the settlement and the bank line

   In Seller Central (or the equivalent for Walmart/eBay), open the settlement whose total paid equals the bank deposit to the cent. Note the settlement ID, period dates and total paid. If the bank amount does not match any settlement total, resolve timing, split deposits or the wrong bank account first.
2. 2

   Stop new marketplace sales from hitting Undeposited Funds

   Change the order sync mapping so Amazon (and other marketplace) sales no longer deposit to Undeposited Funds. Future settlements should post summarized to clearing, not as per-order receipts into Undeposited Funds.
3. 3

   Identify open Undeposited Funds lines for that settlement period

   Filter Undeposited Funds by date range that overlaps the settlement. Decide with your accountant whether to void, delete or reclassify those sales receipts so they are not left as open depositable payments. Keeping both the old receipts and a new settlement entry double-counts income.
4. 4

   Create or confirm a marketplace clearing account

   Add an other-current-asset account such as Amazon Clearing if you do not have one. Use a separate clearing account per major marketplace if you sell on more than one.
5. 5

   Post one balanced journal entry for the settlement

   Credit sales income, debit refunds (or a contra-income account), debit fee and advertising accounts, debit a reserve or receivable account for amounts held, and debit clearing for the total paid. Put the settlement ID in the memo.
6. 6

   Match the bank deposit to clearing

   In the bank feed, match or categorize the Amazon deposit against Amazon Clearing for the same amount. Clearing for that settlement should now be zero.
7. 7

   Review remaining Undeposited Funds

   Anything still open should be true undeposited customer payments, not marketplace orders. If marketplace lines remain, repeat the process for the next settlement until Undeposited Funds only holds what you actually intend to deposit as cash or checks.

In journal-entry form, the example settlement looks like this:

Account names are examples; use the chart of accounts your accountant has set up. After you match the 4,700 bank deposit to Amazon Clearing, that clearing line is cleared and Undeposited Funds is no longer asked to absorb a net settlement it was never built for.

Common mistakes when cleaning Undeposited Funds

A few shortcuts look fast and create harder cleanup later:

• Creating a Bank Deposit that mixes Marketplace Clearing with random Undeposited Funds lines. The deposit total may match the bank by coincidence, but you lose the one-settlement-one-zero proof that clearing is meant to give you.
• Writing the entire Undeposited Funds balance off to "Amazon fees" or "Miscellaneous expense." That hides which settlements were never recorded and usually misstates both income and expenses for the period.
• Matching the Amazon deposit directly to Sales Income. You clear the bank feed, but fees, refunds and reserves never hit the books, and Undeposited Funds stays inflated.
• Leaving old sales receipts open "for history" while also posting settlement journals. Income is counted twice. Pick one source of truth per settlement period with your accountant.
• Using one Undeposited Funds balance for Amazon, Walmart, eBay and real customer checks. Separate clearing accounts per marketplace keep each settlement identifiable.

If you already categorized past Amazon deposits to income or expense just to clear the feed, rebuild from the settlement report for those periods rather than adjusting the bank lines again. The settlement ID is the anchor; the bank line should only confirm the total paid.

Keeping Undeposited Funds clean going forward

Once the stuck balance is cleared, the ongoing rule is simple: Undeposited Funds for payments that equal the bank deposit; marketplace clearing for net settlements. Train anyone who records sales to ask which channel the money comes from before choosing the deposit-to account. In QuickBooks Online, default deposit-to settings on sales receipt templates and payment methods are easy to leave pointing at Undeposited Funds after an accountant set them up for a different business model years ago. Review those defaults when you add Amazon or Walmart.

Each payout still needs a download, a summary by type, a journal entry and a match if you do it by hand. A seller with Amazon alone often has two settlements a month; add Walmart or eBay and the count rises quickly. That repetition is what ClearPayout automates: it reads each Amazon settlement, maps buckets to your QuickBooks accounts once, and posts one balanced entry per settlement with the settlement ID in the memo so the deposit matches clearing without parking anything in Undeposited Funds. You can see the posting flow on the Amazon to QuickBooks integration page, and plans with a 14-day trial are on the pricing page. If you are comparing settlement tools, the A2X comparison outlines how the approaches differ.

Whether you automate or continue by hand, do not ask Undeposited Funds to hold marketplace net payouts. Use clearing, match the deposit to clearing, and leave Undeposited Funds for the payments that really will equal the next trip to the bank.