Answers.Body: <p>I think the core Attendee List report may meet your needs - you can add additional columns for example for fee level, amount paid and balance on the 'Columns' tab and filter by event on the filter tab.</p>
  <p>Unfortunately you would have to change the filter as necessary each time you run the report so there may be a Search Kit option that has more defaults sets and exposes the filter for easier searching and exporting.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-05-19T13:06:02.050Z
Answers.LastActivityDate: 2023-05-19T13:06:02.050Z
Answers.UserDisplayName: RebeccaTregenna
Body: <p>CiviCRM 5.55.0  Wordpress</p>
  <p>Trying to pull a report (export output preferred) to provide a list of registered participants that includes the total amount owing, total paid, and fee level. I have reviewed several posts on various forums indicating a &quot;balance&quot; owing is available as a selected field for export; however, unable to locate the field in custom reports.  The report is intended to be used at check-in and would ideally primarily based on the event, list the participants with the event fee level, total paid, and balance owing.</p>
  
Tags: <civireport><payment><civicrm-event>
Title: Event Report with amount paid and balance owing by participant
ThreadText: # Event Report with amount paid and balance owing by participant
  
  (Asked by: username_0 on 2023-05-19)
  
  CiviCRM 5.55.0 Wordpress
  
  Trying to pull a report (export output preferred) to provide a list of registered participants that includes the total amount owing, total paid, and fee level. I have reviewed several posts on various forums indicating a "balance" owing is available as a selected field for export; however, unable to locate the field in custom reports. The report is intended to be used at check-in and would ideally primarily based on the event, list the participants with the event fee level, total paid, and balance owing.
  
  **Tags:** civireport, payment, civicrm-event
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2023-05-19. Score: 1
  
  I think the core Attendee List report may meet your needs - you can add additional columns for example for fee level, amount paid and balance on the 'Columns' tab and filter by event on the filter tab.
  
  Unfortunately you would have to change the filter as necessary each time you run the report so there may be a Search Kit option that has more defaults sets and exposes the filter for easier searching and exporting.
  
  
  ---
  
  