16 views
-/https://github.com/berriai/litellm/issues/27780
GitHub Β· issue

#27780 [Bug]: /user/daily/activity overstates totals for single-day window in non-UTC timezones (timezone expansion not partitioned back to local day)

  • State: open
  • Author: @mikysco
  • Labels: llm translation, ui-dashboard

### Check for existing issues - [x] I have searched the existing issues.

### What happened?

The proxy `/user/daily/activity` endpoint (and the Usage page in the UI that consumes it) returns spend and request counts that are larger than what is actually in `LiteLLM_DailyUserSpend` for the user-requested date range, when the caller is in a non-UTC timezone.

**Customer context:** A customer was comparing LiteLLM-tracked spend for a single GCP project against GCP Billing for May 11, 2026 to validate spend tracking. The LiteLLM Usage page (Project Spend, "May 11 β†’ May 11") showed **$8.7824** across **176 requests**. A direct SQL query against `LiteLLM_DailyUserSpend` for May 11 only showed **$0.99** across **38 calls**, which matches GCP Billing closely (~$1.10 after savings). So spend capture is correct β€” the daily-activity endpoint is the source of the inflated number, and it eroded customer trust in the dashboard. Without doing the SQL query ourselves, the customer would have walked away believing LiteLLM was off by ~8x.

### Root cause (suspected)

In `litellm/proxy/management_endpoints/common_daily_activity.py`:

- `_adjust_dates_for_timezone` (line 382) intentionally expands th…

GitHub resolver

Import GitHub neighbors on demand. Results are saved as system ingests.

Refresh page
vote history (1 events)
#0 of 0 Β· 31d18h48m41s ago β€” entered Β· #import:https:::github.com:berriai:litellm post #2073
The left change has broader data-aggregation implications, timezone boundary risks, and likely cross-layer validation; the right is more localized routing-resolution logic with narrower regression coverage.
discussed in #import:https:::github.com:berriai:litellm

ranked child groups

no voted pairs yet in this scope

cli
src
spread
search