Page 1 of 1

Reconciliation Report Problems

Posted: Fri Sep 01, 2023 1:15 pm
by antioch-alexandria
I am trying to reconcile July's bank statement and have run into the following problems:

1) We use the check reader for making check deposits, so the checks were recorded on 7/31, but the cash was not deposited until 8/1. In powerchurch the entire deposit is shown, but of course, on the bank statement, just the checks are shown. How do I correct?

2) I have a total of 20 checks that are not showing up in my reconciliation list in powerchurch but are on my bank statement. I can't find them anywhere in powerchurch, however I have the check stub for each check. What in the world do I do to correct and what could have possibly happened?

Re: Reconciliation Report Problems

Posted: Fri Sep 01, 2023 6:05 pm
by NeilZ
antioch-alexandria wrote:
Fri Sep 01, 2023 1:15 pm
I am trying to reconcile July's bank statement and have run into the following problems:

1) We use the check reader for making check deposits, so the checks were recorded on 7/31, but the cash was not deposited until 8/1. In powerchurch the entire deposit is shown, but of course, on the bank statement, just the checks are shown. How do I correct?
It doesn't show up on the Bank Statement, it should NOT affect the bottom line of the reconciliation. You reconcile according to what the statement shows, not on the date of the entry into Powerchurch. That deposit will stay uncleared until the September bank statement.
2) I have a total of 20 checks that are not showing up in my reconciliation list in powerchurch but are on my bank statement. I can't find them anywhere in powerchurch, however I have the check stub for each check. What in the world do I do to correct and what could have possibly happened?
Do you have someone who is writing checks outside of Powerchurch? They should not be doing that. To fix this you're going to have to enter each one of the checks as a MANUAL check, using the check number and based on the check date written. You'll also need to know where the funds were coming from. I suspect some would be very easy, such as electric, would come out of the electric utility expense. However, others you may have to track down.

You really can't do anything until those checks are in the system.

And I would DEFINITELY stop anyone from writing checks without using the system to enter them. That is an audit nightmare ...