I'm wondering whether to start invoicing with Quickbooks and I am wondering if when I upload civicrm transactions into quickbooks if it will automatically link the payment to the invoice?

Can CiviCRM and Quickbooks to work together to avoid double entry?


How about invoicing in CiviCRM - you can do so as of 4.6!

Here's how: https://docs.civicrm.org/user/en/4.6/contributions/invoicing/

  • I noticed that I can create an invoice by creating a contribution in "pending" status. I don't see how to update add a payment against this invoice though unless it is the full amount. Am I missing something? – Yossi Jun 30 '16 at 23:07
  • Have you enabled "Tax and Invoicing"? – KarinG - Semper IT Jun 30 '16 at 23:27

So after searching the web like a mad man for some instructions on integration with Quickbooks, I found very little. I poked around for a while and this is what I found. Most of you probably know this already but for those who don't, this will be helpful.

To import transactions into quickbooks, you have to use Accounting batches in Contributions > Accounting Batches. Figuring out how to create batches is pretty straight forward. Then you want to export the batch as a .IIF file.

In Quickbooks From the File menu, choose Utilities , select Import and click IIF Files.

Quickbooks will import the transactions and its details as a General Journal. So if you were hoping (like I was) that it would create contacts quickbooks and fill the transactional data for each contact, it doesn't.

So my idea of invoicing from Quickbooks and having CiviCRM contributions credit the invoices doesn't work.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.