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 trial

14-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

Stripe Verified Partner BadgeIntuit QuickBooks
★★★★★
“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.”
RyanOwner at Indie Music Academy
★★★★★
“Works well and is really helpful for massive transactions. The support is really fast and helpful. 100% recommended.”
AndresCo-founder and CEO at Kanguro Collections and Reinsurance

Related reading

More glossary terms

See the full glossary

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