Reconciliation is the process of matching your system's payment records with your bank account and payment processor (Stripe) to ensure everything aligns. It catches errors and missing transactions.

Why Reconcile

  • Verify all card payments were deposited to your bank
  • Confirm cash deposits match recorded cash payments
  • Catch duplicate or missing entries
  • Identify processing fees and deductions

Card Payment Reconciliation

  1. Run a Payment Report
    Generate a card payment report for the period you're reconciling (typically one week).
  2. Compare with Stripe
    Log into your payment processor dashboard and view payouts for the same period.
  3. Match Totals
    The system total should match the payout total (minus processing fees). Note: payouts may be delayed by 1-2 business days.
  4. Investigate Discrepancies
    If totals don't match, look for refunds, chargebacks, or transactions on different dates due to payout timing.

Cash Reconciliation

  1. Run a Cash Payment Report
    Filter payments to "Cash" only for the period.
  2. Compare with Deposits
    Match the system's cash total against your bank deposit amounts.
  3. Account for Drawer
    Remember to subtract the cash drawer float (it stays in the drawer, not deposited).

Reconcile weekly. Monthly reconciliation works but makes it harder to track down issues. Weekly is the recommended cadence.

Quick Reference

ActionHow
Card reconciliationCompare Payment Report (Card) vs. Stripe payouts
Cash reconciliationCompare Payment Report (Cash) vs. bank deposits
Recommended frequencyWeekly