Intermediate
Apportionment workpaper: factor sourcing rules and tie-outs
Builds an apportionment workpaper template and ties factor data back to GL/subledgers. Useful for defensible SALT filings and audit readiness.
Build an apportionment workpaper for {company_name} for {tax_year}.
Inputs:
- Sales by state and sourcing basis: {sales_by_state}
- Payroll by state: {payroll_by_state}
- Property by state: {property_by_state}
- State-specific factor rules (if known): {state_factor_rules}
- Tie-out sources (GL, payroll system): {tieout_sources}
Output:
1) Workpaper template with factor calculations and state inputs.
2) Tie-out steps and recon tables to source systems.
3) Exception checks (negative factors, missing states, inconsistent definitions).
4) Documentation checklist for audit defense.
Flag where state-specific rules may change outcomes.Related Prompts
Tax
IntermediateDepreciation book vs tax (MACRS/IFRS) schedule tie-out
Compares book depreciation to tax depreciation, identifies differences, and prepares supporting schedules. Useful for both compliance and provision teams.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
84
Tax
IntermediateSaaS: ASC 340-40 Commissions Capitalization
Amortizes sales commissions over the expected customer life.
GPT-4oClaude 3.5 Sonnet
0
0
63
Tax
IntermediateQualified Business Income (QBI) Deduction Tool
Determines the Section 199A deduction for pass-through entities and SSTBs.
GPT-4oClaude 3.5 Sonnet
0
0
49