Answers.Body: <p>We use Civi &amp; QuickBooks. Our QBs is only used for accounting. If we need to see donation details, we look in Civi. We do not record contribution detail in Quickbooks. We do not see a need to have that data stored in two places.</p>
  
  <p>We just record the deposit in QBs. We use Class in QB for our Functional Expense allocations (Program, Restricted, and Unrestricted). Note, since most donations are not related to Functional Expense allocations (other than Program Income), we have created 2 additional Classes in QBs--Unrestricted and Restricted. So most deposits are recorded using these 2 QB Classes. We use Customer Job in QB for Line Item detail from Civi (General Fund, Building Fund, Scholarship). We do not have any donors entered as a Customer in QB.</p>
  
  <p>We have our payment options in Civi to match our payment processor's deposit schedule. ACH, Visa/Mastercard, Discover. That way we can pull Line Item reports by Payment Type and date and they match our Processor Deposits. Then we record that deposit in QB with Class info (Program...) and Customer Job (We sum the Line Item Types from Civi and have one line on the Deposit entry for General Fund, Building Fund, etc). </p>
  
  <p>FYI, we use the same Class and Customer Job options when recording Expenses in QBs. This allows us to run reports by Class to see Functional Expense (for expenses we do have QB Classes for Management &amp; Fundraising). And reports by Customer Job to see Campaigns-showing income and expense for Capital Campaign.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-03-02T18:08:53.027Z
