Page 1 of 1
Reconciling Bank Account won't zero out
Posted: Mon Mar 02, 2020 1:20 pm
by Jesus Rules
We are new to PC and i'm trying to reconcile for January however I can't get it to zero out and I don't know what I'm doing wrong.
We have PC Plus version 12.
Re: Reconciling Bank Account won't zero out
Posted: Mon Mar 02, 2020 7:49 pm
by NeilZ
Jesus Rules wrote:We are new to PC and i'm trying to reconcile for January however I can't get it to zero out and I don't know what I'm doing wrong.
We have PC Plus version 12.
Quick question .. how much are you off? Are you seeing more in Powerchurch or more in the bank? Are you sure you've posted everything from Accounts Payable, Contributions, and Payroll?
OK ... the first step is to use a paper copy of the bank statement, then check off every check and deduction you see in the Powerchurch reconciliation screen, then do the same with your deposits. Verify each amount to make sure it is what the bank shows as clearing.
Then see if there's anything listed on the bank statement which was not seen in Powerchurch. One of the things often seen is that if the bank charges any kind of service charge, that has not been entered into Powerchurch.
Re: Reconciling Bank Account won't zero out
Posted: Mon Mar 02, 2020 10:28 pm
by Jesus Rules
I'm off by $2903.27 Looking at the balances on the bottom, I have the bank statement balance, the outstanding checks and no outstanding deposits. I have the adjustments, PC Balance and the difference. The book states if they don't match to go to the Check Register by Fund report. I did that and I don't know what to do with it. I have checked all the debits and credits and the numbers all seem correct.
I'm to the point where I want to delete all the transactions and start all over again.
Re: Reconciling Bank Account won't zero out
Posted: Tue Mar 03, 2020 12:37 pm
by Jesus Rules
I just found where the difference is, it was my outstanding checks from December that I cleared. We started with January so in the set up I put in my balance for December and also put in outstanding checks for December. Now the balance showing is those cleared December checks. Do you know a way to get them off? I don't want to carry them over forever. I already closed out December.
Re: Reconciling Bank Account won't zero out
Posted: Tue Mar 03, 2020 12:46 pm
by Zorak
You can enter an adjusting transaction to adjust the balance up (or down) in that account by $2903.27. Since it is a problem with the beginning balance that was entered, the offsetting debit or credit in the transaction would be the unrestricted equity (AKA fund balance/net assets) 3110 account.
To add to the bank balance, the transaction would look something like this:
01-1110-000 Checking (Debit) $2903.27
01-3110-000 Unrestricted Equity (Credit) $2903.27
To lower the balance, the debit and credit would be reversed.
Re: Reconciling Bank Account won't zero out
Posted: Wed Mar 04, 2020 8:02 am
by Jesus Rules
Thank you so much for your help!!! I have spent hours trying to find my problem and it was something simple.