General Ledger Reports

Dana Behler
Dana Behler
Fourth Anniversary Kudos 1 Name Dropper Facilitator 1
in Blackbaud Financial Edge NXT® General Discussions

Does anyone have a way to pull a useful GL report into Excel? I've tried in database and web view, but the reports are just not what I need. I want to be able to pull them into Excel so I can dig into the data more easily (like with a pivot table). The GL report has the data I need, but not in an easily used format. To use in Excel would take hours and hours of data clean-up. Any ideas?

Comments

  • Kristy Soular
    Kristy Soular
    Tenth Anniversary Kudos 3 Name Dropper Participant

    @Dana Behler
    Have you tried extracting the data using Queries within General Ledger? We have a couple queries that we run, export and turn into pivot tables. It works great for us and is super quick.

  • Dana Behler
    Dana Behler
    Fourth Anniversary Kudos 1 Name Dropper Facilitator 1

    @Kristy Soular Thank you! I was making this harder than it needed to be.


  • Kim Szalkus
    Kim Szalkus
    Seventh Anniversary Kudos 2 Name Dropper Facilitator 1

    @Dana Behler I run the reports in FE-NXT and do a “Excel Download” so the headers do not repeat on each page. Usually downloads cleanly.

  • Roberta A. Gilbert
    Roberta A. Gilbert
    Eighth Anniversary Kudos 4 Financial Edge NXT Fall 2025 Product Update Briefing Badge Name Dropper

    @Kim Szalkus:

    @Dana Behler I run the reports in FE-NXT and do a “Excel Download” so the headers do not repeat on each page. Usually downloads cleanly.

    I do this as well. I use the menu item “Export Excel Data” in NXT (vs Run the report). It's especially useful for GL activity, because the columns line up neatly (unlike the Export function in Database View).

  • Tyler Brown
    Tyler Brown
    Fourth Anniversary Name Dropper Facilitator 1

    @Kim Szalkus:

    @Dana Behler I run the reports in FE-NXT and do a “Excel Download” so the headers do not repeat on each page. Usually downloads cleanly.

    I do this as well. I use the menu item “Export Excel Data” in NXT (vs Run the report). It's especially useful for GL activity, because the columns line up neatly (unlike the Export function in Database View).

    I agree 100% with both of these posts. I have been doing something similar with the “Export Excel" item. Doing this will allow you to link the excel with the web view (by clicking on the dates, it will take a user to the FENXT item in question). There is more manipulation involved such as unmerging all cells in the sheet, removing blank columns, creating drop down filters for you header, and then removing any unnecessary data. It's a bit of work, but once you get the hang of it, it's not bad.

    I also add an extra column to the left of A. Next to the first account number in column B, I put in the formula =if(len(B5)=11,B5,A4 Since our account numbers are 11 characters long, I can drag this formula all the way down and now see account numbers NEXT to my transactions instead of grouped together. Make sure to copy all of Column A and Paste it back into Column A as Values so this removes the formula and keeps the account code. This will save you a headache if you try to sort/filter data later.

Categories