Square Cash Clearing Issue

Reconciliation of Square cash clearing accounts in Xero. When customers pay cash at the Square terminal, funds must be physically collected and deposited. The clearing account tracks cash float pending bank deposit and should reconcile to physical cash counts.

The Issue

Square cash transactions may not reconcile cleanly between:

  • Square’s reported cash total
  • Xero’s cash clearing account balance
  • Physical cash float count at venue

Discrepancies can arise from:

  • Timing differences (transactions recorded before deposit)
  • Undeposited cash retained for float
  • Rounding or data entry errors
  • Incomplete clearing of old transactions

Reconciliation Process

  1. Obtain daily cash count from venue
  2. Compare to Square’s reported cash total
  3. Reconcile to Xero clearing account
  4. Investigate variances
  5. Bank deposit receipt when deposited
  6. Final reconciliation to bank statement

Current Status

Square cash clearing has been identified and diagnostics completed. Reconciliation procedures should be formalised into daily cash audit processes.