Convenience fees missing from invoice data export totals
Objective
Align invoice exports and Reports Hub revenue views with QuickBooks by including every convenience-fee component, exposing each fee type as its own column, adding an explicit total with fees column, and backfilling historical Attik inspections so finance can trust the dataset.
Background
- Discrepancies show up on invoices such as AJF40 and AJF110 because exported totals omit convenience fees that exist on the live invoice record.
- Field metadata for exports is centralized in
attik-backend/src/config/exportFieldDefinitions.tsalongside charge and payment catalogs that already surface fee-adjacent attributes (feeDisabledlives onattik-backend/src/models/inspectionSchema.ts). - Reports Hub renders configured runs through
attik-frontend/src/app/tools/data-exports/runs/[id]/RunReportClient.tsxwith filter summaries built fromReportFiltersSection.tsx.
Scope
Backend
- Add the missing fee columns and total-with-fees fields to export definitions, aggregation joins, and any sync routines that populate inspection totals; run the requested backfill across historical Attik jobs.
Frontend
- Surface the new row or columns in saved Reports Hub templates so operators can select them like other financial fields.
References
attik-backend/src/config/exportFieldDefinitions.tsattik-backend/src/models/inspectionSchema.tsattik-frontend/src/app/tools/data-exports/runs/[id]/RunReportClient.tsx- Example invoice IDs noted in the ticket (
AJF40,AJF110)
Status: Completed
Log in to comment and vote
No comments yet
Be the first to share your thoughts.