Daily Sales Sync
Automated daily reconciliation of Square point-of-sale transactions into Xero’s general ledger via Amaka payment integration. This is a core operational process that ensures sales data flows consistently from the venue to the accounting system without manual intervention.
How It Works
- Square processes venue transactions (bar sales, card payments, cash)
- Nightly, Amaka maps Square transaction types to Xero clearing accounts
- Summary totals post automatically to the Xero bank reconciliation module
- Cash reconciliation occurs daily at venue close
Key Benefits
- Eliminates manual data re-entry and reduces reconciliation errors
- Provides real-time visibility of daily sales performance
- Enables accurate cash float management and settlement tracking
- Supports compliance with tax reporting requirements
Current Status
The Daily Sales Sync is implemented and operational. Amaka handles the payment type mapping; see Clearing Account Cycle for details on settlement timing and account codes.
Related Pages
- Square POS — the point-of-sale system generating raw transaction data
- Xero — the accounting platform receiving daily summaries
- Amaka — payment integration service managing the mapping
- Data Integration Architecture — broader integration design
- Settlement Sync — related process for bank reconciliation