Setting up GL Codes or editing the Fundraising Hierarchy - Quickbooks?

Jon Wysong
Jon Wysong
Kudos 1 Name Dropper Participant First Anniversary
in Blackbaud Altru® General Discussions

Our finance team has done a total re-organization on its GL structure - we reconcile by pulling weekly reports for the finance team. It's really time consuming for them and have asked how we might accomplish an easier, more streamlined approach. I can think of a few ways.

  1. Edit the Fundraising Hierarchy - adding GL codes to the funds currently active, knowing full well that GL codes would be more difficult to apply to the membership, merchandise, and tickets/events structures.
  2. Keep everything the same but add the GL numbers in my reports so finance knows where to put them (and can easily sort my reports.
  3. Set up Altru GL System - I got the warning message to reach out to Blackbaud for help with this, saying it's a very complex procedure

What seems to work best for folks?

Further, are there any tools I should be looking at to have Altru data talk with Quickbooks? Any data dump procedures I should be aware of?

Tagged:

Comments

  • Laura Taylor
    Laura Taylor
    Fifth Anniversary Name Dropper Facilitator 1 June 2023 Monthly Challenge

    @Jon Wysong
    Hello Jon,

    I recently looked into setting up the Altru GL System and met with Blackbaud about this. They advised me not to do this unless I was using Financial Edge (or whatever the Blackbaud finance software is called) which we do not use. Our finance team is moving to a new database and has restructured their GL accounts. Previously I would put the GL account in the Report 2 field of funds and the Category for programs. However, the new finance software needs the account numbers segmented out so what I plan to do is use the Report 2 and Category fields to map to the GL account numbers externally using an OData link which is most similar to your second option.

    Best,

    Laura

  • Jon Wysong
    Jon Wysong
    Kudos 1 Name Dropper Participant First Anniversary

    @Laura Taylor - thanks so much! We are going to have a meeting with SmartTHING to see what they have to offer, but this is a really helpful go-to if they can't help us.

  • Laura Taylor
    Laura Taylor
    Fifth Anniversary Name Dropper Facilitator 1 June 2023 Monthly Challenge

    @Jon Wysong
    Great! Just out of curiosity - what is SmartTHING?

  • Jon Wysong
    Jon Wysong
    Kudos 1 Name Dropper Participant First Anniversary

    @Laura Taylor - they're most known for their SmartPASTE plug in for RENXT Database view, which would override the limit on how many lines of data you could paste into a “one of” criteria within a query.

    They are further development SmartSYNC which uses the SkyAPI to link two solutions together. Altru isn't on the list, but my understanding is that Altru has similar structural design to BB CRM, so hopefully it'll be an easy solution for them.


Categories