Money: Reconcile Deposits, Over/Short and Paid In/Out

These reports help you make sure the cash and card money you expect is the money that reached the bank.

Report	Where	What it helps you do
Bank Reconciliation Worksheet	Insights > Audit & Loss Prevention	Consolidates daily payments by method of payment so you can reconcile sales with bank deposits and card settlements.
Bank Reconciliation Extended Worksheet	Insights > Audit & Loss Prevention	The same, with more payment categories and transaction types.
Cash Deposit Worksheet	Worksheets	Daily cash deposit totals by store and date, laid out as a worksheet for recording the actual deposit, tracking variances and keeping notes. Export to Excel to type in the actual amounts.
Over/Short Detail	Insights > Audit & Loss Prevention	Store over/short activity, highlighting variances beyond the limits you configured.
Paid In/Out	Insights > Audit & Loss Prevention	Paid-in and paid-out activity, highlighting transactions outside your store thresholds.
Revenue	Insights > Store Performance	Revenue by method of payment. Use it with MSR for journal entries and reconciliation.

A deposit routine

Run the Cash Deposit Worksheet for the stores and days you are reconciling, with the Excel format.
Enter the actual deposit amounts in the spreadsheet and note any variances.
Check the Bank Reconciliation Worksheet for card and other payment types.
Follow up on anything flagged in Over/Short Detail or Paid In/Out.