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 can systematically prepare tax provisions that survive audit scrutiny by calculating current and deferred tax impacts, reconciling effective tax rates from statutory to reported amounts, and documenting uncertain tax positions with FIN 48 support. The skill guides you through multi-jurisdictional tax exposure analysis and helps you create audit-ready workpapers with clear audit trails for quarterly (10-Q) and annual (10-K) financial statement filings.
by eryet
You can analyze transaction clusters to identify layering, placement, and integration schemes using proven AML methodologies. Claude applies typology frameworks to suspicious fund flows, cross-border movements, and beneficiary ownership chains—transforming raw transaction flags into regulatory-grade narratives that justify SAR escalation and withstand compliance audits.
by eryet
You can execute structured compliance audits that map regulatory requirements to operational controls, test control effectiveness with documented evidence, quantify compliance risk exposure, and track remediation progress with clear accountability. The framework produces audit findings in regulatory-acceptable format, transforming ad-hoc reviews into defensible procedures that satisfy internal audit standards (IIA) and regulatory expectations.
by eryet
You can analyze insurance claim files to uncover fraud indicators by synthesizing evidence from policyholder statements, medical/repair records, financial documents, and prior claims history. This skill helps you reconstruct timelines, identify inconsistencies and impossibilities, recognize suspicious financial patterns, and build defensible fraud conclusions suitable for claims adjustment, litigation support, or settlement negotiations. Transform raw claim data into an evidence hierarchy distinguishing confirmed facts, supported inferences, and investigative leads requiring further development.
by eryet
You can allocate indirect costs (administration, utilities, depreciation, maintenance) across clinical and non-clinical departments using activity-based costing (ABC) and traditional allocation methodologies. This skill helps you calculate precise allocation rates, model reimbursement scenarios, validate cost driver selections, and document allocation methods for compliance—enabling data-driven decisions on service line profitability, pricing strategies, and payer contract negotiations.
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
You can automatically detect attendance discrepancies across time-tracking data, classify exceptions by root cause (system errors, policy violations, legitimate absences), and generate audit-ready documentation. This skill establishes decision frameworks that handle routine exceptions efficiently while flagging complex cases for human review, reducing payroll processing time by 60-70% while improving accuracy and reducing compliance liability.
by eryet
You can rapidly design, document, and validate internal control frameworks aligned with COSO 2013, SOX compliance, and audit standards. Claude helps you map business processes to control objectives, create control matrices linking risks to preventive and detective controls, generate control narratives for auditors, and identify control gaps for remediation planning—compressing what typically takes 200+ annual hours into a fraction of that time while improving control design quality.
by eryet