GASB Financial Statement Reconciliation & Variance Analysis
Reconcile fund balance to government-wide statements with GASB-compliant variance documentation
What You Can Do
You can reconcile fund balance accounting to government-wide net position/net assets by identifying and documenting the specific adjustments required under GASB standards. This skill helps you isolate timing differences between cash and accrual methods, classify variances as timing or substantive, and produce detailed explanations that auditors require. You'll prepare reconciliation schedules, variance analysis documentation, and supporting workpapers that demonstrate compliance with GASB presentation and disclosure requirements.
Features
identify specific GASB adjustment categories (capital assets, long-term liabilities, deferred inflows/outflows)
distinguish accrual vs. cash method variances and quantify their impact on fund vs. government-wide reporting
generate audit-ready explanations for significant discrepancies with supporting calculations
trace internal transfers, capital leases, and internal service fund allocations across fund and government-wide statements
validate major fund reconciliation to budgetary basis
properly classify timing items affecting Statement of Activities
document significant changes and justify movement between restricted categories
maintain workpaper trail documenting all proposed entries and their GASB classification
Example Output
Example 1: Fund Balance to Net Position Reconciliation
General Fund Fund Balance (budgetary basis): $2,450,000
Adjustments:
+ Capital assets purchased (expended in fund): $385,000
- Accumulated depreciation (not in fund): ($92,500)
+ Long-term debt issued (other financing source): $1,200,000
- Principal paid this period (expenditure): ($150,000)
+ Accrued receivables not collected: $47,500
= Government-wide Net Position: $3,740,000
Example 2: Variance Explanation General Fund actual expenditures exceeded budget by $125,000 (3.2%). Root causes: (1) Timing — grant reimbursements received in subsequent period ($75,000 timing difference), (2) Staffing — unforeseen leave payouts in final month ($35,000 substantive variance), (3) Utilities — winter weather impact on heating costs ($15,000 non-recurring). Conclusion: Variance primarily timing-driven; no corrective action needed for subsequent year budget.
Example 3: Interfund Transfer Schedule
Transfer from General Fund to Debt Service: $500,000
Transfer to Internal Service Fund: $125,000
Reciprocal subsidy from Enterprise Fund: ($45,000)
= Net impact on General Fund: $580,000
What's Included
- SKILL.md: Complete GASB reconciliation workflow with decision trees for timing vs. substantive variances
- Fund Balance to Net Position Reconciliation Template: Step-by-step mapping of adjustments by GASB category
- Variance Analysis Checklist: Audit-ready documentation requirements for discrepancies over materiality threshold
- Interfund Transfer Reconciliation Schedule: Template for tracing transfers across fund and government-wide statements
- Supporting Workpaper Framework: Calculation templates for deferred inflows/outflows, capital assets, and long-term obligations
Who It's For
- Government accountants closing the fiscal year and reconciling fund-based to accrual statements
- Finance managers preparing for annual independent audits and addressing auditor inquiries
- Accounting teams documenting Schedule of Revenues, Expenditures, and Changes in Fund Balance for major funds
- Internal audit staff validating GASB compliance and testing reconciliation controls
- Budget analysts explaining significant variances between budgeted and actual results to governing boards
Best For
- Year-end fund balance reconciliation to government-wide net position
- Documenting timing differences between cash and accrual accounting methods
- Generating variance explanations for auditor review and management inquiry
- Tracing interfund transfers, capital leases, and internal service fund allocations
- Preparing supporting schedules for Statement of Activities and fund-level financial statements
- Reconciling period-over-period changes in restricted and unrestricted fund balances
You might also like
You receive a comprehensive framework for evaluating diversified passive income streams, assessing client risk profiles, and recommending portfolio structures that maximize income while maintaining alignment with financial objectives. The skill analyzes income sources (real estate, dividends, bonds, peer lending, digital assets), models cash flow projections, evaluates tax efficiency, and provides data-driven strategy recommendations ranked by performance potential.
by eryet
You can systematically evaluate payment timing decisions across your vendor base by modeling discount capture opportunities against working capital requirements. The skill analyzes vendor payment terms, your cash flow constraints, and strategic vendor priorities to generate prioritized payment schedules that maximize savings while maintaining adequate liquidity and protecting critical supplier relationships.
by eryet
Create comprehensive, personalized wealth strategies that align client assets, goals, and risk tolerance. You can assess complex financial situations, generate multi-faceted investment and tax strategies, and produce professional recommendations that incorporate goal timelines, asset allocation frameworks, and tax efficiency considerations. The skill helps you move beyond generic advice to deliver actionable, client-specific wealth plans backed by structured analysis.
by eryet
You can generate professionally formatted SVG color palettes by providing a theme name, source URL, or specific hex codes. Claude researches color standards, extracts values from web sources, and organizes 4-7 swatches from dark to light with an anchor brand color at center. Each swatch includes click-to-copy hex codes and hover effects for easy reference.
by eryet
You can trace financial transactions across multiple accounts and entities, document complete chain-of-custody for audit evidence, identify fraud indicators and anomaly patterns, and construct defensible audit conclusions that satisfy both forensic rigor and legal admissibility requirements. This skill provides structured protocols for adversarial skepticism, hostile cross-examination preparation, and quantification of losses or damages with transparent methodologies.
by eryet
You can rapidly analyze invoice exceptions—including three-way match failures, discrepancies, duplicates, policy violations, and tax code errors—and automatically assign severity levels (critical, high, medium, low) based on financial impact and risk. Claude then generates targeted remediation instructions and routes each exception to the appropriate resolver (AP clerk, manager, tax team, or procurement), complete with audit trails for compliance and first-touch resolution tracking.
by eryet
You can upload aging data from your accounting system and Claude will systematically categorize invoices by delinquency bucket, identify high-risk accounts with payment pattern analysis, explain why balances are aging, and generate prioritized collection strategies with account-specific context. This transforms static aging reports into actionable recovery plans that help you understand portfolio health and accelerate cash flow.
by eryet
You can systematically classify and track expenses against specific restricted grants and donations, reconcile fund balances with compliance verification, and generate accurate financial statements that separate restricted and unrestricted funds. This skill prevents audit failures, donor relation damage, and grant non-compliance penalties by ensuring every restricted fund expense is properly documented, allowable under grant terms, and traceable to donor/grantor requirements.
by eryet