Module 8
Reconciliation
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
- Run a Payment ReportGenerate a card payment report for the period you're reconciling (typically one week).
- Compare with StripeLog into your payment processor dashboard and view payouts for the same period.
- Match TotalsThe system total should match the payout total (minus processing fees). Note: payouts may be delayed by 1-2 business days.
- Investigate DiscrepanciesIf totals don't match, look for refunds, chargebacks, or transactions on different dates due to payout timing.
Cash Reconciliation
- Run a Cash Payment ReportFilter payments to "Cash" only for the period.
- Compare with DepositsMatch the system's cash total against your bank deposit amounts.
- Account for DrawerRemember 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
| Action | How |
|---|---|
| Card reconciliation | Compare Payment Report (Card) vs. Stripe payouts |
| Cash reconciliation | Compare Payment Report (Cash) vs. bank deposits |
| Recommended frequency | Weekly |