Bank reconciliation is off by $.01

[jwdick]

I have a bank reconciliation problem that I cannot find the answer to. I did a manual check in the Accounts Payable module with check number 90544 in the amount of $203.12. This check was a debit card transaction. The amount of the actual transaction shown on the bank statement was $203.12. The check was posted through the Acct Payable module by the "Post to paid file" selection. It was then posted in the accounting module with the "Post Transaction" link. My statement will not reconcile because when the transaction posted in the accounting module, it posted as $203.11. I have attached a screenshot showing the results of the postings. I know that I can do a JE for the $0.01 to make the bank statement reconcile but it still doesn't explain what happened and how to keep it from happening again.

I am the only person with access to make backups and do restores and no restore has been done in the last 12 months. So a restore overwriting the database is not the issue.

[NeilZ]

I've not seen the system change a number, let alone by one cent. And I've been using Powerchurch for 17 years or so. I've also not seen any other report of such a change.

Just because it was posted from AP to Funds Accounting, doesn't mean it couldn't have been changed while it was sitting in the unposted transaction queue in Funds Accounting.

However, let's eliminate any other issue. Are you on the latest Maintenance Release of Powerchurch 11.55 ??

[jwdick]

I am on the latest release. I also am the only one to use the accounting module. No one else even has access and I can say that I did not edit the transaction in fund accounting. As I stated, I know how to fix it, just was curious as to what may have happened.

[NeilZ]

I am on the latest release. I also am the only one to use the accounting module. No one else even has access and I can say that I did not edit the transaction in fund accounting. As I stated, I know how to fix it, just was curious as to what may have happened.

You may need to talk directly to the Powerchurch techs on this one, as I said, I've never seen this occur in my 17 years of using the system, nor have I seen it reported on the forums.

[jwdick]

Thanks for the input Neil. I won't bother the techs with it unless it happens again. I will explain how I know that it wasn't edited in fund accounting. When I post manual and printed checks in AP to the "Post to paid file", I immediately go to Fund Accounting and post transactions. In some cases, I post to both areas several times a day. From reading the forum, I suspect that most users do not post that often. General question, is there any reason that I should not be posting that often? It doesn't seem to slow the system down.

[NeilZ]

From reading the forum, I suspect that most users do not post that often. General question, is there any reason that I should not be posting that often? It doesn't seem to slow the system down.

None whatsoever ... I tend to do it in batches once a week, as I then send the reports over to the volunteer treasurer. Keeps him from having to print off pages of stuff every other day

[Jeff]

I know this is an old topic, but try running the selected paid items report again. There is an option to "Include account distributions" check the amounts shown in the distribution.