4.2 Receiving Customer Payments, Undeposited Funds / Payments to Deposit & Bank Deposits

Receiving Customer Payments, Undeposited Funds & Bank Deposits

Quick Answer: The QuickBooks Online "Money In" cycle relies on a standardized two-step workflow: Step 1 uses the Receive Payment form to record customer payments against open invoices, debiting the temporary clearing asset account Undeposited Funds (or "Payments to deposit") and crediting Accounts Receivable. Step 2 uses the Bank Deposit form to group individual payments into a single lump sum matching the physical bank statement deposit, debiting the Bank Account and crediting Undeposited Funds. Depositing payments directly to checking and then clicking "Add" on the bank feed causes catastrophic double-counting of revenue.

---

The Architecture of the Two-Step Workflow

In business operations, the way money is received from customers rarely matches the way money lands in a bank account. A business may receive three separate checks and two cash payments throughout a business day. At 4:00 PM, the office manager takes all five payments to the bank and deposits them together using a single bank deposit slip.

The bank processes this transaction as a single consolidated credit on the monthly bank statement.

If the bookkeeper had recorded each customer payment directly into the general ledger Checking account in QuickBooks Online, the software would show five separate transactions, while the bank statement (and the automated Bank Feed) would show a single aggregate total. Reconciling the account becomes cumbersome, error-prone, and confusing. To solve this, QuickBooks Online employs the Undeposited Funds clearing account.

┌─────────────────────────────────────────────────────────────────────────────┐
│                     The Two-Step Money In Workflow Architecture             │
├─────────────────────────────────────────────────────────────────────────────┤
│                                                                             │
│  STEP 1: RECEIVE PAYMENT                                                    │
│  Customer Check A ($500) ──┐                                                │
│  Customer Check B ($350) ──┼──► [Receive Payment] ──► [Undeposited Funds]   │
│  Customer Check C ($1,150)─┘    Dr Undeposited Funds      (Asset Clearing   │
│                                 Cr Accounts Receivable     Holds $2,000)    │
│                                                                             │
│  STEP 2: BANK DEPOSIT                                                       │
│  [Undeposited Funds] ─────────► [Bank Deposit Form] ──► [Checking Account]  │
│  Check A ($500)                 Check off payments        Single $2,000     │
│  Check B ($350)                 Dr Bank Checking          Bank Statement    │
│  Check C ($1,150)               Cr Undeposited Funds      Line Item         │
│                                                                             │
└─────────────────────────────────────────────────────────────────────────────┘

---

Step 1: The Receive Payment Transaction

When a customer remits payment for an outstanding credit sale, the transaction must be entered using the Receive Payment form (navigated via + New > Customers > Receive payment or by clicking Receive payment directly from the Customers list or an open invoice).

Form Mechanics and Field Analysis

1. Customer: Selecting the customer immediately triggers QBO to query the open Accounts Receivable subledger. All unpaid invoices, unapplied credit memos, and opening balances for that customer populate the Outstanding Transactions table.
2. Payment Date: The date the payment was received. This date controls aging reports.
3. Payment Method: Designates how the client paid (e.g., Check, Cash, American Express, Visa, ACH).
4. Reference No.: Captures the customer's physical check number or electronic transaction confirmation ID.
5. Deposit To (The Crucial Fork):
   • Undeposited Funds (Payments to deposit): The standard best-practice destination. Directs the receipt into the temporary clearing account until batched.
   • Specific Bank Account (e.g., Checking): Should only be selected if the payment was an isolated wire transfer or direct ACH deposit that landed as an individual, unbatched line item on the bank statement.
6. Outstanding Transactions Table: Users check off the specific invoices being satisfied. QBO supports partial payments: editing the Payment column allocates a partial amount, leaving the remaining balance open on the invoice.

General Ledger Accounting Impact of Step 1

$\text{Debit: Undeposited Funds (Other Current Asset)} \quad \Longleftrightarrow \quad \text{Credit: Accounts Receivable (Current Asset)}$

Exam Warning: The Receive Payment transaction does not record income. Income was already recognized when the invoice was generated under accrual accounting. Receive Payment simply converts one asset (Accounts Receivable) into another asset (Undeposited Funds).

---

Step 2: The Bank Deposit Transaction

Once physical funds are deposited at the bank, or when a credit card merchant processor settles a daily batch, the user must record a Bank Deposit (navigated via + New > Other > Bank deposit).

Form Mechanics

• Account Header: Select the target physical bank account (e.g., Business Checking 1010) and enter the official deposit date.
• Select the payments included in this deposit: This table displays every transaction currently sitting in Undeposited Funds across the entire company (including received customer payments and point-of-sale sales receipts).
• Grouping Action: The user checks the boxes next to each individual payment that was included in the physical bank deposit.

┌─────────────────────────────────────────────────────────────────────────────┐
│ Bank Deposit Screen: Business Checking 1010            Date: 10/15/2026     │
├─────────────────────────────────────────────────────────────────────────────┤
│ Select the payments included in this deposit:                               │
│ [X] 10/14/2026  Acme Corp      Check #4102   Undeposited Funds   $500.00    │
│ [X] 10/14/2026  Baker LLC      Check #8819   Undeposited Funds   $350.00    │
│ [X] 10/15/2026  Crown Inc      Check #104    Undeposited Funds $1,150.00    │
│ [ ] 10/15/2026  Delta Co       Cash          Undeposited Funds   $400.00    │
├─────────────────────────────────────────────────────────────────────────────┤
│ Total Selected Payments (3): .................................. $2,000.00   │
└─────────────────────────────────────────────────────────────────────────────┘

General Ledger Accounting Impact of Step 2

