6.1 Sales Workflows: Estimates, Invoices, Sales Receipts & Customer Payments
Key Takeaways
- Estimates are non-posting transactions used to provide formal quotes to customers; converting an estimate into an invoice or progressive invoice establishes a posting transaction that debits Accounts Receivable and credits Income.
- Invoices represent sales on credit where payment is deferred (Debit Accounts Receivable, Credit Income and Sales Tax Payable), whereas Sales Receipts record sales where payment is collected immediately at the point of sale (Debit Undeposited Funds/Bank, Credit Income and Sales Tax Payable).
- Credit Memos reduce an open invoice balance or create an unapplied customer credit balance (Debit Sales Returns/Income, Credit Accounts Receivable), while Refund Receipts disburse funds directly back to a customer from a bank or credit card account.
- The Receive Payment workflow must be used to record collections against open invoices (Debit Undeposited Funds/Bank, Credit Accounts Receivable); recording bank deposits directly from the bank feed without matching against open invoices results in severe revenue duplication.
- Undeposited Funds (labeled 'Payments to deposit' in modern QBO) functions as a temporary clearing account that aggregates multiple individual payments into a single consolidated bank deposit matching the physical bank statement.
6.1 Sales Workflows: Estimates, Invoices, Sales Receipts & Customer Payments
Core Principle: In QuickBooks Online (QBO), the sales workflow is governed by the timing of customer payment. When payment is deferred, bookkeepers must execute the two-step Invoice -> Receive Payment workflow to track Accounts Receivable. When payment is received immediately, a one-step Sales Receipt is utilized. To preserve general ledger integrity, all cash and check receipts must pass through the Undeposited Funds clearing account before being batched into a Bank Deposit.
The QBO Sales Workflow Architecture
Every commercial sales transaction in QuickBooks Online begins with an economic exchange between a business and its customer. QBO provides specialized transaction forms tailored to whether the customer pays at the time of sale, receives credit terms, or requests a price quote prior to purchase.
Understanding the distinction between posting transactions (which modify the General Ledger, Balance Sheet, and Income Statement) and non-posting transactions (which serve solely as operational tracking records) is foundational for every Certified Public Bookkeeper.
+-------------------------------------------------------------------------------------------------+
| QBO SALES WORKFLOW: MONEY-IN PATHWAYS |
+-------------------------------------------------------------------------------------------------+
| PATHWAY A: SALES ON CREDIT (Deferred Customer Payment) |
| [Estimate] (Non-Posting) |
| │ |
| ▼ |
| [Invoice] (Posting) ──► DR Accounts Receivable / CR Revenue & Sales Tax Payable |
| │ |
| ▼ |
| [Receive Payment] (Posting) ──► DR Undeposited Funds / CR Accounts Receivable |
| │ |
| ▼ |
| [Bank Deposit] (Posting) ──► DR Checking Account / CR Undeposited Funds |
+-------------------------------------------------------------------------------------------------+
| PATHWAY B: POINT-OF-SALE / IMMEDIATE PAYMENT (Cash, Check, Credit Card at Time of Sale) |
| [Sales Receipt] (Posting) ──► DR Undeposited Funds / CR Revenue & Sales Tax Payable |
| │ |
| ▼ |
| [Bank Deposit] (Posting) ──► DR Checking Account / CR Undeposited Funds |
+-------------------------------------------------------------------------------------------------+
Estimates & Progress Invoicing
An Estimate (historically called a quote or bid) is a formal proposal sent to a prospective or existing customer detailing the products, services, quantities, and prices offered.
Non-Posting Status & Lifecycle
Estimates are strictly non-posting. Creating, saving, or emailing an estimate has zero financial impact on the General Ledger, does not affect the Accounts Receivable balance, and does not recognize revenue on the Income Statement.
Estimates move through four sequential operational statuses in QBO:
- Pending: The estimate has been drafted and issued to the client, awaiting customer review.
- Accepted: The customer has formally approved the estimate. (This status can be updated manually or automatically when the client accepts via the QBO client portal).
- Closed: The estimate has been converted into one or more invoices.
- Rejected: The client declined the quote. Rejected estimates remain in QBO for historical analytics but cannot be converted.
Progress Invoicing Mechanics
For long-term contracts, construction projects, or phased professional service engagements, QBO supports Progress Invoicing (enabled under Account and Settings > Expenses/Sales > Progress Invoicing). Progress invoicing allows a bookkeeper to convert an accepted estimate into multiple incremental invoices over the life of a project.
When converting an estimate to an invoice, QBO presents three progress billing options:
- Remaining Total of All Lines (100%): Invoices the entire unbilled portion of the estimate.
- A Percentage of Each Line: Invoices a uniform percentage (e.g., 25% or 50%) across all line items.
- A Custom Amount for Each Line: Allows the bookkeeper to enter specific quantities or dollar amounts for selected milestones completed during the billing period.
QBO automatically updates the original estimate with the cumulative billed amount, remaining unbilled balance, and percentage complete, preventing over-invoicing errors.
Invoices vs. Sales Receipts: Comparative Mechanics
The choice between an Invoice and a Sales Receipt depends entirely on when payment is collected relative to the delivery of goods or performance of services.
| Operational Dimension | Invoice (+ New > Invoice) | Sales Receipt (+ New > Sales Receipt) |
|---|---|---|
| Payment Timing | Deferred: Goods/services delivered now; payment collected later. | Immediate: Payment collected simultaneously at point of sale. |
| Customer Terms | Requires terms (e.g., Net 15, Net 30, Due on Receipt). | No terms; payment method specified immediately. |
| Posting Impact | DR Accounts Receivable<br>CR Sales/Revenue<br>CR Sales Tax Payable | DR Undeposited Funds (or Bank)<br>CR Sales/Revenue<br>CR Sales Tax Payable |
| Sub-Ledger Impact | Increases Customer Open AR Balance. | No impact on Customer AR balance. |
| Next Required Step | Must execute Receive Payment when funds arrive. | Must execute Bank Deposit (if routed to Undeposited Funds). |
| Standard Use Cases | B2B consulting, wholesale supply, contractor billing. | Retail store sales, ecommerce cash sales, on-the-spot service calls. |
Product & Service Item Mapping
Neither Invoices nor Sales Receipts post directly to general ledger accounts from the transaction header. Instead, every line item links to a Product or Service Item from the Products and Services list (Gear > Products and Services).
Behind each item configuration lies an underlying Income Account (e.g., Service Income or Merchandise Sales). When the bookkeeper selects "Consulting Services" on an invoice, QBO looks up the item configuration and automatically posts the credit to the designated revenue account.
Step-by-Step Posting Walkthrough: The Credit Sales Cycle
To illustrate the exact double-entry flow across the sales cycle, consider a commercial engagement with Apex Manufacturing:
- May 10: Issued Invoice #1042 to Apex for $5,000 of engineering services plus 8% state sales tax ($400), payment terms Net 30.
- May 28: Received a physical paper check (#8831) for $5,400 from Apex.
- May 30: Deposited check #8831 alongside another cash receipt of $600 into the operating checking account.
TRANSACTION STEP 1: ISSUING THE INVOICE (May 10)
General Journal Impact:
Date Account Titles and Explanation Debit Credit
May 10 Accounts Receivable - Apex Manufacturing .... $5,400
Engineering Service Revenue ............. $5,000
Sales Tax Payable (State Dept of Rev) ... $400
(To record Invoice #1042 on Net 30 terms)
TRANSACTION STEP 2: RECEIVING CUSTOMER PAYMENT (May 28)
User Action: + New > Receive Payment > Select Customer: Apex > Check Invoice #1042 > Deposit to: Undeposited Funds
General Journal Impact:
Date Account Titles and Explanation Debit Credit
May 28 Undeposited Funds ........................... $5,400
Accounts Receivable - Apex Manufacturing . $5,400
(To record receipt of Check #8831 against Inv #1042)
TRANSACTION STEP 3: CONSOLIDATED BANK DEPOSIT (May 30)
User Action: + New > Bank Deposit > Select Checking Account > Check $5,400 check and $600 cash
General Journal Impact:
Date Account Titles and Explanation Debit Credit
May 30 Operating Checking Account (1010) ........... $6,000
Undeposited Funds ....................... $6,000
(To record consolidated bank deposit batch #401)
Credit Memos vs. Refund Receipts
When a customer returns merchandise, experiences service dissatisfaction, or is granted a billing concession, the bookkeeper must record an adjustment. QBO provides two distinct mechanisms based on whether the customer holds an open invoice balance or requires an immediate cash payout.
+-------------------------------------------------------------------------------------------------+
| ADJUSTMENT DECISION FRAMEWORK |
+-------------------------------------------------------------------------------------------------+
| Does the customer have an open invoice OR want to keep a store credit on account? |
| │ |
| ├──► YES ──► CREDIT MEMO (+ New > Credit Memo) |
| │ - DR Sales Returns & Allowances (or Income) |
| │ - DR Sales Tax Payable |
| │ - CR Accounts Receivable |
| │ |
| └──► NO ──► REFUND RECEIPT (+ New > Refund Receipt) |
| - DR Sales Returns & Allowances (or Income) |
| - DR Sales Tax Payable |
| - CR Bank Account / Undeposited Funds |
+-------------------------------------------------------------------------------------------------+
1. Credit Memo (+ New > Credit Memo)
A Credit Memo is issued when a customer reduces their outstanding debt or maintains a credit balance toward future purchases.
- Accounting Effect: It debits a revenue/returns account and sales tax liability while crediting Accounts Receivable for that specific customer.
- Application: If the customer has open invoices, QBO can automatically apply the credit memo (if
Automatically apply creditsis enabled in settings) or the bookkeeper can manually link the credit memo inside the Receive Payment window.
2. Refund Receipt (+ New > Refund Receipt)
A Refund Receipt is used when a customer originally paid cash, check, or credit card and the business pays out money immediately to settle the return.
- Accounting Effect: It debits a revenue/returns account and credits the Bank Account (or Credit Card clearing account) from which the refund is disbursed.
- Application: A refund receipt does not touch Accounts Receivable and does not require a Receive Payment step.
The Undeposited Funds / Payments to Deposit Account Mechanics
The most common error made by novice bookkeepers in QuickBooks Online is the misuse or misunderstanding of Undeposited Funds (renamed Payments to deposit in recent QBO interface versions).
What is Undeposited Funds?
Undeposited Funds is an Other Current Asset account on the Balance Sheet. It functions as an electronic holding safe (or desk drawer) that holds customer payments (cash, physical checks, credit card swipes) received during the business day until they are physically or electronically deposited into the actual bank account.
+-------------------------------------------------------------------------------------------------+
| THE FATAL ERROR: DUPLICATING REVENUE VIA BANK FEEDS |
+-------------------------------------------------------------------------------------------------+
| PROPER WORKFLOW: |
| 1. Invoice Created: DR AR $1,000 / CR Sales $1,000 |
| 2. Payment Received: DR Undeposited Funds $1,000 / CR AR $1,000 |
| 3. Bank Deposit: DR Checking $1,000 / CR Undeposited Funds $1,000 |
| 4. Bank Feed Matches: Bank Feed 'Match' confirms step 3. Result: Net Income = $1,000. |
| |
| ERRONEOUS WORKFLOW (THE DUPLICATION TRAP): |
| 1. Invoice Created: DR AR $1,000 / CR Sales $1,000 (Revenue Recognized: $1,000) |
| 2. Payment Received: DR Undeposited Funds $1,000 / CR AR $1,000 |
| 3. Bank Feed Downloaded: User clicks 'Add' as Sales Income instead of 'Match'! |
| DR Checking $1,000 / CR Sales $1,000 (Revenue Recognized: $2,000!) |
| |
| DISASTROUS LEDGER CONSEQUENCES: |
| • Sales Income is OVERSTATED by $1,000 (Tax liability overstated). |
| • Undeposited Funds remains clogged with a lingering $1,000 debit balance that never clears. |
+-------------------------------------------------------------------------------------------------+
Rules for Bank Deposit Grouping
To execute flawless bank reconciliations, the bookkeeper must ensure that the total dollar amount entered on the Bank Deposit form in QBO matches the exact lump-sum figure appearing on the bank statement to the penny.
- Batching Payments: When visiting
+ New > Bank Deposit, QBO displays all open payments currently sitting in Undeposited Funds in the top section (Select the payments included in this deposit). The bookkeeper checks the boxes next to the specific payments included in that deposit slip. - Bank Processing Fees: If a merchant service or credit card processor takes a deduction (e.g., $30 processing fee on a $1,000 batch, depositing $970), the bookkeeper enters a negative line item in the bottom Add other funds to this deposit section:
- Received From: Merchant Processor
- Account: Bank & Merchant Fees (Expense)
- Amount: -$30.00
- Net Deposit Total: $970.00 (Matches bank statement exactly).
- Cash Back: If the owner withdraws cash from the deposit, a negative line item is added pointing to Owner's Drawings.
A bookkeeper creates an Estimate for $8,500 in QuickBooks Online and emails it to a client. What is the immediate effect of this transaction on the General Ledger?
A customer who purchased goods on credit returns $600 of merchandise. The customer has an open invoice of $1,200 and requests that the return reduce their outstanding account balance. Which QBO transaction form must be used?
A bookkeeper receives four customer checks totaling $3,200 for open invoices. In QBO, the payments are recorded via 'Receive Payment' and routed to Undeposited Funds. When the physical deposit of $3,200 appears on the bank feed, the bookkeeper clicks 'Add' categorized to 'Sales Income'. What is the consequence of this action?
When an Invoice is created in QuickBooks Online for $2,000 of taxable services with an 8% sales tax ($160), what exact journal entry is posted to the General Ledger?