QuickBooks Reconciliation & Audit Assistant
Reconcile accounts and audit QuickBooks transactions with step-by-step guidance
What You Can Do
You can systematically reconcile bank accounts, credit cards, and liability accounts in QuickBooks while maintaining a complete audit trail. The skill guides you through identifying discrepancies, analyzing unreconciled transactions, and verifying journal entries to ensure accuracy and compliance. You'll gain confidence in your financial records and be ready for audits with documented reconciliation workflows.
Features
step-by-step guides for bank, credit card, and liability account reconciliation
identify and categorize stuck transactions by age, amount, and type
structured approaches to resolve common reconciliation gaps
verify entries against source documents and flag unusual patterns
handle foreign exchange differences and currency-specific reconciliations
export documented reconciliations with supporting evidence
comprehensive pre-audit preparation and documentation guide
protocols for handling transfers, reversals, and correction entries
Example Output
Example 1: Reconciliation Summary
- Account: Checking Account (ABC Bank)
- Statement Balance: $45,230.15 | Book Balance: $45,105.32
- Difference: $124.83 (2 unreconciled items)
- Outstanding check #1047 ($87.50)
- Deposit in transit ($212.33)
Example 2: Unreconciled Transaction Grouping
- 47 transactions pending: 0-30 days (12), 31-60 days (18), 60+ days (17)
- Amount analysis: $500+ (3), $100-500 (14), <$100 (30)
- Next steps: Verify statements, contact vendors, review entries
Example 3: Audit Readiness Status
- ✓ Bank reconciliations completed for fiscal year-end
- ✓ Outstanding check register verified
- ✓ Intercompany transactions documented
- ⚠ 3 manual journal entries need supporting documentation
What's Included
- Comprehensive SKILL.md with reconciliation protocols and decision trees:
- QuickBooks Reconciliation Workflow Checklist (print-friendly):
- Account Reconciliation Template (bank, credit card, loan accounts):
- Unreconciled Transaction Analysis Worksheet:
- Journal Entry Audit Verification Template:
- Multi-Currency Reconciliation Guide:
- Common Reconciliation Discrepancies Troubleshooting Guide:
- Audit Readiness Preparation Checklist:
- Month-End Close Reconciliation Procedure:
Who It's For
- Bookkeepers and accounting clerks managing QuickBooks accounts
- CPAs and accountants preparing for client or internal audits
- Financial controllers responsible for month-end and year-end closes
- Business owners reviewing financial accuracy before audit season
- AP/AR specialists reconciling subsidiary ledgers and account balances
Best For
- Monthly bank and credit card account reconciliations
- Identifying and resolving long-outstanding discrepancies
- Pre-audit preparation and documentation
- Year-end close procedures and financial statement preparation
- Training staff on proper reconciliation procedures and audit readiness
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 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
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 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
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
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
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