Prove the export with six fictional records.
A six-case acceptance fixture and duration converter for checking time-record exports: units, dates, corrections, duplicate records and missing fields.
Work-record field guide
Make the outgoing file mean what you intended
Check fields, formats, dates, units, duplicate records and total differences before handing data to another system.
Preserve the source, compare like with like, and explain each transformation before accepting a total.
Documentation reviewed · 23 Sep 2026No hands-on merchant testing
Start with the unresolved decision
Start with the untouched export and the receiving specification. Check field meaning and granularity before diagnosing dates, units, rounding or duplicate records. The calculators explain arithmetic using fictional inputs; they cannot decide whether a work record is valid or payable.
Keep the outcome and its limits together
Record what passed, failed or remained unknown. Product features depend on the selected plan and configuration, and these guides do not establish employment, payroll or legal requirements. If the current process already meets the need reliably, keeping it remains an option.
Choose your next check
Build a time-record export data dictionary
Define field type, identity, nulls, unit and meaning for the receiving workflow.
Choose CSV, spreadsheet or PDF for a time report
Match machine-readable handoff or human review to the recipient.
Agree a reporting time zone before comparing totals
Align dates, offsets, grouping and report settings.
Reconcile work records that cross midnight
Preserve elapsed duration while applying an explicit date-assignment rule.
Find the difference between rounding rows and totals
Compare mathematical rounding stages without choosing employment or billing rules.
Import a time CSV without changing its meaning
Preserve identifiers, dates, duration types and original source data.
Find duplicate time records before merging files
Distinguish duplicate identity from merely similar work.
Check overlapping intervals without deleting valid work
Quantify overlap and escalate competing interpretations.
Trace missing entries through capture and export
Localize absent rows using counts, filters, identity and state.
Explain why a report and export disagree
Reconcile population, period, unit, state and rounding in order.
Choose entry, daily or period totals
Keep the detail necessary for the decision and avoid inferring lost history.
Sources and boundaries
Primary documentation supports the dated product facts. Proposed checks and fictional examples are our editorial method, not observed product results.
- DeskTime — export · checked September 23, 2026
- Time Doctor — export · checked September 23, 2026