$\text{Debit: Bank Account (Checking Asset)} \quad \Longleftrightarrow \quad \text{Credit: Undeposited Funds (Asset Clearing)}$

Upon saving, the $2,000 balance in Undeposited Funds is relieved back to $0.00, and a single $2,000 debit appears in the checking account register. When the Bank Feed downloads the $2,000 deposit from the bank, QuickBooks Online recognizes the identical amount and date, displaying a bright green Match banner.

---

The Deadly Bank Feed Trap: Double-Counted Income

One of the most catastrophic errors tested on the ProAdvisor certification exam involves the collision between manual accounts receivable entries and automated bank feeds.

How the Error Occurs (The 4-Step Trap)

1. Step 1 (The Sale): An invoice is issued to a client for $5,000.00.
   • GL Impact: Dr Accounts Receivable $5,000 / Cr Sales Income $5,000.
   • Income Statement: Revenue = $5,000.
2. Step 2 (The Payment): Customer sends a $5,000 check. The bookkeeper uses Receive Payment and chooses Checking in the "Deposit to" field.
   • GL Impact: Dr Checking $5,000 / Cr Accounts Receivable $5,000.
   • Bank Register Balance: +$5,000.
3. Step 3 (The Bank Feed Download): Three days later, the real bank clears the check. The bank feed downloads a credit transaction: +$5,000.00 Deposit.
4. Step 4 (The Blunder): Instead of matching the downloaded transaction to the recorded payment, an untrained clerk clicks Add and selects Sales Income as the category!
   • Bank Feed Addition GL Impact: Dr Checking $5,000 / Cr Sales Income $5,000.

                     THE DOUBLE-COUNTING DISASTER

   Transaction Recorded        Income Recognized     Checking Account Balance
   ──────────────────────────────────────────────────────────────────────────
   Invoice #101                    $5,000.00                  $0.00
   Receive Payment (to Checking)       $0.00              $5,000.00
   Bank Feed "Added" as Income     $5,000.00              $5,000.00 (Duplicate!)
   ──────────────────────────────────────────────────────────────────────────
   TOTAL ON FINANCIAL STATEMENTS: $10,000.00             $10,000.00
   ACTUAL ECONOMIC VALUE:          $5,000.00              $5,000.00
   VARIANCE / DISTORTION:         +$5,000.00 (OVERSTATED)+$5,000.00 (OVERSTATED)

The Remedy and Prevention

• Match, Never Add: Whenever a deposit represents customer invoice collections, the bank feed transaction must always be Matched to the existing Bank Deposit or Receive Payment.
• Audit Technique: If a client's Profit & Loss shows unexpectedly high income while the bank reconciliation has dozens of uncleared deposits in the register, run the Profit and Loss (Accrual vs. Cash) and check for duplicate revenue classifications in the general ledger.

---

Handling Merchant Processing Fees & Deposit Adjustments

Third-party payment processors (e.g., Stripe, Square, PayPal, Shopify Payments) collect funds from customers, subtract a transaction processing fee, and remit the net balance to the business checking account.

The Accounting Challenge

• Gross customer payments received: $2,000.00.
• Processor transaction fee (2.5%): -$50.00.
• Net bank deposit: $1,950.00.

If the user attempts to match the $1,950.00 bank feed deposit directly against the $2,000.00 invoice payments in Undeposited Funds, QBO will not match because the amounts differ by $50.00.

The Correct Bank Deposit Solution

QuickBooks Online resolves this using the "Add other funds to this deposit" (or Add funds to this deposit) table located at the bottom of the Bank Deposit screen:

1. In the top table (Select the payments included in this deposit), check the boxes for all customer payments comprising the batch (totaling $2,000.00).
2. Scroll down to the Add other funds to this deposit grid.
3. Enter the following line:
   • Received From: Select the merchant processor vendor (e.g., Stripe or Square).
   • Account: Select an expense account, typically Bank Charges & Merchant Fees (Expense).
   • Description: Merchant processing fee deduction.
   • Payment Method: Electronic / Processing Fee.
   • Amount: Enter -50.00 (a negative number).
4. Notice the Total Deposit calculation at the bottom right: $\$2,000.00 \text{ (Payments)} + (-\text{\$50.00 fee}) = \mathbf{\$1,950.00}$
5. Save the deposit. The net QBO deposit is now $1,950.00, which matches the physical bank feed deposit to the penny!

┌─────────────────────────────────────────────────────────────────────────────┐
│                     Bank Deposit Merchant Fee Resolution                    │
├─────────────────────────────────────────────────────────────────────────────┤
│ Select Payments:                                                            │
│   [X] Customer A: $1,200.00 | [X] Customer B: $800.00 ....... Subtotal: $2,000.00│
│                                                                             │
│ Add Other Funds to This Deposit:                                            │
│   Received From: Stripe Processor                                           │
│   Account:       Bank Charges & Merchant Fees (Expense)                     │
│   Amount:       -$50.00                                      Adjustment:-$50.00 │
├─────────────────────────────────────────────────────────────────────────────┤
│ NET DEPOSIT POSTED TO CHECKING: ..............................    $1,950.00 │
└─────────────────────────────────────────────────────────────────────────────┘

Other Uses for "Add other funds to this deposit"

• Cash Back: Taking cash out of a physical bank deposit for petty cash (enter a negative line mapped to Petty Cash).
• Owner Capital Contributions: Adding an owner equity check into the company bank account alongside customer receipts (enter a positive line mapped to Owner Investment / Equity).
• Vendor Rebates & Refunds: Banking a vendor refund check without linking it to a bill (enter a positive line mapped to the original Expense account).