Timezone Conversion
Overview
Vendo uses your account timezone to ensure ad performance, payment transactions, and sync schedules align with your local calendar dates. All data is stored in UTC internally and converted to your configured timezone for reporting.
Account Timezone
Set your account timezone in Settings > Account > Regional Settings. This timezone is used for:
- Report dates — Determines which calendar date a transaction or ad impression belongs to
- Sync scheduling — Controls when daily syncs run (e.g., “5:00 AM” in your timezone)
- Dashboard display — Date ranges and time-based charts use your timezone
Default timezone: America/New_York
How Timezone Affects Report Dates
When a Stripe payment occurs at 11:00 PM UTC on January 5th:
| Account Timezone | Report Date |
|---|---|
UTC | January 5 |
America/New_York (UTC-5) | January 5 |
Asia/Tokyo (UTC+9) | January 6 |
The same conversion is reported on different calendar dates depending on your timezone setting. This ensures your Vendo reports match your business’s local date.
Per-Source Sync Scheduling
Each source can have its own sync anchor timezone, controlling when daily syncs trigger:
| Setting | Description |
|---|---|
| Sync Anchor Time | Time of day to run the sync (e.g., 05:00) |
| Sync Anchor Timezone | IANA timezone for interpreting the anchor time |
For example, a sync anchor of 05:00 America/New_York triggers at 5:00 AM Eastern, which automatically adjusts for daylight saving time.
Supported Timezones
Vendo supports 550+ IANA timezone identifiers covering all regions. Common examples:
| Timezone | UTC Offset |
|---|---|
America/New_York | UTC-5 (UTC-4 DST) |
America/Los_Angeles | UTC-8 (UTC-7 DST) |
America/Chicago | UTC-6 (UTC-5 DST) |
Europe/London | UTC+0 (UTC+1 DST) |
Europe/Berlin | UTC+1 (UTC+2 DST) |
Asia/Tokyo | UTC+9 |
Asia/Shanghai | UTC+8 |
Australia/Sydney | UTC+11 (UTC+10 DST) |
UTC | UTC+0 |
Daylight saving time offsets are handled automatically.
Platform-Specific Notes
Ad Platforms
Ad platform data (Google Ads, Meta Ads, etc.) is reported using the ad account’s timezone from the platform. Vendo converts this to your account timezone for unified reporting.
Stripe & PayPal
Payment timestamps arrive in UTC. Vendo applies your account timezone to determine the report date for each transaction.
Mixpanel
When syncing data with Mixpanel, Vendo uses the Mixpanel project timezone (configured in your destination settings) to ensure event timestamps align correctly.