AP GL vs Open Invoice Report

Doug Collins
Doug Collins
Second Anniversary Name Dropper Facilitator 1
in Blackbaud Financial Edge NXT® General Discussions

Good morning - I am new to BB Financial Edge NXT - It was communicated to me that the AP GL should match the Open Invoice Report. I am unable to get the 2 reports to match. BB Chat said if they don't match to tic-n-tie the reports. Has anyone been able to do this or have worked through this process. Is it even possible? Any help is greatly appreciated. Have a GREAT Friday and weekend!

Comments

  • Kevin Brazell
    Kevin Brazell Blackbaud Employee
    Tenth Anniversary Kudos 5 First Reply Name Dropper

    @Doug Collins
    it is. But depending on business rules, data practices, and when the last time the reports were reconciled it can be tougher to do. Check out this KB, outside steps and a link to the reconciliation guide, it also list some reconciling items to be aware of that make it tougher or cause issues reconciling :

  • Karen Avery
    Karen Avery
    Sixth Anniversary Name Dropper Participant Facilitator 1

    @Doug Collins We had this same issue. Our remedy was to determine if our Open Invoice Report was accurate (this was reconciled with our A/P person). When it was, I simply made an adjusting journal entry to our GL account (for us, A/P Vendors) to reconcile with the Open Invoice Report. We've been reconciling ever since.

  • Doug Collins
    Doug Collins
    Second Anniversary Name Dropper Facilitator 1

    @Karen Avery
    Thank you Karen. I will work through the process and am hopeful all will work out in the end.

    Have a wonderful weekend!

    Doug

  • Doug Collins
    Doug Collins
    Second Anniversary Name Dropper Facilitator 1

    @Kevin Brazell
    Thank you Kevin. It seems it has been sometime since last reconciliation. It is going to be a challenge. I will work through the process and am hopeful all will work out in the end.

    Have a wonderful weekend!

    Doug

  • Lisa Olscamp
    Lisa Olscamp
    Seventh Anniversary Kudos 2 August 2025 Monthly Challenge Badge Name Dropper

    @Doug Collins Ours has never matched. We book adjusting entries also.

  • Susan Trippe
    Susan Trippe
    Kudos 4 Fourth Anniversary Name Dropper Participant

    @Doug Collins
    Were you able to reconcile? I always struggle with this report and can seldom get it to reconcile with my general ledger. I'd love to know what you ended up doing.

Categories