Configuring Financial Types/Financial Accounts for export to QuickBooks

[SarahG (FountainTribe)]

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?

[KarinG]

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 also have a client very much interested in using Quickbooks classes.

Any progress or workarounds people can report on?

Shai Gluskin

[KarinG]

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]

Karin,

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

Shai

[KarinG]

Yes. Try that.

[Shai]

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