How Zera Books achieves 95%+ transaction auto-match rate — matching algorithm specs, exception flagging methodology, outstanding check detection, and integration with QuickBooks and Xero reconciliation workflows.
Bank reconciliation matches bank statement transactions to general ledger entries. Zera Books uses a three-signal matching approach, with each signal carrying different weight in the match confidence score.
| Signal | Match Criteria | Weight in Score | Window/Threshold |
|---|---|---|---|
| Amount | Exact match (to 2 decimal places) | 50% | Exact — no tolerance |
| Date | Transaction date proximity | 30% | ±5 calendar days (accounts for bank processing lag) |
| Description | Normalized description similarity | 20% | 80%+ similarity score (fuzzy match) |
| Match Score | Classification | Action |
|---|---|---|
| All 3 signals match | Auto-matched | Transaction cleared automatically; no review needed |
| Amount + Date match; Description partial | Probable match | Flagged for one-click confirmation; shown with match confidence |
| Amount only | Possible match | Listed as candidate; user must review and confirm |
| No match | Exception | Listed in exceptions panel with category classification |
* Benchmarks measured across 1,000 reconciliations at CPA firms using Zera Books + QuickBooks Online, Q1 2025. Auto-match rate improves with AI categorization history — firms with 3+ months of usage see 97%+ auto-match.
| Transaction Type | Auto-Match Rate | Notes |
|---|---|---|
| ACH/wire transfers | 98.1% | Consistent amounts and payee names; exact matches common |
| Payroll direct deposits | 97.8% | Regular amounts and dates; highly predictable |
| Recurring subscriptions | 97.2% | Same amount, same merchant monthly; near-perfect match |
| Bank fees | 96.4% | Standard descriptions well-recognized |
| POS/merchant purchases | 94.3% | Description variation between bank and GL reduces match rate |
| Checks cleared | 91.7% | Dependent on check register matching; improves with check processing |
| Cash/ATM withdrawals | 82.4% | No specific payee; matched by amount + date only |
Zera Books auto-matches 95%+ of transactions before you open the reconciliation screen in QuickBooks or Xero.
Try for one week →Unmatched transactions (exceptions) are classified by category to help accountants prioritize and investigate efficiently. The exception panel shows all exceptions grouped by type with suggested resolution steps.
Transactions present in the GL but not yet on the bank statement (or vice versa) due to processing lag. Flagged as "Timing" with expected clearing date estimate.
Checks recorded in the GL but not yet cleared at the bank. Detected by comparing check register against bank statement. Listed with check number, issue date, and payee.
Transactions on the bank statement that don't appear in the GL with any probable match. Flagged for investigation — could be bank errors, unauthorized charges, or missing GL entries.
Transactions where date and description match but amounts differ. Flagged as "Amount Mismatch" — common causes include bank fees, currency conversion, or data entry errors in the GL.
Deposits recorded in the GL but not yet on the bank statement. Flagged separately from other timing differences because they affect the reconciliation balance calculation differently.
When a reconciliation gap exists, Zera Books searches the transaction list for items equal to or summing to the gap amount — accelerating identification of missing or duplicate entries.
Zera Books integrates directly with QuickBooks Online and Xero's reconciliation workflows, reducing the number of manual steps between statement receipt and completed reconciliation.
| Integration Step | QuickBooks Online | Xero |
|---|---|---|
| Transaction import | Direct API push to "For Review" queue | Direct API push to bank feed |
| Category pre-assignment | Category pushed as account assignment | Category pushed as account code |
| Reconciliation target balance | Statement closing balance sent to rec screen | Statement closing balance set as target |
| Auto-matching | 95%+ transactions auto-cleared on import | 95%+ transactions auto-matched on import |
| Exception handling | Unmatched items remain in "For Review" | Unmatched items in "Reconcile" panel |
| Outstanding checks | Exported to QBO as uncleared checks | Exported to Xero with cleared status: No |
Zera Books achieves a 95%+ auto-match rate in bank reconciliation. This means 95% of extracted bank transactions are automatically matched to their corresponding general ledger entries without human intervention. The remaining 5% are flagged as exceptions for manual review.
Zera Books matches bank transactions to GL entries using three primary signals: exact amount match, date proximity (±5 days), and normalized description similarity (80%+ threshold). Transactions meeting all three criteria are auto-matched. Partial matches (amount + date but different description) are flagged as probable matches for review.
Outstanding checks are identified by comparing the check register (from check processing) against the bank statement. Checks issued but not yet cleared are flagged in the reconciliation output as "Outstanding — Not Yet Cleared" with the check number, date issued, and amount.
When a discrepancy remains after auto-matching, Zera Books runs a difference analysis: it identifies the exact dollar amount of the gap and searches the transaction list for a transaction equal to that amount or a combination of transactions that sum to it.
Explore related Zera Books workflows and features.
Zera Books auto-matches 95%+ of transactions before you open QuickBooks or Xero — leaving only exceptions to investigate.
Try for one week →