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.ts alongside charge and payment catalogs that already surface fee-adjacent attributes (feeDisabled lives on attik-backend/src/models/inspectionSchema.ts).
  • Reports Hub renders configured runs through attik-frontend/src/app/tools/data-exports/runs/[id]/RunReportClient.tsx with filter summaries built from ReportFiltersSection.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.ts
  • attik-backend/src/models/inspectionSchema.ts
  • attik-frontend/src/app/tools/data-exports/runs/[id]/RunReportClient.tsx
  • Example invoice IDs noted in the ticket (AJF40, AJF110)

Please authenticate to join the conversation.

Upvoters
Status

Completed

Board
🏠

Main App

Date

About 2 months ago

Author

Linear

Subscribe to post

Get notified by email when there are changes.