Answers.Text: I highly recommend the book by Kathy Ivens "Running QuickBooks in Nonprofits". She details how to setup Classes for Functional Expense and Customer Job for Fund Accounting. In addition, I set up our Chart of Accounts based on the breakdowns needed for 990 reporting. That makes my 990 reporting a breeze.
Answers.UserDisplayName: Iowa Boy
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-03-02T17:52:53.763Z
Answers.LastActivityDate: 2019-03-02T17:52:53.763Z
Answers.UserDisplayName: Iowa Boy
Answers.Body: <p>I think I have a method that solves 90% of what you're trying to accomplish. 
  Firstly though, I think the reason that some nonprofits want to have the full information in quickbooks is (1) so they can pull P&amp;L reports on specific programs, which can only be done with classed contributions (2) many organizations want to have the full data in quickbooks, especially if they already have years of files in  it.</p>
  
  <p>This method does not use the "accounting batch" feature in civi, as this feature only brings transactions into the journal entry, not into sales receipts. I would recommend that the core team expand the options for "accounting batches to include more fields (like the ones later on in this answer)</p>
  
  <p>Here's what you do:</p>
  
  <p>There is a $200 software called "transaction pro importer" which can convert an excel sheet into sales receipts. (transactionpro.com)</p>
  
  <p>If you create a customized bookkeeping report in civireports and export as spreadsheet (which needs to be saved as regular sheet, not csv), and use very specific fields, you can sort transactions by batch and export all the transactions and fields that you want to pull into quickbooks.</p>
  
  <p>disclaimer:  im still struggling to work out how processing fees show up on reports (i use stripe) because they are currently goofing up my report by including two (or more) line items for every transaction.</p>
  
  <p>The mapping will look something like this:
  Civi>Quickbooks</p>
  
  <ul>
  <li>External ID>>>Customer </li>
  <li>Line item financial type>>>item   </li>
  <li>campaign>>>class (please note you can't use subclasses) </li>
  <li>payment instrument>>>payment type </li>
  <li>date received>>>date </li>
  <li>contribution id>>>receipt # </li>
  <li>check #>>>check #</li>
  </ul>
  
  <p>for those who want their quickbooks to have all the detailed transaction information, i think this is the way to go, even though it could use some improvement.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-03-17T18:03:05.670Z
Answers.Text: A question from my side regarding processing fees from Stripe: Do they show up as (separate) transactions only for events or also for membership purchases? My problem is the opposite from yours - I do need them in my exported batches, but in my setup they are somehow only created for events and not for memberships.
Answers.UserDisplayName: Joachim
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-03-18T19:04:17.273Z
Answers.Text: don't know. i haven't started using memberships yet
Answers.UserDisplayName: Yona
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-03-17T08:07:12.357Z
Answers.LastActivityDate: 2019-03-17T17:39:50.393Z
Answers.LastEditDate: 2019-03-17T17:39:50.393Z
Answers.UserDisplayName: Yona
Answers.Body: <p>I haven't used it, but saw the recent blog post about the <a href="https://github.com/agileware/au.com.agileware.civiquickbooks" rel="nofollow noreferrer">CiviQuickbooks extension</a> which could be worth exploring.</p>
  <ul>
  <li><a href="https://civicrm.org/blog/justinfreeman/quickbooks-online-integration-civicrm-now-available" rel="nofollow noreferrer">QuickBooks Online integration with CiviCRM now available!</a></li>
  </ul>
  <blockquote>
  <p>If your organisation is using QuickBooks Online, then cheer up, we have some good news! You can now integrate your accounting system with CiviCRM:</p>
  <ul>
  <li>CiviCRM Contacts and Contributions are pushed to QuickBooks</li>
  <li>Linked QuickBooks Invoices are pulled into CiviCRM, updating the Contribution status.</li>
  <li>Sit back and enjoy the synchronisation of all things!</li>
  </ul>
  <p>Integration of the two systems saves you time by not having to do repetitive data entry in your accounting system and CiviCRM. This extension does the work for you!</p>
  </blockquote>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-05-16T16:40:29.073Z
Answers.LastActivityDate: 2020-05-16T16:40:29.073Z
Answers.LastEditDate: 2020-06-17T09:00:50.810Z
Answers.UserDisplayName: Laryn
Body: <p>I have three organizations that use Quickbooks and some other process to track contributions.  I would like to encourage all of them to move to Civicrm.  (They are currently using out-of-date MS Access or Excel for tracking donations.)  Each have set up Quickbooks to use classes and sub-classes in their accounting. Are you actually using Civicrm and Quickbooks, AND using classes and sub-classes in Quickbooks, AND have set up Civicrm to then transfer that data into Quickbooks effectively?  I have read all over the Internet and the Civi site.  What I am seeking is someone who is using both programs.  Practically speaking, what did you do in the setup and execution to get classes and sub-classes to translate from Civicrm to Quickbooks?  I have read a little of some people using custom fields and then others who adapt Campaigns or Financial Types to make this happen, but no practical setup or practical process is communicated in their postings.  Help?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-02-05T05:30:37.370Z
Comments.Text: Yes, very important. Please answer!
Comments.UserDisplayName: Yona
Tags: <civicontribute><export><accounting>
Title: Connecting Civicrm to Quickbooks classes / subclasses
ThreadText: # Connecting Civicrm to Quickbooks classes / subclasses
  
  (Asked by: username_0 on 2016-03-13)
  
  I have three organizations that use Quickbooks and some other process to track contributions. I would like to encourage all of them to move to Civicrm. (They are currently using out-of-date MS Access or Excel for tracking donations.) Each have set up Quickbooks to use classes and sub-classes in their accounting. Are you actually using Civicrm and Quickbooks, AND using classes and sub-classes in Quickbooks, AND have set up Civicrm to then transfer that data into Quickbooks effectively? I have read all over the Internet and the Civi site. What I am seeking is someone who is using both programs. Practically speaking, what did you do in the setup and execution to get classes and sub-classes to translate from Civicrm to Quickbooks? I have read a little of some people using custom fields and then others who adapt Campaigns or Financial Types to make this happen, but no practical setup or practical process is communicated in their postings. Help?
  
  **Tags:** civicontribute, export, accounting
  
  > **Comments:**
  > **username_1**: Yes, very important. Please answer!  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_2 on 2019-03-02. Score: 2
  
  We use Civi & QuickBooks. Our QBs is only used for accounting. If we need to see donation details, we look in Civi. We do not record contribution detail in Quickbooks. We do not see a need to have that data stored in two places.
  
  We just record the deposit in QBs. We use Class in QB for our Functional Expense allocations (Program, Restricted, and Unrestricted). Note, since most donations are not related to Functional Expense allocations (other than Program Income), we have created 2 additional Classes in QBs--Unrestricted and Restricted. So most deposits are recorded using these 2 QB Classes. We use Customer Job in QB for Line Item detail from Civi (General Fund, Building Fund, Scholarship). We do not have any donors entered as a Customer in QB.
  
  We have our payment options in Civi to match our payment processor's deposit schedule. ACH, Visa/Mastercard, Discover. That way we can pull Line Item reports by Payment Type and date and they match our Processor Deposits. Then we record that deposit in QB with Class info (Program...) and Customer Job (We sum the Line Item Types from Civi and have one line on the Deposit entry for General Fund, Building Fund, etc).
  
  FYI, we use the same Class and Customer Job options when recording Expenses in QBs. This allows us to run reports by Class to see Functional Expense (for expenses we do have QB Classes for Management & Fundraising). And reports by Customer Job to see Campaigns-showing income and expense for Capital Campaign.
  
  > **Comments:**
  > **username_2**: I highly recommend the book by Kathy Ivens "Running QuickBooks in Nonprofits". She details how to setup Classes for Functional Expense and Customer Job for Fund Accounting. In addition, I set up our Chart of Accounts based on the breakdowns needed for 990 reporting. That makes my 990 reporting a breeze.  
  
  ---
  
  ### Answer by username_1 on 2019-03-17. Score: 1
  
  I think I have a method that solves 90% of what you're trying to accomplish.
  Firstly though, I think the reason that some nonprofits want to have the full information in quickbooks is (1) so they can pull P&L reports on specific programs, which can only be done with classed contributions (2) many organizations want to have the full data in quickbooks, especially if they already have years of files in it.
  
  This method does not use the "accounting batch" feature in civi, as this feature only brings transactions into the journal entry, not into sales receipts. I would recommend that the core team expand the options for "accounting batches to include more fields (like the ones later on in this answer)
  
  Here's what you do:
  
  There is a $200 software called "transaction pro importer" which can convert an excel sheet into sales receipts. (transactionpro.com)
  
  If you create a customized bookkeeping report in civireports and export as spreadsheet (which needs to be saved as regular sheet, not csv), and use very specific fields, you can sort transactions by batch and export all the transactions and fields that you want to pull into quickbooks.
  
  disclaimer: im still struggling to work out how processing fees show up on reports (i use stripe) because they are currently goofing up my report by including two (or more) line items for every transaction.
  
  The mapping will look something like this:
  Civi>Quickbooks
  
  * External ID>>>Customer
  * Line item financial type>>>item
  * campaign>>>class (please note you can't use subclasses)
  * payment instrument>>>payment type
  * date received>>>date
  * contribution id>>>receipt #
  * check #>>>check #
  
  for those who want their quickbooks to have all the detailed transaction information, i think this is the way to go, even though it could use some improvement.
  
  > **Comments:**
  > **username_3**: A question from my side regarding processing fees from Stripe: Do they show up as (separate) transactions only for events or also for membership purchases? My problem is the opposite from yours - I do need them in my exported batches, but in my setup they are somehow only created for events and not for memberships.  
  > **username_1**: don't know. i haven't started using memberships yet  
  
  ---
  
  ### Answer by username_4 on 2020-05-16. Score: 0
  
  I haven't used it, but saw the recent blog post about the [CiviQuickbooks extension](https://github.com/agileware/au.com.agileware.civiquickbooks) which could be worth exploring.
  
  * [QuickBooks Online integration with CiviCRM now available!](https://civicrm.org/blog/justinfreeman/quickbooks-online-integration-civicrm-now-available)
  
  > If your organisation is using QuickBooks Online, then cheer up, we have some good news! You can now integrate your accounting system with CiviCRM:
  >
  > * CiviCRM Contacts and Contributions are pushed to QuickBooks
  > * Linked QuickBooks Invoices are pulled into CiviCRM, updating the Contribution status.
  > * Sit back and enjoy the synchronisation of all things!
  >
  > Integration of the two systems saves you time by not having to do repetitive data entry in your accounting system and CiviCRM. This extension does the work for you!
  
  
  ---
  
  