Glossary
QuickBooks Customer Balance Detail Report
The Customer Balance Detail report is a QuickBooks Online report that breaks each customer’s balance into the transactions behind it (open invoices, unapplied payments and unapplied credit memos), with their due dates, so you can see exactly why a customer owes what QuickBooks says they owe.
Also called: Customer Balance Detail, customer balance detail report
14-day free trial · card required · cancel anytime
Definition
A customer’s balance in QuickBooks is one number. The Customer Balance Detail report is the list of transactions that adds up to it.
Intuit’s one-line description is: “To see customer balances and due dates, run a customer balance detail report.” That undersells it. The Open Invoices report shows only invoices. Customer Balance Detail shows everything that still carries an open balance on the customer’s account, and that includes payments that were never applied to an invoice and credit memos that were never used. Those are the rows that make a customer’s balance look wrong, and this is the report where they are easiest to see.
Intuit points people to it for exactly that job. Its article on clearing an accounts receivable balance from a cash basis balance sheet says: “To find unapplied payments, review the Customer Balance Detail or Vendor Balance Detail report.”
For a business that bills through Stripe, the report is the QuickBooks side of a comparison you will want to make regularly: what Stripe says a customer owes, against what QuickBooks says, transaction by transaction.
Key points
- +Find it under Reports, then Standard reports, in the Who owes you section, or search for “balance detail”.
- +It breaks each customer’s balance into the open transactions behind it, with due dates.
- +Unlike the Open Invoices report, it also shows unapplied payments and unapplied credit memos.
- +Intuit recommends it as the place to find unapplied payments.
- +An unapplied credit with no open invoice to settle leaves the customer’s balance negative.
- +Stripe keeps its own credit balance per customer, which applies to the next finalized invoice. Comparing the two is how you catch drift.
Where to find it and what each row means
Go to Reports, then Standard reports, and select Customer Balance Detail in the Who owes you section. Intuit also suggests typing “balance detail” into the report search, which brings up the customer and vendor versions side by side.
The report groups rows by customer. Under each name you see the transactions that still carry an open balance, and the customer’s rows add up to what they owe you. Three kinds of row show up.
Open invoices are invoices with money still owing. A partly paid invoice shows only what remains.
Unapplied payments are Receive payment entries that aren’t applied to any invoice. The money is on the customer’s account, but nothing is marked paid.
Unapplied credits are credit memos that haven’t been used against an invoice. They reduce the customer’s balance on paper, but every invoice they were meant for stays open.
If you only want one customer, filter the report to that customer. If you want one total per customer without the transactions, Customer Balance Summary is the summary version of the same report.
Customer Balance Detail vs Open Invoices vs A/R aging
All three sit in the Who owes you section and all three read the same receivables. They answer different questions.
Open Invoices answers which invoices are unpaid. Intuit describes it as showing “all unpaid invoices and statement charges with customer totals.” Payments and credits that are floating on the account don’t appear as rows of their own.
A/R aging answers how late the money is. It sorts the same balances into aging periods so the old debt stands out.
Customer Balance Detail answers why a customer’s balance is what it is. It is the only one of the three that puts an unapplied payment or credit next to the invoice it should have closed.
That makes it the report to run when the other two disagree with reality. If Open Invoices shows an invoice the customer swears they paid, Customer Balance Detail is where you will usually find the payment, sitting one row away, not applied to anything.
Unapplied payments and credits: what they do to the balance
QuickBooks treats an invoice as paid only when a payment or credit is applied to it. Recording the payment isn’t enough on its own.
Intuit calls unapplied payments “the second most common cause of a balance in accounts receivable or accounts payable,” and describes the fix as opening the payment and applying it: in Receive payment, “In the Outstanding Transactions section, select the invoice or invoices the payment should be applied to.” Sometimes there is no invoice to apply it to. Intuit’s guidance then is that “you must enter the missing invoices or bills before you can apply the payments to them.”
Credit memos behave the same way. Intuit’s credit memo article says that when credits aren’t applied, “the Customer Balance Detail report shows that both the invoice and the credit memo have open balances.” If the customer has no unpaid invoices when the credit is saved, “the credit memo’s status is Unapplied, and your customer’s balance is negative.”
Whether QuickBooks applies credits for you depends on a company setting. With Automatically apply credits on, Intuit says QuickBooks applies the credit to the oldest unpaid invoice, then the next oldest, until the credit runs out. That keeps the report clean, but it can settle a different invoice from the one the credit was issued against. With the setting off, credits wait until you choose an invoice in Receive payment.
Delayed credits are the exception. Intuit describes them as a way to track a credit for future use without it immediately affecting the customer’s open balance, so a delayed credit doesn’t reduce the balance until it is applied to an invoice.
Reading it against Stripe
Stripe tracks two things per customer that line up with this report: invoices with a remaining balance, and a credit balance.
Stripe’s credit balance is a ledger of adjustments. Stripe’s documentation says “Credits are negative values (a reduction in the amount the customer owes)” and that “The credit balance automatically applies to the next finalized invoice to a customer,” and that you can’t choose a specific invoice to apply it to. So on the Stripe side a credit never sits unapplied for long. It is consumed by the next invoice.
QuickBooks has no equivalent automatic step unless Automatically apply credits is on, which is why the same credit can look settled in Stripe and still show as an open credit memo in Customer Balance Detail.
A useful check, customer by customer, has three parts. Stripe’s open invoices for the customer should match the open invoice rows in Customer Balance Detail. Stripe’s credit balance should match the unapplied credits, if any, on the QuickBooks side. And any unapplied payment in QuickBooks needs an explanation, because a Stripe charge that settled an invoice should not show up as money floating on the account.
Where the lists disagree, the row itself tells you what to fix: apply the floating payment or credit, void what Stripe voided, or record what never reached QuickBooks.
A worked example: a balance that looks wrong
Harbor Analytics has two Stripe invoices. Invoice 1041 for $300 was paid in full. Invoice 1052 for $200 got a $50 credit note after a service outage, so $150 is still open. Stripe says Harbor owes $150.
QuickBooks also says Harbor owes $150, so nothing looks wrong at the top level. Customer Balance Detail tells a different story. It shows four rows: invoice 1041 for $300, open for $300; a $300 payment, unapplied; invoice 1052 for $200, open for $200; and a $50 credit memo, unapplied.
The rows net to $150, which is why the balance matches. But the payment was never applied to invoice 1041 and the credit memo was never applied to invoice 1052. So the Open Invoices report shows $500 of unpaid invoices for Harbor, the aging report shows invoice 1041 as overdue once its due date passes, and a customer statement would show a paid invoice as outstanding.
Applying the $300 payment to invoice 1041 closes both of those rows. Applying the $50 credit memo to invoice 1052 leaves one row: invoice 1052, open for $150. That is the same thing Stripe shows, at the transaction level as well as the total. A matching total is not proof the receivables are right. Matching rows are.
How Acodei’s Invoice Sync shows up on the report
Acodei’s Invoice Sync, a paid-plan feature turned on per company, mirrors Stripe invoices and their payments into QuickBooks Online, so Stripe customers’ invoices, payments and credit memos are the rows you will see on Customer Balance Detail.
When a Stripe invoice is finalized, Acodei creates the QuickBooks invoice. When it is paid, by a successful charge, a manual payment (depending on your settings) or a credit balance offset, Acodei creates a QuickBooks payment receipt or credit memo and applies it to that invoice. Acodei’s documentation notes that the automatic application requires QuickBooks Automatic Application to be on, and its best-practice guidance is to keep it on.
A Stripe credit note becomes a QuickBooks credit memo, linked to the invoice when possible and otherwise posted to the customer. A credit memo posted to the customer rather than linked to an invoice is the kind of row that can appear on this report as an open credit, unless QuickBooks applies it to an invoice.
Stripe’s credit balance also reaches QuickBooks. By default, when Stripe applies a customer balance to an invoice, Acodei includes that applied balance as a line on the QuickBooks invoice so the invoice reflects the exact amount Stripe charged. An admin setting can skip that line and create the invoice at the full amount instead.
Two more details explain rows people don’t expect. If a Stripe customer’s currency differs from the existing QuickBooks customer’s, Acodei creates a separate customer named like “Acme - CAD” before posting the invoice. That is by design, because a QuickBooks customer record holds one currency, and it means that customer’s balance appears under two names on the report. And an invoice marked paid outside Stripe gets a QuickBooks payment only if the Payments Marked as Paid Outside Stripe setting is on, which is off by default. Without it, that invoice stays open on the report.
When a row looks wrong, Acodei recommends resyncing the transaction from its Data Feed rather than editing the synced records by hand in QuickBooks.
Want to see this on your own Stripe data?
Start a free trial14-day free trial · card required · cancel anytime
Frequently asked questions
Where is the Customer Balance Detail report in QuickBooks Online?
Go to Reports, then Standard reports, and select Customer Balance Detail in the Who owes you section. You can also type “balance detail” into the report search.
What is the difference between Customer Balance Detail and Open Invoices?
Open Invoices lists unpaid invoices and statement charges with customer totals. Customer Balance Detail lists every transaction that still carries an open balance on a customer’s account, including unapplied payments and unapplied credit memos, so it shows why the balance is what it is.
How do I find unapplied payments in QuickBooks Online?
Intuit recommends reviewing the Customer Balance Detail report. Unapplied payments appear as open rows under the customer. To fix one, open the payment and, in the Outstanding Transactions section of Receive payment, select the invoice it should be applied to.
Why is a customer’s balance negative in QuickBooks?
Usually because a credit memo or payment has nothing to be applied to. Intuit says that if there are no unpaid invoices, a credit memo’s status is Unapplied and the customer’s balance is negative. Customer Balance Detail shows the credit as an open row.
Why doesn’t Customer Balance Detail match the customer’s balance in Stripe?
Stripe applies a customer’s credit balance to the next finalized invoice automatically, while QuickBooks credits wait to be applied unless Automatically apply credits is on. Other causes are payments recorded but not applied, invoices voided in Stripe but still open in QuickBooks, and invoices marked paid outside Stripe with no matching QuickBooks payment.
What customers say about running Stripe through Acodei

