Glossary

QuickBooks Open Invoices Report

The Open Invoices report is a QuickBooks Online report that lists every unpaid invoice and statement charge, grouped by customer with a total for each, so you can see who owes you money and on which transactions.

Also called: Open Invoices report, open invoices report

14-day free trial · card required · cancel anytime

Definition

Intuit’s description is one line: “Open invoices show all unpaid invoices and statement charges with customer totals.” It is the plainest view of accounts receivable QuickBooks has. Every row is a transaction that still carries a balance, and every customer gets a subtotal.

The word that matters is unpaid, and QuickBooks decides it per invoice. An invoice is open until a payment or credit is applied to it. A customer can owe you nothing in total and still have open invoices on this report, because a payment or credit memo sits on their account without being matched to the invoice it was meant for.

That is why the report is worth reading if you bill through Stripe. Stripe keeps its own list of open invoices. The two lists should describe the same debts, and every row where they disagree points at a specific record to fix.

Key points

  • +Find it under Reports, then Standard reports, in the Who owes you section.
  • +It lists unpaid invoices and statement charges, grouped by customer with a total for each.
  • +It has no aging columns. The A/R aging reports sort the same debts by how long they are past due.
  • +An invoice stays open until a payment or credit is applied to it, even if the money has arrived.
  • +Unapplied payments and credits are easiest to find on the Customer Balance Detail report.
  • +Compared with Stripe’s open invoices, each difference is a missing, unapplied or out-of-date record.

Where to find it and what it lists

Go to Reports, then Standard reports, and select Open Invoices in the Who owes you section. Intuit lists it among the reports for seeing which customers owe you and says it “will show customers who owe you the most.”

The report is a list, not a summary. Each open invoice appears under its customer, so you can see the invoice numbers and dates behind a balance rather than a single figure. Statement charges appear alongside them, which is the other half of Intuit’s description.

What it leaves out matters as much. Invoices that are fully paid don’t appear. Sales receipts never appear, because a sales receipt records a sale and its payment in one form and never leaves anything owed.

Open Invoices vs the A/R aging reports

Both reports sit in the Who owes you section and both are about money customers still owe. They answer different questions.

The A/R aging reports are about lateness. Intuit says aging reports “give you an overview of your customers’ outstanding balances, who are falling behind their payments,” and the summary version shows “the total outstanding balances and how long they’re past due.” Balances are sorted into aging periods so the old debt stands out.

The Open Invoices report is about the transactions themselves. There are no aging periods, just the open invoices for each customer. Use it when the question is which invoices are still open for this customer, and the aging report when the question is how late they are.

Both read the same open balances, so the same mistake shows up on both. An invoice left open by an unapplied payment looks unpaid on Open Invoices and, once its due date passes, overdue on the aging report.

Why a paid invoice can still show as open

QuickBooks needs two things before it treats an invoice as paid: the payment or credit has to exist, and it has to be applied to that invoice. The second step is where invoices get stuck.

Payments. A Receive payment entry that isn’t applied to an invoice leaves the money on the customer’s account and the invoice open. Intuit’s article on clearing an accounts receivable balance from a cash basis balance sheet calls unapplied payments “the second most common cause” and says to “review the Customer Balance Detail” report to find them.

Credits. A credit memo works the same way. Intuit: “If you don’t apply any credits, 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 a credit is saved, the credit memo’s status is Unapplied and the customer’s balance goes negative.

The fix is to apply what is already there, not to record another payment. With Automatically apply credits off, the Credits section of Receive payment is where you choose which credits settle which invoices. With it on, QuickBooks applies credits to the oldest unpaid invoice first, which can close a different invoice from the one the credit was for.

Checking the report against Stripe

Stripe defines an open invoice as one that “has been finalized and still has a remaining balance.” Filter Stripe’s invoice list to open, run Open Invoices in QuickBooks, and compare them customer by customer. Most differences fall into four groups.

Paid in Stripe, open in QuickBooks. The payment never reached QuickBooks, or it did and isn’t applied to the invoice. Check the customer’s Customer Balance Detail for an unapplied payment before entering anything new.

