Unposted Transaction from previous month

Rich Kreissle

Our FY ends on 6/30. The last time a bank rec was completed was December 2025. When I went in to start January's bank rec there were warning messages indicating that there were unposted subledger and journal entries. When I start a bank rec, I want to start clean without any of these types of messages/ There are 4 unposted batches dating from September. After talking with our Advancement office, they are legitimate transactions. Based upon what I've found from other sources, if I post these transactions, bank rec's from September to December will now be out of balance.

Is there any way of resolving and avoid having to redo months worth of bank rec's?

Thank you for you assistance and take care.

Cordially,

Rich Kreissle

Controller

Vermont Academy

Crystal Bruce

Hi @Rich Kreissle - I moved this over to the Financial Edge NXT community. It was posted in Raiser's Edge NXT. Hopefully, that will give you some answers! I'll keep an eye on it. :-)

Rich Kreissle

Thank you very much!
Rich

Patricia Nowak

I would redate the transactions in the unposted JVs to January 1st. If they are unposted subsidiary ledger transactions I would do the same first in the subsidiary and then post the subsidiary ledgers to the GL. You would need to consider whether you have closed all of the months for GL purposes through December and whether it is more important to record the unposted transactions in the correct period. Once we have completed our month end closing process and we mark a period closed we don't go back for this type of thing. We just record in the first open period, January in this case, and move forward. Please note that our monthly closing process includes a check for any unposted transactions in all of the subsidiary ledgers as well as the GL.

Kevin Brazell

https://community.blackbaud.com/discussion/85486/unposted-transaction-from-previous-month

You could have potential out of balances in both the register to statement and also the GL cash account to statement with unposted activity. Before doing any bank rec, a good rule is ensure everything that affects that period , or earlier is posted. Just moving them doesn't totally help the current bank rec. I know you're cleaning it up but moving JE's that aren't posted means their transactions would be in the future, causing an out of balance of both register to statement and gl cash account to statement. IF it's a subledger posting, then that could still cause GL cash account being out of balance ot statement if bank adjustments or payments aren't posted. THIS KB covers potential causes for both types , I'd recommend bookmarking it : Bank rec is out of balance

Rich Kreissle

Hi Kevin,

Thank you for your reply. As a newbie here, I'm juggling a lot so I have a quick moment to review your reply and a just a point of clarification. When you refer to the "register" you're referring to cash/bank register (not sure what term BB uses as compared to other software) and the "statement" is the monthly bank statement. I believe I'm correct here but I just want to be sure we're on the same page.

New user type question: What is the best way to the register balance for any given time period? Is there a function that, prior to doing a bank rec or say a monthly closing, that will report any unposted transactions.

Cordially,

Rich

Kevin Brazell

@Rich Kreissle Yes, Register is Bank register in your bank in FENXT under Treasury. And statement , i did mean you're bank statement. The best , easiest way for unposted activity is using the Closing Assistant under GL>Overview. It shows for a period any unposted activity by module and you can drill down into it.

Rich Kreissle

Thank you Kevin - this has been very helpful!

Cordially,

Rich