Beat Expense Mileage Log Quarter Total

Audit actual quarter mileage/expense rows using caller minor-unit-per-km reimbursement, rounding each trip half-up and excluding exact next-quarter boundary; not tax mileage rates, travel entitlement or currency conversion.

Description

Quarter mileage totals require actual trip dates and an explicit reimbursement rate.

Quarter mileage totals require actual trip dates and an explicit reimbursement rate. Per-trip rounding can differ from rounding one quarter total.^[1]

Enter aligned nonempty dates/nonnegative safe-integer meters/expenses, nonnegative integer rate and exact Jan/Apr/Jul/Oct1 quarter start1900–2199. Return in-quarter indices, distance, separately rounded mileage, other costs and total.

When to use Beat Expense Mileage Log Quarter Total

Use Beat Expense Mileage Log Quarter Total when you need to evaluate the supplied records under the calculation and evidence rules below. No tax rate, entitlement or currency conversion is supplied; all money shares one currency.

Prepare the actual editorial, source, layout, timing or audience records requested. Supply explicit house-policy limits and preserve missing evidence.

How to use Beat Expense Mileage Log Quarter Total and understand its results

Prepare the actual editorial, source, layout, timing or audience records requested. Supply explicit house-policy limits and preserve missing evidence.
Enter tripDates, tripDistancesMeters, tripOtherExpensesMinor, callerMileageRateMinorPerKm, quarterStartDate using the field table and calculation rules, then run the tool.
Read inQuarterTripIndices, quarterDistanceMeters, quarterMileageReimbursementMinor, quarterOtherExpensesMinor, quarterTotalBeatExpenseMinor. The explanation below defines the units, signs, ordering and any flags or placeholder values.
If the tool reports an input issue, correct the values and run it again. Apply the stated assumptions when interpreting a successfully returned result.

Input field	Meaning	Value type; see rules below	Requirement
tripDates	Trip dates	list of string	Required
tripDistancesMeters	Trip distances meters	list of number	Required
tripOtherExpensesMinor	Trip other expenses minor	list of number	Required
callerMileageRateMinorPerKm	Caller mileage rate minor per km	number	Required
quarterStartDate	Quarter start date	string	Required

tripMinor=roundHalfUp(meters×rateMinorPerKm/1000); include dates in [quarterStart,nextQuarter)

Units, indexing, boundary conditions and exceptional cases are defined in the calculation rules above.

Output field	Meaning	Value type
inQuarterTripIndices	In quarter trip indices	list of number
quarterDistanceMeters	Quarter distance meters	number
quarterMileageReimbursementMinor	Quarter mileage reimbursement minor	number
quarterOtherExpensesMinor	Quarter other expenses minor	number
quarterTotalBeatExpenseMinor	Quarter total beat expense minor	number

json

{
  "input": {
    "tripDates": [
      "2025-01-01",
      "2025-04-01"
    ],
    "tripDistancesMeters": [
      1500,
      2000
    ],
    "tripOtherExpensesMinor": [
      50,
      80
    ],
    "callerMileageRateMinorPerKm": 100,
    "quarterStartDate": "2025-01-01"
  },
  "output": {
    "inQuarterTripIndices": [
      0
    ],
    "quarterDistanceMeters": 1500,
    "quarterMileageReimbursementMinor": 150,
    "quarterOtherExpensesMinor": 50,
    "quarterTotalBeatExpenseMinor": 200
  }
}

Limitations and assumptions

No tax rate, entitlement or currency conversion is supplied; all money shares one currency.

Numeric inputs, where present, must be finite. Follow the calculation-specific rules for overflow, underflow and exceptional cases. Numeric lists are limited to 10,000 entries; string lists to 128 strings of at most 128 characters each. The rules above may impose smaller limits. Extremely large text inputs are rejected. Missing required fields, extra fields, wrong value types and violations of the calculation rules are input errors.

Alternative or Complementary methods

Use Expenses per Story Cap Policy Lookup: Expense preapproval and an unapproved-overage cap define separate budgets. Signed margins retain underspend and overspend. For a complementary task, use Kill Fee Percent Unaccepted Pitch Lookup: A commissioned-story cancellation fee depends on an explicit contract trigger and rate. An already paid advance can leave a signed balance.

References

Beat Expense Mileage Log Quarter Total — tool.io

Similar or alternative tools

Expenses per Story Cap Policy Lookup
Expense preapproval and an unapproved-overage cap define separate budgets. Signed margins retain underspend and overspend.
Kill Fee Percent Unaccepted Pitch Lookup
A commissioned-story cancellation fee depends on an explicit contract trigger and rate. An already paid advance can leave a signed balance.