#409 — Create residual reports table including all Commission fields
Repo: Twill-AI/facade State: closed | Status: done Assignee: meliascosta
Created: 2025-07-18 · Updated: 2025-11-19
Description
Sources of truth: Luqra: https://portal.luqra.com/residuals/my EMS: https://myportfolio.emscorporate.com/AgentMost/MonthlyResiduals.aspx
AC:
- Download all reports from Luqra and EMS and upload to a google drive folder
- Understand each field and match into one table
- Ingest the data automatically from the google drive (Patch)
- frontend should be able to merge this data with merchant revenue time sereis (GET)
- Define tasks required to complete the feature.
- Create facade master endpoint to add data to
merchant_kpi - Add CLI tools to
twill-datato ingest using the API - #476
For implementation details see: https://twillpayments.atlassian.net/wiki/spaces/TD/pages/407699457/Current+and+historical+commission+calculations
Notes
Add implementation notes, blockers, and context here
Related
Add wikilinks to related people, meetings, or other tickets