Void or uncollectible in Stripe, open in QuickBooks. Stripe says voided invoices “are treated as zero-value for reporting purposes, and aren’t payable.” Marking an invoice uncollectible is how Stripe writes off an invoice as unlikely to be paid, as part of bad debt accounting. Neither belongs on a list of what customers owe, so QuickBooks needs a matching void or write-off.

Marked paid outside Stripe. If a customer pays by check and you change the Stripe invoice to paid, Stripe moves it out of its open list but no Stripe charge exists, so nothing tells QuickBooks the invoice was paid unless you record the payment there.

In QuickBooks only. Invoices typed into QuickBooks by hand have no Stripe counterpart. They are not errors, but keep them in mind when the totals don’t match.

A worked example: one customer, three invoices

Brightline Studio has three Stripe invoices. A $120 September subscription invoice was charged successfully. A $120 October invoice failed to charge and is still open in Stripe, showing Past due. A $500 one-off invoice from August was marked uncollectible after months of chasing.

Stripe’s open list for Brightline shows one invoice: $120, October.

QuickBooks’ Open Invoices report shows three, totaling $740. September is there because its $120 payment was recorded but never applied to the invoice, so it sits on Brightline’s account as an unapplied payment. October is there because it is genuinely unpaid. August is there because nobody voided it or wrote it off in QuickBooks when it was given up on in Stripe.

Only the October row is a real debt. Applying the September payment closes the first row without changing what Brightline owes, and voiding or writing off the August invoice clears the second. After those two changes QuickBooks shows $120 open for Brightline, the same as Stripe.

How Acodei’s Invoice Sync affects the report

Acodei’s Invoice Sync, a paid-plan feature turned on per company, mirrors Stripe invoices into QuickBooks Online, so Stripe invoices appear on the Open Invoices report as real invoices. 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, which takes the invoice off the report.

That application relies on a QuickBooks setting. Acodei’s documentation says the payment auto-applies to the invoice and that this requires QuickBooks Automatic Application to be on, and its best-practice guidance is to keep it on so payments and credit memos settle invoices automatically.

The other Stripe outcomes follow through too. When a Stripe invoice is voided, Acodei voids the QuickBooks invoice or creates a credit memo, and an invoice marked uncollectible is handled the same way as a void. A Stripe credit note becomes a QuickBooks credit memo, linked to the invoice when possible and otherwise posted to the customer, where it reduces the balance but leaves the invoice open until it is applied. An invoice marked paid outside Stripe gets a QuickBooks payment only if the Payments Marked as Paid Outside Stripe setting is on, and it is off by default.

When a row on the report 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 Open Invoices report in QuickBooks Online?

Go to Reports, then Standard reports, and select Open Invoices in the Who owes you section.

What is the difference between the Open Invoices report and the A/R aging report?

Open Invoices lists each unpaid invoice and statement charge under its customer, with customer totals and no aging periods. The A/R aging reports show the same outstanding balances sorted by how long they are past due. Use Open Invoices to see which invoices are open and aging to see how late they are.

Why does a paid invoice still show on the Open Invoices report?

Usually because the payment or credit was recorded but never applied to that invoice. QuickBooks keeps an invoice open until something is applied to it. Look for an unapplied payment or credit memo on the Customer Balance Detail report and apply it to the invoice instead of recording a second payment.

Why doesn’t the Open Invoices report match my open invoices in Stripe?

Common causes are a Stripe payment that never reached QuickBooks or isn’t applied, a Stripe invoice that was voided or marked uncollectible but is still open in QuickBooks, an invoice marked paid outside Stripe with no matching QuickBooks payment, and invoices entered directly in QuickBooks that don’t exist in Stripe.

Do Stripe sales receipts show on the Open Invoices report?

No. A sales receipt records the sale and its payment together, so nothing is left owing and it never appears on the report. Only Stripe sales that reach QuickBooks as invoices can show up as open.

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