“If you're testing out all the different Stripe/QuickBooks integration apps right now, let me save you some time. This one is the best one by far.”
“Works well and is really helpful for massive transactions. The support is really fast and helpful. 100% recommended.”
Related reading
- QuickBooks Open Invoices report
- QuickBooks A/R aging
- QuickBooks Automatic Application
- QuickBooks credit memo
- Stripe customer balance and credits in QuickBooks
- Customer statements for Stripe invoices in QuickBooks
More glossary terms
- Undeposited Funds
- Stripe Balance Transaction
- Available vs Pending Balance
- Stripe Dispute
- Stripe Dispute Evidence
- Stripe Fee
- Stripe Balance Adjustment
- QuickBooks Credit Memo
- Stripe Tax
- QuickBooks Tax Code
- Stripe Reserve
- Stripe Tax Rate
- Stripe Fee Credit
- Stripe Credit Note
- QuickBooks Product/Service Item
- Stripe Payout
- QuickBooks Sales Receipt
- QuickBooks Bank Deposit
- QuickBooks Transfer
- Stripe Authorization Hold
- QuickBooks Refund Receipt
- QuickBooks Payment
- QuickBooks Expense
- QuickBooks Journal Entry
- Stripe Financial Account
- Holding Account
- Accounts Receivable
- Bank Feed
- Deferred Revenue
- Stripe PaymentIntent
- Stripe Checkout Session
- Stripe SetupIntent
- Stripe PaymentMethod
- Stripe Charge
- Stripe Refund
- QuickBooks Invoice
- QuickBooks Class Tracking
- QuickBooks Location Tracking
- QuickBooks Project
- QuickBooks Closing Date
- Stripe Invoice Line Item
- Stripe Proration
- Stripe Invoice Status
- Stripe Shipping Rate
- Stripe Transfer
- Stripe Mandate
- Stripe on_behalf_of
- Stripe Invoice Item
- QuickBooks Estimate
- Stripe Invoice Payment
- Stripe Invoice Payment Settings
- Stripe Billing Meter
- Stripe Invoice Template
- Stripe Price
- Stripe Subscription Schedule
- Stripe Subscription Item
- QuickBooks Recurring Transaction
- QuickBooks Sub-Customer
- QuickBooks Audit Log
- QuickBooks Bank Rule
- Stripe Subscription Status
- Stripe Mixed Interval Subscription
- Stripe Trial Settings
- QuickBooks Payment Terms
- Stripe Pending Update
- QuickBooks Tags
- QuickBooks Credit Card Credit
- QuickBooks Vendor Credit
- QuickBooks Bill
- QuickBooks Delayed Charge
- Stripe Billing Mode
- QuickBooks Billable Expense
- Stripe Customer Cash Balance
- QuickBooks Purchase Order
- QuickBooks Opening Balance
- QuickBooks Account Type
- QuickBooks Sales Tax Center
- Stripe Webhook
- Stripe Metadata
- Stripe Outbound Payment
- Stripe Received Credit
- Stripe Outbound Transfer
- Stripe Inbound Transfer
- Stripe Received Debit
- Stripe Payout Method
- Stripe Financial Account Transaction
- Stripe Financial Address
- Stripe Application Fee
- Stripe Connected Account
- Stripe Destination Charge
- Stripe Separate Charges and Transfers
- Stripe Direct Charge
- Stripe Payment Method Configuration
- Stripe Dynamic Payment Methods
- Stripe Payment Method Rules
- QuickBooks Bundle
- Stripe Account Capability
- Stripe Merchant of Record
- Stripe Data Pipeline
- Settlement Currency
- Hosted Invoice Page
- Stripe Customer
- Stripe Product
- QuickBooks Home Currency
- QuickBooks Exchange Gain or Loss
- QuickBooks Trial Balance
- QuickBooks General Ledger Report
- QuickBooks Retained Earnings
- QuickBooks Profit and Loss Report
- QuickBooks Balance Sheet Report
- QuickBooks Account Register
- QuickBooks Reclassify Transactions
- QuickBooks A/R Aging Report
- QuickBooks Sales Tax Liability Report
- QuickBooks Sales Tax Payable
- Stripe Tax Transaction
- Stripe Tax Location Report
- Stripe Tax Summarized Export
- Stripe Tax Itemized Export
- Stripe Product Tax Code
- QuickBooks Vendor
- Economic Nexus
- Reverse Charge
- Stripe Statement Descriptor
- Stripe Taxability Reason
- Stripe Tax Filing Currency
- Stripe Tax Cross-Border Goods Option
- Stripe Tax Threshold Monitoring
- QuickBooks Uncategorized Income
- QuickBooks Sales by Product/Service Report
- QuickBooks Sales by Customer Report
- QuickBooks Group Tax Rate
- Form 1099-NEC
- SEPA Direct Debit
- Bacs Direct Debit
- Canadian Pre-Authorized Debit (PAD)
- Australia BECS Direct Debit
- Stripe PayTo
- Stripe Test Clock
- QuickBooks Customer Display Name
- Backup Withholding
- QuickBooks Multicurrency
- Form 1042-S
- Form W-8BEN
- Form W-9
- Form 8233
- Form 1042
- Form 1099-K
- Form W-8BEN-E
- Stripe Tax Behavior
- Stripe Customer Tax ID
- Form 945
- ITIN (Individual Taxpayer Identification Number)
- Form 1099-MISC
- Stripe Customer Tax Exempt Status
- EFTPS (Electronic Federal Tax Payment System)
- Tax Representative (Fiscal Representative)
- Nil Return
- Sales Tax Exemption Certificate
- EU One Stop Shop (OSS)
- Place of Supply
- Simplified Tax Invoice
- Input VAT (Input Tax)
- Streamlined Sales Tax (SST)
- Fixed Establishment (VAT)
- VIES VAT Number Validation
- E-Invoicing Mandate
- Tax Point (Time of Supply)
- Sales Tax Holiday
- Digital Services Tax
- VAT Invoice (Full Tax Invoice)
- Output VAT (Output Tax)
- VAT Bad Debt Relief
- Sales Tax Sourcing
- Gross Receipts Tax
- VAT Cash Accounting Scheme
- Reduced VAT Rate
- VAT Flat Rate Scheme (UK)
- VAT Annual Accounting Scheme (UK)
- EU VAT SME Scheme
- Making Tax Digital for VAT
- VAT Payments on Account (UK)
- Stripe Tax Registration
- Non-Established Taxable Person (NETP)
- VAT Group Registration (UK)
- Zero-Rated vs Exempt Supply
- Electronically Supplied Services (ESS)
- Zero-Decimal Currency
- UK VAT Registration Threshold
- QuickBooks Deposit Detail Report
- Payment Settlement Entity (PSE)
- QuickBooks Reconcile
- QuickBooks Bad Debt Write-Off
- Stripe Radar
- Stripe Smart Retries
- Stripe Decline Code
- QuickBooks Voided Transaction
- Stripe Minimum Charge Amount
- Stripe 3D Secure
- Stripe Preview Invoice
- Stripe Quantity Transformation (transform_quantity)
- Stripe Customer-Chosen Price (custom_unit_amount)
- Stripe Adjustable Quantity (adjustable_quantity)
- Stripe Inline Price (price_data)
- Stripe Default Payment Method
- Stripe Multi-Currency Price
- QuickBooks Automatic Application
- QuickBooks Open Invoices Report
Ready to try Acodei?
Connect Stripe to QuickBooks Online in minutes and let the fees, refunds, and payouts land where your accountant expects them.
14-day free trial · card required · cancel anytime