Excel Data

Gabrielle Evans
Gabrielle Evans
Fourth Anniversary Kudos 1
in Blackbaud Financial Edge NXT® General Discussions
Hello everyone,


This is the first year our organization has utilized FE NXT. We are wanting to export Excel data from GL Detail report that has the Account Number listed in a column next to the data opposed to each account being sectioned off. Is this a possibility with FE NXT?


- Gabrielle

Comments

  • Sylvia Cook
    Sylvia Cook
    Kudos 5 Fifth Anniversary Name Dropper Participant
    following
  • Paul Wu
    Paul Wu
    Sixth Anniversary Kudos 2 Name Dropper Facilitator 1
    I would really like to know as well.


    Best I could do is not have the periods subtotal, in the "Content" tab near the bottom "Subtotal by Period"


    Then it just shows the entire transaction history for each account for the period range.
  • Sylvia Cook
    Sylvia Cook
    Kudos 5 Fifth Anniversary Name Dropper Participant
    I haven't found it in NXT either. I can in FE, but it's only one month at a time.
  • Patricia Parlow
    Patricia Parlow
    Sixth Anniversary Facilitator 1
    I Use Query function in data base view. Comes in as a flat file and can export to excel. Only drawback is that there is no account balance, however can sort by date, amount, project code, fund, divisions, etc. So much better than the General Ledger report
  • Neil Cyriac
    Neil Cyriac
    Sixth Anniversary Facilitator 1
    Sadly no, a workaround is to run a GL Export Excel data report and copy this formula into cell H2 and copy down to create an account column.


    =IF(LEFT(A2,3)="Acc",MID(A2,10,14),H1)
  • Paul Wu
    Paul Wu
    Sixth Anniversary Kudos 2 Name Dropper Facilitator 1
    If you add the Post date you can do a pivot table with the output and this will give you account balances.


    I swear I am crying with joy on how I can see everything.


    I have no idea why I never used the Query function, actually I do, but let's not talk about that.

Categories