Reconciling NetSuite Undeposited Funds

Reconcile Undeposited Funds by tracing each recorded receipt to a supported bank deposit or another approved resolution. Explain the timing between receipt, deposit preparation and bank posting. An old balance should be investigated before creating another deposit, because the cash may already be recorded through a different route.

This guide focuses on the Undeposited Funds account and its payment-to-deposit trail. It is separate from customer deposits held as liabilities and from provider-specific settlement accounting. Ask your controller to approve corrections, fees, foreign-currency treatment and changes affecting a closed or reconciled period.

Understand what the account represents

Oracle's Making Deposits guidance explains that recording a deposit moves selected funds from Undeposited Funds to the bank ledger. Payments posted directly to a bank account do not need another deposit for those amounts.

That distinction is the first investigation step. Determine whether each payment method or integration posts to Undeposited Funds, directly to the bank or through a separate clearing account. Do not assume all receipts use the same route.

A paid invoice answers an AR question. It does not by itself prove that the receipt has been deposited, matched to bank evidence or reconciled to a statement. Keep those checkpoints visible without creating duplicate cash transactions.

Fix the scope and cutoff

Record the account, subsidiary, book and as-of date used for the reconciliation. Obtain the ledger balance and transaction activity for the same scope.

Define the expected deposit cycle by receipt type. Physical checks, cash and processor settlements can have different timing. A receipt recorded late on the final day of a period may legitimately reach the bank in the next period.

Preserve subsequent deposit evidence for those timing items. A reviewer should be able to confirm that the period-end balance existed and then cleared as expected, rather than relying on a current report that has already changed.

Build the payment-to-deposit bridge

List original receipt identifier, date, customer or source, amount, currency, deposit identifier and bank reference where available. Add the remaining unresolved amount and a reason.

For deposits combining several receipts, reconcile the component total to the deposit and then to the bank statement. Keep the grouping identifier so the same payments cannot be included twice in a manual workpaper.

Validate any saved-search joins with known examples. A deposit may have several lines and a payment may have application relationships that multiply rows. Prove that the report counts each cash movement once before relying on its grand total.

Classify unresolved balances by cause

Useful categories include receipt awaiting physical deposit, deposit recorded after cutoff, payment posted to the wrong route, duplicated receipt, missing deposit record, bank deposit already recorded separately and unresolved returned payment.

Do not label every nonzero balance “cash not deposited.” Some items can be accounting or integration errors even when the bank received the money. The reason should determine the next evidence to obtain.

Assign operations to physical cash or check custody questions, AR to receipt identification, treasury to bank evidence and finance to accounting corrections. A single generic owner can coordinate the review, but the supporting facts usually come from several teams.

Hypothetical example of a combined deposit

A business records three checks for 1,200, 1,850 and 950 to Undeposited Funds. The bank statement later shows a 4,000 deposit. The reconciliation should connect all three receipts to one supported deposit record and that bank line.

Now suppose treasury manually entered a 4,000 bank deposit without selecting the underlying receipts. The bank ledger may show the cash while the original payments remain in Undeposited Funds. Creating another 4,000 deposit without investigating would duplicate the bank-side cash record.

Finance must inspect the existing transaction and approve the correction that preserves one receipt-to-bank trail. The example is hypothetical and intentionally does not prescribe a journal entry without knowing the account configuration.

Handle net settlements and fees deliberately

A payment provider may settle several gross receipts after fees, refunds or adjustments. The amount reaching the bank can therefore differ from the sum of customer payments.

Use the provider's settlement evidence to explain the bridge. Identify which fees or adjustments belong to the batch and how they are recorded under your accounting policy. Do not reduce customer payments merely to make them equal the net bank deposit.

Where a dedicated provider-clearing process already owns the reconciliation, avoid creating a competing Undeposited Funds routine. Map the handoff and establish which account holds each timing difference. Provider-specific settlement rules require their own documentation and tests.

Investigate old and negative items

Prioritize receipts that exceed the expected deposit cycle, items linked to inactive customers and balances with no supporting payment evidence. Review negative balances separately, since they may indicate an over-clearing or correction issue.

For returned checks or reversed receipts, trace the original deposit, bank return and customer-account effect. The cash and receivable consequences must both be understood. A bank rejection should not leave the customer's invoice falsely settled.

Avoid clearing old balances with a single unexplained journal. Any approved adjustment should retain the underlying item list, cause, account treatment and reviewer. A zero account balance is insufficient if the source transactions still imply money awaiting deposit.

Control changes to reconciled deposits

Before editing a deposit, inspect its statement-reconciliation status and the period affected. Oracle's Making Deposits page describes different effects for changes to amount and changes to account, so do not assume every edit automatically resets reconciliation in the same way.

Have the owner review the bank account, deposit date, posting period and selected payment lines after a correction. Reperform the relevant statement check and document the effect on prior close evidence.

Limit correction access to appropriate roles. A well-intended account change can move cash between entities or accounts and leave a misleading reconciliation status if nobody checks the complete result.

Maintain a monthly close package

Keep the ledger balance, payment-to-deposit bridge, aged unresolved items, subsequent clearing evidence and approved adjustments. Distinguish real cash in transit from missing records and duplicate postings.

Track new exceptions and resolved exceptions by cause. Repeated missing deposits may require a daily treasury task, while repeated duplicated receipts point to transaction ownership or integration retry design.

For account-specific deposit behavior and reporting, CuriousRubik's NetSuite support services can help trace representative items. Bring the customer payment, deposit and bank statement evidence together.

Frequently asked questions

Is Undeposited Funds the same as Customer Deposits?

No. Undeposited Funds tracks a cash-processing stage; customer deposits can represent advances held as liabilities. Review the actual transaction and account rather than relying on the word deposit.

Should every customer payment have a deposit record?

Oracle says payments posted directly to the bank do not need another deposit. Confirm the payment's actual posting route before creating anything.

Does an old balance prove the cash never reached the bank?

No. The bank receipt may already be recorded separately, or the original payment may be duplicated. Compare the source transaction and bank evidence first.

How should a net processor settlement be reconciled?

Bridge gross receipts, refunds, fees and adjustments to the net bank amount using the provider's evidence and approved accounting treatment.

What is a satisfactory month-end result?

An explained balance supported by identifiable cash-in-transit items and controlled exceptions. The account does not have to be zero when legitimate timing differences remain.