QuickBooks Online Undeposited Funds Clearing Review

August 24, 2026

Bottom line: tie every bank deposit to its Undeposited Funds source before the close packet goes to a reviewer, and keep any unmatched amount as a visible exception with a named owner.

Sidebar: Preparation and approval are separate steps. A VA prepares the tie-out. An authorized reviewer decides how exceptions are treated.

Why a clearing review matters for QBOAssistant work

Undeposited Funds is a holding account that reflects timing between receiving money and depositing it. When it is used consistently, a reviewer can trace a bank deposit back to one or more receipts, invoices, or sales receipts. When it is ignored, the account accumulates a balance that looks like missing income, duplicated income, or an unreconciled bank feed. For small businesses that collect checks, cash, or grouped merchant payouts, the risk is not just a balance. The risk is that a reviewer cannot answer whether all receipts made it to the bank, whether a deposit was recorded twice, or whether a receipt belongs to a prior period.

QBOAssistant clients often delegate daily receipt entry and deposit recording to a virtual assistant while the owner retains bank access and deposit decisions. A structured clearing review preserves the connection between those two roles. The VA documents the QuickBooks side. The bank record supplies the external proof. The owner answers the open question. Without that separation, a bookkeeper might clear a balance by journal entry or by moving amounts without documenting the source, which removes the very trail the owner needs for oversight.

Define the population before testing

Start with a report that shows the Undeposited Funds balance as of the review date. In QuickBooks Online this is typically the Balance Sheet detail for Undeposited Funds, filtered by date, plus the Deposit detail for the period. Export or save the population before changing anything. Record the preparation date, report filters, and the reviewer name. If the business uses class or location, record whether those dimensions are included. State explicitly what is included and what is excluded. For example, merchant fees netted inside a payout may be excluded from the deposit tie-out but included in a separate merchant fee review. That boundary note prevents a later reviewer from assuming the entire bank activity was tested.

Group deposits by bank deposit date and by QuickBooks deposit transaction. The useful grouping shows one bank line beside one or more QuickBooks receipt lines that were combined into that deposit. If the business batches cash and checks, the deposit may contain five or more source lines. If the business uses a payment processor, one bank line may map to many invoices net of fees. Decide the grouping logic before testing so the sample is comparable.

Assemble evidence for each deposit

For each deposit selected for review, capture the internal and external evidence side by side. Internal evidence includes the QuickBooks deposit transaction, the list of payments or sales receipts included, their dates, customers, payment methods, and amounts. External evidence includes the bank statement line or bank feed transaction, the deposit slip or remote capture image where available, and the merchant settlement report for processor deposits. Add the evidence location to the queue so a reviewer can find it without asking for a second export.

Check three matches. First, the sum of the QuickBooks source lines should equal the QuickBooks deposit amount. Second, the QuickBooks deposit amount should match the bank line amount, after considering documented bank fees that post separately. Third, the deposit date in QuickBooks should be consistent with the bank deposit date within the business's stated tolerance for timing. A difference within one business day may be expected for a check batch. A difference of five days signals a possible cutoff question.

Keep facts, exceptions, and proposed corrections in separate fields. The fact field records what the bank and the deposit show. The exception field names the specific mismatch: missing receipt, duplicate receipt, amount difference, date outside tolerance, or source not yet received. The decision field stays blank until the authorized reviewer completes it. This separation stops a prepared correction from being mistaken for an approved entry.

Handle the common exception patterns

Missing source is the most frequent exception. A deposit appears in QuickBooks but the reviewer cannot find a customer payment or sales receipt that should support it. Record the deposit ID, amount, date, and the attempted source search. Do not create a new receipt to match the deposit unless the source actually exists and the owner approves.

Undeposited Funds balance aging is the second pattern. The account holds a balance beyond the expected deposit cycle. Separate current items that are still within the normal float from aged items that should have cleared. Aged items may represent a receipt recorded twice, a deposit recorded without clearing Undeposited Funds, or a receipt that was never deposited. Assign each aged item an owner and a due date. Do not clear an aged balance with a generic adjustment when the underlying receipt or deposit is still unclear.

Amount mismatch is a third pattern. The QuickBooks deposit is 4,820 and the bank shows 4,790. Look for a bank fee, a short deposit, or an extra line included in QuickBooks that did not travel to the bank. If the difference is a fee, link the fee record. If it is a shortage, note it as outstanding and route it for research. If it is an extra line, remove the proposed inclusion from the review queue and flag it for correction rather than quietly editing the deposit.

Timing difference is common at period ends. A receipt dated July 31 deposited August 1 appears in the July Undeposited Funds balance but arrives in the August bank statement. That is expected behavior when the procedure is consistent. Record it as a timing item with the expected clearing date rather than as an error. The reviewer still needs to confirm that the July to August movement nets to zero in the next review.

Duplicate deposit risk appears when a receipt is recorded and the same payment is also created by a bank feed rule. The feed creates a second income line that looks like the same receipt. The clearing review should catch the duplicate because two QuickBooks receipts map to one bank amount. Preserve both record IDs and escalate for duplicate review instead of deleting one to make the queue look clean.

Build a review packet the owner can use

An effective packet fits on one working file with links. Include a cover sheet with business name, review date, prepared-by, reviewed-by, and scope. Add the population summary: opening Undeposited Funds balance, total receipts added to the account during the period, total deposits cleared, and closing balance. Add the exception table with one row per unmatched deposit or aged item. Each row should carry the QuickBooks deposit reference, bank reference, grouped receipt IDs, amounts, evidence location, exception type, impact statement, and owner.

Include a cutoff statement. Name the business day that defines the deposit cutoff and whether deposits in transit are expected at period end. This one sentence often resolves half the questions a reviewer would otherwise ask.

Add a handoff section with resolved items, items waiting on source, and items waiting on decision. Use simple statuses such as supported, missing source, amount difference, timing, duplicate suspected, or awaiting owner decision. Avoid closing an item with a vague label when the evidence is still missing.

Review cadence and follow up

For active businesses, a weekly clearing review keeps the exception count small. The VA prepares the tie-out each time deposits are recorded. The owner or bookkeeping lead reviews the exception table before the bank reconciliation. Before a month-end close, run the same packet with a period cutoff so any in-transit deposit is visible and not presented as a surprise. Archive the packet with the reconciliation and the bank statement export so a later reviewer or accountant can repeat the tie-out.

Quality checks for the reviewer include asking whether every bank deposit was tested to a QuickBooks deposit, whether every QuickBooks deposit maps to a bank line or an approved in-transit, whether every exception has an owner, and whether any adjustment was posted without an approved question being closed. Sampling should include both routine deposits and processor settlements.

Security practice matters. Deposit packets contain bank references and customer payment detail. Share them only with the approved reviewer, store them in the designated location, and avoid copying full bank account numbers into the review notes when a transaction ID and date are sufficient.

What good looks like

Good looks like a reviewer answering five questions in under ten minutes: what was deposited, what receipts support each deposit, what remains in Undeposited Funds and why, what timing items are expected to clear next period, and who owns each exception. The packet makes the operating decision easy without asking the VA to make an accounting determination or the owner to rebuild the file. That separation keeps QuickBooks Online records reconcilable while keeping authorization where it belongs.

Next step

Select one recent deposit week and pilot the clearing review. Use the current Balance Sheet detail for Undeposited Funds, group the bank and QuickBooks lines, record evidence locations, and name one owner for exceptions. Review the first exception table for clarity. Keep the fields that drove a decision, remove fields that produced noise, and reuse the approved template for the next review date. This disciplined start gives the client a repeatable control without turning routine deposits into a complex close project.