Answers.Body: <p>I am not if anyone has done this before but you can use combination of hook_civicrm_batchItems and hook_civicrm_batchQuery to add columns in csv files. I don't think there is any easy solution to add column in iif export file. </p>
  
  <p>HTH</p>
  
  <p>Pradeep</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-03-27T09:17:29.387Z
Answers.Text: I have done this to complete change the layout of the items, works fine :-)
Answers.UserDisplayName: ErikH - CiviCooP
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-03-26T19:36:34.987Z
Answers.LastActivityDate: 2019-03-26T19:36:34.987Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>If you have code or an extension that can add columns to the accounting batch export file, please share.</p>
  
  <p>Specifically, we want to add "campaign" and "external id" to every row.</p>
  
  <p>Preferably, we'd like it to update the iif (quickbooks file)</p>
  
  <p>thank you</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-03-27T01:00:50.180Z
Comments.Text: if you are using Drupal it would be worth exploring if those options are available to you via a Drupal View
Comments.UserDisplayName: petednz - fuzion
Tags: <accounting><batches>
Title: Adding columns to Accounting batch (iif & csv)
ThreadText: # Adding columns to Accounting batch (iif & csv)
  
  (Asked by: username_0 on 2019-03-26)
  
  If you have code or an extension that can add columns to the accounting batch export file, please share.
  
  Specifically, we want to add "campaign" and "external id" to every row.
  
  Preferably, we'd like it to update the iif (quickbooks file)
  
  thank you
  
  **Tags:** accounting, batches
  
  > **Comments:**
  > **username_1**: if you are using Drupal it would be worth exploring if those options are available to you via a Drupal View  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2019-03-26. Score: 3
  
  I am not if anyone has done this before but you can use combination of hook\_civicrm\_batchItems and hook\_civicrm\_batchQuery to add columns in csv files. I don't think there is any easy solution to add column in iif export file.
  
  HTH
  
  Pradeep
  
  > **Comments:**
  > **username_3**: I have done this to complete change the layout of the items, works fine :-)  
  
  ---
  
  