How to reconcile payments and QuickBooks

Steps

1. Start with the invoice and customer payment — Open Finance and confirm the invoice number, customer, service date, amount paid, and remaining balance. A partial payment should remain partial; a full payment should close only the amount that was actually collected. Fix an invoice mismatch before trying to force an accounting sync.
2. Review the payment reference and source — Stripe and Square payments keep their processor identity internally. For a manually recorded check, cash, or other payment, enter the reference you want your office and accountant to recognize. TurfTechAdvisor sends a trimmed manual reference to QuickBooks without exposing processor-generated identifiers as customer-facing references.
3. Separate fees, tips, refunds, and reversals — Treat the customer's gross payment, processor fee, tip, refund, and reversal as separate events. This preserves the amount the customer paid while explaining why a payout deposit may be lower, higher, delayed, or reversed. Do not edit the invoice total just to make a processor deposit match.
4. Compare the payout with QuickBooks — Use Payment Reconciliation to review whether the Stripe payout and its accounting components are matched, pending, parked, or need attention. Confirm the connected Stripe account and QuickBooks company before acting; similarly named transactions can exist in different live or test accounts.
5. Fix mappings before retrying — If a fee, tip, refund, clearing, or payout account is missing or no longer valid, update that mapping first. A temporarily parked record can be retried after the mapping is fixed. The retry uses the saved accounting identity and reconciliation markers so it does not blindly create another copy.
6. Approve or skip only after review — For historical records held during the first QuickBooks connection, approve only the selected record that still belongs in QuickBooks. Skip a record that is already represented there. Skip is a permanent operator decision; temporary parked or failed statuses are recovery states and can resume after their cause is corrected.