Answers.Body: <p>The post can be found here:
  <a href="https://civicrm.org/blogs/chrischinchilla/using-civicrm-project-management-and-budgeting" rel="nofollow noreferrer">https://civicrm.org/blogs/chrischinchilla/using-civicrm-project-management-and-budgeting</a></p>
  
  <p>The description how the budgeting/expense tracking is done is quite short and it only mentions that they are using negative contributions for expenses. They are also using CiviCampaign to assign the expenses to "projects".</p>
  
  <p>The poster Chinchilla is describing an implementation on Drupal using drupal-views, if you are using wordpress I am trying to collect recommended plugins here: <a href="https://civicrm.stackexchange.com/questions/9439/what-is-the-recommended-wordpress-equivalent-for-drupal-views">What is the recommended Wordpress equivalent for drupal-views</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-02-06T00:48:44.783Z
Answers.Text: I haven't heard about a Views equivalent in use with WP and CiviCRM. https://wiki.civicrm.org/confluence/display/CRMDOC/WordPress+and+CiviCRM+Integration mentions X-Data Toolkit as one to consider http://wordpress.org/extend/plugins/xdata-toolkit but i would shift this entirely to a new question or check if an SE question on this already exists.
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-02-06T04:14:32.833Z
Answers.Text: Thanks for the Hint! However it is outdated. I have created a post here: http://civicrm.stackexchange.com/questions/9439/what-is-the-recommended-wordpress-equivalent-for-drupal-views
Answers.UserDisplayName: Alain Schaefer
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-02-05T23:58:32.913Z
Answers.LastActivityDate: 2016-02-06T04:16:13.380Z
Answers.LastEditDate: 2017-04-13T12:53:13.017Z
Answers.UserDisplayName: Alain Schaefer
Answers.Body: <p>I agree that CiviCRM does not (and should not) aim to provide full accounting functionality. However, with campaigns it makes sense that the system is aware of expenses to compare them against revenue.
  Here is an extension that does this: <a href="https://civicrm.org/blogs/niko-bochan/civicrm-strategic-fundraising-and-campaigning-gsoc-completion-report" rel="nofollow">https://civicrm.org/blogs/niko-bochan/civicrm-strategic-fundraising-and-campaigning-gsoc-completion-report</a></p>
  
  <p>This extension, <em>Campaign Manager</em>, emerged from last year's Google Summer of Code and is not recommended for productive use as of now. But if it basically does what you need you might be interested in implementing in a pilot project (full disclosure - it was developed under mentorship of SYSTOPIA, my company).</p>
  
  <p>Here is a public demo: <a href="https://campaignmanager.systopia.de/" rel="nofollow">https://campaignmanager.systopia.de/</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-04-06T13:48:29.203Z
Answers.Text: What I wonder is WHY actually should Civi not be able to manage a basic accounting system? What's wrong with that?
  Income and expenses manager and then basic tax deduction and stuff like that?
  Would that not be a good idea?
Answers.UserDisplayName: SomeDev
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-02-10T08:35:03.503Z
Answers.LastActivityDate: 2016-02-10T08:35:03.503Z
Answers.UserDisplayName: Martin Peth
Answers.Body: <p>We have also had a desire of linking data of cost towards data of income.</p>
  
  <p>What we have tried so far is a simple extension which enables us to create a link between the data of the cost and the data of the income.</p>
  
  <p>What it basically does is to give you an UI where you could search for activities in a certain time span, or contacts that have specific reasons for creation in a certain time span (custom fields). In this UI you could enter a number/text of any kind. In our case we input the invoice number of the cost.</p>
  
  <p>Then we are able to link the SQL-tables of the income, with the SQL-table of the activities, with the non-CiviCRM SQL-table for the cost. Then we are able to make a report, where you could search for an activity, and report on income and cost together.</p>
  
  <p>The extensions is found here:</p>
  
  <p><a href="https://github.com/CiviCooP/no.maf.costinvoicelink" rel="nofollow">Cost Invoice Link</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-02-10T09:24:32.523Z
