Journal entries not showing in register for bank acct created

Tamara Brown

Hello there,

I've setup some bank accounts in NXT to start reconciling through the system. We have been reconciling in excel but trying to use the system more optimally. I want to start effective 6/1 as it starts our fiscal year. I have a posted gl batch for June but I don't see any journal entries in the register. I've been in communication with customer service for a little over 2 weeks, which lastly told me to create adjustment entries I believe so these journals entries will pull into the register. My issues are:

• NXT doesn't allow me to create a new adjustment entry but will allow me to select an adjustment entry if I create it in the database
• If I need to create in the database, how do I set up to pull all the manual entries from the general ledger? I see it works for an older account that was setup but I'm unable to follow that setup for the accounts I'm adding.
• Why am I not see any activity in the register if there are journal entries that have been posted?

Thanks for any help!

Roberta A. Gilbert

@Tamara Brown
Hi Tamara - check your Business Rules in NXT (General Ledger » Settings » Business Rules » Journal Entry)

You want to UNcheck “Allow journal entries to cash accounts without adjusting the bank register”
This will make sure your GL cash account and the bank register are both adjusted together, each time you make a JE to the cash account.

Tamara Brown

@Roberta A Gilbert

Hi Roberta - it is unchecked. I just verified. I wish it was that easy. But I really appreciate the assistance!

Kevin Brazell

@Tamara Brown the rule being checked or unchecked matters at the moment the JE is made and posted. It could be unchecked when you looked but checked when those JE's were made. Go to the Je's in question and see if they have the message near the top right : Create Bank Adjustments.

If you see that, then at the moment that JE was made and posted, the business rule was off. If the JE is posted and you don't see that message, that individual one was made, when the business rule was marked and could have posted to GL without making a corresponding bank adjustment.

Tamara Brown

@Kevin Brazell

Hi Kevin,

I do see that ‘Create bank adjustments, Create interfund entries" in the posted batch for the entry. But still don't see in the register. I'm at a loss. Thanks again for your help!!

Kevin Brazell

@Tamara Brown
Ok if you don't see it in the posted entry then that is the proof the button was off at the time of posting. If it had the box marked to make an adjustment then the top right would say it create bank adjustment.

Tamara Brown

@Kevin Brazell
Hi Kevin. Sorry if I'm confusing. The box in the settings “Allow journal entries to cash account without adjusting the bank register” is unchecked and for the most part, stays unchecked.

In all of the posted journal entry batches, where I record some of the bank activity, they all have at the top “Post” and then underneath: Create bank adjustments, create interfund entries.

In June (and months before) I was able to reconcile an older account (set up before I started), that shows the Journal Entries in the register. This account pulls in the Journal entries automatically somehow as a bank adjustments. I see in the database.

There are few other accounts that have been reconciled manually and I've recently setup these accounts in NXT to try to start reconciling in NXT. I thought once I set up and put the GL cash account code used under the subledger settings, that I would automatically see the transactions in the register. But no luck - hence me reaching out to blackbaud.

The rep told me to create adjustments and sent me links on how to create an adjustment. Is there a clear explanation that explains how these adjustments will be automatically created when I record a JE in the General Ledger? The create adjustments section looks like it's just for one adjustment? I'm sorry I'm confused. Either Im missing something basic, there's additional instructions I need or something isn't working Thanks again for your help.

Angela Davis

@Tamara Brown Hi Tamara. I am having the same issue and I have gone thru the suggestions, but like you, everything is just as it should be, but no entries are there when I go in to reconcile. Did they ever give you a solution that works? Thank you, Angela Davis.

Tamara Brown

@Angela Davis Hi Angela! I'm sorry you're going through the same thing. No. I'm waiting for an answer. I keep getting the wrong suggestions and I sent another very clear email on the issue on Thurs 9/12. I'll let you know when they respond back. It's been several weeks of back and forth.

It would be nice to get someone to actually remote view our system but unfortunately I was told, they don't do that. I'll keep you posted!

Ariana Naqellari

@Tamara Brown we have the same problem waiting for help

Tamara Brown

@Ariana Naqellari

Hi Ariana - funny thing I just went in today and now I see all activity including journal entries showing in the register. The last thing BB support said was he was going to let the engineers know so it might be something internal. I haven't gotten an email back saying the engineers worked on it so I'm just assuming they did something? I hope they can help you resolve too.

Tamara Brown

@Angela Davis

Hi Angela - I think the engineers may have fixed something because I now see all activity. I hope you got yours working!

Tamara Brown

@Ariana Naqellari

I realized that any activity posted before you set up the bank account in NXT won't show in the register. My coworker had recently posted an old JE batch and after he posted it, it showed in the register of the new account and I was able to reconcile. I had to put the beginning balance in the database and the month I started to reconcile was the first month that the activity was posted in. The months before I have the manual excel reconciliations.

My original thinking was I was going to see all the activity to the account funnel through the register once the account was set up, but that was incorrect.

I just wanted to clear that up because I mistakenly thought something was fixed.

I am having another issue which I'm trying to figure out regarding bank accounts that were already set up but was never reconciled through NXT and now the GL balance is off. There are some transactions not showing in the register but I see them when I run a GL report. I may need to reach out to BB for this one.

Angela Davis

@Tamara Brown
Glad yours is fixed. My entries still not showing up. It is only two entries and we won't be using the account again. I have looked at everything folks are suggesting, but everything is already marked how they are saying it should be.