Xero is a cloud-based accounting platform used by over 4.5 million subscribers across 180+ countries, designed for small to medium businesses seeking real-time financial management from any device. Unlike traditional desktop accounting software, Xero operates entirely online β automatically backing up data and enabling unlimited users to collaborate simultaneously on the same live file. The platform's foundation is its bank feed integration connecting to 21,000+ global institutions, with smart reconciliation rules that turn hours of bookkeeping into minutes. The biggest shift in 2025β2026 is JAX (Just Ask Xero), Xero's AI financial superagent that automates bank reconciliation, invoice creation, and financial queries in natural language β while XeroForce allows businesses to build no-code custom AI agents for their own financial workflows.
What This Cheat Sheet Covers
This topic spans 14 focused tables and 119 indexed concepts, 100 flashcards. Below is a complete table-by-table outline of this topic, spanning foundational concepts through advanced details.
A jump-to index of every table row in this cheat sheet.
An interactive map of every table and concept in this topic.
Table 1: Bank Reconciliation
Bank reconciliation in Xero is the daily engine that keeps your books accurate. Mastering bank feeds, rules, and the new JAX auto-reconciliation dramatically reduces time spent on manual matching β the goal is to reach a state where most statement lines reconcile themselves.
| Feature | Example | Description | |
|---|---|---|---|
Direct connection to 21,000+ global institutions updates daily | β’ Automatic transaction import from connected bank accounts β’ eliminates manual data entry and reduces errors by up to 90% compared to manual methods | ||
Match statement line β Search invoices β Click OK | β’ Links imported bank transactions to existing invoices, bills, or expense claims β’ one-click reconciliation for straightforward matches | ||
IF description contains "AWS" THEN code to IT Expenses | β’ Automated coding templates that recognize transaction patterns β’ apply account codes, tax rates, and tracking categories without manual intervention | ||
Enable JAX on bank account β high-confidence lines reconcile automatically | β’ JAX-powered beta feature that auto-matches bank lines using rules, invoice matches, your transaction history, and crowd-sourced patterns from 4.5M subscribers β’ targets 80%+ auto-match rate; low-confidence items flagged for human review | ||
New statement line β Create β Spend money β Save | β’ Records new transactions directly from bank feed β’ used when no matching invoice or bill exists in the system | ||
$500 β $300 Advertising + $200 Meals | β’ Divides a single bank transaction across multiple account codes or tracking categories β’ essential for mixed-purpose payments | ||
Select 20 transactions β Apply account β Reconcile all | β’ Reconciles multiple similar transactions simultaneously using cash coding β’ dramatically speeds up processing of repetitive entries | ||
Enter balance on conversion date: $10,250.00 | β’ Sets starting bank balance when beginning to use Xero β’ must match bank statement on cut-over date exactly | ||
Upload CSV/OFX file β Map columns β Import | β’ Imports transactions from file when direct bank feed unavailable β’ supports various formats including QIF and MT940 | ||
Compare Xero balance vs. bank statement balance | β’ Verifies that accounts reconcile correctly β’ identifies missing or duplicated transactions causing balance discrepancies |