Page 1 of 1

Bank reconciliation date not changing

Posted: Fri Dec 16, 2016 4:49 pm
by eagle654b
Why doesn't the reconciliation date not change after doing the monthly bank reconciliation? I reconcile my bank statement every month but when I go to do the next reconciliation, it still comes up with February 29th as the statement date.
I am using the latest version of the program and have installed all the maintenance releases.
Thank you,
Jim Franklin

Re: Bank reconciliation date not changing

Posted: Fri Dec 16, 2016 5:31 pm
by NeilZ
eagle654b wrote:Why doesn't the reconciliation date not change after doing the monthly bank reconciliation? I reconcile my bank statement every month but when I go to do the next reconciliation, it still comes up with February 29th as the statement date.
I am using the latest version of the program and have installed all the maintenance releases.
Thank you,
Jim Franklin
Are you changing your open month each month ??

Re: Bank reconciliation date not changing

Posted: Fri Dec 16, 2016 6:11 pm
by eagle654b
I am not sure what you mean by changing the open month. I change the working month each month but don't know of any other changes that need to be made. This only started happening this year. Before that it always changed after I reconciled the bank statement.

Re: Bank reconciliation date not changing

Posted: Fri Dec 16, 2016 6:40 pm
by NeilZ
eagle654b wrote:I am not sure what you mean by changing the open month. I change the working month each month but don't know of any other changes that need to be made. This only started happening this year. Before that it always changed after I reconciled the bank statement.
Ok .. so the working month is changed each month.

I'm not seeing that behavior here. Does everything reconcile properly otherwise?

I'm going to suggest something that fixes a lot of minor glitches, have you done a reindex lately? If not, try running one.

Re: Bank reconciliation date not changing

Posted: Fri Dec 16, 2016 6:43 pm
by eagle654b
Yes, the bank statement has reconciled properly each month in the 4 years I have been using the program. But statement date has been stuck on February since I reconciled February's statement.
I have to manually change the statement date each month when I do the reconciliation.

Re: Bank reconciliation date not changing

Posted: Fri Dec 16, 2016 6:49 pm
by NeilZ
eagle654b wrote:Yes, the bank statement has reconciled properly each month in the 4 years I have been using the program. But statement date has been stuck on February since I reconciled February's statement.
I have to manually change the statement date each month when I do the reconciliation.
Have you done a reindex lately ?

Re: Bank reconciliation date not changing

Posted: Fri Dec 16, 2016 6:51 pm
by eagle654b
No.
Should I reindex the database periodically?

Re: Bank reconciliation date not changing

Posted: Fri Dec 16, 2016 7:11 pm
by eagle654b
I just reindexed the program and the reconciliation date still shows 2/29/2016.

Re: Bank reconciliation date not changing

Posted: Fri Dec 16, 2016 9:06 pm
by NeilZ
eagle654b wrote:I just reindexed the program and the reconciliation date still shows 2/29/2016.
Well ... unless its really causing a problem, I wouldn't worry about it.

However, as I've not seen anyone else have this issue, I'm going to suggest that its something local to your installation.

You could always do a backup, uninstall the program, then reinstall it, apply the latest MR, and then restore the backup to see what then happens.

Still, I'll notify one of the Powerchurch techs to take a look a this thread, maybe they'll have some insight.

Re: Bank reconciliation date not changing

Posted: Mon Dec 19, 2016 10:26 am
by Zorak
This sounds like the program is having problems updating one of the data files.

When you run the Bank/Credit Card Reconciliation report, do you see all of your past reconciliations listed? This report can be found under Accounting > Fund Accounting > Reports - Fund Accounting.

The report refers back to the same data file that the reconciliation screen looks at.

In either case, it would probably be best that you give us a call at (800) 486-1800 and speak with a technician about this.

Re: Bank reconciliation date not changing

Posted: Thu Dec 29, 2016 3:42 pm
by Buffalofoodshelf1
FYI - the date doesn't change for me either. I have to change it each month.

Re: Bank reconciliation date not changing

Posted: Thu Dec 29, 2016 4:29 pm
by eagle654b
I called into tech support and they fixed the problem.
You still have to change the date each month, but when you go into the reconciliation function, it should show the last date you performed a reconciliation.
My problem was that the date displayed always showed 2/29/16.

Re: Bank reconciliation date not changing

Posted: Sun Jan 01, 2017 6:58 pm
by debbie.bishop
I am having this same problem. My bank reconciliation for August has not cleared. All the data is still in the reconciliation even though I have finalized everything for August.

Re: Bank reconciliation date not changing

Posted: Sun Jan 01, 2017 7:15 pm
by NeilZ
debbie.bishop wrote:I am having this same problem. My bank reconciliation for August has not cleared. All the data is still in the reconciliation even though I have finalized everything for August.
OK ... you've done your reconciliation, marked all your cleared items from your bank statement, and clicked on the DONE button?
I take it you've done your reconciliations from Sept thru November too ??

If the answer to those questions is yes, then I'd suggest you call the Powerchurch support line directly, as you may have the same issue that eagle654b was having.