Spreadsheet checks before running Wage Backpay in Alaska
5 min read
Published April 15, 2026 • By DocketMath Team
What the checker catches
Run this scenario in DocketMath using the Wage Backpay calculator.
Before you run Wage Backpay calculations in Alaska with DocketMath, a spreadsheet check can prevent the most common “garbage-in, garbage-out” problems. For Alaska, DocketMath’s wage backpay calculator relies on time-based inputs tied to Alaska’s general statute of limitations: 2 years under Alaska Statutes § 12.10.010(b)(2). Because no claim-type-specific sub-rule was found in the jurisdiction data you provided, the checker uses this general/default 2-year period as the applicable limit for filtering eligible backpay dates.
Here’s what the checker catches in your worksheet before you compute:
Date-field mismatches
- Start date / end date entered in the wrong column
- End date earlier than the start date
- “Payment date” used where “work date” is required (or vice versa)
Off-by-one problems
- Row filtering that accidentally drops a day at the beginning or end of the lookback window
- Time zone or spreadsheet date serial conversions shifting dates by 1 day
**Lookback-window errors (Alaska time logic)
- Using the wrong limitation period (e.g., 1 year or 3+ years)
- Filtering out dates incorrectly relative to the “as of” date you’re using for the backpay period
- Applying the limit to the wrong date field (for example, filtering on payment date when your sheet intends to filter on work date)
Inconsistent wage math
- Hour totals that don’t match the sum of line items per day/week
- Rate changes not reflected correctly (e.g., multiple hourly rates across different dates)
Unit drift
- Mixing hours and minutes columns without conversion
- Treating biweekly pay hours as daily hours (or other period-length mixups)
Missing or nonnumeric values
- Blank rate cells
- Text-formatted numbers (common when copying/pasting from payroll systems), which can break totals and filters
Pitfall to watch: If your spreadsheet filters the date range using a limitation period other than the Alaska general 2-year period in AS § 12.10.010(b)(2), the output backpay figure can be materially understated or overstated—even if your hourly math is perfect.
Alaska rule the checker applies (general/default)
- General SOL period: 2 years
- Citation: **Alaska Statutes § 12.10.010(b)(2)
- How it affects your sheet: the checker verifies that your worksheet’s date filtering aligns with a 2-year lookback relative to the date you specify as the calculation “as of”/trigger date—whatever label you use, it must be consistent across the calculator inputs and the sheet.
When to run it
Run the checker immediately before you feed dates and wages into DocketMath /tools/wage-backpay. In practice, that means two high-value moments:
After you import or paste payroll data
- Validate that every row has:
- a work date (or period date) that matches the calculator’s expected structure
- an hourly rate and hours (or the wage amount inputs you’re using)
- Catch “text dates” early—this is where off-by-one errors are born.
After you define the backpay window in your spreadsheet
- The limitation filter is where spreadsheets often diverge from the intended rule.
- Confirm your filtered rows are consistent with the Alaska 2-year general period under AS § 12.10.010(b)(2) (and remember: this is the general/default period because no claim-type-specific sub-rule was identified in the jurisdiction data you provided).
A simple workflow checklist:
Try the checker
You can use DocketMath’s Wage Backpay workflow at:
- Primary CTA: /tools/wage-backpay
If you’re building your spreadsheet, structure your sheet so the checker can validate:
- Work dates by row (or a clear date range per row)
- Hours (or wage amounts) by row
- Applicable wage rate(s) when rates differ across time
- An “as of” date that anchors the 2-year lookback window for Alaska
How inputs change outputs (what to expect)
When the checker runs, it typically produces the most meaningful “diffs” in these areas:
Filtered eligible rows
- If your lookback window is correct, only rows dated within the last 2 years under AS § 12.10.010(b)(2) stay in the eligible set.
- Rows outside the window should be excluded from backpay totals.
Recalculated aggregates
- Total eligible hours and wages will change if:
- rows were previously excluded incorrectly (date mismatch)
- rate/hours were misaligned
- numeric formatting prevented true summation
Alerting for structural issues
- Blank rates, nonnumeric cells, or swapped columns usually trigger warnings so you can fix the spreadsheet before running the final backpay calculation.
If you want a quick sanity test before committing to a full run:
- Pick 3–5 rows at the boundary of your 2-year window (the earliest eligible date and just-beyond it).
- Confirm the checker includes the eligible boundary rows and excludes the day(s) beyond the window.
- Then run the full /tools/wage-backpay calculation.
Gentle note (non-legal advice)
This checker and walkthrough are meant to help you clean data and align your spreadsheet logic with the general/default 2-year period shown in Alaska Statutes § 12.10.010(b)(2). If your situation involves unusual facts or different time rules than a general wage backpay approach, you may need to map the specific legal theory to the correct limitation period separately.