Inspect how the balance reached zero
A paid invoice status answers a billing-balance question. To report cash collections, identify the transaction that settled it. Look for a successful payment, an applied customer credit, a credit note, a zero original balance or an entry recording payment outside the platform. Keep the settlement explanation alongside the invoice instead of assuming all paid invoices represent new money.
Stripe documents that a credit note can reduce an open invoice to zero and change its status to paid without recording a payment. Its subscription guidance also describes invoices that require no payment. These cases belong in the invoice reconciliation even though a bank deposit will never appear for the full invoice amount.
References: Stripe: Issue credit notes; Stripe: Subscription invoices
Build a settlement bridge with separate columns
For each invoice, reconcile the original amount with successful payment applications, credits, approved adjustments and the remaining balance. Report gross cash before separately presenting processor fees and other settlement deductions. If the customer paid externally, require the bank evidence and the invoice application reference before treating the recorded external payment as confirmed cash.
In a hypothetical account, a $1,000 invoice could be settled by a $300 old credit and $700 of new cash. Reporting $1,000 as current-period collections overstates new cash by $300. Reporting only the $700 without explaining the credit leaves the invoice settlement incomplete. Both views are useful when their definitions and dates are kept clear.
Keep credit creation separate from credit use
A customer credit may have been created months before the invoice that consumes it. Trace that original event and preserve its accounting treatment. The later application should not automatically become a second revenue reduction or a second cash receipt. Ask the accountant to confirm the clearing entries between the customer balance and the receivable.
Check whether a refund was also issued against the original adjustment. If the credit remains available after money has been returned, a later invoice may consume a benefit the business intended to settle already. Investigate the combined customer history before reversing anything, and retain the customer-approved resolution and the supporting transaction references.
Follow external-payment entries to independent evidence
If someone marked the invoice paid because the customer said it sent a transfer, find the actual receipt and allocation. Record the bank date, amount, currency and payment reference. A promise, screenshot or remittance advice may support follow-up, but it should be distinguished from the business's own evidence that funds arrived.
For a hypothetical invoice settled outside the billing platform, link the verified bank receipt to the manual payment entry and ledger posting. Check that an accounting connector has not imported that entry as a second cash receipt. The case is resolved when the external evidence explains the invoice status and the books record the receipt once, with any settlement timing difference identified.
Correct the dashboard definition
Review reports that sum invoice totals where status equals paid. Such a report may measure settled invoicing, but it needs a different query or reconciliation to measure actual cash receipts. Label each measure in terms the sales, finance and customer-success teams can use consistently. Preserve historical definitions when changing the report so apparent growth does not result from a new calculation.
At close, compare payment applications to processor and bank settlement records, and inspect unexplained paid-without-cash cases. Do not force the report to match deposits by changing invoice statuses. The final exception list should identify the settlement method, support and owner for each remaining difference, including external receipts that have been recorded but not yet verified.
Sources
Requirements and product details can change. Check the linked guidance for the facts that apply to your situation.
Related reading
Need help with this work?
General information, not personalized accounting, tax, legal, or investment advice. Have the appropriate qualified professional review decisions that depend on your circumstances.