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
Connect your FreshBooks account to pull real-time financial data—invoices, expenses, revenue—and generate professional financial reports, trend analysis, and actionable insights. Create executive summaries, profitability breakdowns, cash flow forecasts, and custom metrics tailored to your business goals.
by megalithic
Systematically troubleshoot dewatering circuit problems by analyzing solids recovery, moisture content, and filtration performance. Use Claude-assisted process modeling to identify root causes, model alternative configurations, and predict performance improvements. Optimize separation parameters and circuit configurations to increase throughput and product quality while minimizing water loss.
by megalithic
You get a detailed audit of your ABAP code that identifies performance bottlenecks, security vulnerabilities, and compliance gaps with SAP standards. This skill analyzes database queries, memory management, code structure, and documentation to deliver actionable optimization recommendations that improve maintainability and runtime efficiency.
by megalithic
This skill transforms raw Bloomberg data into actionable investment insights by extracting key metrics, synthesizing multiple data sources, and generating comprehensive analytical reports automatically. You can benchmark companies against peers, analyze earnings trends, assess portfolio risks, and create presentation-ready analyses in minutes. Perfect for analysts who need to turn market data into investment theses quickly.
by megalithic
Create comprehensive financial models from scratch or refine existing ones using Claude to design formulas, validate calculations, and stress-test scenarios. You'll generate sophisticated models including cash flow projections, P&L statements, balance sheets, and valuation analyses—all with properly structured formulas that reference cleanly and scale efficiently. Claude ensures your model logic is sound, catches circular references, and suggests architectural improvements for maintainability.
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'll analyze your leaching circuit performance against industry standards, identify root causes of efficiency losses, and receive actionable optimization recommendations. The skill generates compliant standard operating procedures (SOPs) tailored to your process parameters, troubleshoots performance issues using your operational data, and calculates cost-benefit analysis for proposed improvements. You get a systematic approach to circuit optimization that reduces downtime, improves extraction rates, and minimizes operating costs.
by megalithic