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
- Obtain daily cash count from venue
- Compare to Square’s reported cash total
- Reconcile to Xero clearing account
- Investigate variances
- Bank deposit receipt when deposited
- 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.
Related Pages
- Clearing Account Cycle — clearing cycle and timing
- Square POS — Square transaction processing
- Xero — Xero clearing account codes
- Daily Sales Sync — related sales data integration
- Bank Reconciliation — overall reconciliation framework