Xero Reconciliation, Close & Analysis Assistant
Reconcile, close, and analyze Xero accounts with AI-powered workflows
What You Can Do
This skill streamlines your month-end and year-end close processes in Xero by automating reconciliation workflows, variance analysis, and close documentation. You'll reconcile bank and credit card accounts faster, identify discrepancies with contextual explanations, and generate clear close-out checklists—all while maintaining audit-ready records and reducing manual error.
Features
Match transactions, identify unreconciled items, and flag suspicious variances automatically
Pinpoint unexpected account movements, explain month-over-month changes, and suggest root causes
Generate step-by-step procedures for each account type (GL, bank, loan, expense) tailored to your chart of accounts
Pre-fill accruals, reversals, and allocations with Xero-native formatting ready to post
Reconcile balance sheet accounts to source documents and create supporting schedules
Auto-generate close memos linking transactions to narratives, suitable for audit review
Flag unusual items (round-dollar entries, late postings, duplicate transactions) for review
Organize inter-company eliminations and reclass entries across entities
Example Output
Example 1: Bank Reconciliation Report
Account: Operating Account (101)
As of: June 30, 2026
Book Balance: $145,230.50
Bank Balance: $149,875.25
Difference: $4,644.75
- ⚠️ Unreconciled Items (3):
- Check #2847 ($2,100) — Outstanding 18 days
- ACH Transfer XYZ ($2,544.75) — In transit, expected 7/2
- Wire receipt (#4521) ($150.00) — Pending GL match
✓ Action: Verify checks with payees; ACH resolves automatically 7/2
Example 2: Close Checklist
## June Close Procedures
□ Reconcile Cash (101) — Rec complete, 0 variances
□ Reconcile AR Aging — Review >60 days; reserve $3.2K
□ Accrue June Expenses — IT: $1,500, Insurance: $450
□ Remove Intercompany Payables — (202) to (202-B): $5,600
□ Review Tax Accounts — Q2 estimated: $18,750
□ Sign-off — Finance: Joel | Controller: Amy
Example 3: Variance Alert
Account: Rent Expense (5200)
June vs. May variance: +$1,200 (15% increase)
- 🔍 Likely cause: Late invoice from landlord for May accrual
Reference: INV-2847 dated 6/15 for May 2026 rent
Recommendation: Reverse into June; confirm lease rate $8,000/month
What's Included
- SKILL.md: Full Claude skill with reconciliation workflows, decision trees, and close process documentation
- Close Checklist Template: Customizable month-end and year-end procedures by account type
- Bank Rec Workflow: Step-by-step matching logic with variance investigation prompts
- Journal Entry Generator: Pre-built templates for accruals, reversals, and intercompany entries
- Variance Analysis Prompt Set: Contextual questions to root-cause account discrepancies
- Audit Workpaper Template: Balance sheet reconciliation schedule and sign-off matrix
- Exception Report Criteria: Rules for flagging unusual items (thresholds, patterns, overrides)
Who It's For
- Accountants & Bookkeepers — Accelerate month-end close and reduce manual rec time
- Finance Managers — Automate variance investigation and close documentation for reporting
- CFOs & Controllers — Streamline multi-entity consolidation prep and audit readiness
- Virtual CFOs (VCFOs) — Scale close services across multiple client organizations
- Internal Audit Teams — Generate balance sheet schedules and close support documentation
Best For
- Month-end and year-end bank reconciliation
- Identifying and explaining account variances (GL, bank, loan accounts)
- Generating audit-ready close documentation and workpapers
- Automating accrual and reversal journal entries
- Creating and maintaining close-out checklists and sign-off matrices
You might also like
You synthesize Bloomberg Terminal data—metrics, valuations, fundamentals, and peer comparisons—into professional institutional equity research reports and investment theses. This skill structures raw Bloomberg output into narrative-driven research with valuation analysis, risk assessments, and actionable investment recommendations that institutional teams can use for portfolio decisions.
by megalithic
You get an expert troubleshooter for your high-temperature metal processing operations. Submit your furnace parameters, process metrics, and observations—receive root-cause analysis, quantified optimization recommendations, and predictive maintenance guidance. Reduce yield loss, cut energy consumption, and extend equipment life while maintaining product quality and regulatory compliance.
by megalithic
You pull company financials, market data, and deal metrics from Capital IQ, then synthesize them into compelling investment theses. The skill helps you identify competitive advantages, financial trends, and growth catalysts while structuring your analysis using professional frameworks. You'll transform raw data into actionable investment insights with built-in validation and risk assessment.
by megalithic
You can automatically validate journal entries for accounting rules compliance, detect errors before posting to QuickBooks, and generate standardized narratives for audit trails. Process multiple entries in batches, verify account codes and debit/credit balances, and export formatted entries ready for QuickBooks import—all while flagging duplicate or suspicious entries for review.
by megalithic
You can design rigorous leaching experiments, model extraction kinetics, and troubleshoot performance issues using fundamental chemistry principles. This skill helps you analyze extraction data, calculate optimal operating parameters (temperature, pH, lixiviant concentration), and predict process behavior at different scales—all grounded in thermodynamic feasibility and kinetic reasoning to maximize recovery while minimizing costs.
by megalithic
You can upload PitchBook reports, transaction summaries, and company profiles, then extract structured insights on deal metrics, market trends, and investment opportunities. Claude analyzes transaction patterns, financials, and risk factors to generate due diligence summaries, comparative analyses, and investment theses—saving you hours of manual data synthesis.
by megalithic
Analyze your complete FreshBooks financial data to identify cash flow bottlenecks, automatically classify expenses for tax deductions, reconcile accounts against bank statements, and uncover billing optimization opportunities. This skill transforms raw transaction data into actionable financial insights and generates audit-ready reconciliation reports.
by megalithic
This skill helps you diagnose leaching failures, optimize metal recovery rates, and reduce operational costs in hydrometallurgical circuits. You can analyze process data to identify bottlenecks in leaching, precipitation, and solvent extraction; calculate optimal pH, temperature, and reagent parameters; and generate data-driven recommendations for improving throughput and product purity.
by megalithic