Answers.Body: <p>Have  you seen Eileen's extension for integration with Xero? 
  <a href="https://civicrm.org/extensions/civixero" rel="nofollow">CiviXero</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-09-11T08:38:34.100Z
Answers.Text: Thanks @frtommy - I have looked at this extension, and the game plan was/is to consider moving towards using this over time (when our knowledge of what we wanted from our links between CiviCRM and Xero was clearer, and so make us better able to assess whether the extension would be a good fit). Also, I got the impression when I did investigate it that it was very much a work in progress, and not the finished article, so I took the view that there was a risk that using the extension could potentially create more problems than it solves. We'll keep it under review, however.
Answers.UserDisplayName: Graham
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-09-10T01:21:45.657Z
Answers.LastActivityDate: 2015-09-10T01:21:45.657Z
Answers.UserDisplayName: frTommy
Answers.Body: <p>You can alter your accounting batches with <a href="http://wiki.civicrm.org/confluence/display/CRMDOC/hook_civicrm_batchItems" rel="nofollow">hook_civicrm_batchItems</a> and <a href="http://wiki.civicrm.org/confluence/display/CRMDOC/hook_civicrm_batchQuery" rel="nofollow">hook_civicrm_batchQuery</a>.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-01-24T18:46:14.267Z
Answers.Text: To clarify, JonG, I would write an extension that calls **hook_civicrm_batchQuery** to get new data into the batch query and then call **hook_civicrm_batchItems** to return the new data so it can be added to the CSV export.  Is that correct?
Answers.UserDisplayName: Allen Hutchison
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-01-09T22:24:40.007Z
Answers.LastActivityDate: 2016-03-05T22:04:22.153Z
Answers.LastEditDate: 2016-03-05T22:04:22.153Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>I want to use the accounting batch feature to group together and export transactions data so that I can them import that data into my accounting system (Xero). But Xero has a strictly defined structure for the CSV file it will accept, and there doesn't seem to be any way to edit the order of fields, or to add in any custom fields, to the data that CivicRM exports.</p>
  
  <p>I did find this useful blog post <a href="https://civicrm.org/blogs/pogstonesarahgladstone/creating-accounting-batch-export-format-accountedge" rel="nofollow">https://civicrm.org/blogs/pogstonesarahgladstone/creating-accounting-batch-export-format-accountedge</a> which gives some pointers about how to hack the core files to make changes.</p>
  
  <p>Surely there has to be an easier way?</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-01-24T00:33:31.287Z
Comments.Text: How did you go about resolving your issue?  We're about to head into the CiviContribute world, and I need to adjust the Batch export to match our accounting software.  I need to add the contact's donor number (custom contact field) and reformat the date of the transaction.  Would you mind sharing your solution for customizing the batch export? Thanks!
Comments.UserDisplayName: Allen Hutchison
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-01-25T11:49:58.863Z
Comments.Text: Hi Allen. In the end we didn't need to get our hands dirty with this, so probably not much help to you.
Comments.UserDisplayName: Graham
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-01-10T17:10:12.130Z
Comments.Text: I wonder if there was any more movement with this?  I'm in the same position, just need to adjust the fields in the export so that I can load in a summary format into Xero.  I also looked at just producing a report for this but it was be a pity not to be able to use the batch export csv as that is precisely what it is for.
Comments.UserDisplayName: user8292
Tags: <accounting><export>
Title: How can I change what data gets exported using the Accounting Batches feature?
ThreadText: # How can I change what data gets exported using the Accounting Batches feature?
  
  (Asked by: username_0 on 2015-06-23)
  
  I want to use the accounting batch feature to group together and export transactions data so that I can them import that data into my accounting system (Xero). But Xero has a strictly defined structure for the CSV file it will accept, and there doesn't seem to be any way to edit the order of fields, or to add in any custom fields, to the data that CivicRM exports.
  
  I did find this useful blog post <https://civicrm.org/blogs/pogstonesarahgladstone/creating-accounting-batch-export-format-accountedge> which gives some pointers about how to hack the core files to make changes.
  
  Surely there has to be an easier way?
  
  **Tags:** accounting, export
  
  > **Comments:**
  > **username_1**: How did you go about resolving your issue?  We're about to head into the CiviContribute world, and I need to adjust the Batch export to match our accounting software.  I need to add the contact's donor number (custom contact field) and reformat the date of the transaction.  Would you mind sharing your solution for customizing the batch export? Thanks!  
  > **username_0**: Hi Allen. In the end we didn't need to get our hands dirty with this, so probably not much help to you.  
  > **username_2**: I wonder if there was any more movement with this?  I'm in the same position, just need to adjust the fields in the export so that I can load in a summary format into Xero.  I also looked at just producing a report for this but it was be a pity not to be able to use the batch export csv as that is precisely what it is for.  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_3 on 2015-09-10. Score: 1
  
  Have you seen Eileen's extension for integration with Xero?
  [CiviXero](https://civicrm.org/extensions/civixero)
  
  > **Comments:**
  > **username_0**: Thanks @frtommy - I have looked at this extension, and the game plan was/is to consider moving towards using this over time (when our knowledge of what we wanted from our links between CiviCRM and Xero was clearer, and so make us better able to assess whether the extension would be a good fit). Also, I got the impression when I did investigate it that it was very much a work in progress, and not the finished article, so I took the view that there was a risk that using the extension could potentially create more problems than it solves. We'll keep it under review, however.  
  
  ---
  
  ### Answer by username_4 on 2016-01-09. Score: 1
  
  You can alter your accounting batches with [hook\_civicrm\_batchItems](http://wiki.civicrm.org/confluence/display/CRMDOC/hook_civicrm_batchItems) and [hook\_civicrm\_batchQuery](http://wiki.civicrm.org/confluence/display/CRMDOC/hook_civicrm_batchQuery).
  
  > **Comments:**
  > **username_1**: To clarify, JonG, I would write an extension that calls **hook_civicrm_batchQuery** to get new data into the batch query and then call **hook_civicrm_batchItems** to return the new data so it can be added to the CSV export.  Is that correct?  
  
  ---
  
  