Answers.Body: <p>I agree with what you said at the start of your paper, &quot;QB looks at money from the perspective of the business (the primary concern is where the money is coming from, going to, profit and loss, health of business, successful/failing programs).  The people who gave the money are only incidentally important.  Civi (or any CRM) is primarily dealing with people.&quot;</p>
  <p>Because of this...We do not export our donor data to QuickBooks. We do not see the need to record who gave the money in both places. QB only holds the deposit information--when, how much and what campaign/fund the deposit is split into.</p>
  <p><strong>In Civi</strong> we have Financial Type to mark our Master categories:</p>
  <p>Donations (Tax deductible),
  Tuition (Not tax deductible),
  Event Fees (Not Tax deductible),
  <em>This is useful for reports where you want to see all tuition payments for x time period</em></p>
  <p>Line items are our fund accounts:
  General Fund,
  Capital Campaign,
  Scholarship,
  Event ABC,
  <em>This allows us to drill down into more detail as needed</em></p>
  <p><strong>In QBs</strong>
  We use:
  <em>Customer</em> = Fund accounting, this allows us to show income and expenses tied to our fund accounting. We can demonstrate to donors how much came in and how those funds were spent according to their designation.
  <em>Class</em> = Functional Expense tracking, with each expense we apply it to Program, Management and Fundraising. At the end of the year when we do our 990, everything is already labeled. No need to estimate.
  <em>Department</em> = Budget categories that different staff oversee.</p>
  <p>This allows us to overcome QBs inability to truely handle fund accounting.</p>
  <p>YES, as you pointed out we have to use a special report to split the deposits into the different funds/campaign before entering it into QB. We have developed a Drupal View that helps our Accounts Receivables more easily create the QB deposit entries from CiviCRM.</p>
  <p>For my feedback: I am fine with your idea as an extension, it looks well thought out for your case use. I would make the argument that your paper starts off with the correct premise but then turns from that and treats QBs as a CRM--something it is not.</p>
  <p>Thanks for taking the time to think through and write out your ideas on improving Civi!</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-10-09T00:46:27.027Z
Answers.LastActivityDate: 2020-10-09T00:46:27.027Z
Answers.UserDisplayName: Iowa Boy
Answers.Body: <p>It may be worth exploring the Civi extension already in place</p>
  
  <p><a href="https://civicrm.org/extensions/quickbooks-online-civicrm-contribution-and-contact-synchronization" rel="nofollow noreferrer">https://civicrm.org/extensions/quickbooks-online-civicrm-contribution-and-contact-synchronization</a></p>
  
  <p>It states</p>
  
  <blockquote>
    <p>QuickBooks Online provides different Tax APIs for US and non-US
    countries. This extension has been developed and tested for QuickBooks
    Online, Australia. With initial development and testing to support
    QuickBooks Online, US.</p>
  </blockquote>
  
  <p>So depending on your locality it may already be meeting your needs.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-05-11T10:17:02.000Z
Answers.LastActivityDate: 2020-05-11T10:17:02.000Z
Answers.UserDisplayName: RebeccaTregenna
Body: <p>With all the integrations out there, there's no reason bookkeeping should take more than five minutes a month, without a bookkeeper.</p>
  
  <p>Does anyone have a system for this that doesn't require lot's of manual work, and still imports all the important information into Quickbooks?</p>
  
  <p>I have some ideas, but want to hear from you first.</p>
  
  <p>thanks in advance</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-10-08T18:06:07.327Z
