Would like a pre post report like in DB

I would like to see the ability to have a pre post report when posting RE to FE as it was in database view so that I can check the totals before running the post. We have different batches and some gifts not in batches that I like to post separately and it is nice to be able to see the total before posting. I am not a fan of the way it works right now in NXT, It is hard to tell what is going to post and if there's a discrepancy to be able to tell what the discrepancy is.

  • Kay Wastler
  • Jun 23 2025
  • Shipped
  • Attach files
  • Sophia Frome commented
    01 Jul 17:18

    Is there a way for this report to be totaled by date like in database view? Having the posting totals by date helps with reconciliation while we are posting the gifts.

  • Elizabeth Schultz commented
    15 Jun 17:37

    Will you post a message in this idea about the missing fields for the reports when you've added/updated? I would appreciate it.

  • Admin
    Anthony Gallo commented
    15 Jun 16:29

    You are correct. The reports can be run whenever as they are not just output from running the process. You are correct about leaving those posting events in unposted until you are ready to commit.

  • Elizabeth Schultz commented
    15 Jun 15:16

    Thank you so much! I apologize for being a pain. So to clarify (please correct me if I'm wrong) - right now in dbv I get the detail export file in CSV as well the GL pre-posting report in PDF. To match that in NXT, I would just need to run the report twice - once in CSV for Jenzabar and once in PDF for a GL for auditors. And it's fine then to leave the batches as unposted as only people with my access would be able to see those.

  • Admin
    Anthony Gallo commented
    15 Jun 15:02

    I will check on adding the missing fields.

    As for the process in web view. We do show the pre post details in the UI and mark those gifts as posted while in this state to avoid any editing of the gift before it can be committed. You are correct on the process that if you do not like what you see, you would reject that post and the gifts would be freed up for any changes that need to be made.

  • Elizabeth Schultz commented
    15 Jun 14:55

    Hello Anthony, I tried this posting procedure this morning to see what the reports looked like, figuring I would just not push through the posting. However, the reports are not the same. My Finance dept. needs the C/D column for Credit/Debit, complete name & ID of the donor and the batch number. Can these be added? They use the CSV for Jenzabar and I would have to manually add the C/D column each batch in addition to editing donor info. Also, is not pushing the post what you would recommend for pre-posting? I ended up rejecting the post to go back through dbv and get the report formats we're used to.

  • Admin
    Anthony Gallo commented
    15 Jun 14:40

    This is available today for posting in web view. The export option contains a link to export to PDF which will give you the uneditable report format that was being used in database view.

  • Elizabeth Schultz commented
    15 Jun 13:55

    We do not fully post - our Finance department uses Jenzabar, so I need that export file CSV to look like it does now for me to make the edits I need to for them to post correctly. Also, the GL PDF that is generated in NXT doesn't list the entire name or the ID # of the donor. Please have these match the database view reports as well.

  • Tanya commented
    October 08, 2025 12:38

    This is an important step in our posting process of gifts from RE to FE. We've had posts for one reason or another not make it through to FENXT and the only way to recreate the entries is with the prepost report. Once the gifts are marked posted in RE, we haven't found a way to easily isolate the gifts which didn't post correctly.