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 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
This skill automates the complex work of calculating material price, quantity, and usage variances; labor rate and efficiency variances; and overhead variances across products, departments, and time periods. You input production data and standard cost tables, and Claude processes the variance calculations, organizes findings by significance, and generates detailed narratives explaining root causes of deviations. This transforms hours of spreadsheet manipulation into a structured analysis package ready for management review and variance committee meetings.
by eryet
You can rapidly cross-reference transaction patterns, revenue data, and economic activity against state-specific nexus thresholds to identify which states trigger filing obligations. The skill flags compliance gaps across physical presence, economic nexus, click-through, and affiliate nexus types, helping you determine filing requirements, quantify retroactive exposure risk, and prioritize registration in new states as clients expand.
by eryet
You can upload aging reports and AR subledger data to Claude, which analyzes bucket distributions, reconciles balances to the general ledger, flags anomalies and aging pattern irregularities, and generates documented collection strategies. Claude produces prioritized customer lists, DSO benchmarking analysis, allowance adequacy assessments, and compliance-ready audit schedules—transforming raw AR data into actionable cash flow optimization strategies.
by eryet
You can systematically validate employee payroll records, cross-check tax withholding calculations against current tax brackets, verify regulatory compliance across federal/state/local requirements, and flag anomalies that could trigger penalties—all before executing payment runs. This reduces processing time by 40-60% while catching errors that manual spreadsheet reviews typically miss, working across ADP, Workday, Gusto, and manual payroll systems.
by eryet
You systematically extract financial red flags from claim submissions, construct causal narratives linking evidence to fraud conclusions, and quantify potential loss exposure. This skill helps you distinguish between legitimate claim variations and fraud indicators, enabling you to generate investigation summaries defensible in litigation, settlement negotiations, or Special Investigation Unit (SIU) presentations.
by eryet
This skill helps you audit nexus comprehensively by analyzing physical presence rules, economic thresholds, affiliate connections, and marketplace facilitator statutes across all 50 states and relevant localities. You'll document nexus triggers specific to your client's business model—whether they're selling through marketplaces, using drop-shipping, hiring remote employees, or expanding operations. The result is an actionable filing calendar and remediation strategy that minimizes compliance gaps and protects against substantial back-tax assessments, penalties, and interest.
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