Trial Balance Filters

Stephanie St. Clair
Stephanie St. Clair
Facilitator 1
in Blackbaud Financial Edge NXT® General Discussions
image.png

I just started at an organization and there is some pretty major clean up/catch up to do. However, when I pull a Trial Balance, the account balances in the TB are not matching the account balances I see in the GL.

We have many old JE batches that have not been posted going back many years, so I filtered for that. However, the way I am reading this filter (above), is my TB ONLY including transactions that are Not Yet Posted, or is it also included Posted transactions by default.

Seems pretty obvious, but it reads like it's only including the ones Not Yet Posted.

Alternatively, when I filter for posted transactions, it's asking for specific JE numbers and I just want to include them all.

Any advice on how to get my TB to match figures in the GL would be greatly appreciated. I have a lot of work ahead of me. Thank you.

Best Answer

Answers

  • Patricia Nowak
    Patricia Nowak Community All-Star
    Sixth Anniversary First Reply Kudos 1 Name Dropper

    Try setting the Not Yet Posted Transaction filter to not include those transaction. The All option will include the Not Yet Posted along with Posted transactions. It also sounds like you have not consistently closed fiscal periods or fiscal years as unposted JVs would not allow you to run those closing processes.

    Another option might be to remove the filter for Not Yet Posted transaction entirely as the Trial balance should only include posted transactions with that filter removed.

  • Stephanie St. Clair
    Stephanie St. Clair
    Facilitator 1

    Thank you! Very helpful!

Categories