Answers.LastActivityDate: 2016-02-10T09:24:32.523Z
Answers.UserDisplayName: Flying
Answers.Body: <p>CiviCRM isn't aiming to provide full accounting functionality. It does provide a schema that can record expenses (e.g. grants, also premiums as a cost of goods sold) and functionality to export them to Quickbooks (as .IIF files) and other acconting packages (as .csv files).</p>
  
  <p>As Martin Peth comments, there was a Google Summer of Code project in 2015 that created a working prototype of an extension that would record expenses of CiviCampaigns to allow calculation of campaign ROI.</p>
  
  <p>FWIW, JMA Consulting (full disclosure-my company) provides check printing and control functionality in our Grant Programs extension. </p>
  
  <p>Most relevant in some ways, but still unstarted so far as I know: CiviHR has had support for expense tracking on its roadmap since the first blog post, and it is currently scheduled for v1.8 (<a href="https://wiki.civicrm.org/confluence/display/HR/CiviHR+-+Version+1.8" rel="nofollow">https://wiki.civicrm.org/confluence/display/HR/CiviHR+-+Version+1.8</a>). </p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-02-10T01:10:23.357Z
Answers.LastActivityDate: 2016-02-10T13:27:16.953Z
Answers.LastEditDate: 2016-02-10T13:27:16.953Z
Answers.UserDisplayName: Joe Murray
Body: <p>Some time ago I saw a post about how one organization was or was considering using Civi to track not only income but to also track expenses (e.g., to track expenses against a campaign so that revenue less expenses would give true campaign net). We are interested in this, so that our board could use Civi to see revenue and expenses and not have to worry about any access to QuickBooks and reduce me having to prepare financials for them from QuickBooks. My thought would be that an expense might be a specific financial type such that a user could exclude that financial type to get revenue only, include it along with other revenue financial types to get the total picture, or include only the expense financial type to see expenses. </p>
  
  <p>All that being said, I have searched high and low and can't find that post. I can't recall if it was from the CiviCRM blogs (again - looked/searched but couldn't find) or some other blog. I also searched here on Stack and couldn't find it. I did find a post about tracking scholarships disbursed (<a href="https://civicrm.stackexchange.com/questions/792/how-to-manage-a-scholarship-fund/802#802">How to manage a scholarship fund?</a>). That helps some, but curious about the entry itself (which was mentioned in the post I can't find).</p>
  
  <p>Anyone recall seeing that post? Or, anyone using Civi to track expenses as well as revenue? If so, I would love to know how you are handling (i.e., how recording in CiviContribute, etc. -- presumably to get net raised as revenue less expenses the expenses must be entered as a negative amount, and whether a "generic" contact was created for payments [i.e., used as the "vendor"]). FWIW, I'm on Civi 4.6.11 and WP, but since this is not CRM specific, this is a more global question and more of a way of thinking out-of-the box on how Civi is setup and typically used.</p>
  
Tags: <civicontribute>
Title: Tracking expenses with Civi
ThreadText: # Tracking expenses with Civi
  
  (Asked by: username_0 on 2016-02-05)
  
  Some time ago I saw a post about how one organization was or was considering using Civi to track not only income but to also track expenses (e.g., to track expenses against a campaign so that revenue less expenses would give true campaign net). We are interested in this, so that our board could use Civi to see revenue and expenses and not have to worry about any access to QuickBooks and reduce me having to prepare financials for them from QuickBooks. My thought would be that an expense might be a specific financial type such that a user could exclude that financial type to get revenue only, include it along with other revenue financial types to get the total picture, or include only the expense financial type to see expenses.
  
  All that being said, I have searched high and low and can't find that post. I can't recall if it was from the CiviCRM blogs (again - looked/searched but couldn't find) or some other blog. I also searched here on Stack and couldn't find it. I did find a post about tracking scholarships disbursed ([How to manage a scholarship fund?](https://civicrm.stackexchange.com/questions/792/how-to-manage-a-scholarship-fund/802#802)). That helps some, but curious about the entry itself (which was mentioned in the post I can't find).
  
  Anyone recall seeing that post? Or, anyone using Civi to track expenses as well as revenue? If so, I would love to know how you are handling (i.e., how recording in CiviContribute, etc. -- presumably to get net raised as revenue less expenses the expenses must be entered as a negative amount, and whether a "generic" contact was created for payments [i.e., used as the "vendor"]). FWIW, I'm on Civi 4.6.11 and WP, but since this is not CRM specific, this is a more global question and more of a way of thinking out-of-the box on how Civi is setup and typically used.
  
  **Tags:** civicontribute
  
  
  ---
  
  ## 4 answers
  
  ### Answer by username_1 on 2016-02-05. Score: 3
  
  The post can be found here:
  <https://civicrm.org/blogs/chrischinchilla/using-civicrm-project-management-and-budgeting>
  
  The description how the budgeting/expense tracking is done is quite short and it only mentions that they are using negative contributions for expenses. They are also using CiviCampaign to assign the expenses to "projects".
  
  The poster Chinchilla is describing an implementation on Drupal using drupal-views, if you are using wordpress I am trying to collect recommended plugins here: [What is the recommended Wordpress equivalent for drupal-views](https://civicrm.stackexchange.com/questions/9439/what-is-the-recommended-wordpress-equivalent-for-drupal-views)
  
  > **Comments:**
  > **username_2**: I haven't heard about a Views equivalent in use with WP and CiviCRM. https://wiki.civicrm.org/confluence/display/CRMDOC/WordPress+and+CiviCRM+Integration mentions X-Data Toolkit as one to consider http://wordpress.org/extend/plugins/xdata-toolkit but i would shift this entirely to a new question or check if an SE question on this already exists.  
  > **username_1**: Thanks for the Hint! However it is outdated. I have created a post here: http://civicrm.stackexchange.com/questions/9439/what-is-the-recommended-wordpress-equivalent-for-drupal-views  
  
  ---
  
  ### Answer by username_3 on 2016-02-10. Score: 1
  
  I agree that CiviCRM does not (and should not) aim to provide full accounting functionality. However, with campaigns it makes sense that the system is aware of expenses to compare them against revenue.
  Here is an extension that does this: <https://civicrm.org/blogs/niko-bochan/civicrm-strategic-fundraising-and-campaigning-gsoc-completion-report>
  
  This extension, *Campaign Manager*, emerged from last year's Google Summer of Code and is not recommended for productive use as of now. But if it basically does what you need you might be interested in implementing in a pilot project (full disclosure - it was developed under mentorship of SYSTOPIA, my company).
  
  Here is a public demo: <https://campaignmanager.systopia.de/>
  
  > **Comments:**
  > **username_4**: What I wonder is WHY actually should Civi not be able to manage a basic accounting system? What's wrong with that? Income and expenses manager and then basic tax deduction and stuff like that? Would that not be a good idea?  
  
  ---
  
  ### Answer by username_5 on 2016-02-10. Score: 0
  
  We have also had a desire of linking data of cost towards data of income.
  
  What we have tried so far is a simple extension which enables us to create a link between the data of the cost and the data of the income.
  
  What it basically does is to give you an UI where you could search for activities in a certain time span, or contacts that have specific reasons for creation in a certain time span (custom fields). In this UI you could enter a number/text of any kind. In our case we input the invoice number of the cost.
  
  Then we are able to link the SQL-tables of the income, with the SQL-table of the activities, with the non-CiviCRM SQL-table for the cost. Then we are able to make a report, where you could search for an activity, and report on income and cost together.
  
  The extensions is found here:
  
  [Cost Invoice Link](https://github.com/CiviCooP/no.maf.costinvoicelink)
  
  
  ---
  
  ### Answer by username_6 on 2016-02-10. Score: 0
  
  CiviCRM isn't aiming to provide full accounting functionality. It does provide a schema that can record expenses (e.g. grants, also premiums as a cost of goods sold) and functionality to export them to Quickbooks (as .IIF files) and other acconting packages (as .csv files).
  
  As username_3 comments, there was a Google Summer of Code project in 2015 that created a working prototype of an extension that would record expenses of CiviCampaigns to allow calculation of campaign ROI.
  
  FWIW, JMA Consulting (full disclosure-my company) provides check printing and control functionality in our Grant Programs extension.
  
  Most relevant in some ways, but still unstarted so far as I know: CiviHR has had support for expense tracking on its roadmap since the first blog post, and it is currently scheduled for v1.8 (<https://wiki.civicrm.org/confluence/display/HR/CiviHR+-+Version+1.8>).
  
  
  ---
  
  