Comments.Text: @Yona - only just come across this.  Your Google doc is an interesting read.  I'd encourage to get on to Mattermost and the dev-financial channel and share this.  There is ongoing thought around improvements to Civi's financial handling
Comments.UserDisplayName: Aidan
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-10-09T10:50:26.570Z
Comments.Text: I can second this. Currently, CiviCRM is trying a lot regarding the accounting functionality - and maybe a little too much. I came across places, where the existing functionality in theory is great but in reality is not quite working. One example are the mentioned payment processor fees, which are taken care of, but not with Stripe payments. Other example is deferred revenue/accruals accounting. Maybe a better integration with financial packages (or dedicated extensions for defined tasks) can help to take development load off Civi and improve the results at the same time.
Comments.UserDisplayName: Joachim
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-10T20:29:22.777Z
Comments.Text: These seems a very broad question - why don't you outline your thoughts and ask for feedback
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-12T05:08:40.493Z
Comments.Text: i wrote up a whole thing in a google doc, but want more feedback before posting publicly: https://docs.google.com/document/d/1xx71nW3imKJ4Rsd-kD8O7gjQwc4a4SjQh-sT5snM8b8/edit?usp=sharing
Comments.UserDisplayName: Yona
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-12T09:11:06.097Z
Comments.Text: and have you tested out the agileware extension? are you happy for me to share the above link with them?
Comments.UserDisplayName: petednz - fuzion
Tags: <bookkeeping><quickbooks>
Title: Bookkeeping in 5 Minutes a month
ThreadText: # Bookkeeping in 5 Minutes a month
  
  (Asked by: username_0 on 2020-05-10)
  
  With all the integrations out there, there's no reason bookkeeping should take more than five minutes a month, without a bookkeeper.
  
  Does anyone have a system for this that doesn't require lot's of manual work, and still imports all the important information into Quickbooks?
  
  I have some ideas, but want to hear from you first.
  
  thanks in advance
  
  **Tags:** bookkeeping, quickbooks
  
  > **Comments:**
  > **username_3**: These seems a very broad question - why don't you outline your thoughts and ask for feedback  
  > **username_0**: i wrote up a whole thing in a google doc, but want more feedback before posting publicly: https://docs.google.com/document/d/1xx71nW3imKJ4Rsd-kD8O7gjQwc4a4SjQh-sT5snM8b8/edit?usp=sharing  
  > **username_3**: and have you tested out the agileware extension? are you happy for me to share the above link with them?  
  > **username_1**: @username_0 - only just come across this.  Your Google doc is an interesting read.  I'd encourage to get on to Mattermost and the dev-financial channel and share this.  There is ongoing thought around improvements to Civi's financial handling  
  > **username_2**: I can second this. Currently, CiviCRM is trying a lot regarding the accounting functionality - and maybe a little too much. I came across places, where the existing functionality in theory is great but in reality is not quite working. One example are the mentioned payment processor fees, which are taken care of, but not with Stripe payments. Other example is deferred revenue/accruals accounting. Maybe a better integration with financial packages (or dedicated extensions for defined tasks) can help to take development load off Civi and improve the results at the same time.  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_4 on 2020-10-09. Score: 2
  
  I agree with what you said at the start of your paper, "QB looks at money from the perspective of the business (the primary concern is where the money is coming from, going to, profit and loss, health of business, successful/failing programs). The people who gave the money are only incidentally important. Civi (or any CRM) is primarily dealing with people."
  
  Because of this...We do not export our donor data to QuickBooks. We do not see the need to record who gave the money in both places. QB only holds the deposit information--when, how much and what campaign/fund the deposit is split into.
  
  **In Civi** we have Financial Type to mark our Master categories:
  
  Donations (Tax deductible),
  Tuition (Not tax deductible),
  Event Fees (Not Tax deductible),
  *This is useful for reports where you want to see all tuition payments for x time period*
  
  Line items are our fund accounts:
  General Fund,
  Capital Campaign,
  Scholarship,
  Event ABC,
  *This allows us to drill down into more detail as needed*
  
  **In QBs**
  We use:
  *Customer* = Fund accounting, this allows us to show income and expenses tied to our fund accounting. We can demonstrate to donors how much came in and how those funds were spent according to their designation.
  *Class* = Functional Expense tracking, with each expense we apply it to Program, Management and Fundraising. At the end of the year when we do our 990, everything is already labeled. No need to estimate.
  *Department* = Budget categories that different staff oversee.
  
  This allows us to overcome QBs inability to truely handle fund accounting.
  
  YES, as you pointed out we have to use a special report to split the deposits into the different funds/campaign before entering it into QB. We have developed a Drupal View that helps our Accounts Receivables more easily create the QB deposit entries from CiviCRM.
  
  For my feedback: I am fine with your idea as an extension, it looks well thought out for your case use. I would make the argument that your paper starts off with the correct premise but then turns from that and treats QBs as a CRM--something it is not.
  
  Thanks for taking the time to think through and write out your ideas on improving Civi!
  
  
  ---
  
  ### Answer by username_5 on 2020-05-11. Score: 1
  
  It may be worth exploring the Civi extension already in place
  
  <https://civicrm.org/extensions/quickbooks-online-civicrm-contribution-and-contact-synchronization>
  
  It states
  
  > QuickBooks Online provides different Tax APIs for US and non-US
  > countries. This extension has been developed and tested for QuickBooks
  > Online, Australia. With initial development and testing to support
  > QuickBooks Online, US.
  
  So depending on your locality it may already be meeting your needs.
  
  
  ---
  
  