Xero
Cloud-based accounting software used by Pride of Our Footscray. Authoritative source for account balances, trial balances, and financial reporting. Currently experiences significant reconciliation challenges due to downstream issues with Amaka middleware and bank settlement flows.
Role in Pride’s Systems
Xero is the central ledger where all transactions are recorded:
- Chart of Accounts: Structured with specific clearing accounts for Square, cash, bank transfers, tips, and gift cards
- Daily sync: Amaka (middleware) creates invoices for daily Square POS activity
- Settlement sync: Amaka records bank transfers and processing fees
- Bank feeds: Three Westpac accounts plus Square Balance account (non-bank clearing account)
- Payroll: Wages, superannuation, novated lease deductions
- Loan tracking: Eight loan-related accounts across Square Capital, Westpac, Lumi, and intercompany facilities
Current Data Quality Issues
Balance Sheet problems:
- SQ-000000 (Square Balance): $4.67M unreconciled vs statement—represents cumulative Amaka settlement transactions never reconciled against bank feed
- SQ-600000 (Square Cash Clearing): ($396,364.25) credit balance—includes $343.6K correct ATM reclassification but also ~$209K Zeller EFTPOS miscoding
- SQ-600002 (Other Payment Clearing): $27,968.32 debit balance—revenue double-counted via bank transfer route
- SQ-600001 (Square Capital Loan Payable): $247,618.39 phantom balance—fully repaid loans never netted off after Lumi refinancing
P&L problems:
- FY25 interest expense ~$29,530 entirely unrecognised
- Revenue overstated ~$7,674 due to bank transfer double-counting
- Superannuation expense miscoded; requires ~$35,583 reallocation across prior years
Bank reconciliation: Three Westpac accounts show material differences between statement balance and Xero balance:
- Westpac 2203: Difference $116,057.91
- Staff Petty Purchase: Difference $15,705.46
- CBA 9522: Difference $18,259.56
Data Sources and Hierarchy
Priority hierarchy for Xero data:
- Westpac bank statements — external, tamper-resistant, authoritative
- Xero Trial Balances — authoritative account balances
- Xero Account Transaction Reports — line-level account activity
- Xero P&L reports — revenue and expense by account
- Xero GL CSV — pattern matching only; structurally incomplete (missing Receivable Payment entries)
Critical limitation: GL CSV export is incomplete. Must never use GL CSV for balance calculations.
Corrective Actions In Progress
Phase 1 (completed): Diagnostic analysis identifying 8 major findings Phase 2 (in progress): Posting corrective journals for clearing accounts and loan cleanup Phase 3 (planned): Bank rule setup for Westpac and Lumi repayments once loan schedules obtained
New Features and Recommendations (April 2026)
Xero JAX (Free — Enable When Available)
AI financial assistant included in Xero subscription. Handles cash flow questions, smart bank reconciliation, and auto-categorisation. Enable when it reaches the account.
Fathom Add-On ($65/month)
Recommended for board-ready P&L reports. Visual dashboards, budget vs actual variance, scenario modelling, PDF exports. Brisbane-built, AUD pricing. Does not replace the custom BI dashboard but fills the financial reporting gap.
Plan Requirement
Xero must be on Grow plan ($75/month) — the Starter plan’s 20-invoice limit breaks the Amaka integration on day 21 of each month.
API Pricing Risk (March 2026)
Xero introduced new tiered API pricing effective March 2026. Deputy is likely insulated as a major Xero partner (USD $25M investment, exclusive embedded rostering partner), but this represents a background ecosystem risk for any third-party or custom integrations consuming Xero’s API — including potential Humphrey Intelligence App connections. Per Deputy Xero Integration Research.
Deputy Integration Context
The Deputy→Xero payroll integration is semi-automated: a manager must manually trigger each export. Pay rate dollar amounts do not transfer — Xero applies its own earnings rates. HIGA award gaps (leave loading 17.5%, casual loading 25%, most allowances) require manual Xero-side adjustments every pay run regardless of integration. Full detail on Deputy.
See Tech Stack Optimisation for full stack recommendations.
Related Pages
- Amaka — middleware syncing transactions from Square to Xero
- Chart of Accounts — account structure, codes, and purposes
- Financial Reporting — P&L and Balance Sheet accuracy
- Square Cash Clearing Issue — SQ-600000 Zeller miscoding detail
- Other Payment Clearing Issue — SQ-600002 revenue double-count detail
- Loan Accounts Diagnostic — clearing and consolidating loan accounts
- Tax Lodgement — ITR preparation dependent on Xero data quality
- Tech Stack Optimisation — stack assessment
- Deputy — rostering system with semi-automated payroll export to Xero
- Deputy Xero Integration Research — source: comprehensive integration research (April 2026)
- Melbourne Venue Tech Stack Research — source: Xero evaluation