A QuickBooks sales receipt should not enter the same open accounts receivable forecast population as an invoice. An invoice records an amount the customer will pay later; a sales receipt records a sale paid at the time of purchase. The first can create an open customer balance. The second is evidence of a completed sale and recorded payment, subject to deposit and reconciliation checks.
Intuit's transaction guide defines invoices as amounts customers owe and sales receipts as payments made when goods or services are purchased. Intuit's invoice-versus-sales-receipt guidance also ties invoices to later payment terms and sales receipts to payment on the spot.
Separate the source populations
Start an invoice-level collections forecast with issued invoices that remain open at the report cutoff. Preserve invoice number, customer, invoice date, due date, original amount, open amount, and status.
Keep sales receipts in a separate receipt or reconciliation population. Record the receipt date, customer, amount, payment method, deposit status, and linked source transaction. A sales receipt can help explain observed cash, but it is not a future collection from an open invoice.
This distinction prevents two common errors: adding a paid sale to expected collections and treating a sales receipt as proof that a different open invoice was settled.
Review exceptions before forecasting
Flag a row when the form type is missing, a sales receipt appears in invoice detail, a payment was recorded twice, or a receipt cannot be traced to a deposit or other cash record. Do not silently relabel a transaction. Route the exception to the person who owns the books and keep it outside supported expected cash until the source is understood.
The QuickBooks report-selection guide explains why invoice-level detail matters. The cash-receipt cutoff checklist keeps recorded receipts on the correct side of the forecast boundary. If a payment is waiting to be grouped into a bank deposit, use the Undeposited Funds boundary rather than counting it again.
Use a three-state decision rule
- **Open invoice:** eligible for forecast review if the source balance is valid.
- **Sales receipt:** observed transaction evidence; not future open-invoice cash.
- **Unclear form or link:** reconciliation exception; no timing assumption yet.
For each eligible invoice, add expected week, evidence date, evidence type, owner, and next review date. For each sales receipt, preserve deposit and cutoff evidence separately.
What AR Pulse adds
AR Pulse analyzes an authorized QuickBooks receivables export to produce a ranked cash-action list and four-week collections forecast. It does not require QuickBooks credentials, change books, or contact customers. Finance owners can view the example report after invoice and receipt populations are separated.