CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviContribute (Moderator: Donald Lobo) »
  • Configuring Financial Types/Financial Accounts for export to QuickBooks
Pages: [1]

Author Topic: Configuring Financial Types/Financial Accounts for export to QuickBooks  (Read 543 times)

SarahG (FountainTribe)

  • Ask me questions
  • ****
  • Posts: 782
  • Karma: 29
  • CiviCRM version: 4.4.7
  • CMS version: Drupal 6, Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Configuring Financial Types/Financial Accounts for export to QuickBooks
March 25, 2014, 09:08:02 pm
If an organization is using the "classes/subclasses" feature in QuickBooks, how should financial types/financial accounts be set up so that the information is exported with the class/subclass data when using the Accounting batches feature in CiviCRM.

Is anyone already doing this?
Did I help you? Please donate to the Civi-Make-It-Happen campaign  CiviCRM for mobile devices! 

KarinG

  • I post frequently
  • ***
  • Posts: 134
  • Karma: 9
  • CiviCRM version: 4+
  • CMS version: Drupal 6 / 7
  • MySQL version: MariaDB
  • PHP version: 5.3/5.4/5.5
Re: Configuring Financial Types/Financial Accounts for export to QuickBooks
April 01, 2014, 03:28:27 pm
I just had an organization that I work with ask me this question as well. Is this possible? I've been told "classes in Quickbooks is one of its best features".

Shai

  • I post frequently
  • ***
  • Posts: 202
  • Karma: 8
    • Content2zero
  • CiviCRM version: 4.3.x, 4.4.x, 4.5.x
  • CMS version: Drupal 7
  • MySQL version: 5.5.x
  • PHP version: 5.3.x, 5.4.x
Re: Configuring Financial Types/Financial Accounts for export to QuickBooks
July 15, 2014, 09:31:32 am
I also have a client very much interested in using Quickbooks classes.

Any progress or workarounds people can report on?

Shai Gluskin
Don't miss out! Sign up now for free expert advice on CiviCRM's new StackExchange help site.

KarinG

  • I post frequently
  • ***
  • Posts: 134
  • Karma: 9
  • CiviCRM version: 4+
  • CMS version: Drupal 6 / 7
  • MySQL version: MariaDB
  • PHP version: 5.3/5.4/5.5
Re: Configuring Financial Types/Financial Accounts for export to QuickBooks
July 15, 2014, 09:37:10 am
Hi Shai - try something like this for a work around: add your classes in CiviCRM by appending ;class name. Run a financial batch export - then split the columns to get the classes into their own column.

Shai

  • I post frequently
  • ***
  • Posts: 202
  • Karma: 8
    • Content2zero
  • CiviCRM version: 4.3.x, 4.4.x, 4.5.x
  • CMS version: Drupal 7
  • MySQL version: 5.5.x
  • PHP version: 5.3.x, 5.4.x
Re: Configuring Financial Types/Financial Accounts for export to QuickBooks
July 15, 2014, 09:44:49 am
Karin,

Thanks. Where does the appendage go, to the Financial Type?

Shai
Don't miss out! Sign up now for free expert advice on CiviCRM's new StackExchange help site.

KarinG

  • I post frequently
  • ***
  • Posts: 134
  • Karma: 9
  • CiviCRM version: 4+
  • CMS version: Drupal 6 / 7
  • MySQL version: MariaDB
  • PHP version: 5.3/5.4/5.5
Re: Configuring Financial Types/Financial Accounts for export to QuickBooks
July 15, 2014, 09:49:56 am
Yes. Try that.

Shai

  • I post frequently
  • ***
  • Posts: 202
  • Karma: 8
    • Content2zero
  • CiviCRM version: 4.3.x, 4.4.x, 4.5.x
  • CMS version: Drupal 7
  • MySQL version: 5.5.x
  • PHP version: 5.3.x, 5.4.x
Re: Configuring Financial Types/Financial Accounts for export to QuickBooks
July 15, 2014, 11:17:15 am
Karin,

Thanks.

Hmm, so lets say that I have two Financial types:
1. Donations
2. Event Income

And I have 2 classes:
1. Daycare program
2. After school program

According to your suggestion I would create the following Financial Types in CiviCRM:
1. Donations;Daycare program
2. Donations;After school program
3. Event Income;Daycare program
4. Event Income;After school program

If that is what you are suggesting, this is simple to understand, but if you have 10 financial types and 10 classes you have 100 choices in the dropdown. But at least it is only admins who would see that dropdown.

Please confirm this is what you mean.

I started trying to put the class in a custom field set and then add that to a profile for an online event registration. I couldn't find an easy way to pre-populate the field with a particular value for that event. Hiding it so users wouldn't see it shouldn't be too hard.

How would I pre-populate it though?

Shai
Don't miss out! Sign up now for free expert advice on CiviCRM's new StackExchange help site.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviContribute (Moderator: Donald Lobo) »
  • Configuring Financial Types/Financial Accounts for export to QuickBooks

This forum was archived on 2017-11-26.