Evidence and data quality
Build a Chargeback Timeline Without Timezone Contradictions

Build the timeline in one display timezone, but retain every event’s original timestamp and timezone. This lets a reviewer compare events without losing the source record. Converting timestamps without preserving their origin can hide mistakes, especially around midnight, daylight-saving changes and delayed system updates.
The purpose is to establish a defensible sequence of payment, cancellation, fulfillment and communication events. It is not to calculate the merchant’s response deadline. Keep that operational deadline in a separate field so it cannot be confused with the time an underlying transaction event occurred.
Preserve the original time before converting it
For each event, collect the original timestamp string, source system, field name and any recorded timezone or offset. Also record whether the time represents the event itself, the system’s receipt of the event or the date the record was exported.
These distinctions matter. A carrier scan can occur before Shopify receives the update. A support message can be written before it reaches a shared inbox. An accounting export can be created days after the underlying refund transaction. Do not order those events solely by when they appeared in your dashboard.
If the source lacks a timezone, record that uncertainty. A store’s current timezone setting does not necessarily establish the timezone used by an old third-party export. Ask the system owner or consult the relevant field documentation. Do not choose the timezone that creates the most favorable sequence.
Shopify’s response guidance includes transaction chronology among the facts merchants may need to establish. Your timeline should preserve the underlying records supporting those facts. Shopify’s dispute process guidance
Use a consistent conversion rule
Choose a display standard, such as UTC, and state it above the table. Convert from the recorded offset or a verified named timezone appropriate to the event date. A named timezone can have different offsets across the year; using today’s offset for a historical date can create an error.
Do not silently turn a date-only record into midnight. A record showing only a calendar date provides a range within that day, not a precise instant. Represent it as “date only” and keep it separate from events with exact times when the order cannot be determined.
Similarly, if two sources are only precise to the minute, do not infer a second-by-second sequence. State that the events share the displayed minute unless another authoritative record resolves their order.
A hypothetical midnight contradiction
Consider a hypothetical order with a cancellation message recorded at 23:50 with an offset of minus five hours. A fulfillment system records a shipment event at 04:40 UTC on the following calendar date. Looking only at the displayed dates makes shipment appear later than cancellation.
After normalization, the cancellation is 04:50 UTC. The shipment event is ten minutes earlier. That sequence may matter, but the meaning of “shipment event” still needs checking: was it a label creation or physical carrier acceptance?
| Event | Original record | Normalized display | Interpretation |
|---|---|---|---|
| Carrier acceptance | 04:40 UTC | 04:40 UTC | Parcel accepted, if source confirms |
| Cancellation message | 23:50, UTC−05:00, prior date | 04:50 UTC | Message event in support system |
| Shopify update | 05:05 UTC | 05:05 UTC | Update arrival, not physical handoff |
The merchant should not use Shopify’s later update time as the shipment time. Nor should the merchant claim that the customer knew shipment had occurred merely because the carrier acceptance preceded the message. The timeline establishes sequence, not awareness.
Use a chronology worksheet
Create one row per material event with these fields:
Event description: [precise action]. Source: [system and record]. Original time: [unchanged value]. Timezone evidence: [offset, documented setting or unknown]. Time type: [occurrence, ingestion, update or export]. Normalized time: [converted value or unresolved]. Precision: [seconds, minutes or date only]. Exhibit reference: [page]. Open question: [if any].
Keep a short conversion note with the worksheet. It should identify the chosen display timezone, the method used and any manual corrections. If a colleague repeats the conversion, they should reach the same result from the retained source values.
For ambiguous local times around a daylight-saving transition, do not guess which occurrence was intended. Seek the recorded offset, a neighboring event with an unambiguous timestamp or a processor-confirmed time. If none exists, mark the sequence uncertain and avoid a precise claim dependent on it.
Audit the narrative against the timeline
After building the table, compare every date and time in the merchant statement with the normalized record. Writers often introduce contradictions when they shorten a timestamp to a date or describe an update as an event.
Use a consistent style in captions and prose. Where local time matters, show it alongside the standard display rather than switching silently. Keep the original timezone visible in the supporting exhibit so a reviewer can understand an apparent date difference.
Stripe recommends chronological evidence organization; the added discipline here is preserving the meaning and provenance of each timestamp. Stripe’s evidence guidance
Finally, separate what is certain from what remains unresolved. A truthful statement such as “the available records do not establish whether the date-only cancellation preceded carrier acceptance” is stronger than an exact timeline assembled from assumptions. The finished chronology should make both the sequence and its evidential limits easy to inspect.
Keep the dispute reason, amount and response deadline visible in Lower Chargeback while you prepare your response in Shopify or with your provider.
Related reading in this collection:
- Link a Chargeback to the Correct Shopify Order and Payment Record
- Read a Disputed Order’s Authorization and Capture Events in Shopify
- Shopify Chargeback Evidence File Limits: Prepare Readable Uploads