What it is
Multistate businesses split their income among the states where they file using factors for property, payroll and sales. States differ on weights, many use a single sales factor, and sourcing rules vary.
Enter the weights your states use, then property, payroll and sourced sales by state. The workbook computes each factor, the apportionment percentage, apportioned income and estimated tax at your state rates, and checks that the percentages add to 100 percent.
When to use it
- Preparing multistate returns.
- Estimating state tax by jurisdiction.
- Reviewing the effect of moving operations.
What’s inside
- Weights for property, payroll and sales
- 15 state rows with factor amounts
- Factors, apportionment percentage and apportioned income
- Estimated tax and a sum-to-100-percent check
Standard cited
This template follows State income tax law. It is written in our own words, except for phrases the standard requires the document to contain, with [bracketed placeholders] for client details, amounts in USD and dates as MM/DD/YYYY. Check it against the current standard and your firm’s methodology before use.
Questions
Which weights apply?
Each state sets its own. Enter the weights for the states in the sheet, and make a copy for a state that uses different weights.
What if a factor has no amount anywhere?
Its factor is zero. Some states then drop the factor, so set its weight to zero.
Does it handle nonbusiness income?
No. Allocation of nonbusiness income is not modeled.
Related templates
- Sales Tax Nexus Matrix (Excel)
- Income Tax Provision Workbook (ASC 740)
- Rate Reconciliation Template (ASC 740)
- Business Tax Return Review Checklist
Last updated 11/05/2026. All free templates.