Overview

Use this reference when an annualized Position cost must be allocated across a selected report range or split among funding lines. It explains the two allocation methods, final contributing period rule, deterministic cent reconciliation, and the difference between displayed and exported money.

For the annualized amount that enters these rules, see Position cost calculation reference. For a practical investigation sequence, start with Reconcile position costs.

Actual calendar days

Actual calendar days uses each included day’s share of its calendar year.

For one slice:

period amount = annualized amount × included days ÷ days in that calendar year

A common year uses 365 days. A leap year uses 366. A range crossing New Year uses each year’s denominator for that year’s days.

For $52,000.00:

Period Exact calculation Display
February 2026 $52,000.00 × 28 ÷ 365 $3,989.04
February 2028 $52,000.00 × 29 ÷ 366 $4,120.22

A complete unchanged leap year still equals one annualized amount. FTE Tree does not automatically change annual hours in a leap year; annual hours changes only when your dated setup changes.

Even monthly

Even monthly assigns one-twelfth of annualized cost to a complete month.

full-month amount = annualized amount ÷ 12

A partial month uses:

partial-month amount = annualized amount ÷ 12 × included days ÷ days in that month

For $52,000.00, one complete month has an exact amount of $4,333.333333... and displays according to the selected-range reconciliation described below.

February 15 through 28, 2026 includes 14 of 28 days:

$52,000.00 ÷ 12 × 14 ÷ 28 = $2,166.666666...

If a pay changes on February 15, February 1 through 14 uses the old annualized amount and February 15 through 28 uses the new one.

Why period rows need reconciliation

Rounding each row independently can make the row sum differ from the rounded exact total. FTE Tree calculates the exact selected-range total separately and then reconciles the rows to that target.

The rule is:

  1. Calculate every period contribution without cent rounding.
  2. Calculate and round the exact total for the complete selected range.
  3. Round the individual period cells.
  4. Compare the row sum with the rounded exact total.
  5. Put the difference in the final period that has a positive contribution.

This is the final contributing period rule.

Three-month remainder example

Allocate $100.00 annualized cost over January through March using Even monthly.

The exact amount for each month is:

$100.00 ÷ 12 = $8.333333...

Month Exact amount Normal cent rounding Final displayed amount
January $8.333333... $8.33 $8.33
February $8.333333... $8.33 $8.33
March $8.333333... $8.33 $8.34
Total $25.000000... $24.99 row sum $25.00

The three displayed monthly amounts are $8.33, $8.33, and $8.34.

March is the final contributing period, so March receives the one-cent difference.

FTE Tree does not scatter the cent randomly, assign it to the first month, or change the recipient when the same report is run again.

A multi-cent negative remainder

Suppose six chronological exact cells are each $0.006.

  • Each cell would normally round to $0.01.
  • Six rounded cells would total $0.06.
  • The exact total is $0.036.
  • $0.036 rounds to $0.04.

The two-cent reduction begins at the latest contributing cell:

$0.01, $0.01, $0.01, $0.01, $0.00, $0.00

No cell becomes negative. If the final cell cannot absorb the complete reduction, the remainder continues backward through earlier contributing periods.

A period with more than one split cell

The final period can be split by funding source, department, job code, or another dated allocation. FTE Tree first uses the fraction discarded by cent rounding to choose the best line for the correction. If two lines have the same discarded fraction, the same inputs choose the same recipient even if you sort the report differently.

Display order does not decide the recipient. Reversing a table sort or rerunning the report does not move the cent.

Why a different date range can place the cent differently

The target is calculated for the complete selected range. Changing the start date, end date, allocation method, or included positions changes the report range and can change its final contributing period.

Two reports should place the same cent only when their dates, filters, allocation method, included positions, approved or proposed choice, and report timing all match.

Funding allocation

Funding percentages must total exactly 100.00%. FTE Tree does not change percentages to make an incomplete or excessive total equal 100%.

For $10.00 allocated 33.33%, 33.33%, and 33.34%:

Funding line Displayed amount
First 33.33% $3.33
Second 33.33% $3.33
33.34% $3.34
Total $10.00

FTE Tree compares the fractions left after rounding and assigns whole cents consistently so the funding lines equal the amount being allocated. If two fractions are equal, sorting the report differently does not change which line receives the cent.

For a date-range report, period reconciliation and funding reconciliation both apply. The completed position-period amount is the total the funding rows must equal.

Missing funding

Funding can be optional or required by your setup.

  • If optional and blank, the position cost can remain valid without a funding split.
  • If required, the position cannot complete approval without a valid allocation.
  • If rows exist, they must total exactly 100.00%.
  • Clearing funding through an import uses the documented clearing value rather than a $ amount.

Money presentation

Every money amount shown in FTE Tree uses the same rules:

  • $ appears before the numeric characters.
  • Grouping commas appear in displayed thousands.
  • Exactly two decimals appear, including .00.
  • A negative value displays with its sign in the numeric amount, such as $-125.50.
  • Missing money displays as -.
  • Exact zero displays as $0.00.

Restricted means you do not have access to that pay-derived value. It is not a blank and it is not $0.00. Do not substitute zero when reconciling a restricted report; use an analyst with the required compensation and department access.

Inputs can show $ as a visual prefix. Enter the numeric value without $ or commas unless the form explicitly says otherwise.

On-screen reports and exported files

The same money value has different presentation at different boundaries:

Location Example
Position page, approval, activity history, or on-screen report $50,000.00
CSV money cell 50000.00
Excel money cell 50000.00
Form entry 50000.00
Import numeric cell 50000.00

CSV and Excel numeric cells do not include $, USD, or grouping commas. This makes the values easier to reuse in other tools.

Excel money values are exported as text to preserve their decimal places. If you convert those cells into spreadsheet numbers, document the spreadsheet’s precision and rounding settings as part of your reconciliation.