Help needed on exporting transaction data from RE into new accounting software

Options
JoAnn Strommen
JoAnn Strommen ✭✭✭✭✭
Ancient Membership Facilitator 4 Name Dropper Photogenic
in Blackbaud Raiser's Edge NXT®: General Discussion
I posted this in FE forum at request of CFO but know there's a lot of wisdom here in the RE one so will ask here also.


We are switching to a non-integrated accounting software.  We are looking for help on how to export the needed info including GL accounts from RE so that it can be imported into Daxko Accounting.


If there is anyone familiar with Daxko that would be great but would appreciate any advise on getting needed data out of RE. CFO said she spoke to support and was told she cannot export GL#s.


Thanks in advance.
Tagged:

Comments

  • Ryan Hyde
    Ryan Hyde ✭
    Tenth Anniversary Facilitator 3 Name Dropper Photogenic
    Assuming you have information in the GL Distributions tab of your fund records, then you can do a fund query, GL Credit Account Number <not blank>, and output anything you want from the Distribution tree toward the bottom of the query. And also output the fund ID of course as you're going to get dupes (assuming you have repeat distributions per gift type/subtype). You can also output the debit account numbers the same way. 


    EDIT: This is from within RE of course. Not sure about exporting this kind of info directly from FE. Have limited experience with that system, though it seems like it should be possible.
  • Heather MacKenzie
    Heather MacKenzie ✭
    Tenth Anniversary Facilitator 4 Name Dropper Photogenic
    JoAnn,


    There's gotta be a way to export anything you need from the gifts, the fund records, or wherever we need to find it.  Find out what specific information needs to be in the import into Daxko and I'll help you figure out how to get it out of RE.


    Do you currently have your Fund ID set to be the G/L number?  That's also one thing that could help out, I'd think.


    My org does not integrate with our accounting software either, so I have some ideas for you.  Plus, I have an accounting background, which could be useful.  Let me know if you'd like to chat over the phone.  I'd be happy to brainstorm with you.
  • JoAnn Strommen
    JoAnn Strommen ✭✭✭✭✭
    Ancient Membership Facilitator 4 Name Dropper Photogenic
    Thanks, Heather.  Sending you a PM.

Categories