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

“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 A/R aging
- QuickBooks Automatic Application
- QuickBooks payment
- Stripe invoice status
- Customer statements for Stripe invoices in QuickBooks
- Voided and uncollectible 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
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